metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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
26629275	26629275	PRJNA1195551_S_NODE_26921_length_195_cov_1.780822_g26568_i0	PRJNA1195551	26921	195	1.780822	3.4726029	Bacteroidota bacterium	1898104	Bacteria	Bacteria	122	1.77e-30	NR	MFN4892480.1	1898104	g26568	i0	95.3	7.87692307692308	64	3	98.5	0	194	3	827	890	MFN4892480.1 type I restriction endonuclease subunit R [Bacteroidota bacterium]	diamond	1536	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26851162	26851162	PRJNA1195551_S_NODE_13801_length_261_cov_3.188679_g13448_i0	PRJNA1195551	13801	261	3.188679	8.32245219	Chryseobacterium viscerum	1037377	Bacteria	Bacteria	102	1.64e-24	NR	WP_103233036.1	1037377	g13448	i0	54.2	0.954022988505747	83	38	95.4	0	2	250	96	178	WP_103233036.1 HNH endonuclease [Chryseobacterium viscerum]	diamond	249	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium viscerum
27040867	27040867	PRJNA1195551_S_NODE_40242_length_163_cov_0.824561_g39889_i0	PRJNA1195551	40242	163	0.824561	1.34403443	Aequorivita sp. 6	1872390	Bacteria	Bacteria	64.7	1.43e-11	NR	WP_185099496.1	2760087	g39889	i0	88.9	3.97546012269939	36	4	66.3	0	144	37	65	100	WP_185099496.1 40S ribosomal protein S17, partial [Aequorivita sp. 609]	diamond	648	64.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita sp. 609
27230458	27230458	PRJNA1195551_S_NODE_18083_length_233_cov_8.228261_g17730_i0	PRJNA1195551	18083	233	8.228261	19.17184813	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	43.5	0.0104	NR	RYD87703.1	2044944	g17730	i0	89.5	0.244635193133047	19	2	24.5	0	168	112	150	168	RYD87703.1 MAG: LysR family transcriptional regulator [Sphingobacteriales bacterium]	diamond	57	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
27357083	27357083	PRJNA1195551_S_NODE_14463_length_256_cov_4.415459_g14110_i0	PRJNA1195551	14463	256	4.415459	11.30357504	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	45.8	0.0035	NR	MBL7956557.1	2021391	g14110	i0	37.1	0.8203125	70	41	78.5	1	26	226	351	420	MBL7956557.1 hypothetical protein [Flavobacteriales bacterium]	diamond	210	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27736175	27736175	PRJNA1195551_S_NODE_18484_length_231_cov_4.697802_g18131_i0	PRJNA1195551	18484	231	4.697802	10.85192262	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42.7	0.0313	NR	MBQ3882713.1	2030927	g18131	i0	31	0.922077922077922	71	48	90.9	1	11	220	351	421	MBQ3882713.1 hypothetical protein [Bacteroidales bacterium]	diamond	213	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28367197	28367197	PRJNA1195551_S_NODE_33426_length_176_cov_1.275591_g33073_i0	PRJNA1195551	33426	176	1.275591	2.24504016	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	41.2	0.0383	NR	MBR5843814.1	2212467	g33073	i0	33.3	0.767045454545455	45	20	76.7	1	15	149	68	102	MBR5843814.1 nitroreductase family protein [Bacteroidaceae bacterium]	diamond	135	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
28746201	28746201	PRJNA1195551_S_NODE_19347_length_227_cov_1.460674_g18994_i0	PRJNA1195551	19347	227	1.460674	3.31572998	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.9	0.0116	NR	MDQ3100885.1	1898104	g18994	i0	40.8	0.647577092511013	49	26	60.8	1	219	82	138	186	MDQ3100885.1 hypothetical protein [Bacteroidota bacterium]	diamond	147	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29724725	29724725	PRJNA1195551_S_NODE_16870_length_240_cov_9.691099_g16517_i0	PRJNA1195551	16870	240	9.691099	23.2586376	Bacteroides caecimuris	1796613	Bacteria	Bacteria	143	8.34e-41	NR	WP_255204297.1	1796613	g16517	i0	89.7	0.975	78	8	97.5	0	236	3	37	114	WP_255204297.1 hypothetical protein [Bacteroides caecimuris]	diamond	234	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caecimuris
30862309	30862309	PRJNA1195551_S_NODE_27734_length_192_cov_2.545455_g27381_i0	PRJNA1195551	27734	192	2.545455	4.8872736	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	112	6.77e-27	NR	MBR5204604.1	2212467	g27381	i0	87.3	0.984375	63	8	98.4	0	190	2	525	587	MBR5204604.1 serine hydrolase [Bacteroidaceae bacterium]	diamond	189	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
30925765	30925765	PRJNA1195551_S_NODE_26894_length_195_cov_2.102740_g26541_i0	PRJNA1195551	26894	195	2.10274	4.100343	Pedobacter sp.	1411316	Bacteria	Bacteria	41.6	0.0494	NR	MDQ8038756.1	1411316	g26541	i0	50	0.553846153846154	36	17	53.8	1	10	114	4	39	MDQ8038756.1 hypothetical protein [Pedobacter sp.]	diamond	108	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp.
31368263	31368263	PRJNA1195551_S_NODE_26076_length_198_cov_1.395973_g25723_i0	PRJNA1195551	26076	198	1.395973	2.76402654	Chryseobacterium sp. 6424	2039166	Bacteria	Bacteria	61.6	2.56e-10	NR	WP_122028713.1	2039166	g25723	i0	77.3	0.666666666666667	44	9	65.2	1	69	197	1	44	WP_122028713.1 hypothetical protein [Chryseobacterium sp. 6424]	diamond	132	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 6424
31905711	31905711	PRJNA1195551_S_NODE_10757_length_287_cov_4.588235_g10404_i0	PRJNA1195551	10757	287	4.588235	13.16823445	Bacteroidales bacterium	2030927	Bacteria	Bacteria	159	1.4099999999999996e-43	NR	MBO5942039.1	2030927	g10404	i0	96.3	0.857142857142857	82	3	85.7	0	40	285	1	82	MBO5942039.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Bacteroidales bacterium]	diamond	246	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32019670	32019670	PRJNA1195551_S_NODE_25698_length_199_cov_3.120000_g25345_i0	PRJNA1195551	25698	199	3.12	6.2088	Bacteria	2	Bacteria	Bacteria	53.5	1.48e-6	NR	HEX3023776.1	1869212	g25345	i0	39.4	1.98994974874372	66	40	99.5	0	1	198	89	154	HEX3023776.1 gluconate 2-dehydrogenase subunit 3 family protein [Chitinophagaceae bacterium]	diamond	396	53.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32063866	32063866	PRJNA1195551_S_NODE_15418_length_250_cov_3.104478_g15065_i0	PRJNA1195551	15418	250	3.104478	7.761195	Bacteroidales bacterium	2030927	Bacteria	Bacteria	154	3.86e-46	NR	MBR1765981.1	2030927	g15065	i0	85.4	4.932	82	12	98.4	0	5	250	55	136	MBR1765981.1 DUF1573 domain-containing protein [Bacteroidales bacterium]	diamond	1233	154	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);;