metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
1215500	1215500	PRJNA792582_P_NODE_55081_length_245_cov_3.970930_g54267_i0	PRJNA792582	55081	245	3.97093	9.7287785	Chlamydiaceae	809	Bacteria	Bacteria	213	9.59e-51	NTclustered	gi\|2074314328\|gb\|CP063177.1\|	83559	g54267	i0	82.845	153.085714285714	239	39	97	2	3	240	418547	418310	Chlamydia suis strain 253.1 chromosome	blastn	37506	213	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia suis
2052722	2052722	PRJNA792582_P_NODE_16362_length_426_cov_2.611898_g15548_i0	PRJNA792582	16362	426	2.611898	11.12668548	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	76.8	2.44e-9	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g15548	i0	89.062	3.1056338028169	64	3	15	4	364	425	1297318	1297379	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	1323	76.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
3328183	3328183	PRJNA792582_P_NODE_43263_length_269_cov_1.346939_g42449_i0	PRJNA792582	43263	269	1.346939	3.62326591	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	387	5.95e-103	NTclustered	gi\|18029206\|gb\|AF364577.1\|	174324	g42449	i0	92.565	102.371747211896	269	20	100	0	1	269	272	4	Uncultured Chlamydiales bacterium clone P-11 16S ribosomal RNA gene, partial sequence	blastn	27538	387	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
7155533	7155533	PRJNA792582_P_NODE_51826_length_249_cov_0.875000_g51012_i0	PRJNA792582	51826	249	0.875	2.17875	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g51012	i0	95.984	163.064257028112	249	10	100	0	1	249	1251331	1251579	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40603	405	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7155625	7155625	PRJNA792582_P_NODE_60066_length_236_cov_2.993865_g59252_i0	PRJNA792582	60066	236	2.993865	7.0655214	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	67.6	7.56e-7	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g59252	i0	79.787	0.775423728813559	94	17	40	2	131	224	2253534	2253625	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	183	67.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8430287	8430287	PRJNA792582_P_NODE_53327_length_247_cov_1.632184_g52513_i0	PRJNA792582	53327	247	1.632184	4.03149448	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	320	5.54e-83	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g52513	i0	91.453	103.174089068826	234	18	94	2	1	233	2059782	2060014	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	25484	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13969158	13969158	PRJNA792582_P_NODE_15031_length_443_cov_23.186486_g14218_i0	PRJNA792582	15031	443	23.186486	102.71613298	Chlamydiia	204429	Bacteria	Bacteria	75	9.15e-9	NTclustered	gi\|559133869\|tpe\|HG788876.1\|	765953	g14218	i0	87.692	3.25507900677201	65	6	14	2	1	64	438	375	TPA: Waddlia chondrophila 2032/99 transfer-messenger mRNA Waddl_chond_WSU861, single chain mature transcript	blastn	1442	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
16079633	16079633	PRJNA792582_P_NODE_5333_length_714_cov_3.858034_g4598_i0	PRJNA792582	5333	714	3.858034	27.54636276	Parachlamydiaceae bacterium CRIB39	665613	Bacteria	Bacteria	1256	0	NTclustered	gi\|256014209\|gb\|FJ532292.1\|	665613	g4598	i0	98.457	112.259103641457	713	11	99	0	2	714	1	713	Parachlamydiaceae bacterium CRIB39 16S ribosomal RNA gene, partial sequence	blastn	80153	1256	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium CRIB39
16518183	16518183	PRJNA792582_P_NODE_22693_length_362_cov_1.065744_g21879_i0	PRJNA792582	22693	362	1.065744	3.85799328	Parachlamydia	83551	Bacteria	Bacteria	307	6.630000000000001e-79	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g21879	i0	82.337	116.986187845304	368	51	100	14	1	362	1669	1310	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	42349	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
16518188	16518188	PRJNA792582_P_NODE_22853_length_361_cov_0.739583_g22039_i0	PRJNA792582	22853	361	0.739583	2.66989463	Parachlamydiaceae	92713	Bacteria	Bacteria	409	1.76e-109	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g22039	i0	88.034	134.495844875346	351	34	97	5	3	351	1290	946	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	48553	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
17355060	17355060	PRJNA792582_P_NODE_16254_length_427_cov_7.573446_g15440_i0	PRJNA792582	16254	427	7.573446	32.33861442	Chlamydiales bacterium CF280911-8	1345607	Bacteria	Bacteria	322	2.84e-83	NTclustered	gi\|512502429\|gb\|KC469550.1\|	1345607	g15440	i0	82.262	132.27868852459	389	54	89	11	39	420	2063	1683	Chlamydiales bacterium CF280911-8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56483	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium CF280911-8
19903630	19903630	PRJNA792582_P_NODE_22416_length_364_cov_1.384880_g21602_i0	PRJNA792582	22416	364	1.3848800000000001	5.0409632	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	416	1.0599999999999999e-111	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g21602	i0	87.5	189.409340659341	368	37	100	9	1	364	654047	653685	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	68945	416	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19903810	19903810	PRJNA792582_P_NODE_42276_length_272_cov_1.160804_g41462_i0	PRJNA792582	42276	272	1.160804	3.15738688	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	431	2.74e-116	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g41462	i0	95.221	118.011029411765	272	13	100	0	1	272	1250694	1250965	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	32099	431	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
22454114	22454114	PRJNA792582_P_NODE_23978_length_352_cov_2.200717_g23164_i0	PRJNA792582	23978	352	2.200717	7.74652384	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	516	9.82e-142	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g23164	i0	93.182	116.213068181818	352	23	99	1	1	351	627520	627169	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	40907	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
22893072	22893072	PRJNA792582_P_NODE_39458_length_279_cov_1.461165_g38644_i0	PRJNA792582	39458	279	1.461165	4.07665035	Parachlamydiaceae	92713	Bacteria	Bacteria	398	2.8599999999999996e-106	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g38644	i0	95.219	152.197132616487	251	12	90	0	9	259	1249720	1249970	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	42463	398	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25003465	25003465	PRJNA792582_P_NODE_39980_length_278_cov_1.126829_g39166_i0	PRJNA792582	39980	278	1.126829	3.13258462	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	292	1.39e-74	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g39166	i0	88.571	87.5251798561151	245	20	86	6	6	245	1336496	1336737	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	24332	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;