metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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
4111768	4111768	PRJNA1137393_P_NODE_42584_length_169_cov_0.866667_g42068_i0	PRJNA1137393	42584	169	0.866667	1.46466723	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	148	1.75e-31	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g42068	i0	86.567	8.2189349112426	134	18	79	0	1	134	4689604	4689737	Gemmatimonas phototrophica strain AP64, complete genome	blastn	1389	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
4111894	4111894	PRJNA1137393_P_NODE_9764_length_265_cov_2.208333_g9248_i0	PRJNA1137393	9764	265	2.208333	5.85208245	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	348	2.76e-91	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g9248	i0	91.188	149.350943396226	261	15	97	7	9	265	802205	801949	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	39578	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5387873	5387873	PRJNA1137393_P_NODE_20525_length_200_cov_2.178808_g20009_i0	PRJNA1137393	20525	200	2.178808	4.357616	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	239	1.24e-58	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g20009	i0	96.528	88.655	144	5	72	0	1	144	1103077	1103220	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	17731	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
5388063	5388063	PRJNA1137393_P_NODE_9185_length_274_cov_0.928889_g8669_i0	PRJNA1137393	9185	274	0.928889	2.54515586	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	248	2.99e-61	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g8669	i0	88.725	191.704379562044	204	21	74	2	1	202	802691	802894	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	52527	248	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6134920	6134920	PRJNA1137393_P_NODE_35605_length_173_cov_1.935484_g35089_i0	PRJNA1137393	35605	173	1.935484	3.34838732	root	1	Root_unresolved	Root_unresolved	172	1.07e-38	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g35089	i0	85.143	79.1734104046243	175	18	100	6	1	173	231347	231515	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	13697	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
6662507	6662507	PRJNA1137393_P_NODE_15346_length_220_cov_2.333333_g14830_i0	PRJNA1137393	15346	220	2.333333	5.1333326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.07e-64	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g14830	i0	88.288	14.8136363636364	222	19	100	5	1	220	1903338	1903554	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3259	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11763274	11763274	PRJNA1137393_P_NODE_10370_length_257_cov_5.769231_g9854_i0	PRJNA1137393	10370	257	5.7692310000000004	14.82692367	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	396	9.379999999999997e-106	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g9854	i0	95.547	157.750972762646	247	11	96	0	11	257	803510	803756	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	40542	396	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11763349	11763349	PRJNA1137393_P_NODE_31250_length_179_cov_2.100000_g30734_i0	PRJNA1137393	31250	179	2.1	3.759	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	185	1.43e-42	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g30734	i0	86.826	8.44692737430168	167	20	93	2	3	168	2075176	2075011	Gemmatimonas phototrophica strain AP64, complete genome	blastn	1512	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
14313577	14313577	PRJNA1137393_P_NODE_10852_length_252_cov_1.901478_g10336_i0	PRJNA1137393	10852	252	1.901478	4.79172456	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	361	3.34e-95	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10336	i0	92.49	17.4563492063492	253	17	100	2	1	252	3043564	3043815	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4399	361	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14313671	14313671	PRJNA1137393_P_NODE_41812_length_169_cov_0.866667_g41296_i0	PRJNA1137393	41812	169	0.866667	1.46466723	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g41296	i0	100	0.177514792899408	30	0	18	0	114	143	403654	403683	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14313780	14313780	PRJNA1137393_P_NODE_74172_length_159_cov_2.272727_g73656_i0	PRJNA1137393	74172	159	2.272727	3.61363593	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	233	4.38e-57	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g73656	i0	93.082	2	159	11	100	0	1	159	3043929	3043771	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	318	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15587647	15587647	PRJNA1137393_P_NODE_4933_length_399_cov_5.120000_g4418_i0	PRJNA1137393	4933	399	5.12	20.4288	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	499	1.14e-136	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g4418	i0	89.594	100.037593984962	394	39	98	2	2	394	421004	421396	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	39915	499	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19410653	19410653	PRJNA1137393_P_NODE_32596_length_177_cov_2.617188_g32080_i0	PRJNA1137393	32596	177	2.617188	4.63242276	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	239	1.07e-58	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g32080	i0	91.111	218.45197740113	180	10	100	6	1	177	1904741	1904565	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	38666	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20686101	20686101	PRJNA1137393_P_NODE_26777_length_186_cov_8.518248_g26261_i0	PRJNA1137393	26777	186	8.518248	15.84394128	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	204	4.15e-48	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g26261	i0	90.446	94.6881720430108	157	11	84	4	28	183	343510	343663	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	17612	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24510785	24510785	PRJNA1137393_P_NODE_73780_length_161_cov_4.000000_g73264_i0	PRJNA1137393	73780	161	4	6.44	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	150	4.61e-32	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g73264	i0	88.71	72.4472049689441	124	12	78	2	36	158	420757	420879	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	11664	150	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);;