metadata: contig_metadata: 6 rows where bioproject = "PRJNA395690" and tax

6 rows where bioproject = "PRJNA395690" 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
1078949	1078949	PRJNA395690_P_NODE_12101_length_234_cov_1.616216_g11949_i0	PRJNA395690	12101	234	1.616216	3.78194544	Chlamydiia	204429	Bacteria	Bacteria	276	1.1399999999999999e-69	NTclustered	gi\|880804288\|gb\|KT263032.1\|	174324	g11949	i0	88.462	98.7735042735043	234	19	100	7	1	234	7	232	Uncultured Chlamydiales bacterium clone SW210C 16S ribosomal RNA gene, partial sequence	blastn	23113	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
1686432	1686432	PRJNA395690_P_NODE_22602_length_180_cov_2.007634_g22450_i0	PRJNA395690	22602	180	2.007634	3.6137412	Waddlia malaysiensis	219016	Bacteria	Bacteria	219	1.4199999999999999e-52	NTclustered	gi\|27903501\|gb\|AY184804.1\|	219016	g22450	i0	88.398	120.127777777778	181	19	100	2	1	180	2261	2082	Waddlia sp. G817 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21623	219	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia malaysiensis
2962276	2962276	PRJNA395690_P_NODE_17883_length_192_cov_1.692308_g17731_i0	PRJNA395690	17883	192	1.692308	3.24923136	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	239	1.18e-58	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g17731	i0	89.231	49.5833333333333	195	15	100	5	1	192	2363977	2364168	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	9520	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
8064884	8064884	PRJNA395690_P_NODE_18587_length_190_cov_1.148936_g18435_i0	PRJNA395690	18587	190	1.148936	2.1829784	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	254	4.17e-63	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18435	i0	91.005	61.9578947368421	189	16	99	1	2	189	1881689	1881877	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	11772	254	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
18930567	18930567	PRJNA395690_P_NODE_37155_length_153_cov_2.682692_g37002_i0	PRJNA395690	37155	153	2.682692	4.10451876	Candidatus Protochlamydia	282132	Bacteria	Bacteria	244	1.93e-60	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g37002	i0	95.425	53.437908496732	153	7	100	0	1	153	1249188	1249340	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	8176	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
28166032	28166032	PRJNA395690_P_NODE_21925_length_182_cov_1.503759_g21773_i0	PRJNA395690	21925	182	1.503759	2.73684138	Pseudomonadati	3379134	Bacteria	Bacteria	71.2	1.46e-12	NR	WP_079992932.1	389348	g21773	i0	55.4	4.63186813186813	56	25	92.3	0	175	8	472	527	WP_079992932.1 DEAD/DEAH box helicase [Candidatus Protochlamydia naegleriophila]	diamond	843	71.6	0.994413407821229	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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