metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
1614577	1614577	PRJNA1237347_P_NODE_272242_length_355_cov_1.375887_g265669_i0	PRJNA1237347	272242	355	1.375887	4.88439885	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	573	5.799999999999999e-159	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g265669	i0	95.775	324.76338028169	355	15	100	0	1	355	177394	177040	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	115291	573	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
5445922	5445922	PRJNA1237347_P_NODE_402305_length_278_cov_4.204878_g395732_i0	PRJNA1237347	402305	278	4.204878	11.68956084	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	383	7.99e-102	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g395732	i0	91.756	114.514388489209	279	17	100	4	1	278	1249833	1249560	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	31835	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
5447568	5447568	PRJNA1237347_P_NODE_490085_length_249_cov_0.875000_g483512_i0	PRJNA1237347	490085	249	0.875	2.17875	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	58.4	4.84e-4	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g483512	i0	94.595	0.14859437751004	37	2	15	0	122	158	72214	72178	Neochlamydia sp. S13 DNA, complete genome	blastn	37	58.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
6716451	6716451	PRJNA1237347_P_NODE_210106_length_419_cov_7.462428_g203534_i0	PRJNA1237347	210106	419	7.462428	31.26757332	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	628	1.46e-175	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g203534	i0	93.78	189.887828162291	418	26	99	0	1	418	836249	835832	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	79563	628	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
7991205	7991205	PRJNA1237347_P_NODE_167767_length_487_cov_1.811594_g161200_i0	PRJNA1237347	167767	487	1.811594	8.82246278	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	656	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g161200	i0	91.152	107.026694045175	486	39	99	4	5	487	654803	654319	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	52122	656	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13097240	13097240	PRJNA1237347_P_NODE_451331_length_258_cov_7.081081_g444758_i0	PRJNA1237347	451331	258	7.081081	18.26918898	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	366	7.38e-97	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g444758	i0	92.248	171.779069767442	258	20	100	0	1	258	1249073	1249330	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	44319	366	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13098494	13098494	PRJNA1237347_P_NODE_520711_length_245_cov_0.895349_g514138_i0	PRJNA1237347	520711	245	0.895349	2.19360505	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g514138	i0	88.477	126.567346938776	243	14	99	4	1	243	654562	654790	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	31009	281	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15640733	15640733	PRJNA1237347_P_NODE_16793_length_1936_cov_8.836286_g14602_i0	PRJNA1237347	16793	1936	8.836286	171.07049696	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	2412	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g14602	i0	90.149	175.892561983471	1878	152	96	26	78	1936	655438	653575	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	340528	2412	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15644652	15644652	PRJNA1237347_P_NODE_360613_length_297_cov_2.700893_g354040_i0	PRJNA1237347	360613	297	2.700893	8.02165221	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	340	5.259999999999999e-89	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g354040	i0	88.612	59.9057239057239	281	31	94	1	17	296	791098	791378	Neochlamydia sp. S13 DNA, complete genome	blastn	17792	340	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
16915213	16915213	PRJNA1237347_P_NODE_181374_length_462_cov_2.863753_g174803_i0	PRJNA1237347	181374	462	2.863753	13.23053886	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	701	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g174803	i0	94.13	112.779220779221	460	27	99	0	2	461	1251121	1251580	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	52104	701	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23290603	23290603	PRJNA1237347_P_NODE_19059_length_1812_cov_7.623347_g14602_i1	PRJNA1237347	19059	1812	7.623347	138.13504764	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	2211	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g14602	i1	89.834	181.32174392936	1751	139	95	32	6	1735	653706	655438	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	328555	2211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
25273993	25273993	PRJNA1237347_P_NODE_230840_length_394_cov_3.155763_g224268_i0	PRJNA1237347	230840	394	3.155763	12.43370622	Parachlamydiales	1963360	Bacteria	Bacteria	139	2.81e-28	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g224268	i0	73.858	14.8553299492386	394	84	99	12	1	392	1979	2355	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	5853	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis

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