metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA287283" 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
27832200	27832200	PRJNA287283_P_NODE_9424_length_179_cov_0.888889_g9200_i0	PRJNA287283	9424	179	0.888889	1.59111131	Rikenellaceae bacterium	2049048	Bacteria	Bacteria	42.4	0.0216	NR	MFI3265974.1	2049048	g9200	i0	44.7	0.636871508379888	38	21	63.7	0	176	63	161	198	MFI3265974.1 ammonium transporter [Rikenellaceae bacterium]	diamond	114	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae		Rikenellaceae bacterium
29221705	29221705	PRJNA287283_P_NODE_10269_length_176_cov_0.910569_g10045_i0	PRJNA287283	10269	176	0.910569	1.60260144	Flavobacterium indicum	312277	Bacteria	Bacteria	119	7.439999999999999e-30	NR	WP_014389705.1	312277	g10045	i0	93.1	0.988636363636364	58	4	98.9	0	3	176	62	119	WP_014389705.1 OmpA family protein [Flavobacterium indicum]	diamond	174	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
29902351	29902351	PRJNA287283_P_NODE_9951_length_177_cov_0.903226_g9727_i0	PRJNA287283	9951	177	0.903226	1.59871002	root	1	Root_unresolved	Root_unresolved	44.3	0.0046	NR	WP_144887603.1	510947	g9727	i0	37	2.20338983050847	46	29	78	0	25	162	42	87	WP_144887603.1 caspase family protein [Lacibacter cauensis]	diamond	390	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter cauensis
32823813	32823813	PRJNA287283_P_NODE_8420_length_183_cov_0.861538_g8196_i0	PRJNA287283	8420	183	0.861538	1.57661454	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.5	0.00896	NR	MBN2173308.1	2030927	g8196	i0	42.6	1.59016393442623	54	24	80.3	3	170	24	158	209	MBN2173308.1 PAN domain-containing protein [Bacteroidales bacterium]	diamond	291	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;