metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax_phylum = "Gemmatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2771615	2771615	PRJNA1112809_P_NODE_56063_length_496_cov_1.848700_g52792_i0	PRJNA1112809	56063	496	1.8487	9.169552	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	231	5.799999999999999e-56	NTclustered	gi\|2518596698\|emb\|OX639991.1\|	2910168	g52792	i0	84.1	7.125	239	38	48	0	186	424	4424248	4424010	MAG: Longimicrobiales bacterium isolate affa3490-31b4-448a-b7fc-cc7950b7f85b genome assembly, chromosome: 1	blastn	3534	231	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
4046150	4046150	PRJNA1112809_P_NODE_139564_length_274_cov_1.532338_g136289_i0	PRJNA1112809	139564	274	1.532338	4.19860612	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	213	1.09e-50	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g136289	i0	81.712	32.985401459854	257	45	93	2	19	274	4498648	4498393	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	9038	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4046258	4046258	PRJNA1112809_P_NODE_145384_length_268_cov_1.502564_g142109_i0	PRJNA1112809	145384	268	1.502564	4.02687152	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	259	1.35e-64	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g142109	i0	84.211	16.0820895522388	266	42	99	0	3	268	5247503	5247768	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4310	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5321647	5321647	PRJNA1112809_P_NODE_111485_length_310_cov_1.624473_g108210_i0	PRJNA1112809	111485	310	1.624473	5.0358663	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2108172456\|gb\|CP070716.1\|	2026742	g108210	i0	100	0.0903225806451613	28	0	9	0	79	106	67837	67864	MAG: Gemmatimonadetes bacterium isolate bin486 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
5322628	5322628	PRJNA1112809_P_NODE_165265_length_251_cov_0.865169_g161990_i0	PRJNA1112809	165265	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	185	2.1499999999999994e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g161990	i0	86.747	44.4980079681275	166	22	66	0	86	251	1874736	1874571	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	11169	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5324117	5324117	PRJNA1112809_P_NODE_65425_length_441_cov_3.073370_g62151_i0	PRJNA1112809	65425	441	3.07337	13.5535617	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	697	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g62151	i0	97.33	95.7981859410431	412	7	100	4	1	410	1102785	1102376	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	42247	697	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
7871528	7871528	PRJNA1112809_P_NODE_107727_length_316_cov_2.329218_g104452_i0	PRJNA1112809	107727	316	2.329218	7.36032888	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	313	1.23e-80	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g104452	i0	84.783	100.142405063291	322	37	100	12	1	316	4128338	4128023	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	31645	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7872231	7872231	PRJNA1112809_P_NODE_144227_length_269_cov_1.571429_g140952_i0	PRJNA1112809	144227	269	1.571429	4.22714401	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	89.8	1.88e-13	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g140952	i0	93.333	0.947955390334573	60	4	22	0	7	66	1075325	1075266	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	255	89.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
11698165	11698165	PRJNA1112809_P_NODE_146350_length_267_cov_1.567010_g143075_i0	PRJNA1112809	146350	267	1.56701	4.1839167	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	263	1.04e-65	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g143075	i0	84.906	13.9925093632959	265	34	99	4	5	267	4020081	4019821	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3736	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12973377	12973377	PRJNA1112809_P_NODE_151991_length_261_cov_3.250000_g148716_i0	PRJNA1112809	151991	261	3.25	8.4825	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	414	2.63e-111	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g148716	i0	96.078	238.513409961686	255	9	97	1	1	254	1102310	1102056	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	62252	414	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
15522043	15522043	PRJNA1112809_P_NODE_144313_length_269_cov_1.566327_g141038_i0	PRJNA1112809	144313	269	1.566327	4.21341963	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	348	2.81e-91	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g141038	i0	90.769	62.7063197026022	260	24	97	0	2	261	4292592	4292333	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	16868	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17601128	17601128	PRJNA1112809_P_NODE_199794_length_226_cov_4.895425_g196519_i0	PRJNA1112809	199794	226	4.895425	11.0636605	Gemmatimonas	173479	Bacteria	Bacteria	333	6.41e-87	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g196519	i0	95.652	131.172566371681	207	9	92	0	20	226	2834	2628	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	29645	335	0.994029850746269	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
18070411	18070411	PRJNA1112809_P_NODE_112035_length_309_cov_1.834746_g108760_i0	PRJNA1112809	112035	309	1.834746	5.66936514	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	230	1.2399999999999998e-55	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g108760	i0	83.267	48.9255663430421	251	40	81	2	4	253	413827	413578	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	15118	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18070455	18070455	PRJNA1112809_P_NODE_114115_length_306_cov_1.300429_g110840_i0	PRJNA1112809	114115	306	1.300429	3.97931274	Gaopeijia maritima	3119007	Bacteria	Bacteria	233	9.5e-57	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g110840	i0	81.145	112.18954248366	297	50	96	6	13	306	961969	961676	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	34330	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
20622563	20622563	PRJNA1112809_P_NODE_77337_length_392_cov_1.526646_g74062_i0	PRJNA1112809	77337	392	1.526646	5.98445232	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	407	6.94e-109	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g74062	i0	85.496	105.640306122449	393	53	99	4	2	392	5000622	5001012	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	41411	407	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20622711	20622711	PRJNA1112809_P_NODE_84297_length_369_cov_3.016892_g81022_i0	PRJNA1112809	84297	369	3.016892	11.13233148	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	132	4.38e-26	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g81022	i0	81.325	0.848238482384824	166	28	45	3	1	165	183734	183571	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	313	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21896827	21896827	PRJNA1112809_P_NODE_177658_length_246_cov_1.421965_g174383_i0	PRJNA1112809	177658	246	1.421965	3.4980339	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g174383	i0	90.678	141.939024390244	236	19	95	3	13	246	8175790	8175556	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	34917	311	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21898638	21898638	PRJNA1112809_P_NODE_92618_length_347_cov_2.883212_g89343_i0	PRJNA1112809	92618	347	2.883212	10.00474564	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	451	2.77e-122	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g89343	i0	90.173	37.5302593659942	346	34	99	0	2	347	1101488	1101833	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	13023	451	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
23172028	23172028	PRJNA1112809_P_NODE_161819_length_252_cov_2.770950_g158544_i0	PRJNA1112809	161819	252	2.77095	6.982794	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	285	2.07e-72	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g158544	i0	87.5	536.801587301587	248	29	98	2	3	249	1593084	1593330	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	135274	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales 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);;