metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
27455818	27455818	PRJNA492406_P_NODE_19463_length_286_cov_1.276995_g19164_i0	PRJNA492406	19463	286	1.276995	3.6522057	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.00604	NR	NGX31959.1	2081524	g19164	i0	58.6	1.3006993006993	29	12	30.4	0	23	109	2	30	NGX31959.1 hypothetical protein [Chlamydiota bacterium]	diamond	372	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28907771	28907771	PRJNA492406_P_NODE_23368_length_267_cov_0.891753_g23069_i0	PRJNA492406	23368	267	0.891753	2.38098051	Chlamydiia bacterium	2052156	Bacteria	Bacteria	105	3.99e-25	NR	MCH9621550.1	2052156	g23069	i0	55.2	0.97752808988764	87	39	97.8	0	267	7	71	157	MCH9621550.1 hypothetical protein [Chlamydiia bacterium]	diamond	261	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
29145362	29145362	PRJNA492406_P_NODE_6889_length_460_cov_1.400517_g6590_i0	PRJNA492406	6889	460	1.400517	6.4423782	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.02e-15	NR	OGN62432.1	1797603	g6590	i0	32.3	4.00434782608696	161	96	99.8	4	2	460	79	234	OGN62432.1 MAG: hypothetical protein A3F09_04955 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11]	diamond	1842	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11
29302883	29302883	PRJNA492406_P_NODE_29849_length_245_cov_0.895349_g29550_i0	PRJNA492406	29849	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	81.3	1.03e-15	NR	MCB1107385.1	2052156	g29550	i0	43.8	3.61224489795918	73	41	89.4	0	237	19	62	134	MCB1107385.1 hypothetical protein [Chlamydiia bacterium]	diamond	885	81.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30487235	30487235	PRJNA492406_P_NODE_22473_length_271_cov_1.555556_g22174_i0	PRJNA492406	22473	271	1.555556	4.21555676	Chlamydiales bacterium	2047757	Bacteria	Bacteria	202	7.07e-62	NR	MFI5344317.1	2047757	g22174	i0	94.4	0.996309963099631	90	5	99.6	0	2	271	170	259	MFI5344317.1 fatty acid desaturase [Chlamydiales bacterium]	diamond	270	202	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31624985	31624985	PRJNA492406_P_NODE_15556_length_318_cov_1.257143_g15257_i0	PRJNA492406	15556	318	1.257143	3.99771474	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	82.8	9.53e-17	NR	OJU81588.1	1895742	g15257	i0	70.4	1	54	16	50.9	0	157	318	3	56	OJU81588.1 MAG: 50S ribosomal protein L1 [Chlamydia sp. 32-24]	diamond	318	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24

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