metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1111077" 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
215013	215013	PRJNA1111077_P_NODE_5021_length_509_cov_5.493119_g4800_i0	PRJNA1111077	5021	509	5.493119	27.95997571	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	385	4.32e-102	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g4800	i0	80.583	152.664047151277	515	82	100	9	1	509	1594945	1594443	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	77706	385	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1489165	1489165	PRJNA1111077_P_NODE_15342_length_310_cov_3.270042_g15121_i0	PRJNA1111077	15342	310	3.270042	10.1371302	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	87.9	7.94e-13	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g15121	i0	91.935	0.374193548387097	62	5	20	0	17	78	5208222	5208161	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	116	87.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1489232	1489232	PRJNA1111077_P_NODE_18102_length_294_cov_4.334842_g17881_i0	PRJNA1111077	18102	294	4.334842	12.74443548	uncultured Gemmatimonas sp.	221169	Bacteria	Bacteria	516	8.05e-142	NTclustered	gi\|219811751\|gb\|FJ551965.1\|	221169	g17881	i0	98.305	100.142857142857	295	3	100	2	1	294	316	23	Uncultured Gemmatimonas sp. clone LTSP_BACT_P4O22 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29442	516	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	uncultured Gemmatimonas sp.
2765239	2765239	PRJNA1111077_P_NODE_1843_length_768_cov_18.581295_g1644_i0	PRJNA1111077	1843	768	18.581295	142.7043456	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	963	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1644	i0	89.406	423.30078125	774	68	99	12	2	768	3043574	3042808	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	325095	963	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2765854	2765854	PRJNA1111077_P_NODE_8963_length_391_cov_29.452830_g8742_i0	PRJNA1111077	8963	391	29.45283	115.1605653	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	499	1.11e-136	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8742	i0	89.77	143.191815856777	391	39	100	1	1	391	3043303	3043692	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	55988	499	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4041368	4041368	PRJNA1111077_P_NODE_17704_length_296_cov_11.896861_g17483_i0	PRJNA1111077	17704	296	11.896861	35.21470856	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	217	9.21e-52	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g17483	i0	83.333	198.246621621622	246	29	81	11	3	243	2074720	2074958	Gemmatimonas phototrophica strain AP64, complete genome	blastn	58681	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
4041868	4041868	PRJNA1111077_P_NODE_5304_length_496_cov_3.607565_g5083_i0	PRJNA1111077	5304	496	3.607565	17.8935224	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	595	1.7799999999999994e-165	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g5083	i0	88.623	111.618951612903	501	42	100	13	1	496	1552950	1552460	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	55363	595	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
6592727	6592727	PRJNA1111077_P_NODE_22206_length_279_cov_3.946602_g21985_i0	PRJNA1111077	22206	279	3.946602	11.01101958	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	294	3.87e-75	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g21985	i0	87.5	332.799283154122	256	30	91	2	1	254	2077296	2077551	Gemmatimonas phototrophica strain AP64, complete genome	blastn	92851	294	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
12499824	12499824	PRJNA1111077_P_NODE_130_length_1984_cov_27.557823_g80_i0	PRJNA1111077	130	1984	27.557823	546.74720832	Gemmatimonas	173479	Bacteria	Bacteria	2918	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g80	i0	93.41	169.890120967742	1988	102	100	14	1	1984	1978	16	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	337062	2918	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
12968275	12968275	PRJNA1111077_P_NODE_13831_length_318_cov_9.632653_g13610_i0	PRJNA1111077	13831	318	9.632653	30.63183654	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	320	7.4e-83	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g13610	i0	87.633	35.6918238993711	283	25	87	9	5	281	231282	231560	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	11350	320	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
14243859	14243859	PRJNA1111077_P_NODE_4152_length_553_cov_5.887500_g3931_i0	PRJNA1111077	4152	553	5.8875	32.557875	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	532	1.59e-146	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g3931	i0	84.409	47.9312839059674	558	70	100	11	1	553	1102649	1103194	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	26506	532	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
16791731	16791731	PRJNA1111077_P_NODE_20254_length_286_cov_1.417840_g20033_i0	PRJNA1111077	20254	286	1.41784	4.0550224	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	313	1.1e-80	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g20033	i0	86.505	80.9475524475525	289	33	100	5	1	286	118597	118312	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	23151	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16791905	16791905	PRJNA1111077_P_NODE_26754_length_263_cov_10.221053_g26533_i0	PRJNA1111077	26754	263	10.221053	26.88136939	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	324	4.61e-84	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g26533	i0	89.098	344.300380228137	266	22	100	7	1	263	1904480	1904741	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	90551	324	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18066205	18066205	PRJNA1111077_P_NODE_175_length_1822_cov_32.540309_g80_i1	PRJNA1111077	175	1822	32.540309	592.88442998	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	2268	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g80	i1	89.313	266.998353457739	1834	160	99	21	2	1822	1468210	1466400	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	486471	2268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
18872782	18872782	PRJNA1111077_P_NODE_4435_length_536_cov_15.917927_g4214_i0	PRJNA1111077	4435	536	15.917927	85.32008872	Gemmatimonas	173479	Bacteria	Bacteria	610	6.929999999999997e-170	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g4214	i0	87.269	56.1212686567164	542	59	100	8	1	536	21	558	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	30081	610	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
19340872	19340872	PRJNA1111077_P_NODE_37036_length_239_cov_2.608434_g36815_i0	PRJNA1111077	37036	239	2.608434	6.23415726	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	252	1.97e-62	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g36815	i0	87.615	96.5523012552301	218	25	91	2	23	239	802578	802362	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	23076	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19340905	19340905	PRJNA1111077_P_NODE_38516_length_196_cov_4.910569_g38295_i0	PRJNA1111077	38516	196	4.910569	9.62471524	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	209	9.51e-50	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g38295	i0	86.364	54.7551020408163	198	19	99	7	2	195	231281	231474	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	10732	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
20147333	20147333	PRJNA1111077_P_NODE_1036_length_955_cov_20.763039_g80_i2	PRJNA1111077	1036	955	20.763039	198.28702245	Gemmatimonas	173479	Bacteria	Bacteria	1236	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g80	i2	90.094	369.862827225131	959	85	100	6	1	955	1026	1978	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	353219	1236	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
20616193	20616193	PRJNA1111077_P_NODE_4197_length_550_cov_9.918239_g3976_i0	PRJNA1111077	4197	550	9.918239	54.5503145	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	496	2.08e-135	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g3976	i0	83.303	16.9963636363636	551	79	100	9	1	550	1102649	1103187	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	9348	496	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
23166722	23166722	PRJNA1111077_P_NODE_12279_length_338_cov_6.973585_g12058_i0	PRJNA1111077	12279	338	6.973585	23.5707173	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	449	9.68e-122	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g12058	i0	91.124	236.825443786982	338	20	100	7	4	338	172212	171882	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	80047	449	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23973565	23973565	PRJNA1111077_P_NODE_8719_length_396_cov_5.619195_g8498_i0	PRJNA1111077	8719	396	5.619195	22.2520122	Gemmatimonadaceae	219687	Bacteria	Bacteria	143	2.19e-29	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8498	i0	84.459	2.77777777777778	148	20	37	3	250	396	3043644	3043499	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1100	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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