metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA672101" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA672101" and tax_phylum = "Bacteroidota"

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
29102947	29102947	PRJNA672101_S_NODE_9208_length_355_cov_3.549645_g9177_i0	PRJNA672101	9208	355	3.549645	12.60123975	Hymenobacter piscis	2839984	Bacteria	Bacteria	176	4.38e-54	NR	WP_215594636.1	2839984	g9177	i0	74.6	0.963380281690141	114	29	96.3	0	344	3	1	114	WP_215594636.1 hypothetical protein [Hymenobacter piscis]	diamond	342	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter piscis
30176429	30176429	PRJNA672101_S_NODE_15352_length_310_cov_1.624473_g15321_i0	PRJNA672101	15352	310	1.624473	5.0358663	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0359	NR	PCJ66719.1	1898104	g15321	i0	45.5	0.425806451612903	44	18	42.6	1	121	252	40	77	PCJ66719.1 MAG: YbhB/YbcL family Raf kinase inhibitor-like protein [Bacteroidota bacterium]	diamond	132	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30599066	30599066	PRJNA672101_S_NODE_16233_length_304_cov_4.333333_g16202_i0	PRJNA672101	16233	304	4.333333	13.17333232	Flavobacteriaceae	49546	Bacteria	Bacteria	62	1.29e-8	NR	WP_298138967.1	239	g16202	i0	57.4	3.65131578947368	54	22	53.3	1	304	143	92	144	WP_298138967.1 asparagine synthase (glutamine-hydrolyzing) [Flavobacterium sp.]	diamond	1110	62.4	0.993589743589744	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
31282354	31282354	PRJNA672101_S_NODE_7775_length_369_cov_6.081081_g7744_i0	PRJNA672101	7775	369	6.081081	22.43918889	Hymenobacter pini	2880879	Bacteria	Bacteria	206	6.27e-59	NR	WP_226271418.1	2880879	g7744	i0	88.6	1	123	14	100	0	369	1	6	128	WP_226271418.1 SusC/RagA family TonB-linked outer membrane protein [Hymenobacter pini]	diamond	369	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter pini
32021972	32021972	PRJNA672101_S_NODE_30118_length_247_cov_3.982759_g30087_i0	PRJNA672101	30118	247	3.982759	9.83741473	Flavobacterium	237	Bacteria	Bacteria	71.6	5.78e-13	NR	WP_078227953.1	1938609	g30087	i0	49.2	3.06072874493927	63	30	76.5	1	1	189	154	214	WP_078227953.1 HAD family hydrolase [Flavobacterium sp. LM4]	diamond	756	71.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. LM4

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