metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1197996" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1197996" 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_species
323931	323931	PRJNA1197996_S_NODE_1681_length_594_cov_3.410749_g1633_i0	PRJNA1197996	1681	594	3.410749	20.25984906	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	63.2	4.93e-9	NR	NLJ07050.1	2044944	g1633	i0	39.8	0.944444444444444	93	55	46.5	1	103	378	22	114	NLJ07050.1 30S ribosomal protein S13 [Sphingobacteriales bacterium]	diamond	561	63.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales		Sphingobacteriales bacterium
26692623	26692623	PRJNA1197996_S_NODE_20741_length_263_cov_1.463158_g20687_i0	PRJNA1197996	20741	263	1.463158	3.84810554	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42.4	0.0234	NR	HWP83456.1	1898104	g20687	i0	30.8	0.741444866920152	65	41	74.1	1	230	36	9	69	HWP83456.1 response regulator [Bacteroidota bacterium]	diamond	195	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota				Bacteroidota bacterium
26933291	26933291	PRJNA1197996_S_NODE_662_length_821_cov_4.494652_g627_i0	PRJNA1197996	662	821	4.494652	36.90109292	Bacteria	2	Bacteria	Bacteria	110	3.07e-26	NR	HNF30084.1	1869212	g627	i0	52.3	0.811205846528624	111	50	39.5	1	482	159	1	111	HNF30084.1 50S ribosomal protein L14 [Chitinophagaceae bacterium]	diamond	666	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophagaceae bacterium
27420456	27420456	PRJNA1197996_S_NODE_27023_length_244_cov_0.900585_g26969_i0	PRJNA1197996	27023	244	0.900585	2.1974274	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	94.4	1.8399999999999998e-23	NR	HEV8514473.1	2099675	g26969	i0	86.2	4.97950819672131	58	8	71.3	0	70	243	1	58	HEV8514473.1 50S ribosomal protein L29 [Cyclobacteriaceae bacterium]	diamond	1215	94.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cyclobacteriaceae bacterium
29081016	29081016	PRJNA1197996_S_NODE_7968_length_358_cov_7.838596_g7914_i0	PRJNA1197996	7968	358	7.838596	28.06217368	Pseudomonadati	3379134	Bacteria	Bacteria	62.8	1.94e-9	NR	MCR9066919.1	2053541	g7914	i0	69	1.27374301675978	42	13	35.2	0	1	126	108	149	MCR9066919.1 Hsp20/alpha crystallin family protein [Cytophagales bacterium]	diamond	456	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales		Cytophagales bacterium
30957380	30957380	PRJNA1197996_S_NODE_11854_length_317_cov_1.225410_g11800_i0	PRJNA1197996	11854	317	1.22541	3.8845497	Cytophagales bacterium	2053541	Bacteria	Bacteria	78.2	1.36e-15	NR	MCR9066919.1	2053541	g11800	i0	57.6	0.624605678233438	66	28	62.5	0	317	120	82	147	MCR9066919.1 Hsp20/alpha crystallin family protein [Cytophagales bacterium]	diamond	198	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales		Cytophagales bacterium
32000743	32000743	PRJNA1197996_S_NODE_2078_length_550_cov_3.161426_g2028_i0	PRJNA1197996	2078	550	3.161426	17.387843	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	60.1	7.14e-7	NR	HNF29017.1	1869212	g2028	i0	27.8	0.981818181818182	180	111	91.1	4	7	507	501	674	HNF29017.1 NADH-quinone oxidoreductase subunit NuoG [Chitinophagaceae bacterium]	diamond	540	60.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophagaceae bacterium
32759188	32759188	PRJNA1197996_S_NODE_9880_length_335_cov_4.278626_g9826_i0	PRJNA1197996	9880	335	4.278626	14.3333971	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42	0.0277	NR	MDR1974868.1	2030927	g9826	i0	45.2	0.277611940298507	31	17	27.8	0	28	120	47	77	MDR1974868.1 DUF3791 domain-containing protein [Bacteroidales bacterium]	diamond	93	42	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);;