metadata: contig_metadata: 16 rows where bioproject = "PRJNA613025" and tax

16 rows where bioproject = "PRJNA613025" 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
1867687	1867687	PRJNA613025_S_NODE_20622_length_215_cov_1.228916_g20468_i0	PRJNA613025	20622	215	1.228916	2.6421694	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	231	2.27e-56	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g20468	i0	86.385	116.311627906977	213	27	98	1	3	213	1249378	1249166	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	25007	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
2424103	2424103	PRJNA613025_S_NODE_29822_length_168_cov_1.067227_g29668_i0	PRJNA613025	29822	168	1.067227	1.79294136	Simkania sp.	34094	Bacteria	Bacteria	105	2.01e-26	NR	MCB1084310.1	34094	g29668	i0	90.9	0.982142857142857	55	5	98.2	0	3	167	33	87	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	165	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
3700444	3700444	PRJNA613025_S_NODE_27143_length_178_cov_1.953488_g26989_i0	PRJNA613025	27143	178	1.953488	3.47720864	Chlamydiia	204429	Bacteria	Bacteria	220	3.8999999999999997e-53	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g26989	i0	90.173	266.247191011236	173	12	96	5	1	170	1827139	1826969	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	47392	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
4419448	4419448	PRJNA613025_S_NODE_27464_length_177_cov_1.367188_g27310_i0	PRJNA613025	27464	177	1.367188	2.41992276	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	239	1.07e-58	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g27310	i0	90.96	163.067796610169	177	16	100	0	1	177	2624378	2624554	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	28863	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
5695200	5695200	PRJNA613025_S_NODE_16425_length_257_cov_4.456731_g16271_i0	PRJNA613025	16425	257	4.4567310000000004	11.45379867	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	396	9.379999999999997e-106	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g16271	i0	95.219	143.996108949416	251	11	99	1	2	252	655776	656025	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	37007	396	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7526518	7526518	PRJNA613025_S_NODE_16086_length_262_cov_2.079812_g15932_i0	PRJNA613025	16086	262	2.079812	5.44910744	Parachlamydia	83551	Bacteria	Bacteria	285	2.1699999999999997e-72	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g15932	i0	86.59	181.114503816794	261	31	99	4	3	262	498	241	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	47452	285	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
14620709	14620709	PRJNA613025_S_NODE_21252_length_210_cov_2.950311_g21098_i0	PRJNA613025	21252	210	2.950311	6.1956531	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	285	1.67e-72	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g21098	i0	91.346	96.9428571428571	208	18	99	0	3	210	2061483	2061276	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	20358	285	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14621058	14621058	PRJNA613025_S_NODE_5512_length_639_cov_2.562712_g1720_i1	PRJNA613025	5512	639	2.562712	16.37572968	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	907	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1720	i1	92.415	111.400625978091	646	34	99	11	2	639	653964	654602	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	71185	907	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15177069	15177069	PRJNA613025_S_NODE_17692_length_242_cov_2.129534_g17538_i0	PRJNA613025	17692	242	2.129534	5.15347228	Parachlamydia	83551	Bacteria	Bacteria	383	6.81e-102	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g17538	i0	96.93	157.078512396694	228	7	94	0	15	242	2398	2625	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	38013	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15894722	15894722	PRJNA613025_S_NODE_22713_length_201_cov_1.368421_g22559_i0	PRJNA613025	22713	201	1.368421	2.75052621	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	270	4.43e-68	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g22559	i0	91.133	56.6965174129353	203	12	100	6	1	201	7746	7944	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	11396	270	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
18443929	18443929	PRJNA613025_S_NODE_27395_length_177_cov_1.984375_g27241_i0	PRJNA613025	27395	177	1.984375	3.51234375	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	244	2.3e-60	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g27241	i0	92	151.033898305085	175	13	98	1	4	177	655074	654900	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	26733	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20993892	20993892	PRJNA613025_S_NODE_16017_length_263_cov_2.401869_g15863_i0	PRJNA613025	16017	263	2.401869	6.31691547	Candidatus Criblamydia sequanensis	340071	Bacteria	Bacteria	254	6.13e-63	NTclustered	gi\|636559636\|ref\|NR_115696.1\|	1437425	g15863	i0	85.484	98.3840304182509	248	30	94	3	1	248	290	49	Criblamydia sequanensis CRIB-18 16S ribosomal RNA, partial sequence	blastn	25875	254	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
22268612	22268612	PRJNA613025_S_NODE_10638_length_374_cov_3.289231_g10485_i0	PRJNA613025	10638	374	3.289231	12.30172394	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	442	1.8099999999999994e-119	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g10485	i0	88.172	200.032085561497	372	43	99	1	1	371	2633945	2634316	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	74812	442	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
22269241	22269241	PRJNA613025_S_NODE_4518_length_739_cov_4.262319_g4381_i0	PRJNA613025	4518	739	4.262319	31.49853741	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	1343	0	NTclustered	gi\|18029193\|gb\|AF364564.1\|	174324	g4381	i0	99.459	107.407307171854	739	4	100	0	1	739	760	22	Uncultured Chlamydiales bacterium clone P-4 16S ribosomal RNA gene, partial sequence	blastn	79374	1343	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23543965	23543965	PRJNA613025_S_NODE_11579_length_349_cov_3.093333_g11425_i0	PRJNA613025	11579	349	3.093333	10.79573217	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	381	3.7e-101	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g11425	i0	86.744	111.845272206304	347	40	99	6	6	349	653458	653801	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	39034	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
31831515	31831515	PRJNA613025_S_NODE_25217_length_187_cov_1.775362_g25063_i0	PRJNA613025	25217	187	1.775362	3.31992694	root	1	Root_unresolved	Root_unresolved	103	1.97e-26	NR	MCB1084350.1	34094	g25063	i0	75.4	3.88235294117647	61	15	97.9	0	185	3	18	78	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	726	103	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.

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