metadata: contig_metadata: 7 rows where bioproject = "PRJNA977246", tax_kingdom = "Thermotogati" and tax

7 rows where bioproject = "PRJNA977246", 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
16571455	16571455	PRJNA977246_S_NODE_36293_length_196_cov_1.616766_g35301_i0	PRJNA977246	36293	196	1.616766	3.16886136	Bacteria	2	Bacteria	Bacteria	340	3.229999999999999e-89	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g35301	i0	98.454	4.96938775510204	194	2	98	1	4	196	520598	520791	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	974	340	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
20395085	20395085	PRJNA977246_S_NODE_12636_length_421_cov_6.091837_g11665_i0	PRJNA977246	12636	421	6.091837	25.64663377	Fervidobacterium	2422	Bacteria	Bacteria	693	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g11665	i0	97.995	31.3586698337292	399	8	95	0	12	410	304885	305283	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	13202	693	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
21671078	21671078	PRJNA977246_S_NODE_11757_length_439_cov_9095.436585_g10797_i0	PRJNA977246	11757	439	9095.436585	39928.96660815	Fervidobacterium	2422	Bacteria	Bacteria	628	1.5399999999999998e-175	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g10797	i0	98.87	94.9612756264237	354	1	80	3	37	389	288213	287862	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	41688	628	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
26772949	26772949	PRJNA977246_S_NODE_23261_length_277_cov_5.379032_g22269_i0	PRJNA977246	23261	277	5.379032	14.89991864	Fervidobacterium sp.	1871331	Bacteria	Bacteria	121	3.5500000000000004e-33	NR	MDM7320281.1	1871331	g22269	i0	84.7	0.779783393501805	72	11	78	0	267	52	1	72	MDM7320281.1 hypothetical protein [Fervidobacterium sp.]	diamond	216	121	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
27569350	27569350	PRJNA977246_S_NODE_27044_length_246_cov_3.972350_g26052_i0	PRJNA977246	27044	246	3.97235	9.771981	Thermotogati	3384194	Bacteria	Bacteria	50.8	5.37e-5	NR	WP_287568784.1	1968895	g26052	i0	50.9	4.13414634146341	55	26	65.9	1	166	5	612	666	WP_287568784.1 type IV secretory system conjugative DNA transfer family protein [Thermosipho sp. (in: thermotogales)]	diamond	1017	50.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
28447528	28447528	PRJNA977246_S_NODE_28926_length_233_cov_3.397059_g27934_i0	PRJNA977246	28926	233	3.397059	7.91514747	Fervidobacterium sp.	1871331	Bacteria	Bacteria	123	1.19e-33	NR	MDM7320314.1	1871331	g27934	i0	84.8	0.849785407725322	66	10	85	0	34	231	7	72	MDM7320314.1 hypothetical protein [Fervidobacterium sp.]	diamond	198	123	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32207491	32207491	PRJNA977246_S_NODE_50438_length_153_cov_1.903226_g49446_i0	PRJNA977246	50438	153	1.903226	2.91193578	Fervidobacterium sp.	1871331	Bacteria	Bacteria	48.9	7.06e-5	NR	MDM7321177.1	1871331	g49446	i0	87	0.450980392156863	23	3	45.1	0	83	15	1	23	MDM7321177.1 hypothetical protein [Fervidobacterium sp.]	diamond	69	48.9	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);;