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

23 rows where analysis = "blastn", bioproject = "PRJNA558770" 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
1816389	1816389	PRJNA558770_P_NODE_297262_length_233_cov_26.060606_g295257_i0	PRJNA558770	297262	233	26.060606	60.72121198	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	119	2.03e-22	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g295257	i0	94.737	0.652360515021459	76	4	33	0	158	233	1532840	1532765	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	152	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
1816806	1816806	PRJNA558770_P_NODE_332702_length_233_cov_5.555556_g330697_i0	PRJNA558770	332702	233	5.555556	12.94444548	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	108	4.39e-19	NTclustered	gi\|2082224995\|gb\|CP075586.1\|	225148	g330697	i0	94.286	1.15021459227468	70	4	30	0	164	233	5971	5902	Candidatus Rhabdochlamydia porcellionis strain 15C plasmid unnamed, complete sequence	blastn	268	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
1816893	1816893	PRJNA558770_P_NODE_343122_length_233_cov_2.969697_g341117_i0	PRJNA558770	343122	233	2.969697	6.91939401	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	95.3	3.42e-15	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g341117	i0	91.304	0.296137339055794	69	6	30	0	8	76	393576	393508	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	69	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
6916064	6916064	PRJNA558770_P_NODE_146286_length_234_cov_6.693467_g144281_i0	PRJNA558770	146286	234	6.693467	15.66271278	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	135	2.02e-27	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g144281	i0	100	0.632478632478632	73	0	63	0	3	75	2839372	2839444	Parachlamydia acanthamoebae UV-7, complete genome	blastn	148	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
6918876	6918876	PRJNA558770_P_NODE_306086_length_233_cov_14.106061_g304081_i0	PRJNA558770	306086	233	14.106061	32.86712213	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	108	4.39e-19	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g304081	i0	93.151	0.313304721030043	73	5	31	0	1	73	896473	896545	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	73	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
9467481	9467481	PRJNA558770_P_NODE_183948_length_234_cov_4.457286_g181943_i0	PRJNA558770	183948	234	4.457286	10.43004924	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	132	2.62e-26	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g181943	i0	98.649	0.316239316239316	74	1	32	0	1	74	1782986	1783059	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	74	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9469069	9469069	PRJNA558770_P_NODE_278088_length_234_cov_1.763819_g276083_i0	PRJNA558770	278088	234	1.763819	4.12733646	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	95.3	3.43e-15	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g276083	i0	90.411	8.62393162393162	73	6	31	1	162	234	653905	653976	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	2018	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10742119	10742119	PRJNA558770_P_NODE_140469_length_234_cov_7.155779_g138464_i0	PRJNA558770	140469	234	7.155779	16.74452286	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	122	1.5699999999999994e-23	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g138464	i0	96	8.70940170940171	75	3	32	0	1	75	43926	43852	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	2038	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
10745092	10745092	PRJNA558770_P_NODE_302029_length_233_cov_16.919192_g300024_i0	PRJNA558770	302029	233	16.919192	39.42171736	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	121	5.64e-23	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g300024	i0	98.529	0.59656652360515	68	1	29	0	161	228	646685	646752	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	139	121	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
10745212	10745212	PRJNA558770_P_NODE_311669_length_233_cov_11.580808_g309664_i0	PRJNA558770	311669	233	11.580808	26.98328264	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	95.3	3.42e-15	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g309664	i0	89.333	0.321888412017167	75	8	32	0	1	75	942071	942145	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	75	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
12016216	12016216	PRJNA558770_P_NODE_111250_length_234_cov_10.396985_g109245_i0	PRJNA558770	111250	234	10.396985	24.3289449	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g109245	i0	95.455	0.282051282051282	66	3	28	0	162	227	243156	243221	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	66	106	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
12018718	12018718	PRJNA558770_P_NODE_230230_length_234_cov_2.798995_g228225_i0	PRJNA558770	230230	234	2.798995	6.5496483	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	117	7.33e-22	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g228225	i0	94.667	0.320512820512821	75	4	32	0	1	75	145789	145863	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	75	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
12020223	12020223	PRJNA558770_P_NODE_333090_length_233_cov_5.449495_g331085_i0	PRJNA558770	333090	233	5.449495	12.69732335	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	110	1.22e-19	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g331085	i0	92.208	0.330472103004292	77	6	33	0	1	77	847548	847624	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	77	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
13295011	13295011	PRJNA558770_P_NODE_315991_length_233_cov_10.126263_g313986_i0	PRJNA558770	315991	233	10.126263	23.59419279	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	110	1.22e-19	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g313986	i0	93.243	0.317596566523605	74	5	32	0	160	233	309651	309724	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	74	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
13295299	13295299	PRJNA558770_P_NODE_345151_length_233_cov_2.464646_g343146_i0	PRJNA558770	345151	233	2.464646	5.74262518	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	110	1.22e-19	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g343146	i0	93.333	0.643776824034335	75	4	32	1	159	233	217758	217685	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	150	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
14566201	14566201	PRJNA558770_P_NODE_109792_length_234_cov_10.618090_g107787_i0	PRJNA558770	109792	234	10.61809	24.8463306	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	132	2.62e-26	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g107787	i0	98.649	0.636752136752137	74	1	32	0	160	233	1475519	1475446	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	149	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
15844196	15844196	PRJNA558770_P_NODE_36493_length_354_cov_3.529781_g34506_i0	PRJNA558770	36493	354	3.529781	12.49542474	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	231	4.01e-56	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g34506	i0	100	55.1581920903955	125	0	65	0	145	269	1063	1187	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	19526	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
17117095	17117095	PRJNA558770_P_NODE_212774_length_234_cov_3.321608_g210769_i0	PRJNA558770	212774	234	3.321608	7.77256272	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	95.3	3.43e-15	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g210769	i0	89.333	0.320512820512821	75	8	32	0	2	76	763617	763543	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	75	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
17117794	17117794	PRJNA558770_P_NODE_254034_length_234_cov_2.221106_g252029_i0	PRJNA558770	254034	234	2.221106	5.19738804	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g252029	i0	85.915	0.303418803418803	71	10	30	0	161	231	319571	319501	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	71	76.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
18392810	18392810	PRJNA558770_P_NODE_310455_length_233_cov_12.055556_g308450_i0	PRJNA558770	310455	233	12.055556	28.08944548	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	113	9.43e-21	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g308450	i0	94.521	0.313304721030043	73	4	31	0	161	233	984333	984405	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	73	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
20939887	20939887	PRJNA558770_P_NODE_134177_length_234_cov_7.718593_g132172_i0	PRJNA558770	134177	234	7.718593	18.06150762	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	117	7.33e-22	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g132172	i0	95.89	0.88034188034188	73	2	58	1	162	234	802597	802526	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	206	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
22214998	22214998	PRJNA558770_P_NODE_138238_length_234_cov_7.341709_g136233_i0	PRJNA558770	138238	234	7.341709	17.17959906	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	119	2.04e-22	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g136233	i0	95.89	0.311965811965812	73	3	31	0	160	232	790156	790084	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	73	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
24766153	24766153	PRJNA558770_P_NODE_243200_length_234_cov_2.462312_g241195_i0	PRJNA558770	243200	234	2.462312	5.76181008	Chlamydiales bacterium BSEPT1	3097555	Bacteria	Bacteria	75	4.47e-9	NTclustered	gi\|2783367630\|emb\|OZ156466.1\|	3097555	g241195	i0	84.932	0.311965811965812	73	11	31	0	160	232	824363	824291	Chlamydiales bacterium BSEPT1 isolate 488b1680-3485-4b59-b0c6-665df4973624 genome assembly, chromosome: 1	blastn	73	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium BSEPT1

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