metadata: contig_metadata: 32 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax

32 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax_clade = "FCB group"

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
26621597	26621597	PRJEB25583_P_NODE_3841_length_207_cov_1.235294_g3664_i0	PRJEB25583	3841	207	1.235294	2.55705858	Bacteroidota bacterium	1898104	Bacteria	Bacteria	97.1	4.75e-22	NR	MEI6879798.1	1898104	g3664	i0	67.2	0.971014492753623	67	22	97.1	0	3	203	56	122	MEI6879798.1 hypothetical protein [Bacteroidota bacterium]	diamond	201	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26747858	26747858	PRJEB25583_P_NODE_8081_length_152_cov_1.452174_g7904_i0	PRJEB25583	8081	152	1.452174	2.20730448	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	45.8	8.73e-4	NR	MCX6158007.1	2026749	g7904	i0	51.1	0.927631578947368	47	21	92.8	1	144	4	363	407	MCX6158007.1 ATP-binding protein [Ignavibacteriota bacterium]	diamond	141	45.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
26969774	26969774	PRJEB25583_P_NODE_7782_length_154_cov_1.521368_g7605_i0	PRJEB25583	7782	154	1.521368	2.34290672	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.00471	NR	MEY4572166.1	1898104	g7605	i0	42.2	0.876623376623377	45	26	87.7	0	3	137	114	158	MEY4572166.1 hypothetical protein [Bacteroidota bacterium]	diamond	135	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27064741	27064741	PRJEB25583_P_NODE_6302_length_166_cov_2.875969_g6125_i0	PRJEB25583	6302	166	2.875969	4.77410854	Bacteroidia bacterium	2044936	Bacteria	Bacteria	89.4	5.84e-20	NR	HNO71335.1	2044936	g6125	i0	77.6	0.885542168674699	49	11	88.6	0	18	164	1	49	HNO71335.1 hypothetical protein [Bacteroidia bacterium]	diamond	147	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
27286025	27286025	PRJEB25583_P_NODE_2763_length_244_cov_1.304348_g2586_i0	PRJEB25583	2763	244	1.304348	3.18260912	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	102	8.52e-25	NR	HAT64186.1	1871037	g2586	i0	61.5	0.959016393442623	78	30	95.9	0	3	236	80	157	HAT64186.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	234	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
27728543	27728543	PRJEB25583_P_NODE_4124_length_200_cov_2.674847_g3947_i0	PRJEB25583	4124	200	2.674847	5.349694	Myroides sp. JBRI-B21	1874736	Bacteria	Bacteria	61.2	1.25e-9	NR	WP_303445020.1	3119977	g3947	i0	50.8	0.885	59	28	88.5	1	181	5	72	129	WP_303445020.1 hypothetical protein [Myroides sp. JBRI-B21084]	diamond	177	61.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp. JBRI-B21084
27728544	27728544	PRJEB25583_P_NODE_7764_length_154_cov_1.803419_g7587_i0	PRJEB25583	7764	154	1.803419	2.77726526	Puia sp.	2045100	Bacteria	Bacteria	60.5	4.2e-9	NR	HEV3223884.1	2045100	g7587	i0	59.1	0.857142857142857	44	17	83.8	1	131	3	65	108	HEV3223884.1 hypothetical protein [Puia sp.]	diamond	132	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Puia	Puia sp.
27949200	27949200	PRJEB25583_P_NODE_5025_length_183_cov_2.198630_g4848_i0	PRJEB25583	5025	183	2.19863	4.0234929	Bacteroidota bacterium	1898104	Bacteria	Bacteria	85.1	3.72e-18	NR	MES2287397.1	1898104	g4848	i0	66	0.819672131147541	50	17	82	0	152	3	4	53	MES2287397.1 hypothetical protein [Bacteroidota bacterium]	diamond	150	85.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27974328	27974328	PRJEB25583_P_NODE_8005_length_153_cov_1.000000_g7828_i0	PRJEB25583	8005	153	1	1.53	Flectobacillus	101	Bacteria	Bacteria	104	1.5399999999999999e-24	NR	WP_095160603.1	1509483	g7828	i0	100	2	51	0	100	0	1	153	70	120	WP_095160603.1 T9SS type A sorting domain-containing protein [Flectobacillus sp. BAB-3569]	diamond	306	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
27980815	27980815	PRJEB25583_P_NODE_4405_length_195_cov_0.981013_g4228_i0	PRJEB25583	4405	195	0.981013	1.91297535	Bacteroidales bacterium	2030927	Bacteria	Bacteria	85.9	2.73e-20	NR	MBR0291932.1	2030927	g4228	i0	58.7	0.969230769230769	63	26	96.9	0	3	191	7	69	MBR0291932.1 hypothetical protein [Bacteroidales bacterium]	diamond	189	85.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28864777	28864777	PRJEB25583_P_NODE_6628_length_163_cov_1.785714_g6451_i0	PRJEB25583	6628	163	1.785714	2.91071382	Bacteroidota bacterium	1898104	Bacteria	Bacteria	82.4	5.91e-18	NR	MES2287369.1	1898104	g6451	i0	75.5	0.975460122699387	53	13	97.5	0	5	163	25	77	MES2287369.1 hypothetical protein [Bacteroidota bacterium]	diamond	159	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29559346	29559346	PRJEB25583_P_NODE_7590_length_155_cov_2.288136_g7413_i0	PRJEB25583	7590	155	2.288136	3.5466108	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	42	0.00244	NR	WP_288981882.1	165435	g7413	i0	51.7	0.561290322580645	29	14	56.1	0	97	11	5	33	WP_288981882.1 hypothetical protein [uncultured Flavobacterium sp.]	diamond	87	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
29843641	29843641	PRJEB25583_P_NODE_5971_length_170_cov_1.804511_g5794_i0	PRJEB25583	5971	170	1.804511	3.0676687	Bacteroidota bacterium	1898104	Bacteria	Bacteria	85.5	1.19e-17	NR	MES2287381.1	1898104	g5794	i0	71.4	0.988235294117647	56	16	98.8	0	170	3	85	140	MES2287381.1 hypothetical protein [Bacteroidota bacterium]	diamond	168	85.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30191039	30191039	PRJEB25583_P_NODE_3952_length_204_cov_1.401198_g3775_i0	PRJEB25583	3952	204	1.401198	2.85844392	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89.4	3.6100000000000005e-21	NR	HMQ80826.1	2053306	g3775	i0	59.7	0.985294117647059	67	27	98.5	0	2	202	19	85	HMQ80826.1 bacillithiol system redox-active protein YtxJ [Ignavibacteria bacterium]	diamond	201	89.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30222687	30222687	PRJEB25583_P_NODE_5292_length_179_cov_1.464789_g5115_i0	PRJEB25583	5292	179	1.464789	2.62197231	Bacteroidota bacterium	1898104	Bacteria	Bacteria	58.2	2.79e-8	NR	RLD19121.1	1898104	g5115	i0	68.8	1.27374301675978	32	10	53.6	0	64	159	25	56	RLD19121.1 MAG: hypothetical protein DRI69_09080 [Bacteroidota bacterium]	diamond	228	58.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30311598	30311598	PRJEB25583_P_NODE_4292_length_197_cov_1.575000_g4115_i0	PRJEB25583	4292	197	1.575	3.10275	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	3.84e-7	NR	MBT5974180.1	1871037	g4115	i0	74.2	1.44670050761421	31	8	47.2	0	103	195	5	35	MBT5974180.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	285	54.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
30318080	30318080	PRJEB25583_P_NODE_7072_length_159_cov_1.795082_g6895_i0	PRJEB25583	7072	159	1.795082	2.85418038	Ferruginibacter sp.	1940288	Bacteria	Bacteria	47	1.79e-4	NR	MFT3680711.1	1940288	g6895	i0	51.1	0.886792452830189	47	23	88.7	0	159	19	109	155	MFT3680711.1 hypothetical protein [Ferruginibacter sp.]	diamond	141	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
30444064	30444064	PRJEB25583_P_NODE_2313_length_270_cov_4.506438_g2136_i0	PRJEB25583	2313	270	4.506438	12.1673826	Bacteroidota bacterium	1898104	Bacteria	Bacteria	46.6	1.91e-4	NR	MES2382440.1	1898104	g2136	i0	45.6	0.633333333333333	57	28	63.3	2	80	250	1	54	MES2382440.1 hypothetical protein [Bacteroidota bacterium]	diamond	171	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30538671	30538671	PRJEB25583_P_NODE_4713_length_189_cov_1.065789_g4536_i0	PRJEB25583	4713	189	1.065789	2.01434121	Bacteroidota bacterium	1898104	Bacteria	Bacteria	87.8	3.48e-20	NR	MEN9331608.1	1898104	g4536	i0	73.7	2.71428571428571	57	15	90.5	0	188	18	83	139	MEN9331608.1 hypothetical protein [Bacteroidota bacterium]	diamond	513	87.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30791461	30791461	PRJEB25583_P_NODE_6214_length_167_cov_2.176923_g6037_i0	PRJEB25583	6214	167	2.176923	3.63546141	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	46.6	3.9e-5	NR	MBL0294883.1	2202734	g6037	i0	93.1	0.520958083832335	29	2	52.1	0	81	167	22	50	MBL0294883.1 hypothetical protein [Saprospiraceae bacterium]	diamond	87	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
30791462	30791462	PRJEB25583_P_NODE_7654_length_155_cov_1.313559_g7477_i0	PRJEB25583	7654	155	1.313559	2.03601645	Bacteroidales bacterium	2030927	Bacteria	Bacteria	51.2	1.07e-6	NR	MBR0054986.1	2030927	g7477	i0	55.1	0.948387096774194	49	22	94.8	0	149	3	36	84	MBR0054986.1 helix-turn-helix transcriptional regulator [Bacteroidales bacterium]	diamond	147	51.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31170365	31170365	PRJEB25583_P_NODE_4555_length_192_cov_1.251613_g4378_i0	PRJEB25583	4555	192	1.251613	2.40309696	Bacteroidota bacterium	1898104	Bacteria	Bacteria	123	1.36e-33	NR	MFM2203125.1	1898104	g4378	i0	85.9	1	64	9	100	0	1	192	9	72	MFM2203125.1 hypothetical protein [Bacteroidota bacterium]	diamond	192	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32024691	32024691	PRJEB25583_P_NODE_6878_length_161_cov_1.258065_g6701_i0	PRJEB25583	6878	161	1.258065	2.02548465	Chitinophaga sp. sic	1869181	Bacteria	Bacteria	82	1.19e-16	NR	WP_218377501.1	2854785	g6701	i0	82.2	0.838509316770186	45	8	83.9	0	160	26	322	366	WP_218377501.1 DNA cytosine methyltransferase [Chitinophaga sp. sic0106]	diamond	135	82	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. sic0106
32119710	32119710	PRJEB25583_P_NODE_6978_length_160_cov_1.585366_g6801_i0	PRJEB25583	6978	160	1.585366	2.5365856	Flectobacillus roseus	502259	Bacteria	Bacteria	102	1.5199999999999995e-23	NR	WP_283344306.1	502259	g6801	i0	98.1	0.975	52	1	97.5	0	3	158	426	477	WP_283344306.1 hypothetical protein [Flectobacillus roseus]	diamond	156	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus roseus
32303269	32303269	PRJEB25583_P_NODE_1779_length_317_cov_5.675000_g1602_i0	PRJEB25583	1779	317	5.675	17.98975	FCB group	1783270	Bacteria	Bacteria	87.4	1.39e-18	NR	WP_087318690.1	371601	g1602	i0	49.3	7.84542586750789	75	38	71	0	317	93	130	204	WP_087318690.1 hypothetical protein [Bacteroides xylanisolvens]	diamond	2487	87.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides xylanisolvens
32309718	32309718	PRJEB25583_P_NODE_2719_length_246_cov_1.669856_g2542_i0	PRJEB25583	2719	246	1.669856	4.10784576	Cytophagia bacterium	2026730	Bacteria	Bacteria	63.2	4.41e-11	NR	NBW38461.1	2026730	g2542	i0	66.7	0.51219512195122	42	14	51.2	0	157	32	3	44	NBW38461.1 hypothetical protein [Cytophagia bacterium]	diamond	126	63.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia				Cytophagia bacterium
32309720	32309720	PRJEB25583_P_NODE_6599_length_163_cov_3.000000_g6422_i0	PRJEB25583	6599	163	3	4.89	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42	0.0243	NR	MBS7314694.1	2030927	g6422	i0	44.2	0.791411042944785	43	23	79.1	1	28	156	809	850	MBS7314694.1 calcium-translocating P-type ATPase, PMCA-type [Bacteroidales bacterium]	diamond	129	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32436243	32436243	PRJEB25583_P_NODE_5119_length_182_cov_0.944828_g4942_i0	PRJEB25583	5119	182	0.944828	1.71958696	Bacteroidota bacterium	1898104	Bacteria	Bacteria	100	5.2499999999999996e-23	NR	MEY3421265.1	1898104	g4942	i0	73.8	1.00549450549451	61	15	98.9	1	3	182	334	394	MEY3421265.1 hypothetical protein [Bacteroidota bacterium]	diamond	183	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32467868	32467868	PRJEB25583_P_NODE_8199_length_151_cov_2.035088_g8022_i0	PRJEB25583	8199	151	2.035088	3.07298288	Bacteroidota bacterium	1898104	Bacteria	Bacteria	61.6	1.63e-10	NR	MBS1652912.1	1898104	g8022	i0	86.7	0.596026490066225	30	4	59.6	0	3	92	86	115	MBS1652912.1 hypothetical protein [Bacteroidota bacterium]	diamond	90	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32720021	32720021	PRJEB25583_P_NODE_7680_length_155_cov_1.220339_g7503_i0	PRJEB25583	7680	155	1.220339	1.89152545	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	41.6	0.0292	NR	MFN3794299.1	1869212	g7503	i0	75	0.464516129032258	24	6	46.5	0	77	6	867	890	MFN3794299.1 beta strand repeat-containing protein [Chitinophagaceae bacterium]	diamond	72	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32751463	32751463	PRJEB25583_P_NODE_5460_length_177_cov_0.900000_g5283_i0	PRJEB25583	5460	177	0.9	1.593	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	85.9	5.21e-18	NR	MBK6773423.1	2053306	g5283	i0	93.6	0.796610169491525	47	3	79.7	0	35	175	243	289	MBK6773423.1 hypothetical protein [Ignavibacteria bacterium]	diamond	141	85.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32877367	32877367	PRJEB25583_P_NODE_4700_length_189_cov_1.519737_g4523_i0	PRJEB25583	4700	189	1.519737	2.87230293	Chitinophagales bacterium	2448779	Bacteria	Bacteria	63.9	6.28e-10	NR	MCZ2458032.1	2448779	g4523	i0	58.7	10	63	26	100	0	189	1	922	984	MCZ2458032.1 right-handed parallel beta-helix repeat-containing protein [Chitinophagales bacterium]	diamond	1890	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales 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);;