metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1123436" 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
279001	279001	PRJNA1123436_P_NODE_113641_length_245_cov_0.895349_g112427_i0	PRJNA1123436	113641	245	0.895349	2.19360505	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	219	2.0599999999999993e-52	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g112427	i0	84.305	55.5918367346939	223	35	91	0	1	223	2191598	2191820	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	13620	219	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1553391	1553391	PRJNA1123436_P_NODE_106262_length_248_cov_0.880000_g105048_i0	PRJNA1123436	106262	248	0.88	2.1824	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|2107779373\|gb\|CP070829.1\|	2448054	g105048	i0	84.615	12.633064516129	247	36	100	2	1	246	3599111	3599356	MAG: Gemmatimonadales bacterium isolate bin109 chromosome	blastn	3133	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
1553499	1553499	PRJNA1123436_P_NODE_111802_length_246_cov_0.890173_g110588_i0	PRJNA1123436	111802	246	0.890173	2.18982558	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	183	7.549999999999997e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g110588	i0	82.192	16.0487804878049	219	33	88	6	1	216	876328	876113	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3948	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2831501	2831501	PRJNA1123436_P_NODE_98243_length_250_cov_0.870056_g97029_i0	PRJNA1123436	98243	250	0.870056	2.17514	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g97029	i0	86.056	86.084	251	33	100	2	1	250	1454496	1454247	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	21521	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5382028	5382028	PRJNA1123436_P_NODE_109605_length_247_cov_0.867816_g108391_i0	PRJNA1123436	109605	247	0.867816	2.14350552	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2893358440\|emb\|OZ220732.1\|	2910168	g108391	i0	100	0.11336032388664	28	0	11	0	175	202	3179095	3179122	MAG: Longimicrobiales bacterium isolate 1657d605-667c-4cd4-94fa-5f7303d281ff genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
5382774	5382774	PRJNA1123436_P_NODE_36525_length_420_cov_1.109510_g35311_i0	PRJNA1123436	36525	420	1.10951	4.659942	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	187	1.0599999999999999e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g35311	i0	81.818	36.2166666666667	231	34	53	6	1	224	5449407	5449178	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	15211	187	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7931739	7931739	PRJNA1123436_P_NODE_103167_length_249_cov_0.875000_g101953_i0	PRJNA1123436	103167	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	106	1.71e-18	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g101953	i0	86.139	2.03212851405622	101	10	40	3	54	152	1396893	1396795	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	506	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7931914	7931914	PRJNA1123436_P_NODE_112707_length_246_cov_0.890173_g111493_i0	PRJNA1123436	112707	246	0.890173	2.18982558	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	78.7	3.67e-10	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g111493	i0	88.889	3.90243902439024	63	7	26	0	3	65	1821097	1821159	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	960	78.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10483965	10483965	PRJNA1123436_P_NODE_78349_length_281_cov_1.394231_g77135_i0	PRJNA1123436	78349	281	1.394231	3.91778911	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	159	1.48e-34	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g77135	i0	82.703	58.8434163701068	185	26	65	5	78	259	2078021	2078202	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	16535	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
11759410	11759410	PRJNA1123436_P_NODE_99230_length_250_cov_0.870056_g98016_i0	PRJNA1123436	99230	250	0.870056	2.17514	uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_1650	1665094	Bacteria	Bacteria	135	2.1900000000000003e-27	NTclustered	gi\|874574182\|gb\|KT006960.1\|	1665094	g98016	i0	82.895	1.792	152	24	60	2	4	154	23390	23240	Uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_1650 genomic sequence	blastn	448	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_1650
13032351	13032351	PRJNA1123436_P_NODE_100171_length_250_cov_0.870056_g98957_i0	PRJNA1123436	100171	250	0.870056	2.17514	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	191	4.6e-44	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g98957	i0	82.018	9.568	228	37	90	4	25	250	584645	584420	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	2392	191	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14308083	14308083	PRJNA1123436_P_NODE_125672_length_241_cov_0.916667_g124458_i0	PRJNA1123436	125672	241	0.916667	2.20916747	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	189	1.58e-43	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g124458	i0	88.889	52.253112033195	153	17	63	0	26	178	1020810	1020658	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	12593	189	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16856009	16856009	PRJNA1123436_P_NODE_104774_length_248_cov_0.880000_g103560_i0	PRJNA1123436	104774	248	0.88	2.1824	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g103560	i0	91.6	91.8387096774194	250	17	100	4	1	248	749904	749657	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	22776	342	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
16856097	16856097	PRJNA1123436_P_NODE_109534_length_247_cov_0.885057_g108320_i0	PRJNA1123436	109534	247	0.885057	2.18609079	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	165	2.75e-36	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g108320	i0	80.357	29.9068825910931	224	38	89	6	3	223	1105533	1105753	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	7387	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16857550	16857550	PRJNA1123436_P_NODE_73854_length_289_cov_1.717593_g72640_i0	PRJNA1123436	73854	289	1.717593	4.96384377	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	165	3.29e-36	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g72640	i0	90.4	1.64359861591696	125	12	48	0	3	127	203547	203423	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	475	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18130764	18130764	PRJNA1123436_P_NODE_116755_length_244_cov_0.900585_g115541_i0	PRJNA1123436	116755	244	0.900585	2.1974274	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	69.4	2.19e-7	NTclustered	gi\|2108172456\|gb\|CP070716.1\|	2026742	g115541	i0	90.385	0.213114754098361	52	5	21	0	16	67	1331218	1331269	MAG: Gemmatimonadetes bacterium isolate bin486 chromosome	blastn	52	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
19404843	19404843	PRJNA1123436_P_NODE_114096_length_245_cov_0.895349_g112882_i0	PRJNA1123436	114096	245	0.895349	2.19360505	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	204	5.77e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g112882	i0	83.556	19.3020408163265	225	30	90	6	12	232	612822	612601	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4729	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19406453	19406453	PRJNA1123436_P_NODE_85796_length_267_cov_1.360825_g84582_i0	PRJNA1123436	85796	267	1.360825	3.63340275	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g84582	i0	94.595	0.138576779026217	37	1	14	1	154	190	304603	304638	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	37	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20681814	20681814	PRJNA1123436_P_NODE_73757_length_290_cov_0.714286_g72543_i0	PRJNA1123436	73757	290	0.714286	2.0714294	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	185	2.5399999999999998e-42	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g72543	i0	78.873	15.7172413793103	284	52	97	7	11	290	2818341	2818620	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	4558	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21955892	21955892	PRJNA1123436_P_NODE_121918_length_243_cov_0.905882_g120704_i0	PRJNA1123436	121918	243	0.905882	2.20129326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	309	1.1800000000000002e-79	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g120704	i0	89.958	92.320987654321	239	24	98	0	3	241	111986	111748	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	22434	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23231941	23231941	PRJNA1123436_P_NODE_39179_length_404_cov_0.858006_g37965_i0	PRJNA1123436	39179	404	0.858006	3.46634424	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	86.1	3.82e-12	NTclustered	gi\|2108325062\|gb\|CP070666.1\|	2026742	g37965	i0	86.25	0.198019801980198	80	10	20	1	134	212	1401721	1401642	MAG: Gemmatimonadetes bacterium isolate bin75 chromosome	blastn	80	86.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
24504949	24504949	PRJNA1123436_P_NODE_115840_length_245_cov_0.877907_g114626_i0	PRJNA1123436	115840	245	0.877907	2.15087215	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|2893358400\|emb\|OZ220691.1\|	2026742	g114626	i0	83.898	96.7591836734694	236	36	96	2	11	245	2076026	2076260	MAG: Gemmatimonadota bacterium isolate 1766b9ea-3269-4cc1-97f5-695b05480569 genome assembly, chromosome: 1	blastn	23706	224	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
24506265	24506265	PRJNA1123436_P_NODE_73460_length_290_cov_1.281106_g72246_i0	PRJNA1123436	73460	290	1.281106	3.7152074	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	196	1.17e-45	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g72246	i0	84.058	20.7103448275862	207	29	75	4	3	208	4885800	4885597	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	6006	196	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);;