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

21 rows where analysis = "blastn", bioproject = "PRJNA853203" 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
2116687	2116687	PRJNA853203_P_NODE_11702_length_285_cov_1.240566_g11553_i0	PRJNA853203	11702	285	1.240566	3.5356131	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	329	1.09e-85	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g11553	i0	87.805	2.0140350877193	287	28	99	5	1	283	2807239	2806956	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	574	329	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
2116808	2116808	PRJNA853203_P_NODE_29322_length_252_cov_0.871508_g29173_i0	PRJNA853203	29322	252	0.871508	2.19620016	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	219	2.13e-52	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g29173	i0	82.857	0.972222222222222	245	40	97	2	1	244	3726237	3726480	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	245	219	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
2116835	2116835	PRJNA853203_P_NODE_33822_length_249_cov_0.886364_g33673_i0	PRJNA853203	33822	249	0.886364	2.20704636	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	178	3.56e-40	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g33673	i0	87.179	0.626506024096386	156	20	63	0	20	175	3790357	3790202	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	156	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4669808	4669808	PRJNA853203_P_NODE_18804_length_269_cov_0.959184_g18655_i0	PRJNA853203	18804	269	0.959184	2.58020496	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	231	2.95e-56	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g18655	i0	82.331	2.08550185873606	266	47	99	0	4	269	2236636	2236371	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	561	231	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
7219471	7219471	PRJNA853203_P_NODE_13866_length_280_cov_1.082126_g13717_i0	PRJNA853203	13866	280	1.082126	3.0299528	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	259	1.42e-64	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g13717	i0	87.225	1.62142857142857	227	29	81	0	54	280	1752572	1752346	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	454	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
8494306	8494306	PRJNA853203_P_NODE_26747_length_253_cov_0.866667_g26598_i0	PRJNA853203	26747	253	0.866667	2.19266751	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	139	1.71e-28	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g26598	i0	83.333	0.592885375494071	150	25	59	0	9	158	276663	276812	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	150	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
8494382	8494382	PRJNA853203_P_NODE_35647_length_248_cov_0.891429_g35498_i0	PRJNA853203	35647	248	0.891429	2.21074392	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g35498	i0	81.279	0.883064516129032	219	31	86	10	35	248	1443499	1443712	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	219	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
9769538	9769538	PRJNA853203_P_NODE_36648_length_248_cov_0.891429_g36499_i0	PRJNA853203	36648	248	0.891429	2.21074392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g36499	i0	92.771	60.616935483871	249	17	100	1	1	248	421576	421824	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	15033	359	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9769595	9769595	PRJNA853203_P_NODE_45268_length_243_cov_0.917647_g45119_i0	PRJNA853203	45268	243	0.917647	2.22988221	Gaopeijia maritima	3119007	Bacteria	Bacteria	161	3.4899999999999997e-35	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g45119	i0	79.741	3.48559670781893	232	39	94	7	1	228	2651646	2651873	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	847	161	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
11045240	11045240	PRJNA853203_P_NODE_47969_length_242_cov_0.923077_g47820_i0	PRJNA853203	47969	242	0.923077	2.23384634	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	320	5.41e-83	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g47820	i0	90.496	2.96694214876033	242	23	100	0	1	242	1953725	1953966	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	718	320	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
11045274	11045274	PRJNA853203_P_NODE_8149_length_295_cov_1.756757_g8000_i0	PRJNA853203	8149	295	1.756757	5.18243315	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	268	2.5e-67	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g8000	i0	83.051	2	295	50	100	0	1	295	826307	826601	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	590	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
12320762	12320762	PRJNA853203_P_NODE_44190_length_244_cov_0.912281_g44041_i0	PRJNA853203	44190	244	0.912281	2.22596564	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	291	4.28e-74	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g44041	i0	88.115	2	244	29	100	0	1	244	1805419	1805176	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	488	291	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
12320763	12320763	PRJNA853203_P_NODE_44270_length_244_cov_0.912281_g44121_i0	PRJNA853203	44270	244	0.912281	2.22596564	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g44121	i0	84.536	13.3606557377049	194	30	80	0	50	243	3242481	3242288	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	3260	193	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13595196	13595196	PRJNA853203_P_NODE_30911_length_251_cov_0.876404_g30762_i0	PRJNA853203	30911	251	0.876404	2.19977404	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	337	5.609999999999998e-88	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g30762	i0	90.837	12.4382470119522	251	23	100	0	1	251	1074649	1074899	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	3122	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
18692886	18692886	PRJNA853203_P_NODE_48755_length_237_cov_3.347561_g48606_i0	PRJNA853203	48755	237	3.347561	7.93371957	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	176	1.21e-39	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g48606	i0	90.909	1.42616033755274	132	10	55	2	1	131	392459	392589	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	338	176	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
22518056	22518056	PRJNA853203_P_NODE_14918_length_277_cov_1.529412_g14769_i0	PRJNA853203	14918	277	1.529412	4.23647124	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	329	1.05e-85	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g14769	i0	88.129	4.52346570397112	278	31	100	2	1	277	2282905	2283181	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	1253	329	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
22518091	22518091	PRJNA853203_P_NODE_19318_length_267_cov_3.015464_g19169_i0	PRJNA853203	19318	267	3.015464	8.05128888	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	283	7.96e-72	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g19169	i0	85.821	2.00749063670412	268	36	100	2	1	267	2026983	2027249	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	536	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
23793537	23793537	PRJNA853203_P_NODE_12579_length_283_cov_1.052381_g12430_i0	PRJNA853203	12579	283	1.052381	2.97823823	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	128	4.22e-25	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g12430	i0	80.982	2.06360424028269	163	29	57	2	84	245	5736522	5736683	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	584	128	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25067436	25067436	PRJNA853203_P_NODE_12920_length_282_cov_1.210526_g12771_i0	PRJNA853203	12920	282	1.210526	3.41368332	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	200	8.78e-47	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g12771	i0	79.931	1.86524822695035	289	44	100	11	1	282	694765	695046	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	526	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25067612	25067612	PRJNA853203_P_NODE_37680_length_247_cov_0.896552_g37531_i0	PRJNA853203	37680	247	0.896552	2.21448344	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	213	9.68e-51	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g37531	i0	82.186	2	247	44	100	0	1	247	1184442	1184196	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	494	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
25067727	25067727	PRJNA853203_P_NODE_9440_length_290_cov_1.751152_g9291_i0	PRJNA853203	9440	290	1.751152	5.0783408	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	217	9e-52	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9291	i0	86.275	1.1	204	22	69	6	2	202	1596335	1596535	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	319	217	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);;