metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax

17 rows where analysis = "diamond", bioproject = "PRJDB12134" 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
10202910	10202910	PRJDB12134_P_NODE_13149_length_248_cov_1.748571_g13014_i0	PRJDB12134	13149	248	1.748571	4.33645608	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	162	8.36e-48	NR	MDX1421393.1	2838334	g13014	i0	90.2	0.991935483870968	82	8	99.2	0	247	2	5	86	MDX1421393.1 IS5 family transposase [Rubricoccaceae bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
12753541	12753541	PRJDB12134_P_NODE_12851_length_250_cov_0.875706_g12716_i0	PRJDB12134	12851	250	0.875706	2.189265	Chitinophagaceae	563835	Bacteria	Bacteria	149	1.25e-40	NR	WP_240743211.1	2575867	g12716	i0	86.7	4.98	83	11	99.6	0	250	2	192	274	WP_240743211.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Ilyomonas limi]	diamond	1245	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ilyomonas	Ilyomonas limi
17851927	17851927	PRJDB12134_P_NODE_12795_length_250_cov_0.881356_g12660_i0	PRJDB12134	12795	250	0.881356	2.20339	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	152	6.14e-42	NR	HJQ21209.1	2026741	g12660	i0	89.2	3.984	83	9	99.6	0	1	249	107	189	HJQ21209.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Gemmatimonadaceae bacterium]	diamond	996	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26900058	26900058	PRJDB12134_P_NODE_12401_length_252_cov_0.871508_g12266_i0	PRJDB12134	12401	252	0.871508	2.19620016	Gemmatimonadaceae	219687	Bacteria	Bacteria	110	2.0500000000000003e-27	NR	WP_025411944.1	861299	g12266	i0	75.9	1.97619047619048	83	16	98.8	1	3	251	181	259	WP_025411944.1 peptide chain release factor N(5)-glutamine methyltransferase [Gemmatirosa kalamazoonensis]	diamond	498	111	0.990990990990991	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27126760	27126760	PRJDB12134_P_NODE_5962_length_423_cov_1.205714_g5828_i0	PRJDB12134	5962	423	1.205714	5.10017022	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	44.7	0.0403	NR	HCU11550.1	2026742	g5828	i0	35.1	0.524822695035461	74	45	50.4	1	36	248	19	92	HCU11550.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	222	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28643201	28643201	PRJDB12134_P_NODE_13147_length_248_cov_1.760000_g13012_i0	PRJDB12134	13147	248	1.76	4.3648	Porphyromonas sp. HMSC	1924944	Bacteria	Bacteria	147	7.81e-41	NR	WP_070466412.1	1739394	g13012	i0	96.1	0.919354838709677	76	3	91.9	0	248	21	283	358	WP_070466412.1 tetraacyldisaccharide 4'-kinase [Porphyromonas sp. HMSC065F10]	diamond	228	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. HMSC065F10
29148617	29148617	PRJDB12134_P_NODE_10809_length_277_cov_1.200980_g10674_i0	PRJDB12134	10809	277	1.20098	3.3267146	Flavobacterium lindanitolerans	428988	Bacteria	Bacteria	185	6.2799999999999985e-55	NR	WP_343623098.1	428988	g10674	i0	96.7	0.996389891696751	92	3	99.6	0	2	277	198	289	WP_343623098.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Flavobacterium lindanitolerans]	diamond	276	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium lindanitolerans
29937693	29937693	PRJDB12134_P_NODE_11751_length_262_cov_1.550265_g11616_i0	PRJDB12134	11751	262	1.550265	4.0616943	Cnuella takakiae	1302690	Bacteria	Bacteria	118	2e-29	NR	WP_073042344.1	1302690	g11616	i0	98.3	0.687022900763359	60	1	68.7	0	181	2	1	60	WP_073042344.1 putative DNA modification/repair radical SAM protein [Cnuella takakiae]	diamond	180	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Cnuella	Cnuella takakiae
30000946	30000946	PRJDB12134_P_NODE_11311_length_269_cov_1.260204_g11176_i0	PRJDB12134	11311	269	1.260204	3.38994876	uncultured Pedobacter sp.	246139	Bacteria	Bacteria	82.4	5.67e-16	NR	WP_294895967.1	246139	g11176	i0	48.2	1.89591078066915	85	34	94.8	1	268	14	675	749	WP_294895967.1 phenylalanine--tRNA ligase subunit beta [uncultured Pedobacter sp.]	diamond	510	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	uncultured Pedobacter sp.
30595109	30595109	PRJDB12134_P_NODE_12113_length_256_cov_1.060109_g11978_i0	PRJDB12134	12113	256	1.060109	2.71387904	Porphyromonas	836	Bacteria	Bacteria	171	2.33e-50	NR	MFC2631976.1	1583331	g11978	i0	100	5.9765625	85	0	99.6	0	255	1	72	156	MFC2631976.1 N-acetylmuramoyl-L-alanine amidase [Porphyromonas pasteri]	diamond	1530	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pasteri
30917242	30917242	PRJDB12134_P_NODE_10674_length_279_cov_1.373786_g10539_i0	PRJDB12134	10674	279	1.373786	3.83286294	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	75.9	4.73e-14	NR	HEX8384657.1	2838334	g10539	i0	62.7	0.634408602150538	59	21	63.4	1	179	3	3	60	HEX8384657.1 alpha/beta hydrolase [Rubricoccaceae bacterium]	diamond	177	75.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
31200991	31200991	PRJDB12134_P_NODE_13815_length_245_cov_0.901163_g13680_i0	PRJDB12134	13815	245	0.901163	2.20784935	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	141	3.61e-38	NR	MCA6440076.1	1869212	g13680	i0	93.8	0.991836734693878	81	5	99.2	0	3	245	199	279	MCA6440076.1 TolC family protein [Chitinophagaceae bacterium]	diamond	243	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32182144	32182144	PRJDB12134_P_NODE_14118_length_243_cov_0.917647_g13983_i0	PRJDB12134	14118	243	0.917647	2.22988221	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	170	6.57e-47	NR	MBN8850464.1	2044944	g13983	i0	100	0.987654320987654	80	0	98.8	0	2	241	739	818	MBN8850464.1 VCBS repeat-containing protein [Sphingobacteriales bacterium]	diamond	240	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32271230	32271230	PRJDB12134_P_NODE_11478_length_266_cov_1.580311_g11343_i0	PRJDB12134	11478	266	1.580311	4.20362726	Prevotella	838	Bacteria	Bacteria	163	8.4e-45	NR	WP_044260099.1	340486	g11343	i0	92	2.97744360902256	88	7	99.2	0	266	3	233	320	WP_044260099.1 zinc-dependent metalloprotease, partial [Prevotella conceptionensis]	diamond	792	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella conceptionensis
32403613	32403613	PRJDB12134_P_NODE_12899_length_250_cov_0.864407_g12764_i0	PRJDB12134	12899	250	0.864407	2.1610175	Bacteroides sp. 51	2302938	Bacteria	Bacteria	51.6	1.08e-5	NR	WP_163178564.1	2302938	g12764	i0	52.8	0.636	53	24	62.4	1	3	158	112	164	WP_163178564.1 HU family DNA-binding protein [Bacteroides sp. 51]	diamond	159	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. 51
32403615	32403615	PRJDB12134_P_NODE_13399_length_247_cov_0.896552_g13264_i0	PRJDB12134	13399	247	0.896552	2.21448344	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	138	1.21e-37	NR	MBN8853300.1	2044944	g13264	i0	93.2	0.898785425101215	74	5	89.9	0	222	1	73	146	MBN8853300.1 DUF4974 domain-containing protein [Sphingobacteriales bacterium]	diamond	222	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32839196	32839196	PRJDB12134_P_NODE_11780_length_261_cov_2.175532_g11645_i0	PRJDB12134	11780	261	2.175532	5.67813852	Sediminibacterium	504481	Bacteria	Bacteria	179	2.69e-53	NR	MEY3675574.1	1898104	g11645	i0	100	1.97701149425287	86	0	98.9	0	3	260	225	310	MEY3675574.1 hypothetical protein [Bacteroidota bacterium]	diamond	516	179	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);;