metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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_order	tax_family	tax_genus	tax_species
4127303	4127303	PRJNA1148190_P_NODE_802784_length_230_cov_2.114650_g791611_i0	PRJNA1148190	802784	230	2.11465	4.863695	Bradymonas sediminis	1548548	Bacteria	Bacteria	63.9	9.49e-6	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g791611	i0	82.432	0.926086956521739	74	11	31	1	122	193	1050213	1050286	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	213	63.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
5399712	5399712	PRJNA1148190_P_NODE_502125_length_266_cov_1.523316_g490952_i0	PRJNA1148190	502125	266	1.523316	4.05202056	uncultured delta proteobacterium	34034	Bacteria	Bacteria	69.4	2.42e-7	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g490952	i0	100	0.139097744360902	37	0	14	0	222	258	4043896	4043860	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	37	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6672550	6672550	PRJNA1148190_P_NODE_369146_length_294_cov_0.832579_g357973_i0	PRJNA1148190	369146	294	0.832579	2.44778226	uncultured delta proteobacterium	34034	Bacteria	Bacteria	477	3.8e-130	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g357973	i0	95.918	198.125850340136	294	12	100	0	1	294	14430	14723	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	58249	477	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7946541	7946541	PRJNA1148190_P_NODE_288407_length_325_cov_1.051587_g277236_i0	PRJNA1148190	288407	325	1.051587	3.41765775	Bradymonas sediminis	1548548	Bacteria	Bacteria	219	2.85e-52	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g277236	i0	81.887	75.7969230769231	265	42	81	5	1	262	4092621	4092882	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	24634	219	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
8688790	8688790	PRJNA1148190_P_NODE_568007_length_253_cov_2.177778_g556834_i0	PRJNA1148190	568007	253	2.177778	5.50977834	Bacteria	2	Bacteria	Bacteria	217	7.689999999999999e-52	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g556834	i0	82.49	128.774703557312	257	36	99	9	2	253	5713979	5714231	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	32580	217	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10499015	10499015	PRJNA1148190_P_NODE_412729_length_284_cov_1.094787_g401556_i0	PRJNA1148190	412729	284	1.094787	3.10919508	uncultured delta proteobacterium	34034	Bacteria	Bacteria	76.8	1.56e-9	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g401556	i0	90	0.795774647887324	60	4	20	2	17	74	3808349	3808408	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	226	76.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
11238878	11238878	PRJNA1148190_P_NODE_535949_length_260_cov_0.882353_g524776_i0	PRJNA1148190	535949	260	0.882353	2.2941178	Thermodesulfobacteriota	200940	Bacteria	Bacteria	222	1.71e-53	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g524776	i0	91.566	59.6923076923077	166	7	63	5	49	212	2201694	2201534	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	15520	224	0.991071428571429	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12513695	12513695	PRJNA1148190_P_NODE_376550_length_291_cov_1.486239_g365377_i0	PRJNA1148190	376550	291	1.486239	4.32495549	Bacteria	2	Bacteria	Bacteria	239	1.93e-58	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g365377	i0	81.507	19.9587628865979	292	52	100	2	1	291	6948111	6948401	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	5808	241	0.991701244813278	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13054055	13054055	PRJNA1148190_P_NODE_803391_length_229_cov_2.589744_g792218_i0	PRJNA1148190	803391	229	2.589744	5.93051376	uncultured delta proteobacterium	34034	Bacteria	Bacteria	196	8.92e-46	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g792218	i0	82.883	24.1135371179039	222	34	96	4	8	227	2386328	2386547	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	5522	196	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18150718	18150718	PRJNA1148190_P_NODE_691135_length_246_cov_0.890173_g679962_i0	PRJNA1148190	691135	246	0.890173	2.18982558	uncultured delta proteobacterium	34034	Bacteria	Bacteria	178	3.5099999999999993e-40	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g679962	i0	80.08	26.6138211382114	251	40	100	9	1	246	569152	569397	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	6547	178	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
19420685	19420685	PRJNA1148190_P_NODE_357296_length_298_cov_1.026667_g346123_i0	PRJNA1148190	357296	298	1.026667	3.05946766	uncultured delta proteobacterium	34034	Bacteria	Bacteria	239	1.98e-58	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g346123	i0	83.525	56.3288590604027	261	38	87	3	1	260	5575420	5575164	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	16786	239	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
21975237	21975237	PRJNA1148190_P_NODE_649598_length_248_cov_0.880000_g638425_i0	PRJNA1148190	649598	248	0.88	2.1824	Persicimonas caeni	2292766	Bacteria	Bacteria	73.1	1.72e-8	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g638425	i0	77.344	1.03225806451613	128	25	51	4	1	126	397293	397168	Persicimonas caeni strain YN101 chromosome	blastn	256	73.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
21976835	21976835	PRJNA1148190_P_NODE_775858_length_241_cov_1.375000_g764685_i0	PRJNA1148190	775858	241	1.375	3.31375	uncultured delta proteobacterium	34034	Bacteria	Bacteria	414	2.3999999999999993e-111	NTclustered	gi\|511202521\|gb\|KC994752.1\|	34034	g764685	i0	97.925	99.9170124481328	241	1	100	1	1	241	468	232	Uncultured delta proteobacterium clone BF 072 16S ribosomal RNA gene, partial sequence	blastn	24080	414	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22711694	22711694	PRJNA1148190_P_NODE_324938_length_310_cov_1.135021_g313765_i0	PRJNA1148190	324938	310	1.135021	3.5185651	Bacteria	2	Bacteria	Bacteria	104	7.88e-18	NTclustered	gi\|2190143862\|gb\|CP085041.1\|	1750598	g313765	i0	90.909	31.0354838709677	77	7	25	0	150	226	836224	836148	Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome	blastn	9621	104	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Dissulfurimicrobium	Dissulfurimicrobium hydrothermale
23251494	23251494	PRJNA1148190_P_NODE_711259_length_245_cov_0.895349_g700086_i0	PRJNA1148190	711259	245	0.895349	2.19360505	Persicimonas caeni	2292766	Bacteria	Bacteria	167	7.57e-37	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g700086	i0	81.34	3.54285714285714	209	36	85	3	2	209	6277731	6277525	Persicimonas caeni strain YN101 chromosome	blastn	868	167	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
23987628	23987628	PRJNA1148190_P_NODE_470279_length_272_cov_1.703518_g459106_i0	PRJNA1148190	470279	272	1.703518	4.63356896	root	1	Root_unresolved	Root_unresolved	503	5.729999999999998e-138	NTclustered	gi\|1139283245\|emb\|LT697265.1\|	34034	g459106	i0	100	99.6727941176471	272	0	100	0	1	272	16	287	uncultured delta proteobacterium partial 16S rRNA gene, isolate 10T_22683	blastn	27111	503	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);;