metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA393181" 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
410634	410634	PRJNA393181_S_NODE_35381_length_184_cov_1.061224_g35275_i0	PRJNA393181	35381	184	1.061224	1.95265216	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874253636\|emb\|OY968762.1\|	3107663	g35275	i0	96.875	0.173913043478261	32	1	17	0	110	141	1987272	1987303	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
410985	410985	PRJNA393181_S_NODE_7341_length_438_cov_4.264339_g7235_i0	PRJNA393181	7341	438	4.264339	18.67780482	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	285	3.83e-72	NTclustered	gi\|2874253918\|emb\|OY970243.1\|	3107663	g7235	i0	79.167	13.1187214611872	432	75	97	15	10	434	245668	245245	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1	blastn	5746	285	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
1685467	1685467	PRJNA393181_S_NODE_342_length_1118_cov_3.284921_g300_i0	PRJNA393181	342	1118	3.284921	36.72541678	Vulcanimicrobium alpinum	3016050	Bacteria	Bacteria	551	9.199999999999999e-152	NTclustered	gi\|2416250577\|dbj\|AP025523.1\|	3016050	g300	i0	79.048	24.8980322003578	840	148	74	22	136	958	2421877	2422705	Vulcanimicrobium alpinum WC8-2 DNA, complete genome	blastn	27836	551	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Vulcanimicrobium	Vulcanimicrobium alpinum
13164126	13164126	PRJNA393181_S_NODE_24051_length_235_cov_3.227273_g23945_i0	PRJNA393181	24051	235	3.227273	7.58409155	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	141	4.37e-29	NTclustered	gi\|2874253824\|emb\|OY969808.1\|	3107663	g23945	i0	78.733	6.88510638297872	221	39	92	8	1	217	4095933	4095717	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.1 genome assembly, chromosome: 1	blastn	1618	141	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
20812634	20812634	PRJNA393181_S_NODE_6517_length_462_cov_2.336471_g6411_i0	PRJNA393181	6517	462	2.336471	10.79449602	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	52.8	0.045	NTclustered	gi\|2874254122\|emb\|OY970207.1\|	3107663	g6411	i0	100	0.0606060606060606	28	0	6	0	2	29	1290823	1290850	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1	blastn	28	52.8	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);;