metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA704949" 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
690235	690235	PRJNA704949_P_NODE_1533901_length_198_cov_1.382550_g1518562_i0	PRJNA704949	1533901	198	1.38255	2.737449	Chlamydia suis	83559	Bacteria	Bacteria	176	9.76e-40	NTclustered	gi\|1388147981\|emb\|LS398097.1\|	83559	g1518562	i0	82.741	29.9242424242424	197	34	99	0	2	198	730790	730986	Chlamydia suis isolate 5-22b genome assembly, chromosome: I	blastn	5925	176	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia suis
690487	690487	PRJNA704949_P_NODE_1565321_length_195_cov_1.780822_g1549982_i0	PRJNA704949	1565321	195	1.780822	3.4726029	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	102	1.65e-17	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1549982	i0	96.774	25.025641025641	62	0	31	2	127	186	573791	573730	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	4880	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
1972989	1972989	PRJNA704949_P_NODE_357862_length_453_cov_1.750000_g342851_i0	PRJNA704949	357862	453	1.75	7.9275	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	263	1.86e-65	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g342851	i0	78.241	2.57836644591611	432	78	94	12	20	444	2256361	2255939	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	1168	263	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
4518234	4518234	PRJNA704949_P_NODE_150224_length_661_cov_1.866013_g136770_i0	PRJNA704949	150224	661	1.866013	12.33434593	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	239	4.71e-58	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g136770	i0	73.879	1.04689863842663	647	147	96	13	1	636	2510244	2509609	Parachlamydia acanthamoebae UV-7, complete genome	blastn	692	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
5013856	5013856	PRJNA704949_P_NODE_1101924_length_245_cov_1.525510_g1086588_i0	PRJNA704949	1101924	245	1.52551	3.7374995	Chlamydia	810	Bacteria	Bacteria	187	5.809999999999998e-43	NTclustered	gi\|2079652794\|emb\|OU508367.1\|	83555	g1086588	i0	81.513	51.5673469387755	238	35	96	8	11	244	257431	257199	Chlamydia abortus strain 15-58d44 genome assembly, chromosome: I	blastn	12634	187	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia abortus
5797402	5797402	PRJNA704949_P_NODE_1974805_length_168_cov_0.873950_g1959466_i0	PRJNA704949	1974805	168	0.87395	1.468236	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	130	6.34e-26	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g1959466	i0	82.468	0.916666666666667	154	21	90	6	18	168	522206	522056	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	154	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
8345470	8345470	PRJNA704949_P_NODE_1788187_length_178_cov_1.883721_g1772848_i0	PRJNA704949	1788187	178	1.883721	3.35302338	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	279	6.35e-71	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1772848	i0	94.944	2	178	9	100	0	1	178	1257999	1257822	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	356	279	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8351500	8351500	PRJNA704949_P_NODE_492807_length_388_cov_1.820059_g477556_i0	PRJNA704949	492807	388	1.820059	7.06182892	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	248	4.4e-61	NTclustered	gi\|61676019\|gb\|AY845412.1\|	112235	g477556	i0	78.919	4.34278350515464	370	74	95	4	21	388	27	394	Neochlamydia hartmannellae translation elongation factor TU gene, partial cds	blastn	1685	248	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
10890641	10890641	PRJNA704949_P_NODE_1067669_length_250_cov_1.368159_g1052333_i0	PRJNA704949	1067669	250	1.368159	3.4203975	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	139	1.6899999999999999e-28	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1052333	i0	81.006	4.468	179	30	70	3	74	249	243644	243467	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	1117	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
12172132	12172132	PRJNA704949_P_NODE_184810_length_606_cov_1.233393_g170852_i0	PRJNA704949	184810	606	1.233393	7.47436158	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	115	7.550000000000001e-21	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g170852	i0	94.595	10.5742574257426	74	4	12	0	363	436	1444790	1444863	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	6408	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
12669952	12669952	PRJNA704949_P_NODE_770190_length_305_cov_1.082031_g754859_i0	PRJNA704949	770190	305	1.082031	3.30019455	Parachlamydiales	1963360	Bacteria	Bacteria	134	9.87e-27	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g754859	i0	98.667	16.5803278688525	75	1	25	0	132	206	1210284	1210210	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	5057	135	0.992592592592593	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
13453165	13453165	PRJNA704949_P_NODE_628071_length_342_cov_1.419795_g612746_i0	PRJNA704949	628071	342	1.419795	4.8556989	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	239	2.31e-58	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g612746	i0	82.593	0.789473684210526	270	47	79	0	69	338	584818	584549	Neochlamydia sp. S13 DNA, complete genome	blastn	270	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
14715282	14715282	PRJNA704949_P_NODE_1047732_length_253_cov_1.274510_g1032396_i0	PRJNA704949	1047732	253	1.27451	3.2245103	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	183	7.8e-42	NTclustered	gi\|444301715\|gb\|KC514617.1\|	112235	g1032396	i0	80.417	0.948616600790514	240	47	95	0	1	240	808	1047	Neochlamydia hartmannellae strain ATCC 50802 DNA-directed RNA polymerase beta subunit gene, complete cds	blastn	240	183	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
14716125	14716125	PRJNA704949_P_NODE_114992_length_739_cov_2.424638_g102193_i0	PRJNA704949	114992	739	2.424638	17.91807482	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	422	4.8999999999999986e-113	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g102193	i0	77.389	1.26928281461434	743	147	99	17	7	739	1419970	1419239	Neochlamydia sp. S13 DNA, complete genome	blastn	938	422	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
14716190	14716190	PRJNA704949_P_NODE_115732_length_737_cov_2.170058_g102921_i0	PRJNA704949	115732	737	2.170058	15.99332746	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	235	6.83e-57	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g102921	i0	88.177	27.5943012211669	203	16	27	5	1	202	1768766	1768961	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	20337	235	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
14720863	14720863	PRJNA704949_P_NODE_1738772_length_182_cov_1.353383_g1723433_i0	PRJNA704949	1738772	182	1.353383	2.46315706	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	113	7e-21	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1723433	i0	94.521	1.45054945054945	73	4	40	0	104	176	2522036	2521964	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	264	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14727722	14727722	PRJNA704949_P_NODE_55032_length_1030_cov_3.117227_g44166_i0	PRJNA704949	55032	1030	3.117227	32.1074381	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	248	1.24e-60	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g44166	i0	92.571	10.3592233009709	175	10	17	3	591	762	979115	979289	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	10670	248	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
15998103	15998103	PRJNA704949_P_NODE_223393_length_559_cov_1.670588_g209051_i0	PRJNA704949	223393	559	1.670588	9.33858692	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	233	1.83e-56	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g209051	i0	79.651	15.3059033989267	344	55	60	11	224	557	755389	755051	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	8556	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
16000633	16000633	PRJNA704949_P_NODE_475493_length_395_cov_1.823699_g460267_i0	PRJNA704949	475493	395	1.823699	7.20361105	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	117	1.32e-21	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g460267	i0	91.765	0.443037974683544	85	5	21	2	188	271	1225524	1225607	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	175	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
16002397	16002397	PRJNA704949_P_NODE_676733_length_328_cov_1.681004_g661405_i0	PRJNA704949	676733	328	1.681004	5.51369312	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	119	3e-22	NTclustered	gi\|2041291174\|gb\|CP073762.1\|	2698248	g661405	i0	92.683	4.09756097560976	82	6	25	0	227	308	77361	77280	MAG: Simkaniaceae bacterium isolate M30B2 chromosome, complete genome	blastn	1344	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
17268834	17268834	PRJNA704949_P_NODE_1607194_length_192_cov_1.454545_g1591855_i0	PRJNA704949	1607194	192	1.454545	2.7927264	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g1591855	i0	100	0.291666666666667	28	0	15	0	71	98	179515	179542	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
17270449	17270449	PRJNA704949_P_NODE_1821354_length_176_cov_1.228346_g1806015_i0	PRJNA704949	1821354	176	1.228346	2.16188896	Chlamydiifrater volucris	2681470	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2031803722\|emb\|LR777655.1\|	2681470	g1806015	i0	100	0.164772727272727	29	0	16	0	28	56	2892	2864	Chlamydiaceae bacterium 15-2067_O50 genome assembly, plasmid: 15-2067_O50_	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydiifrater	Chlamydiifrater volucris
18538030	18538030	PRJNA704949_P_NODE_103575_length_773_cov_2.165746_g91052_i0	PRJNA704949	103575	773	2.165746	16.74121658	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	399	2.4e-106	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g91052	i0	82.781	0.586028460543338	453	73	58	4	77	526	1864692	1865142	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	453	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
21097752	21097752	PRJNA704949_P_NODE_2184597_length_161_cov_2.160714_g2169258_i0	PRJNA704949	2184597	161	2.160714	3.47874954	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	80.5	6.14e-11	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g2169258	i0	95.918	0.304347826086957	49	2	30	0	12	60	1702693	1702741	Neochlamydia sp. S13 DNA, complete genome	blastn	49	80.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
21103879	21103879	PRJNA704949_P_NODE_86637_length_835_cov_1.949109_g74579_i0	PRJNA704949	86637	835	1.949109	16.27506015	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	612	3.0699999999999993e-170	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g74579	i0	80.097	4.98323353293413	824	162	99	2	13	835	778554	779376	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	4161	612	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
22374933	22374933	PRJNA704949_P_NODE_41738_length_1191_cov_2.096322_g31676_i0	PRJNA704949	41738	1191	2.096322	24.96719502	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	267	3.99e-66	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g31676	i0	72.432	1.38623005877414	954	222	78	34	7	933	2248166	2249105	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	1651	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
22865633	22865633	PRJNA704949_P_NODE_2067738_length_165_cov_0.896552_g2052399_i0	PRJNA704949	2067738	165	0.896552	1.4793108	Candidatus Protochlamydia	282132	Bacteria	Bacteria	143	7.96e-30	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g2052399	i0	100	53.7575757575758	77	0	47	0	9	85	1318021	1318097	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	8870	143	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23646082	23646082	PRJNA704949_P_NODE_1879559_length_172_cov_1.268293_g1864220_i0	PRJNA704949	1879559	172	1.268293	2.18146396	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	172	1.06e-38	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1864220	i0	84.971	1.00581395348837	173	22	99	3	2	172	263487	263317	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	173	172	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24914503	24914503	PRJNA704949_P_NODE_1272840_length_224_cov_0.891429_g1257503_i0	PRJNA704949	1272840	224	0.891429	1.99680096	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	145	3.19e-30	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1257503	i0	97.619	17.0401785714286	84	2	38	0	70	153	490598	490515	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	3817	145	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24924917	24924917	PRJNA704949_P_NODE_516880_length_379_cov_1.281818_g501605_i0	PRJNA704949	516880	379	1.281818	4.85809022	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	217	1.21e-51	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g501605	i0	79.439	6.01583113456464	321	54	84	10	62	378	2263631	2263319	Neochlamydia sp. S13 DNA, complete genome	blastn	2280	217	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13

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);;