metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_clade = "delta/epsilon subdivisions"

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_clade	tax_class	tax_genus	tax_species
2168337	2168337	PRJNA911178_P_NODE_300202_length_234_cov_2.236025_g297728_i0	PRJNA911178	300202	234	2.236025	5.2322985	uncultured delta proteobacterium	34034	Bacteria	Bacteria	331	2.4e-86	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g297728	i0	97.917	0.82051282051282	192	3	82	1	44	234	1331662	1331853	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	192	331	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
5995228	5995228	PRJNA911178_P_NODE_184985_length_280_cov_1.454106_g182512_i0	PRJNA911178	184985	280	1.454106	4.0714968	uncultured delta proteobacterium	34034	Bacteria	Bacteria	324	4.9499999999999995e-84	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g182512	i0	87.544	140.778571428571	281	33	100	2	1	280	83116	82837	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	39418	324	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
5996371	5996371	PRJNA911178_P_NODE_41685_length_532_cov_3.407407_g39274_i0	PRJNA911178	41685	532	3.407407	18.12740524	uncultured delta proteobacterium	34034	Bacteria	Bacteria	281	6.12e-71	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g39274	i0	76.636	61.4906015037594	535	110	99	13	1	525	1541657	1541128	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	32713	281	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
7269593	7269593	PRJNA911178_P_NODE_120646_length_334_cov_1.494253_g118174_i0	PRJNA911178	120646	334	1.494253	4.99080502	uncultured delta proteobacterium	34034	Bacteria	Bacteria	424	5.79e-114	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g118174	i0	90.402	80.8952095808383	323	30	96	1	6	327	82188	82510	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	27019	424	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
7271282	7271282	PRJNA911178_P_NODE_36626_length_565_cov_2.884146_g34236_i0	PRJNA911178	36626	565	2.884146	16.2954249	uncultured delta proteobacterium	34034	Bacteria	Bacteria	774	0	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g34236	i0	91.504	195.886725663717	565	45	99	3	3	565	83941	83378	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	110676	774	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
8544974	8544974	PRJNA911178_P_NODE_196047_length_274_cov_1.273632_g193574_i0	PRJNA911178	196047	274	1.273632	3.48975168	uncultured delta proteobacterium	34034	Bacteria	Bacteria	274	4.93e-69	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g193574	i0	85.075	96.8868613138686	268	40	98	0	1	268	83435	83702	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	26547	274	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
8545029	8545029	PRJNA911178_P_NODE_20247_length_747_cov_3.632047_g18086_i0	PRJNA911178	20247	747	3.632047	27.13139109	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1319	0	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g18086	i0	98.527	320.823293172691	747	11	100	0	1	747	82750	82004	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	239655	1319	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
9820564	9820564	PRJNA911178_P_NODE_266128_length_246_cov_0.890173_g263654_i0	PRJNA911178	266128	246	0.890173	2.18982558	uncultured delta proteobacterium	34034	Bacteria	Bacteria	294	3.34e-75	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g263654	i0	88.259	2.00406504065041	247	28	100	1	1	246	82422	82176	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	493	294	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
11096982	11096982	PRJNA911178_P_NODE_78909_length_399_cov_2.920245_g76443_i0	PRJNA911178	78909	399	2.920245	11.65177755	uncultured delta proteobacterium	34034	Bacteria	Bacteria	580	3.94e-161	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g76443	i0	92.982	121.699248120301	399	27	99	1	1	398	81998	82396	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	48558	580	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
12370844	12370844	PRJNA911178_P_NODE_159410_length_297_cov_0.968750_g156937_i0	PRJNA911178	159410	297	0.96875	2.8771875	uncultured delta proteobacterium	34034	Bacteria	Bacteria	322	1.9e-83	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g156937	i0	86.288	308.265993265993	299	38	100	3	1	297	82521	82224	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	91555	322	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
12372254	12372254	PRJNA911178_P_NODE_45250_length_513_cov_1.529545_g42828_i0	PRJNA911178	45250	513	1.529545	7.84656585	uncultured delta proteobacterium	34034	Bacteria	Bacteria	643	6.509999999999999e-180	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g42828	i0	89.432	492.528265107212	511	53	99	1	3	513	83920	83411	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	252667	643	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
13646920	13646920	PRJNA911178_P_NODE_57011_length_461_cov_4.389175_g54572_i0	PRJNA911178	57011	461	4.389175	20.23409675	uncultured delta proteobacterium	34034	Bacteria	Bacteria	813	0	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g54572	i0	98.482	424.713665943601	461	7	100	0	1	461	83397	83857	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	195793	813	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
17470041	17470041	PRJNA911178_P_NODE_163494_length_293_cov_2.440909_g161021_i0	PRJNA911178	163494	293	2.440909	7.15186337	uncultured delta proteobacterium	34034	Bacteria	Bacteria	486	6.2799999999999984e-133	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g161021	i0	97.535	160.266211604096	284	7	97	0	10	293	81872	81589	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	46958	486	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
17827643	17827643	PRJNA911178_P_NODE_245634_length_250_cov_0.870056_g243160_i0	PRJNA911178	245634	250	0.870056	2.17514	Acidobacteriota	57723	Bacteria	Bacteria	355	1.54e-93	NTclustered	gi\|319659418\|gb\|HM565063.1\|	558712	g243160	i0	93.004	90.668	243	17	97	0	8	250	7	249	Uncultured Desulfocaldus sp. clone N-181 16S ribosomal RNA gene, partial sequence	blastn	22667	355	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Desulfocaldus	uncultured Desulfocaldus sp.
17827878	17827878	PRJNA911178_P_NODE_299754_length_234_cov_3.521739_g297280_i0	PRJNA911178	299754	234	3.521739	8.24086926	root	1	Root_unresolved	Root_unresolved	433	6.41e-117	NTclustered	gi\|219917285\|emb\|AM936907.1\|	34034	g297280	i0	100	99.974358974359	234	0	100	0	1	234	689	922	Uncultured delta proteobacterium partial 16S rRNA gene, clone CM14G7	blastn	23394	433	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
18743173	18743173	PRJNA911178_P_NODE_145855_length_308_cov_3.170213_g143382_i0	PRJNA911178	145855	308	3.170213	9.76425604	uncultured delta proteobacterium	34034	Bacteria	Bacteria	449	8.73e-122	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g143382	i0	93.443	301.590909090909	305	17	98	3	1	303	83070	83373	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	92890	449	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
18745096	18745096	PRJNA911178_P_NODE_85255_length_386_cov_3.115016_g82787_i0	PRJNA911178	85255	386	3.115016	12.02396176	uncultured delta proteobacterium	34034	Bacteria	Bacteria	708	0	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g82787	i0	99.741	111.782383419689	386	1	100	0	1	386	83413	83028	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	43148	708	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
20019588	20019588	PRJNA911178_P_NODE_303236_length_229_cov_3.429487_g300762_i0	PRJNA911178	303236	229	3.429487	7.85352523	uncultured delta proteobacterium	34034	Bacteria	Bacteria	394	2.9499999999999995e-105	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g300762	i0	97.807	0.995633187772926	228	5	99	0	2	229	82437	82210	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	228	394	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
20376364	20376364	PRJNA911178_P_NODE_229296_length_256_cov_1.666667_g226822_i0	PRJNA911178	229296	256	1.666667	4.26666752	Bacteria	2	Bacteria	Bacteria	342	1.2299999999999997e-89	NTclustered	gi\|116811023\|emb\|AM157614.1\|	34034	g226822	i0	91.27	97.16015625	252	20	98	2	3	253	163	413	Uncultured delta proteobacterium partial 16S rRNA gene, clone MU053	blastn	24873	342	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
21294864	21294864	PRJNA911178_P_NODE_299777_length_234_cov_3.385093_g297303_i0	PRJNA911178	299777	234	3.385093	7.92111762	uncultured delta proteobacterium	34034	Bacteria	Bacteria	267	6.87e-67	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g297303	i0	88.053	194.589743589744	226	26	96	1	10	234	83397	83172	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	45534	267	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
21652343	21652343	PRJNA911178_P_NODE_244757_length_250_cov_1.553672_g242283_i0	PRJNA911178	244757	250	1.553672	3.88418	root	1	Root_unresolved	Root_unresolved	446	8.89e-121	NTclustered	gi\|443301439\|emb\|HE613616.1\|	34034	g242283	i0	99.59	97.08	244	1	98	0	1	244	719	476	Uncultured delta proteobacterium partial 16S rRNA gene, clone A60B0W9	blastn	24270	446	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
22927523	22927523	PRJNA911178_P_NODE_177558_length_284_cov_2.184834_g175085_i0	PRJNA911178	177558	284	2.184834	6.20492856	Bdellovibrionota	3018035	Bacteria	Bacteria	514	2.78e-141	NTclustered	gi\|343206979\|gb\|JN371756.1\|	34034	g175085	i0	99.296	96.080985915493	284	2	100	0	1	284	426	143	Uncultured delta proteobacterium clone B12-54 16S ribosomal RNA gene, partial sequence	blastn	27287	514	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
22928470	22928470	PRJNA911178_P_NODE_89478_length_378_cov_5.163934_g87008_i0	PRJNA911178	89478	378	5.163934	19.51967052	Pseudomonadota	1224	Bacteria	Bacteria	680	0	NTclustered	gi\|194452251\|gb\|EU849395.1\|	34034	g87008	i0	99.731	97.8650793650794	372	0	98	1	1	371	674	303	Uncultured delta proteobacterium clone TTJFR349 16S ribosomal RNA gene, partial sequence	blastn	36993	686	0.991253644314869	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
23845461	23845461	PRJNA911178_P_NODE_49779_length_490_cov_10.563549_g47351_i0	PRJNA911178	49779	490	10.563549	51.7613901	uncultured delta proteobacterium	34034	Bacteria	Bacteria	734	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g47351	i0	93.84	184.626530612245	487	30	99	0	4	490	14167	14653	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	90467	734	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium

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