metadata: contig_metadata: 5 rows where bioproject = "PRJNA565778", tax_kingdom = "Thermotogati" and tax

5 rows where bioproject = "PRJNA565778", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4385860	4385860	PRJNA565778_S_NODE_34024_length_187_cov_3.246667_g33728_i0	PRJNA565778	34024	187	3.246667	6.07126729	FCB group	1783270	Bacteria	Bacteria	109	4.4e-26	NR	NPU90251.1	1871331	g33728	i0	96.4	5.3903743315508	56	2	89.8	0	18	185	459	514	NPU90251.1 site-specific DNA-methyltransferase [Fervidobacterium sp.]	diamond	1008	110	0.990909090909091	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
7513694	7513694	PRJNA565778_S_NODE_38266_length_174_cov_1.905109_g37970_i0	PRJNA565778	38266	174	1.905109	3.31488966	Fervidobacterium	2422	Bacteria	Bacteria	296	6.12e-76	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g37970	i0	98.802	26.0977011494253	167	1	96	1	1	167	103839	103674	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	4541	296	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
12614808	12614808	PRJNA565778_S_NODE_31690_length_194_cov_461.993631_g31394_i0	PRJNA565778	31690	194	461.993631	896.26764414	Bacteria	2	Bacteria	Bacteria	276	9.13e-70	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g31394	i0	98.125	54.8298969072165	160	0	81	3	1	157	521553	521394	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	10637	276	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
22235259	22235259	PRJNA565778_S_NODE_19538_length_250_cov_347.107981_g19242_i0	PRJNA565778	19538	250	347.107981	867.7699525	Oceanotoga sp. DSM 15011	2984951	Bacteria	Bacteria	99	2.87e-16	NTclustered	gi\|2321114327\|gb\|CP107547.1\|	2984951	g19242	i0	93.939	29.26	66	3	26	1	38	102	1061574	1061639	Oceanotoga sp. DSM 15011 chromosome, complete genome	blastn	7315	99	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Oceanotoga	Oceanotoga sp. DSM 15011
30364288	30364288	PRJNA565778_S_NODE_38632_length_172_cov_6.400000_g38336_i0	PRJNA565778	38632	172	6.4	11.008	Fervidobacterium sp.	1871331	Bacteria	Bacteria	83.2	2.74e-18	NR	MDM7321174.1	1871331	g38336	i0	89.1	0.802325581395349	46	5	80.2	0	138	1	92	137	MDM7321174.1 hypothetical protein [Fervidobacterium sp.]	diamond	138	83.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;