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

5 rows where bioproject = "PRJEB48218", 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	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
11540807	11540807	PRJEB48218_S_NODE_25790_length_170_cov_2.241135_g24828_i0	PRJEB48218	25790	170	2.241135	3.8099295	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	150	4.9e-32	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g24828	i0	84.314	0.9	153	24	90	17	169	204447	204599	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	153	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
26906980	26906980	PRJEB48218_S_NODE_25282_length_172_cov_3.048951_g24320_i0	PRJEB48218	25282	172	3.048951	5.24419572	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	96.7	1.9599999999999994e-23	NR	MBN2478880.1	2052178	g24320	i0	78.2	0.959302325581395	55	12	95.9	165	1	35	89	MBN2478880.1 NUDIX hydrolase [Parachlamydiales bacterium]	diamond	165	96.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27222955	27222955	PRJEB48218_S_NODE_24023_length_180_cov_1.754967_g23061_i0	PRJEB48218	24023	180	1.754967	3.1589406	Simkania negevensis	83561	Bacteria	Bacteria	110	2.36e-28	NR	MBI3211930.1	83561	g23061	i0	98.2	0.916666666666667	55	1	91.7	1	165	74	128	MBI3211930.1 YebC/PmpR family DNA-binding transcriptional regulator [Simkania negevensis]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
29970297	29970297	PRJEB48218_S_NODE_30191_length_152_cov_1.634146_g29229_i0	PRJEB48218	30191	152	1.634146	2.48390192	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	100	6.31e-23	NR	MBX9922998.1	2047756	g29229	i0	89.8	0.967105263157895	49	5	96.7	6	152	254	302	MBX9922998.1 phosphoenolpyruvate carboxykinase (GTP) [Rhabdochlamydiaceae bacterium]	diamond	147	100	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31582229	31582229	PRJEB48218_S_NODE_27996_length_160_cov_2.603053_g27034_i0	PRJEB48218	27996	160	2.603053	4.1648848	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	71.6	7.51e-13	NR	HEY2810941.1	2047756	g27034	i0	69.6	0.8625	46	14	86.3	158	21	254	299	HEY2810941.1 phenylalanine--tRNA ligase subunit beta [Rhabdochlamydiaceae bacterium]	diamond	138	71.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae 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);;