metadata: contig_metadata: 6 rows where bioproject = "PRJNA326068", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA326068", 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
1664122	1664122	PRJNA326068_P_NODE_12222_length_266_cov_4.810127_g11259_i0	PRJNA326068	12222	266	4.810127	12.79493782	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	204	6.35e-48	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g11259	i0	80.597	73.8834586466165	268	48	100	4	1	266	5031735	5031470	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	19653	204	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
6767024	6767024	PRJNA326068_P_NODE_14406_length_227_cov_6.949495_g13443_i0	PRJNA326068	14406	227	6.949495	15.77535365	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	250	6.68e-62	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g13443	i0	87.444	172.083700440529	223	21	99	5	7	227	5031458	5031241	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	39063	250	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
8042739	8042739	PRJNA326068_P_NODE_9007_length_342_cov_22.035144_g8053_i0	PRJNA326068	9007	342	22.035144	75.36019248	Vulcanimicrobium alpinum	3016050	Bacteria	Bacteria	111	5.26e-20	NTclustered	gi\|2416250577\|dbj\|AP025523.1\|	3016050	g8053	i0	98.413	24.1812865497076	63	1	18	0	278	340	1951529	1951591	Vulcanimicrobium alpinum WC8-2 DNA, complete genome	blastn	8270	111	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Vulcanimicrobium	Vulcanimicrobium alpinum
13143003	13143003	PRJNA326068_P_NODE_5831_length_455_cov_102.025822_g4967_i0	PRJNA326068	5831	455	102.025822	464.2174901	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	409	2.2699999999999996e-109	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g4967	i0	83.153	277.8	463	62	100	15	1	455	5032399	5031945	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	126399	409	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
23341345	23341345	PRJNA326068_P_NODE_2419_length_702_cov_82.080238_g1854_i0	PRJNA326068	2419	702	82.080238	576.20327076	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1011	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1854	i0	92.98	488.974358974359	698	41	99	5	1	696	5032131	5032822	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	343260	1011	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
24615517	24615517	PRJNA326068_P_NODE_15400_length_215_cov_201.849462_g14437_i0	PRJNA326068	15400	215	201.849462	433.9763433	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	326	1.01e-84	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g14437	i0	94.037	296.218604651163	218	8	100	5	1	215	5032160	5031945	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	63687	326	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota 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);;