metadata: contig_metadata: 25 rows where bioproject = "PRJNA493828" and tax

25 rows where bioproject = "PRJNA493828" and tax_phylum = "Chlamydiota"

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
1749605	1749605	PRJNA493828_P_NODE_2622_length_655_cov_37.835052_g2281_i0	PRJNA493828	2622	655	37.835052	247.8195906	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	1186	0	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g2281	i0	99.39	118.703816793893	656	1	100	2	1	655	234	887	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	77751	1186	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
2381982	2381982	PRJNA493828_P_NODE_17222_length_302_cov_1.668122_g16803_i0	PRJNA493828	17222	302	1.668122	5.03772844	Pseudomonadati	3379134	Bacteria	Bacteria	420	6.689999999999998e-113	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g16803	i0	92.491	117.546357615894	293	22	97	0	1	293	175867	175575	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	35499	420	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
2382033	2382033	PRJNA493828_P_NODE_22182_length_280_cov_1.115942_g21763_i0	PRJNA493828	22182	280	1.115942	3.1246376	Candidatus Protochlamydia	282132	Bacteria	Bacteria	357	4.88e-94	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g21763	i0	89.68	20.1357142857143	281	28	100	1	1	280	1249894	1250174	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	5638	357	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
4301893	4301893	PRJNA493828_P_NODE_6404_length_437_cov_16.324176_g6004_i0	PRJNA493828	6404	437	16.324176	71.33664912	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	808	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g6004	i0	100	117.395881006865	437	0	100	0	1	437	1251175	1251611	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	51302	808	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
4934813	4934813	PRJNA493828_P_NODE_37764_length_243_cov_1.847059_g37345_i0	PRJNA493828	37764	243	1.847059	4.48835337	Candidatus Fritschea	206680	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g37345	i0	99.588	159.925925925926	243	1	100	0	1	243	9293	9535	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	38862	444	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
6209845	6209845	PRJNA493828_P_NODE_19005_length_291_cov_2.738532_g18586_i0	PRJNA493828	19005	291	2.738532	7.96912812	Candidatus Protochlamydia	282132	Bacteria	Bacteria	361	3.939999999999999e-95	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18586	i0	89.226	205.257731958763	297	21	100	9	1	291	1251345	1251054	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	59730	361	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
6852115	6852115	PRJNA493828_P_NODE_14186_length_312_cov_1.472803_g13767_i0	PRJNA493828	14186	312	1.472803	4.59514536	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	339	2e-88	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13767	i0	90.076	0.83974358974359	262	24	84	2	1	261	386100	385840	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	262	339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
6852346	6852346	PRJNA493828_P_NODE_27586_length_262_cov_14.317460_g27167_i0	PRJNA493828	27586	262	14.31746	37.5117452	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g27167	i0	100	65.3015267175573	262	0	100	0	1	262	1892	1631	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	17109	484	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
8759408	8759408	PRJNA493828_P_NODE_207_length_1976_cov_3.485024_g124_i0	PRJNA493828	207	1976	3.485024	68.86407424	Chlamydia	810	Bacteria	Bacteria	130	9.16e-25	NTclustered	gi\|698191871\|gb\|CP009609.1\|	83560	g124	i0	81.935	14.1978744939271	155	26	8	2	661	814	136356	136509	Chlamydia muridarum strain Nigg3 clone G28.38.1, complete genome	blastn	28055	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia muridarum
10678505	10678505	PRJNA493828_P_NODE_43709_length_227_cov_3.818182_g43290_i0	PRJNA493828	43709	227	3.818182	8.66727314	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	217	6.78e-52	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g43290	i0	84.716	69.1541850220264	229	21	97	10	5	224	2058762	2058539	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	15698	217	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11953666	11953666	PRJNA493828_P_NODE_46330_length_208_cov_13.474074_g45911_i0	PRJNA493828	46330	208	13.474074	28.02607392	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	368	1.59e-97	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g45911	i0	98.558	107.668269230769	208	3	100	0	1	208	937	730	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	22395	368	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
11953732	11953732	PRJNA493828_P_NODE_670_length_1241_cov_3.658390_g475_i0	PRJNA493828	670	1241	3.65839	45.4006199	Candidatus Syngnamydia medusae	3141954	Bacteria	Bacteria	2039	0	NTclustered	gi\|1127901232\|emb\|LT599033.1\|	3141954	g475	i0	96.811	105.115229653505	1223	36	99	3	2	1224	699	1918	Uncultured Simkania sp. partial 23S rRNA gene, isolate M1	blastn	130448	2039	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia medusae
15777073	15777073	PRJNA493828_P_NODE_12693_length_327_cov_1.011811_g12274_i0	PRJNA493828	12693	327	1.011811	3.30862197	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	422	2.03e-113	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g12274	i0	92.027	171.498470948012	301	22	92	2	1	300	654705	655004	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	56080	422	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17051736	17051736	PRJNA493828_P_NODE_12094_length_333_cov_3.226923_g11675_i0	PRJNA493828	12094	333	3.226923	10.74565359	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	289	2.1999999999999994e-73	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g11675	i0	83.654	0.936936936936937	312	46	93	5	23	332	586970	587278	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	312	289	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
18326413	18326413	PRJNA493828_P_NODE_33575_length_249_cov_0.875000_g33156_i0	PRJNA493828	33575	249	0.875	2.17875	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	287	5.670000000000001e-73	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g33156	i0	94.149	1.28112449799197	188	11	76	0	62	249	1005405	1005592	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	319	287	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19600846	19600846	PRJNA493828_P_NODE_45216_length_217_cov_5.229167_g44797_i0	PRJNA493828	45216	217	5.229167	11.34729239	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	209	1.0700000000000001e-49	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g44797	i0	84.186	0.990783410138249	215	34	99	0	3	217	2210712	2210498	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	215	209	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23426829	23426829	PRJNA493828_P_NODE_10719_length_350_cov_3.494585_g10300_i0	PRJNA493828	10719	350	3.494585	12.2310475	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	193	1.87e-44	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g10300	i0	77.089	2.09428571428571	371	62	100	14	1	350	1138215	1137847	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	733	193	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
23427268	23427268	PRJNA493828_P_NODE_37879_length_243_cov_1.429412_g37460_i0	PRJNA493828	37879	243	1.429412	3.47347116	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g37460	i0	93.827	1.99588477366255	243	15	100	0	1	243	2276214	2275972	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	485	366	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23427501	23427501	PRJNA493828_P_NODE_9759_length_364_cov_3.945017_g9341_i0	PRJNA493828	9759	364	3.945017	14.35986188	Candidatus Neptunichlamydia sp. REUL1	3064277	Bacteria	Bacteria	351	3.04e-92	NTclustered	gi\|2578658231\|emb\|OY735137.1\|	3064277	g9341	i0	84.409	3.07142857142857	372	43	99	14	3	364	1607843	1607477	Candidatus Neptunochlamydia sp. REUL1 isolate 46185 genome assembly, chromosome: 4	blastn	1118	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia sp. REUL1
24700493	24700493	PRJNA493828_P_NODE_1860_length_775_cov_3.746439_g1542_i0	PRJNA493828	1860	775	3.746439	29.03490225	Candidatus Syngnamydia medusae	3141954	Bacteria	Bacteria	1164	0	NTclustered	gi\|1127901232\|emb\|LT599033.1\|	3141954	g1542	i0	97.101	118.165161290323	690	20	89	0	1	690	690	1	Uncultured Simkania sp. partial 23S rRNA gene, isolate M1	blastn	91578	1164	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia medusae
26981974	26981974	PRJNA493828_P_NODE_29482_length_257_cov_2.945652_g29063_i0	PRJNA493828	29482	257	2.945652	7.57032564	Chlamydia psittaci	83554	Bacteria	Bacteria	40.8	0.0263	NR	EPJ13726.1	1112252	g29063	i0	55.6	0.420233463035019	36	15	40.9	1	244	140	26	61	EPJ13726.1 hypothetical protein CP01DC11_1481, partial [Chlamydia psittaci 01DC11]	diamond	108	40.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28213619	28213619	PRJNA493828_P_NODE_32646_length_250_cov_1.423729_g32227_i0	PRJNA493828	32646	250	1.423729	3.5593225	Chlamydiales bacterium 38-26	1895743	Bacteria	Bacteria	95.1	1.4e-20	NR	OJV08385.1	1895743	g32227	i0	100	1.176	43	0	51.6	0	248	120	4	46	OJV08385.1 MAG: hypothetical protein BGO14_05655 [Chlamydiales bacterium 38-26]	diamond	294	95.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium 38-26
30850740	30850740	PRJNA493828_P_NODE_37234_length_244_cov_0.900585_g36815_i0	PRJNA493828	37234	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	120	7.289999999999999e-30	NR	WP_032125010.1	389348	g36815	i0	70.4	10.9549180327869	81	19	99.6	1	243	1	171	246	WP_032125010.1 asparagine--tRNA ligase [Candidatus Protochlamydia naegleriophila]	diamond	2673	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31024833	31024833	PRJNA493828_P_NODE_26215_length_267_cov_1.237113_g25796_i0	PRJNA493828	26215	267	1.237113	3.30309171	Chlamydiales bacterium	2047757	Bacteria	Bacteria	118	3.51e-30	NR	HSX13160.1	2047757	g25796	i0	63.1	0.943820224719101	84	31	94.4	0	14	265	174	257	HSX13160.1 FAD-dependent oxidoreductase [Chlamydiales bacterium]	diamond	252	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31815284	31815284	PRJNA493828_P_NODE_38717_length_242_cov_1.396450_g38298_i0	PRJNA493828	38717	242	1.39645	3.379409	Chlamydiales bacterium	2047757	Bacteria	Bacteria	155	7.9499999999999995e-47	NR	MBN9377900.1	2047757	g38298	i0	100	0.991735537190083	80	0	99.2	0	242	3	62	141	MBN9377900.1 YtxH domain-containing protein [Chlamydiales bacterium]	diamond	240	155	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;