metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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
27261637	27261637	PRJNA1151638_P_NODE_6483_length_243_cov_0.917647_g6416_i0	PRJNA1151638	6483	243	0.917647	2.22988221	Hanamia sp.	2930256	Bacteria	Bacteria	137	7.12e-39	NR	HET7115091.1	2930256	g6416	i0	72.8	1	81	22	100	0	243	1	99	179	HET7115091.1 hypothetical protein [Hanamia sp.]	diamond	243	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hanamia	Hanamia sp.
27924749	27924749	PRJNA1151638_P_NODE_5645_length_248_cov_0.891429_g5578_i0	PRJNA1151638	5645	248	0.891429	2.21074392	uncultured Porphyromonas sp.	159274	Bacteria	Bacteria	172	3.25e-49	NR	WP_296119579.1	159274	g5578	i0	97.6	0.991935483870968	82	2	99.2	0	248	3	353	434	WP_296119579.1 sialidase family protein [uncultured Porphyromonas sp.]	diamond	246	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	uncultured Porphyromonas sp.
27956352	27956352	PRJNA1151638_P_NODE_6185_length_245_cov_0.906977_g6118_i0	PRJNA1151638	6185	245	0.906977	2.22209365	Spirosoma sp. SC4-14	3128900	Bacteria	Bacteria	118	8.22e-29	NR	WP_338875046.1	3128900	g6118	i0	73.4	0.96734693877551	79	21	96.7	0	245	9	361	439	WP_338875046.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Spirosoma sp. SC4-14]	diamond	237	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. SC4-14
29901857	29901857	PRJNA1151638_P_NODE_5551_length_248_cov_0.891429_g5484_i0	PRJNA1151638	5551	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	135	2.2e-35	NR	HAO98541.1	2052160	g5484	i0	82.5	1.93548387096774	80	14	96.8	0	2	241	101	180	HAO98541.1 hypothetical protein [Fibrobacterota bacterium]	diamond	480	135	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30893511	30893511	PRJNA1151638_P_NODE_6174_length_245_cov_0.906977_g6107_i0	PRJNA1151638	6174	245	0.906977	2.22209365	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	149	3.2799999999999993e-40	NR	HEX3233915.1	2448054	g6107	i0	88.9	1.98367346938776	81	9	99.2	0	243	1	269	349	HEX3233915.1 D-aminoacylase [Gemmatimonadales bacterium]	diamond	486	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31082959	31082959	PRJNA1151638_P_NODE_1275_length_403_cov_1.624242_g1208_i0	PRJNA1151638	1275	403	1.624242	6.54569526	Ancylomarina euxinus	2283627	Bacteria	Bacteria	68.9	8.63e-11	NR	WP_125029224.1	2283627	g1208	i0	46.6	0.655086848635236	88	46	65.5	1	274	11	3	89	WP_125029224.1 hypothetical protein [Ancylomarina euxinus]	diamond	264	68.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinifilaceae	Ancylomarina	Ancylomarina euxinus
31177467	31177467	PRJNA1151638_P_NODE_6355_length_244_cov_0.912281_g6288_i0	PRJNA1151638	6355	244	0.912281	2.22596564	Candidatus Pseudobacter hemicellulosilyticus	3121375	Bacteria	Bacteria	141	7.16e-39	NR	WEK34143.1	3121375	g6288	i0	77.8	1.99180327868852	81	18	99.6	0	243	1	103	183	WEK34143.1 MAG: glycosyltransferase [Candidatus Pseudobacter hemicellulosilyticus]	diamond	486	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Candidatus Pseudobacter hemicellulosilyticus
31208888	31208888	PRJNA1151638_P_NODE_5895_length_246_cov_0.901734_g5828_i0	PRJNA1151638	5895	246	0.901734	2.21826564	Panacibacter sp.	1874622	Bacteria	Bacteria	64.7	5.09e-10	NR	HRI20735.1	1874622	g5828	i0	48.8	0.975609756097561	80	37	95.1	2	13	246	181	258	HRI20735.1 hypothetical protein [Panacibacter sp.]	diamond	240	64.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter sp.
31545167	31545167	PRJNA1151638_P_NODE_5256_length_250_cov_0.881356_g5189_i0	PRJNA1151638	5256	250	0.881356	2.20339	Porphyromonas	836	Bacteria	Bacteria	160	3.2e-48	NR	WP_287362643.1	1924944	g5189	i0	100	4.872	81	0	97.2	0	247	5	79	159	WP_287362643.1 hypothetical protein [Porphyromonas sp.]	diamond	1218	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp.
32190024	32190024	PRJNA1151638_P_NODE_6138_length_245_cov_0.906977_g6071_i0	PRJNA1151638	6138	245	0.906977	2.22209365	Larkinella terrae	2025311	Bacteria	Bacteria	159	2.96e-44	NR	WP_154178953.1	2025311	g6071	i0	98.8	2.97551020408163	81	1	99.2	0	3	245	246	326	WP_154178953.1 amidase [Larkinella terrae]	diamond	729	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella terrae
32253556	32253556	PRJNA1151638_P_NODE_5078_length_251_cov_0.876404_g5011_i0	PRJNA1151638	5078	251	0.876404	2.19977404	Ferruginibacter sp.	1940288	Bacteria	Bacteria	77.8	1.18e-15	NR	MBC7886364.1	1940288	g5011	i0	69.2	0.621513944223108	52	16	62.2	0	3	158	114	165	MBC7886364.1 hypothetical protein [Ferruginibacter sp.]	diamond	156	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
32399352	32399352	PRJNA1151638_P_NODE_1139_length_424_cov_2.227920_g1072_i0	PRJNA1151638	1139	424	2.22792	9.4463808	Bacteroidales	171549	Bacteria	Bacteria	91.7	2.27e-18	NR	WP_286151340.1	85831	g1072	i0	40.3	2.63207547169811	124	66	87.7	2	380	9	181	296	WP_286151340.1 Eco57I restriction-modification methylase domain-containing protein [Bacteroides acidifaciens]	diamond	1116	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides acidifaciens
32651671	32651671	PRJNA1151638_P_NODE_4780_length_253_cov_0.866667_g4713_i0	PRJNA1151638	4780	253	0.866667	2.19266751	Chitinophagaceae	563835	Bacteria	Bacteria	120	4.49e-30	NR	MEO6542090.1	1940288	g4713	i0	84.4	2.27667984189723	64	10	75.9	0	253	62	409	472	MEO6542090.1 glycoside hydrolase family 125 protein [Ferruginibacter sp.]	diamond	576	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.

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);;