metadata: contig_metadata: 13 rows where bioproject = "PRJNA1120203", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJNA1120203", tax_kingdom = "Bacillati" and tax_phylum = "Vulcanimicrobiota"

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
14304300	14304300	PRJNA1120203_P_NODE_83732_length_249_cov_0.875000_g82716_i0	PRJNA1120203	83732	249	0.875	2.17875	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	142	2.11e-39	NR	HMF27180.1	2952917	g82716	i0	85.5	1	83	12	100	0	1	249	67	149	HMF27180.1 sigma-54 dependent transcriptional regulator [Candidatus Cybelea sp.]	diamond	249	142	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
26753189	26753189	PRJNA1120203_P_NODE_100061_length_243_cov_0.905882_g99045_i0	PRJNA1120203	100061	243	0.905882	2.20129326	Candidatus Rubrimentiphilum sp.	3069591	Bacteria	Bacteria	109	4.22e-29	NR	HEX5274715.1	3069591	g99045	i0	81	0.777777777777778	63	12	77.8	0	190	2	1	63	HEX5274715.1 transposase [Candidatus Rubrimentiphilum sp.]	diamond	189	109	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Rubrimentiphilum	Candidatus Rubrimentiphilum sp.
27196337	27196337	PRJNA1120203_P_NODE_96322_length_244_cov_0.900585_g95306_i0	PRJNA1120203	96322	244	0.900585	2.1974274	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	111	1.59e-28	NR	HZZ00984.1	2952909	g95306	i0	84.7	1.48770491803279	59	9	72.5	0	2	178	141	199	HZZ00984.1 GNAT family N-acetyltransferase [Candidatus Baltobacteraceae bacterium]	diamond	363	111	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
28522938	28522938	PRJNA1120203_P_NODE_79387_length_251_cov_0.865169_g78371_i0	PRJNA1120203	79387	251	0.865169	2.17157419	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	137	2.88e-36	NR	HYM33078.1	2952917	g78371	i0	76.8	1.9601593625498	82	19	98	0	5	250	285	366	HYM33078.1 FAD-binding oxidoreductase [Candidatus Cybelea sp.]	diamond	492	137	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
28680844	28680844	PRJNA1120203_P_NODE_104187_length_241_cov_0.916667_g103171_i0	PRJNA1120203	104187	241	0.916667	2.20916747	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	145	1.4999999999999999e-40	NR	HLI97979.1	2952909	g103171	i0	83.8	0.995850622406639	80	13	99.6	0	240	1	152	231	HLI97979.1 hypothetical protein [Candidatus Baltobacteraceae bacterium]	diamond	240	145	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
28933354	28933354	PRJNA1120203_P_NODE_98208_length_244_cov_0.900585_g97192_i0	PRJNA1120203	98208	244	0.900585	2.1974274	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	84	1.16e-16	NR	HUO24395.1	2952903	g97192	i0	50	0.959016393442623	78	39	95.9	0	11	244	231	308	HUO24395.1 glycosyltransferase family 39 protein [Candidatus Aquilonibacter sp.]	diamond	234	84	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter sp.
29533205	29533205	PRJNA1120203_P_NODE_81630_length_250_cov_0.870056_g80614_i0	PRJNA1120203	81630	250	0.870056	2.17514	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	108	6.5e-28	NR	HEV3152721.1	2952909	g80614	i0	61.4	0.996	83	30	97.2	1	1	243	1	83	HEV3152721.1 phosphohistidine phosphatase SixA [Candidatus Baltobacteraceae bacterium]	diamond	249	108	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
29880722	29880722	PRJNA1120203_P_NODE_86791_length_248_cov_0.880000_g85775_i0	PRJNA1120203	86791	248	0.88	2.1824	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	50.8	5.56e-6	NR	HXE74430.1	3036772	g85775	i0	79.3	0.350806451612903	29	6	35.1	0	2	88	63	91	HXE74430.1 hypothetical protein [Candidatus Xenobia bacterium]	diamond	87	50.8	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia				Candidatus Xenobia bacterium
29912302	29912302	PRJNA1120203_P_NODE_88571_length_247_cov_0.885057_g87555_i0	PRJNA1120203	88571	247	0.885057	2.18609079	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	49.7	1.11e-4	NR	HEX8805761.1	2952903	g87555	i0	50.7	0.862348178137652	71	26	86.2	2	246	34	176	237	HEX8805761.1 ATP-binding protein [Candidatus Aquilonibacter sp.]	diamond	213	49.7	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter sp.
30038497	30038497	PRJNA1120203_P_NODE_91911_length_246_cov_0.890173_g90895_i0	PRJNA1120203	91911	246	0.890173	2.18982558	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	149	1.87e-39	NR	HZW91694.1	3069296	g90895	i0	93.9	3	82	5	100	0	1	246	223	304	HZW91694.1 TonB-dependent receptor [Candidatus Eremiobacteraceae bacterium]	diamond	738	149	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae		Candidatus Eremiobacteraceae bacterium
30859968	30859968	PRJNA1120203_P_NODE_99654_length_243_cov_0.905882_g98638_i0	PRJNA1120203	99654	243	0.905882	2.20129326	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	47.8	6.46e-4	NR	HTU69158.1	2952909	g98638	i0	40.9	1.08641975308642	88	33	98.8	5	241	2	1324	1400	HTU69158.1 DUF6531 domain-containing protein [Candidatus Baltobacteraceae bacterium]	diamond	264	47.8	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
31460786	31460786	PRJNA1120203_P_NODE_92576_length_246_cov_0.890173_g91560_i0	PRJNA1120203	92576	246	0.890173	2.18982558	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	142	6.36e-38	NR	HEX8806587.1	2952903	g91560	i0	86.6	1	82	11	100	0	1	246	350	431	HEX8806587.1 amino acid permease [Candidatus Aquilonibacter sp.]	diamond	246	142	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter sp.
32788112	32788112	PRJNA1120203_P_NODE_95980_length_244_cov_1.339181_g94964_i0	PRJNA1120203	95980	244	1.339181	3.26760164	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	80.1	1.97e-16	NR	HZW93196.1	3069296	g94964	i0	65.8	0.897540983606557	73	25	89.8	0	230	12	6	78	HZW93196.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium]	diamond	219	80.1	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae		Candidatus Eremiobacteraceae bacterium

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);;