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

5 rows where bioproject = "PRJNA800090", 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_species
23750663	23750663	PRJNA800090_P_NODE_174299_length_235_cov_0.879518_g172114_i0	PRJNA800090	174299	235	0.879518	2.0668673	Chlamydiales bacterium BSEPT1	3097555	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2783367630\|emb\|OZ156466.1\|	3097555	g172114	i0	100	0.119148936170213	28	0	12	0	92	119	1434922	1434895	Chlamydiales bacterium BSEPT1 isolate 488b1680-3485-4b59-b0c6-665df4973624 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales bacterium BSEPT1
29968291	29968291	PRJNA800090_P_NODE_180111_length_233_cov_0.878049_g177926_i0	PRJNA800090	180111	233	0.878049	2.04585417	Bacteria	2	Bacteria	Bacteria	70.9	3.88e-12	NR	MDP1608612.1	2047757	g177926	i0	44	8.72961373390558	75	40	96.6	1	227	3	24	96	MDP1608612.1 asparagine--tRNA ligase [Chlamydiales bacterium]	diamond	2034	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales bacterium
31159560	31159560	PRJNA800090_P_NODE_174195_length_235_cov_0.879518_g172010_i0	PRJNA800090	174195	235	0.879518	2.0668673	Chlamydiales bacterium	2047757	Bacteria	Bacteria	74.3	1.45e-13	NR	HSX25620.1	2047757	g172010	i0	54.5	0.702127659574468	55	25	70.2	0	165	1	4	58	HSX25620.1 class I SAM-dependent methyltransferase [Chlamydiales bacterium]	diamond	165	74.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales bacterium
32276234	32276234	PRJNA800090_P_NODE_100858_length_324_cov_2.043137_g98673_i0	PRJNA800090	100858	324	2.043137	6.61976388	Bacteria	2	Bacteria	Bacteria	58.9	1.95e-7	NR	MBF8262630.1	2052178	g98673	i0	38.7	1.22222222222222	75	42	69.4	1	225	1	2	72	MBF8262630.1 Asparagine--tRNA ligase [Parachlamydiales bacterium]	diamond	396	59.3	0.993254637436762	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales		Parachlamydiales bacterium
32835219	32835219	PRJNA800090_P_NODE_168520_length_239_cov_1.288235_g166335_i0	PRJNA800090	168520	239	1.288235	3.07888165	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	102	2.39e-23	NR	QVL54756.1	2698248	g166335	i0	63.3	0.99163179916318	79	28	97.9	1	235	2	375	453	QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium]	diamond	237	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkaniaceae 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);;