metadata: contig_metadata: 5 rows where bioproject = "PRJNA745553" and tax

5 rows where bioproject = "PRJNA745553" 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
4552758	4552758	PRJNA745553_S_NODE_23924_length_252_cov_11.648045_g23729_i0	PRJNA745553	23924	252	11.648045	29.3530734	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	411	3.269999999999999e-110	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g23729	i0	99.556	85.7698412698413	225	1	89	0	5	229	605	381	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	21614	411	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
7103141	7103141	PRJNA745553_S_NODE_8406_length_414_cov_4.260997_g8211_i0	PRJNA745553	8406	414	4.260997	17.64052758	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	361	5.8199999999999987e-95	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g8211	i0	85.596	145.642512077295	361	33	84	15	55	403	655015	655368	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	60296	361	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14752976	14752976	PRJNA745553_S_NODE_14772_length_320_cov_4.866397_g14577_i0	PRJNA745553	14772	320	4.866397	15.5724704	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	555	1.8799999999999998e-153	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g14577	i0	99.67	161.865625	303	1	95	0	18	320	882	580	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	51797	555	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
17302300	17302300	PRJNA745553_S_NODE_22714_length_259_cov_13.784946_g22519_i0	PRJNA745553	22714	259	13.784946	35.70301014	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	327	3.5e-85	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g22519	i0	92.889	77.6409266409266	225	16	87	0	13	237	1881694	1881918	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	20109	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
32613521	32613521	PRJNA745553_S_NODE_27880_length_233_cov_5.800000_g27685_i0	PRJNA745553	27880	233	5.8	13.514	Chlamydia trachomatis	813	Bacteria	Bacteria	56.6	2.52e-8	NR	CRH76625.1	813	g27685	i0	50.7	0.862660944206009	67	24	79.8	2	228	43	29	91	CRH76625.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	201	56.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis

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