metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax_phylum = "Acidobacteriota"

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
2248886	2248886	PRJNA986481_P_NODE_41342_length_262_cov_0.948357_g40817_i0	PRJNA986481	41342	262	0.948357	2.48469534	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	97.1	1.09e-15	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g40817	i0	87.805	1.81297709923664	82	10	31	0	161	242	7654650	7654569	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	475	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
2249212	2249212	PRJNA986481_P_NODE_61422_length_235_cov_2.064516_g60897_i0	PRJNA986481	61422	235	2.064516	4.8516126	Paludibaculum fermentans	1473598	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g60897	i0	99.574	100.182978723404	235	1	100	0	1	235	4786635	4786869	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	23543	429	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
6076609	6076609	PRJNA986481_P_NODE_24405_length_332_cov_1.996466_g23880_i0	PRJNA986481	24405	332	1.996466	6.62826712	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	453	7.34e-123	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g23880	i0	91.343	249.171686746988	335	24	100	5	1	332	151809	152141	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	82725	453	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
8626140	8626140	PRJNA986481_P_NODE_1027_length_1285_cov_9.845469_g584_i1	PRJNA986481	1027	1285	9.845469	126.51427665	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	1967	0	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g584	i1	94.41	94.0856031128405	1288	59	100	10	1	1285	634340	635617	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	120900	1967	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
11176787	11176787	PRJNA986481_P_NODE_25869_length_323_cov_1.127737_g25344_i0	PRJNA986481	25869	323	1.127737	3.64259051	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	189	2.2199999999999998e-43	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g25344	i0	81.858	16.0928792569659	226	39	70	2	20	244	1653664	1653440	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	5198	189	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12452805	12452805	PRJNA986481_P_NODE_37010_length_267_cov_41.412844_g36485_i0	PRJNA986481	37010	267	41.412844	110.57229348	Mesoterricola silvestris	2927979	Bacteria	Bacteria	405	1.63e-108	NTclustered	gi\|2490891634\|dbj\|AP027080.1\|	2927979	g36485	i0	96.341	148.483146067416	246	9	92	0	22	267	4786059	4785814	Mesoterricola silvestris W79 DNA, complete genome	blastn	39645	405	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola silvestris
20099675	20099675	PRJNA986481_P_NODE_1276_length_1186_cov_95.944591_g1049_i0	PRJNA986481	1276	1186	95.944591	1137.90284926	Paludibaculum fermentans	1473598	Bacteria	Bacteria	1391	0	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g1049	i0	89.8	151.807757166948	1098	94	92	17	1	1089	4785514	4786602	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	180044	1391	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
21375980	21375980	PRJNA986481_P_NODE_52577_length_249_cov_1.355000_g52052_i0	PRJNA986481	52577	249	1.355	3.37395	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g52052	i0	99.598	159.991967871486	249	1	100	0	1	249	633436	633684	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	39838	455	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
22651064	22651064	PRJNA986481_P_NODE_61938_length_231_cov_2.274725_g61413_i0	PRJNA986481	61938	231	2.274725	5.25461475	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	128	3.3299999999999998e-25	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g61413	i0	81.132	6.17316017316017	159	30	69	0	69	227	2967923	2967765	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	1426	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella 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);;