metadata: contig_metadata: 5 rows where bioproject = "PRJNA801875", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA801875", tax_clade = "PVC group" 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
3351969	3351969	PRJNA801875_P_NODE_1703_length_289_cov_1.496063_g1600_i0	PRJNA801875	1703	289	1.496063	4.32362207	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	331	3.07e-86	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1600	i0	87.805	189.314878892734	287	30	98	4	3	286	655090	655374	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	54712	331	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14829486	14829486	PRJNA801875_P_NODE_1392_length_332_cov_4.767677_g1289_i0	PRJNA801875	1392	332	4.767677	15.82868764	Bacteria	2	Bacteria	Bacteria	109	9.42e-27	NR	WP_006341469.1	83552	g1289	i0	74.3	8.06024096385542	70	18	63.3	0	312	103	1	70	WP_006341469.1 SDR family NAD(P)-dependent oxidoreductase [Parachlamydia acanthamoebae]	diamond	2676	110	0.990909090909091	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15249858	15249858	PRJNA801875_P_NODE_2472_length_219_cov_2.500000_g2369_i0	PRJNA801875	2472	219	2.5	5.475	Bacteria	2	Bacteria	Bacteria	219	1.8099999999999993e-52	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g2369	i0	85.377	117.972602739726	212	29	97	2	5	216	415119	415328	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	25836	220	0.995454545454545	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17379468	17379468	PRJNA801875_P_NODE_3134_length_187_cov_2.980263_g3031_i0	PRJNA801875	3134	187	2.980263	5.57309181	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	322	1.1e-83	NTclustered	gi\|116292835\|gb\|DQ996922.1\|	305355	g3031	i0	97.849	106.48128342246	186	4	99	0	2	187	581	396	Uncultured Chlamydiae bacterium clone MD2896-0.1m.78 16S ribosomal RNA gene, partial sequence	blastn	19912	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17379482	17379482	PRJNA801875_P_NODE_4274_length_158_cov_1.666667_g4171_i0	PRJNA801875	4274	158	1.666667	2.63333386	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	230	5.619999999999999e-56	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4171	i0	94.595	311.291139240506	148	8	94	0	10	157	655043	654896	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	49184	230	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured 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);;