metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax

16 rows where analysis = "diamond", bioproject = "PRJDB12578" 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
26652257	26652257	PRJDB12578_S_NODE_123641_length_237_cov_1.031915_g100583_i0	PRJDB12578	123641	237	1.031915	2.44563855	Pedobacter heparinus	984	Bacteria	Bacteria	40.8	0.0465	NR	WP_262496240.1	984	g100583	i0	44.9	0.620253164556962	49	23	62	2	25	171	51	95	WP_262496240.1 lantibiotic dehydratase family protein [Pedobacter heparinus]	diamond	147	40.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
26937327	26937327	PRJDB12578_S_NODE_142362_length_211_cov_1.530864_g119304_i0	PRJDB12578	142362	211	1.530864	3.23012304	Bacteroidia bacterium	2044936	Bacteria	Bacteria	42.4	0.0324	NR	MCG9881345.1	2044936	g119304	i0	33.3	1.06635071090047	75	40	96.7	3	3	206	85	156	MCG9881345.1 hypothetical protein [Bacteroidia bacterium]	diamond	225	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
26937334	26937334	PRJDB12578_S_NODE_205602_length_165_cov_0.887931_g182544_i0	PRJDB12578	205602	165	0.887931	1.46508615	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	40.8	0.0233	NR	MBS7347346.1	2498093	g182544	i0	41.5	0.745454545454545	41	20	67.3	1	12	122	70	110	MBS7347346.1 type II toxin-antitoxin system RelE/ParE family toxin [Muribaculaceae bacterium]	diamond	123	40.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
27406020	27406020	PRJDB12578_S_NODE_185183_length_174_cov_1.624000_g162125_i0	PRJDB12578	185183	174	1.624	2.82576	Bacteroidales	171549	Bacteria	Bacteria	59.3	9.58e-10	NR	MBP3567304.1	2049036	g162125	i0	76.2	6.53448275862069	42	10	72.4	0	45	170	1	42	MBP3567304.1 HU family DNA-binding protein [Paraprevotella sp.]	diamond	1137	59.7	0.993299832495812	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Paraprevotella	Paraprevotella sp.
27948437	27948437	PRJDB12578_S_NODE_124105_length_236_cov_1.112299_g101047_i0	PRJDB12578	124105	236	1.112299	2.62502564	Flavobacteriaceae bacterium FS1-H7996/R	1721092	Bacteria	Bacteria	40.4	0.0193	NR	PLB19823.1	1721092	g101047	i0	53.3	0.38135593220339	30	14	38.1	0	192	103	11	40	PLB19823.1 MAG: hypothetical protein TRG1_1350 [Flavobacteriaceae bacterium FS1-H7996/R]	diamond	90	40.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium FS1-H7996/R
28737795	28737795	PRJDB12578_S_NODE_106747_length_272_cov_1.156951_g83689_i0	PRJDB12578	106747	272	1.156951	3.14690672	Flavobacterium sp.	239	Bacteria	Bacteria	81.3	1.5e-15	NR	HBK83011.1	239	g83689	i0	52.3	0.716911764705882	65	31	71.7	0	195	1	452	516	HBK83011.1 hypothetical protein [Flavobacterium sp.]	diamond	195	81.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
28800719	28800719	PRJDB12578_S_NODE_156488_length_197_cov_1.168919_g133430_i0	PRJDB12578	156488	197	1.168919	2.30277043	Flavobacterium sp.	239	Bacteria	Bacteria	73.2	3.78e-13	NR	HBK84078.1	239	g133430	i0	60.4	0.807106598984772	53	21	80.7	0	195	37	274	326	HBK84078.1 hypothetical protein [Flavobacterium sp.]	diamond	159	73.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29426337	29426337	PRJDB12578_S_NODE_72509_length_466_cov_2.719424_g49481_i0	PRJDB12578	72509	466	2.719424	12.67251584	Dysgonomonas	156973	Bacteria	Bacteria	243	7.29e-76	NR	WP_134436824.1	45254	g49481	i0	76.6	5.94849785407725	154	36	99.1	0	462	1	145	298	WP_134436824.1 NAD-dependent succinate-semialdehyde dehydrogenase [Dysgonomonas capnocytophagoides]	diamond	2772	244	0.995901639344262	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas capnocytophagoides
30569240	30569240	PRJDB12578_S_NODE_132093_length_224_cov_0.885714_g109035_i0	PRJDB12578	132093	224	0.885714	1.98399936	Aestuariibaculum suncheonense	1028745	Bacteria	Bacteria	43.1	0.00538	NR	WP_188217153.1	1028745	g109035	i0	35.6	1.58035714285714	59	38	79	0	224	48	39	97	WP_188217153.1 VanZ family protein [Aestuariibaculum suncheonense]	diamond	354	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aestuariibaculum	Aestuariibaculum suncheonense
31011830	31011830	PRJDB12578_S_NODE_181455_length_177_cov_1.195312_g158397_i0	PRJDB12578	181455	177	1.195312	2.11570224	Bacteroidota bacterium	1898104	Bacteria	Bacteria	41.2	0.0314	NR	MFM7700947.1	1898104	g158397	i0	40.5	1.42372881355932	42	24	71.2	1	147	22	75	115	MFM7700947.1 fibrobacter succinogenes major paralogous domain-containing protein [Bacteroidota bacterium]	diamond	252	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31353731	31353731	PRJDB12578_S_NODE_68876_length_514_cov_3.286022_g45920_i0	PRJDB12578	68876	514	3.286022	16.89015308	Dysgonomonas	156973	Bacteria	Bacteria	212	1.25e-63	NR	WP_134436824.1	45254	g45920	i0	69.9	2.56225680933852	146	44	85.2	0	440	3	1	146	WP_134436824.1 NAD-dependent succinate-semialdehyde dehydrogenase [Dysgonomonas capnocytophagoides]	diamond	1317	214	0.990654205607477	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas capnocytophagoides
31928862	31928862	PRJDB12578_S_NODE_135137_length_220_cov_0.982456_g112079_i0	PRJDB12578	135137	220	0.982456	2.1614032	Bacteroidota bacterium	1898104	Bacteria	Bacteria	41.6	0.0107	NR	MEY4127562.1	1898104	g112079	i0	36	0.681818181818182	50	27	61.4	1	29	163	14	63	MEY4127562.1 hypothetical protein [Bacteroidota bacterium]	diamond	150	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32562043	32562043	PRJDB12578_S_NODE_144239_length_209_cov_1.293750_g121181_i0	PRJDB12578	144239	209	1.29375	2.7039375	Flavobacterium sp.	239	Bacteria	Bacteria	69.7	7.4e-12	NR	HBK83011.1	239	g121181	i0	53.6	0.803827751196172	56	26	80.4	0	170	3	438	493	HBK83011.1 hypothetical protein [Flavobacterium sp.]	diamond	168	69.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
32687596	32687596	PRJDB12578_S_NODE_157320_length_196_cov_1.414966_g134262_i0	PRJDB12578	157320	196	1.414966	2.77333336	Lewinella sp.	2004506	Bacteria	Bacteria	42.7	0.0198	NR	MCB0609414.1	2004506	g134262	i0	44.4	0.688775510204082	45	25	68.9	0	153	19	251	295	MCB0609414.1 ATP-binding cassette domain-containing protein [Lewinella sp.]	diamond	135	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp.
32719190	32719190	PRJDB12578_S_NODE_105300_length_276_cov_1.140969_g82242_i0	PRJDB12578	105300	276	1.140969	3.14907444	Flavisolibacter sp.	1954249	Bacteria	Bacteria	45.8	0.0045	NR	HWI93094.1	1954249	g82242	i0	34.8	0.717391304347826	66	41	70.7	2	62	256	415	479	HWI93094.1 heparinase II/III family protein [Flavisolibacter sp.]	diamond	198	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
32813610	32813610	PRJDB12578_S_NODE_160060_length_194_cov_0.972414_g137002_i0	PRJDB12578	160060	194	0.972414	1.88648316	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0143	NR	MEM6272772.1	1898104	g137002	i0	42.9	0.649484536082474	42	24	64.9	0	63	188	263	304	MEM6272772.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium]	diamond	126	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota 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);;