metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA493827" 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
473043	473043	PRJNA493827_P_NODE_42261_length_558_cov_1.936082_g40075_i0	PRJNA493827	42261	558	1.936082	10.80333756	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	684	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g40075	i0	89.331	1.53046594982079	553	48	99	8	9	558	386386	386930	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	854	684	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3022944	3022944	PRJNA493827_P_NODE_221723_length_243_cov_0.905882_g219525_i0	PRJNA493827	221723	243	0.905882	2.20129326	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	268	2e-67	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g219525	i0	93.443	0.753086419753086	183	9	74	3	63	243	460489	460670	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	183	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
5573478	5573478	PRJNA493827_P_NODE_119865_length_312_cov_1.288703_g117667_i0	PRJNA493827	119865	312	1.288703	4.02075336	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	527	3.9799999999999996e-145	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g117667	i0	97.115	2.00320512820513	312	9	100	0	1	312	1147239	1147550	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	625	527	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
5575008	5575008	PRJNA493827_P_NODE_190705_length_250_cov_0.870056_g188507_i0	PRJNA493827	190705	250	0.870056	2.17514	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	230	9.75e-56	NTclustered	gi\|971149050\|emb\|LN879503.1\|	389348	g188507	i0	94.631	0.596	149	6	59	2	96	242	95912	96060	Protochlamydia naegleriophila genome assembly PNK1, plasmid : pPNK	blastn	149	230	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8122557	8122557	PRJNA493827_P_NODE_102847_length_338_cov_0.845283_g100649_i0	PRJNA493827	102847	338	0.845283	2.85705654	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	558	1.54e-154	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g100649	i0	96.45	1.94674556213018	338	12	100	0	1	338	2280703	2280366	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	658	558	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8125189	8125189	PRJNA493827_P_NODE_223567_length_243_cov_0.905882_g221369_i0	PRJNA493827	223567	243	0.905882	2.20129326	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	316	7.03e-82	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g221369	i0	90.123	1	243	24	100	0	1	243	245174	244932	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	243	316	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8127371	8127371	PRJNA493827_P_NODE_95507_length_351_cov_1.107914_g93309_i0	PRJNA493827	95507	351	1.107914	3.88877814	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	521	2.1e-143	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g93309	i0	93.447	77.7692307692308	351	23	100	0	1	351	263225	262875	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	27297	521	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8758077	8758077	PRJNA493827_P_NODE_17727_length_941_cov_2.625576_g16035_i0	PRJNA493827	17727	941	2.625576	24.70667016	Chlamydia	810	Bacteria	Bacteria	130	4.27e-25	NTclustered	gi\|698191871\|gb\|CP009609.1\|	83560	g16035	i0	81.935	29.8140276301807	155	26	16	2	128	281	136509	136356	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
9399415	9399415	PRJNA493827_P_NODE_186848_length_251_cov_0.865169_g184650_i0	PRJNA493827	186848	251	0.865169	2.17157419	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	381	2.549999999999999e-101	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g184650	i0	94.024	2.00398406374502	251	15	100	0	1	251	1147044	1146794	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	503	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
9400334	9400334	PRJNA493827_P_NODE_232108_length_241_cov_0.916667_g229910_i0	PRJNA493827	232108	241	0.916667	2.20916747	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	278	3.29e-70	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g229910	i0	87.5	0.995850622406639	240	30	99	0	2	241	730837	731076	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	240	278	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
10674667	10674667	PRJNA493827_P_NODE_168589_length_263_cov_2.989474_g166391_i0	PRJNA493827	168589	263	2.989474	7.86231662	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	222	1.73e-53	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g166391	i0	83.806	602.422053231939	247	26	89	10	30	263	7991	7746	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	158437	222	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
11950073	11950073	PRJNA493827_P_NODE_187250_length_251_cov_0.865169_g185052_i0	PRJNA493827	187250	251	0.865169	2.17157419	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	207	4.59e-49	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g185052	i0	81.781	0.98406374501992	247	45	98	0	1	247	1650991	1651237	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	247	207	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11950634	11950634	PRJNA493827_P_NODE_214010_length_245_cov_0.895349_g211812_i0	PRJNA493827	214010	245	0.895349	2.19360505	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	307	4.2700000000000006e-79	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g211812	i0	89.344	0.995918367346939	244	26	99	0	1	244	456039	455796	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	244	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14498956	14498956	PRJNA493827_P_NODE_133352_length_296_cov_1.035874_g131154_i0	PRJNA493827	133352	296	1.035874	3.06618704	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	475	1.3799999999999998e-129	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g131154	i0	95.608	2	296	13	100	0	1	296	961729	962024	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	592	475	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14502695	14502695	PRJNA493827_P_NODE_82252_length_379_cov_2.830065_g80054_i0	PRJNA493827	82252	379	2.830065	10.72594635	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	617	2.84e-172	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g80054	i0	96.053	4.58575197889182	380	14	100	1	1	379	2181892	2182271	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	1738	617	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
15134349	15134349	PRJNA493827_P_NODE_98852_length_344_cov_4.719557_g96654_i0	PRJNA493827	98852	344	4.719557	16.23527608	Candidatus Neptunichlamydia	1891669	Bacteria	Bacteria	248	3.87e-61	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g96654	i0	81.424	6.42732558139535	323	42	92	12	2	318	592600	592910	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	2211	248	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
15776269	15776269	PRJNA493827_P_NODE_68153_length_422_cov_0.868195_g65956_i0	PRJNA493827	68153	422	0.868195	3.6637829	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	575	1.9499999999999994e-159	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g65956	i0	91.429	0.995260663507109	420	34	99	1	3	422	2277843	2277426	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	420	575	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17046802	17046802	PRJNA493827_P_NODE_102574_length_338_cov_1.452830_g100376_i0	PRJNA493827	102574	338	1.45283	4.9105654	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	532	9.35e-147	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g100376	i0	95.266	1.61834319526627	338	13	100	2	1	338	1148282	1148616	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	547	532	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17049377	17049377	PRJNA493827_P_NODE_222354_length_243_cov_0.905882_g220156_i0	PRJNA493827	222354	243	0.905882	2.20129326	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g220156	i0	86.307	0.991769547325103	241	33	99	0	1	241	1641024	1640784	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	241	263	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17051059	17051059	PRJNA493827_P_NODE_73954_length_402_cov_20.595745_g71756_i0	PRJNA493827	73954	402	20.595745	82.7948949	Candidatus Neptunichlamydia sp. REUL1	3064277	Bacteria	Bacteria	409	1.9899999999999997e-109	NTclustered	gi\|2578658231\|emb\|OY735137.1\|	3064277	g71756	i0	85.33	9.23383084577114	409	45	99	14	3	401	1607843	1607440	Candidatus Neptunochlamydia sp. REUL1 isolate 46185 genome assembly, chromosome: 4	blastn	3712	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia sp. REUL1
18322638	18322638	PRJNA493827_P_NODE_170195_length_262_cov_1.629630_g167997_i0	PRJNA493827	170195	262	1.62963	4.2696306	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	473	4.31e-129	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g167997	i0	99.237	2	262	2	100	0	1	262	2283108	2282847	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	524	473	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19597178	19597178	PRJNA493827_P_NODE_182916_length_252_cov_0.888268_g180718_i0	PRJNA493827	182916	252	0.888268	2.23843536	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	309	1.23e-79	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g180718	i0	88.889	179.384920634921	252	26	100	2	1	252	653669	653918	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	45205	309	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19598581	19598581	PRJNA493827_P_NODE_30296_length_680_cov_9.879736_g5290_i1	PRJNA493827	30296	680	9.879736	67.1822048	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1151	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g5290	i1	97.21	142.997058823529	681	18	100	1	1	680	1250583	1249903	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	97238	1151	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
20871216	20871216	PRJNA493827_P_NODE_100257_length_342_cov_1.401487_g98059_i0	PRJNA493827	100257	342	1.401487	4.79308554	Chlamydiales bacterium QZY	2803004	Bacteria	Bacteria	435	2.75e-117	NTclustered	gi\|1955632013\|gb\|MW471098.1\|	2803004	g98059	i0	94.056	91.5672514619883	286	17	84	0	57	342	37	322	Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence	blastn	31316	435	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium QZY
22149647	22149647	PRJNA493827_P_NODE_47378_length_521_cov_4.194196_g45189_i0	PRJNA493827	47378	521	4.194196	21.85176116	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	577	6.809999999999999e-160	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g45189	i0	87.054	109.671785028791	533	42	99	23	5	521	655392	654871	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	57139	577	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
22783127	22783127	PRJNA493827_P_NODE_68798_length_419_cov_2.080925_g66601_i0	PRJNA493827	68798	419	2.080925	8.71907575	Waddlia	71666	Bacteria	Bacteria	514	4.28e-141	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g66601	i0	88.863	130.878281622912	422	41	100	5	1	419	1015	1433	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	54838	514	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
23422066	23422066	PRJNA493827_P_NODE_109359_length_327_cov_1.212598_g107161_i0	PRJNA493827	109359	327	1.212598	3.96519546	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	466	9.27e-127	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g107161	i0	92.355	14.7217125382263	327	25	100	0	1	327	2024445	2024771	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	4814	466	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24696426	24696426	PRJNA493827_P_NODE_144000_length_285_cov_1.334906_g141802_i0	PRJNA493827	144000	285	1.334906	3.8044821	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	355	1.79e-93	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g141802	i0	89.123	1	285	31	100	0	1	285	1805633	1805917	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	285	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24698211	24698211	PRJNA493827_P_NODE_228540_length_242_cov_0.911243_g226342_i0	PRJNA493827	228540	242	0.911243	2.20520806	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	265	2.5699999999999997e-66	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g226342	i0	86.42	337.272727272727	243	32	100	1	1	242	1827595	1827353	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	81620	265	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured 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);;