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

6 rows where analysis = "diamond", bioproject = "PRJNA610520" 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
22824756	22824756	PRJNA610520_S_NODE_26678_length_334_cov_1.475096_g26588_i0	PRJNA610520	26678	334	1.475096	4.92682064	Bacteroidota bacterium	1898104	Bacteria	Bacteria	68.2	1.27e-11	NR	MCE3279722.1	1898104	g26588	i0	39.8	0.745508982035928	83	42	67.4	1	330	106	75	157	MCE3279722.1 ribosomal protein [Bacteroidota bacterium]	diamond	249	68.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27819969	27819969	PRJNA610520_S_NODE_52504_length_267_cov_1.865979_g52414_i0	PRJNA610520	52504	267	1.865979	4.98216393	Bacteroidota	976	Bacteria	Bacteria	44.3	0.0132	NR	HYF29897.1	1869212	g52414	i0	60.7	1.25842696629213	28	11	31.5	0	263	180	299	326	HYF29897.1 ADP-glyceromanno-heptose 6-epimerase [Chitinophagaceae bacterium]	diamond	336	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27996221	27996221	PRJNA610520_S_NODE_42865_length_288_cov_1.702326_g42775_i0	PRJNA610520	42865	288	1.702326	4.90269888	Flavobacterium sp.	239	Bacteria	Bacteria	175	5.309999999999999e-54	NR	HEY4628803.1	239	g42775	i0	93.8	1	96	6	100	0	288	1	60	155	HEY4628803.1 RNA polymerase sigma factor [Flavobacterium sp.]	diamond	288	175	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
28546267	28546267	PRJNA610520_S_NODE_55927_length_260_cov_2.679144_g55837_i0	PRJNA610520	55927	260	2.679144	6.9657744	root	1	Root_unresolved	Root_unresolved	50.4	1.65e-5	NR	WP_337580933.1	454154	g55837	i0	52.8	4.21153846153846	53	20	61.2	1	258	100	67	114	WP_337580933.1 ubiquitin-like protein [Paraprevotella clara]	diamond	1095	50.8	0.992125984251969	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Paraprevotella	Paraprevotella clara
29795679	29795679	PRJNA610520_S_NODE_43511_length_286_cov_3.530516_g43421_i0	PRJNA610520	43511	286	3.530516	10.09727576	Flavimarina sp. Hel_I_48	1392488	Bacteria	Bacteria	65.1	4.85e-10	NR	WP_031426029.1	1392488	g43421	i0	50.8	2.13986013986014	65	31	68.2	1	35	229	187	250	WP_031426029.1 DNA/RNA non-specific endonuclease [Flavimarina sp. Hel_I_48]	diamond	612	65.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavimarina	Flavimarina sp. Hel_I_48
30933295	30933295	PRJNA610520_S_NODE_20654_length_356_cov_7.526502_g20564_i0	PRJNA610520	20654	356	7.526502	26.79434712	Crocinitomix catalasitica	184607	Bacteria	Bacteria	48.5	0.00113	NR	WP_035844478.1	184607	g20564	i0	35.2	0.76685393258427	91	55	74.2	2	345	82	91	180	WP_035844478.1 trypsin-like peptidase domain-containing protein [Crocinitomix catalasitica]	diamond	273	48.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Crocinitomix	Crocinitomix catalasitica

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