metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
474791	474791	PRJNA493828_P_NODE_32401_length_250_cov_3.282486_g31982_i0	PRJNA493828	32401	250	3.282486	8.206215	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	409	1.17e-109	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g31982	i0	96.748	124.74	246	7	98	1	6	250	359925	360170	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	31185	409	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
475071	475071	PRJNA493828_P_NODE_6061_length_448_cov_3.880000_g5668_i0	PRJNA493828	6061	448	3.88	17.3824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	564	4.5099999999999997e-156	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g5668	i0	89.509	213.977678571429	448	44	99	2	4	448	4233949	4233502	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	95862	564	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1749440	1749440	PRJNA493828_P_NODE_16622_length_307_cov_1.692308_g16203_i0	PRJNA493828	16622	307	1.692308	5.19538556	Paludibaculum fermentans	1473598	Bacteria	Bacteria	296	1.1999999999999999e-75	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g16203	i0	91.284	154.820846905537	218	17	71	2	8	224	4786181	4785965	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	47530	296	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
2382011	2382011	PRJNA493828_P_NODE_19702_length_288_cov_4.390698_g19283_i0	PRJNA493828	19702	288	4.390698	12.64521024	Bacteria	2	Bacteria	Bacteria	333	8.5e-87	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g19283	i0	87.586	123.267361111111	290	33	100	2	1	288	24	312	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	35501	333	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4301436	4301436	PRJNA493828_P_NODE_19164_length_290_cov_5.497696_g18745_i0	PRJNA493828	19164	290	5.497696	15.9433184	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	1.45e-74	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g18745	i0	86.296	129.965517241379	270	35	93	2	4	272	27	295	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	37690	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5578413	5578413	PRJNA493828_P_NODE_38565_length_242_cov_1.923077_g38146_i0	PRJNA493828	38565	242	1.923077	4.65384634	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	268	1.99e-67	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g38146	i0	88.106	65.2231404958678	227	25	93	2	4	228	4358385	4358611	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	15784	268	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6852253	6852253	PRJNA493828_P_NODE_22206_length_279_cov_8.917476_g21787_i0	PRJNA493828	22206	279	8.917476	24.87975804	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	436	6.069999999999999e-118	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g21787	i0	95.926	400.035842293907	270	9	96	2	11	279	10906	10638	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	111610	436	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8127573	8127573	PRJNA493828_P_NODE_16807_length_305_cov_4.844828_g16388_i0	PRJNA493828	16807	305	4.844828	14.7767254	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	438	1.8699999999999994e-118	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g16388	i0	92.605	110.019672131148	311	14	99	6	4	305	3556692	3556382	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	33556	438	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
9402809	9402809	PRJNA493828_P_NODE_36928_length_244_cov_2.567251_g36509_i0	PRJNA493828	36928	244	2.567251	6.26409244	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	346	9.019999999999999e-91	NTclustered	gi\|31789387\|gb\|AY281353.1\|	171953	g36509	i0	92.213	114.55737704918	244	19	100	0	1	244	30101	29858	Uncultured Acidobacteria bacterium clone 32d1 genomic sequence	blastn	27952	346	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15777489	15777489	PRJNA493828_P_NODE_40933_length_237_cov_3.121951_g40514_i0	PRJNA493828	40933	237	3.121951	7.39902387	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	292	1.15e-74	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g40514	i0	90.265	436.616033755274	226	19	95	3	4	229	3556599	3556377	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	103478	292	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
17052200	17052200	PRJNA493828_P_NODE_41274_length_236_cov_2.521472_g40855_i0	PRJNA493828	41274	236	2.521472	5.95067392	Paludibaculum fermentans	1473598	Bacteria	Bacteria	335	1.8799999999999996e-87	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g40855	i0	92.34	107.385593220339	235	18	99	0	1	235	4786457	4786223	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	25343	335	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
18326525	18326525	PRJNA493828_P_NODE_41575_length_235_cov_2.419753_g41156_i0	PRJNA493828	41575	235	2.419753	5.68641955	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	327	3.12e-85	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g41156	i0	96.02	61.0978723404255	201	8	86	0	2	202	634730	634930	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	14358	327	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
18326580	18326580	PRJNA493828_P_NODE_45715_length_213_cov_4.828571_g45296_i0	PRJNA493828	45715	213	4.828571	10.28485623	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	388	1.26e-103	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g45296	i0	99.531	315.943661971831	213	1	100	0	1	213	4572846	4572634	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	67296	388	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
20232799	20232799	PRJNA493828_P_NODE_14956_length_310_cov_3.523207_g14537_i0	PRJNA493828	14956	310	3.523207	10.9219417	Bacteria	2	Bacteria	Bacteria	132	3.62e-26	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g14537	i0	82.781	4.92258064516129	151	23	48	3	162	310	1278461	1278312	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	1526	132	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20876244	20876244	PRJNA493828_P_NODE_13257_length_320_cov_4.291498_g12838_i0	PRJNA493828	13257	320	4.291498	13.7327936	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	372	2.03e-98	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g12838	i0	87.963	220.65	324	27	99	11	3	320	2618172	2618489	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	70608	372	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
20876620	20876620	PRJNA493828_P_NODE_40637_length_238_cov_3.145455_g40218_i0	PRJNA493828	40637	238	3.145455	7.4861829	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	363	8.69e-96	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g40218	i0	94.492	152.59243697479	236	11	99	2	1	235	715727	715961	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	36317	363	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20876651	20876651	PRJNA493828_P_NODE_43457_length_228_cov_2.961290_g43038_i0	PRJNA493828	43457	228	2.96129	6.7517412	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	303	5.08e-78	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g43038	i0	92.093	99.0570175438596	215	17	94	0	3	217	634138	633924	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	22585	303	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183

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