assembly_summary

Identifier

genbank.assembly_summary

Description

Selected current and historical GenBank genome assemblies, one row per versioned GCA assembly.

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Source provenance for the row.
assembly_accession	TEXT	Versioned GenBank assembly accession (GCA accession).
bioproject_accession	TEXT	NCBI BioProject accession associated with the assembly, if supplied.
biosample_accession	TEXT	NCBI BioSample accession associated with the assembly, if supplied.
wgs_master_accession	TEXT	GenBank Nucleotide accession and version for the Whole Genome Shotgun project master record, if applicable.
is_historical	BOOLEAN	Whether this row originated from NCBI’s historical, rather than current, GenBank assembly summary.
version_status	TEXT	NCBI status of the assembly version, such as latest, replaced, suppressed, or withdrawn.
refseq_exclusion_reason	TEXT	NCBI reason the assembly is excluded from RefSeq, if supplied.
assembly_not_live_date	DATE	Date NCBI marked the assembly as no longer live, if applicable.
is_reference	BOOLEAN	Whether NCBI designates the assembly as a reference genome.
organism_taxon_id	TEXT	Opaque string NCBI taxonomy ID assigned to the organism represented by this assembly; maps to registry.taxa.taxon_id.
species_taxon_id	TEXT	Opaque string NCBI taxonomy ID assigned to the assembly’s species.
organism_name	TEXT	Scientific organism name reported by NCBI.
infraspecific_names	STRUCT(type TEXT, name TEXT)[]	Infraspecific names reported by NCBI, parsed into type and name pairs.
isolate	TEXT	Isolate name reported by NCBI, if supplied.
assembly_level	TEXT	Assembly completeness classification reported by NCBI.
release_type	TEXT	Release classification reported by NCBI.
genome_representation	TEXT	Extent of genome representation reported by NCBI.
sequence_release_date	DATE	Date the assembly sequence was released in an INSDC database.
assembly_name	TEXT	Readable NCBI assembly label; it is not globally unique.
assembly_submitter	TEXT	Organization or individual that submitted the assembly.
refseq_assembly_accession	TEXT	Paired RefSeq assembly accession (GCF accession), if NCBI provides one.
is_identical_to_refseq	BOOLEAN	Whether NCBI reports the paired RefSeq assembly as identical; null when no comparison is available.
assembly_url	TEXT	NCBI directory URL for the GenBank assembly package and its files.
relation_to_type_material	TEXT	Relationship of the organism to type material reported by NCBI, if supplied.
assembly_type	TEXT	Ploidy or assembly type reported by NCBI, if supplied.
organism_group	TEXT	NCBI organism group, if supplied.
assembly_size	BIGINT	Total assembly length in base pairs, if supplied.
assembly_size_ungapped	BIGINT	Total ungapped assembly length in base pairs, if supplied.
assembly_gc_fraction	FLOAT	Assembly GC content as a fraction from zero through one, if supplied.
assembly_replicon_count	INT	Number of replicons in the assembly, if supplied.
assembly_scaffold_count	INT	Number of scaffolds in the assembly, if supplied.
assembly_contig_count	INT	Number of contigs in the assembly, if supplied.
annotation_provider	TEXT	Organization that supplied the current annotation, if supplied.
annotation_name	TEXT	NCBI annotation release name or version, if supplied.
annotation_date	DATE	Date of the current annotation release, if supplied.
total_gene_count	INT	Total annotated gene count, if supplied.
protein_coding_gene_count	INT	Protein-coding annotated gene count, if supplied.
non_coding_gene_count	INT	Non-coding annotated gene count, if supplied.
pubmed_ids	TEXT[]	PubMed identifiers associated with the assembly.