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

15 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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
5454586	5454586	PRJNA1245487_P_NODE_19885_length_250_cov_0.881356_g19547_i0	PRJNA1245487	19885	250	0.881356	2.20339	Cloacibacterium rupense	517423	Bacteria	Bacteria	121	1.6100000000000002e-33	NR	WP_188616684.1	517423	g19547	i0	95.2	0.744	62	3	74.4	0	188	3	1	62	WP_188616684.1 hypothetical protein [Cloacibacterium rupense]	diamond	186	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium rupense
6728905	6728905	PRJNA1245487_P_NODE_17686_length_265_cov_1.401042_g17348_i0	PRJNA1245487	17686	265	1.401042	3.7127613	Chishuiella changwenlii	1434701	Bacteria	Bacteria	157	3.38e-46	NR	WP_072932230.1	1434701	g17348	i0	89.7	0.984905660377358	87	9	98.5	0	3	263	4	90	WP_072932230.1 CBS domain-containing protein [Chishuiella changwenlii]	diamond	261	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chishuiella	Chishuiella changwenlii
8704204	8704204	PRJNA1245487_P_NODE_20467_length_248_cov_0.891429_g20129_i0	PRJNA1245487	20467	248	0.891429	2.21074392	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	124	2.79e-32	NR	MDP2058583.1	1871037	g20129	i0	78	1.98387096774194	82	17	99.2	1	246	1	160	240	MDP2058583.1 HAD-IC family P-type ATPase [Flavobacteriaceae bacterium]	diamond	492	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
15654023	15654023	PRJNA1245487_P_NODE_11553_length_345_cov_2.518382_g11215_i0	PRJNA1245487	11553	345	2.518382	8.6884179	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	122	4.09e-32	NR	MDP2061423.1	1871037	g11215	i0	68.1	0.817391304347826	94	30	81.7	0	5	286	126	219	MDP2061423.1 30S ribosomal protein S8e [Flavobacteriaceae bacterium]	diamond	282	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
16928312	16928312	PRJNA1245487_P_NODE_18554_length_257_cov_1.695652_g18216_i0	PRJNA1245487	18554	257	1.695652	4.35782564	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	60.5	2.45e-8	NR	RYY11016.1	2026729	g18216	i0	82.1	0.653696498054475	56	3	57.2	4	111	257	1	56	RYY11016.1 MAG: hypothetical protein EOO36_19650, partial [Cytophagaceae bacterium]	diamond	168	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
22728236	22728236	PRJNA1245487_P_NODE_20478_length_248_cov_0.891429_g20140_i0	PRJNA1245487	20478	248	0.891429	2.21074392	Segetibacter	460073	Bacteria	Bacteria	156	1.57e-42	NR	WP_018615018.1	398037	g20140	i0	98.7	2.83064516129032	78	1	94.4	0	234	1	1	78	WP_018615018.1 molecular chaperone DnaK [Segetibacter koreensis]	diamond	702	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Segetibacter	Segetibacter koreensis
27263319	27263319	PRJNA1245487_P_NODE_21743_length_243_cov_0.917647_g21405_i0	PRJNA1245487	21743	243	0.917647	2.22988221	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	133	1.08e-35	NR	MCU0404716.1	1869212	g21405	i0	76.3	8.88888888888889	80	19	98.8	0	2	241	192	271	MCU0404716.1 quinolinate synthase NadA [Chitinophagaceae bacterium]	diamond	2160	133	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27515951	27515951	PRJNA1245487_P_NODE_16983_length_271_cov_1.535354_g16645_i0	PRJNA1245487	16983	271	1.535354	4.16080934	Capnocytophaga gingivalis	1017	Bacteria	Bacteria	173	3.83e-51	NR	WP_314306210.1	1017	g16645	i0	94.4	0.985239852398524	89	5	98.5	0	3	269	169	257	WP_314306210.1 DUF445 domain-containing protein [Capnocytophaga gingivalis]	diamond	267	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga gingivalis
28526509	28526509	PRJNA1245487_P_NODE_20727_length_247_cov_0.896552_g20389_i0	PRJNA1245487	20727	247	0.896552	2.21448344	Bacteroidota bacterium	1898104	Bacteria	Bacteria	115	1.18e-27	NR	RKV83888.1	1898104	g20389	i0	96.6	0.716599190283401	59	2	71.7	0	177	1	449	507	RKV83888.1 MAG: internalin, partial [Bacteroidota bacterium]	diamond	177	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28904950	28904950	PRJNA1245487_P_NODE_4768_length_575_cov_1.203187_g4435_i0	PRJNA1245487	4768	575	1.203187	6.91832525	Flectobacillus sp. BAB-3569	1509483	Bacteria	Bacteria	112	1.1500000000000002e-27	NR	WP_095166595.1	1509483	g4435	i0	88.8	0.79304347826087	152	11	76.2	1	53	490	1	152	WP_095166595.1 hypothetical protein [Flectobacillus sp. BAB-3569]	diamond	456	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
28968438	28968438	PRJNA1245487_P_NODE_15468_length_287_cov_1.378505_g15130_i0	PRJNA1245487	15468	287	1.378505	3.95630935	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	91.3	5.42e-20	NR	MBK8621143.1	2202734	g15130	i0	59.5	12.4808362369338	74	22	69	1	3	200	166	239	MBK8621143.1 30S ribosomal protein S3 [Saprospiraceae bacterium]	diamond	3582	91.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29270425	29270425	PRJNA1245487_P_NODE_13529_length_312_cov_1.774059_g13191_i0	PRJNA1245487	13529	312	1.774059	5.53506408	Chryseobacterium	59732	Bacteria	Bacteria	190	3.66e-60	NR	WP_294202073.1	259322	g13191	i0	93.6	4.51923076923077	94	6	90.4	0	2	283	49	142	WP_294202073.1 hypothetical protein [uncultured Chryseobacterium sp.]	diamond	1410	190	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	uncultured Chryseobacterium sp.
29820635	29820635	PRJNA1245487_P_NODE_13731_length_309_cov_2.262712_g13393_i0	PRJNA1245487	13731	309	2.262712	6.99178008	Bacteroidia bacterium	2044936	Bacteria	Bacteria	55.8	2.11e-6	NR	MBJ7427349.1	2044936	g13393	i0	45.1	0.883495145631068	91	44	87.4	2	32	301	1689	1774	MBJ7427349.1 cadherin-like beta sandwich domain-containing protein [Bacteroidia bacterium]	diamond	273	55.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
31021491	31021491	PRJNA1245487_P_NODE_22075_length_242_cov_0.923077_g21737_i0	PRJNA1245487	22075	242	0.923077	2.23384634	Emticicia agri	2492393	Bacteria	Bacteria	152	6.94e-41	NR	WP_229239424.1	2492393	g21737	i0	96.3	1.98347107438017	80	3	99.2	0	2	241	109	188	WP_229239424.1 TonB-dependent receptor [Emticicia agri]	diamond	480	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia agri
31134032	31134032	PRJNA1245487_P_NODE_20095_length_249_cov_1.238636_g19757_i0	PRJNA1245487	20095	249	1.238636	3.08420364	Emticicia	312278	Bacteria	Bacteria	68.9	2.4e-11	NR	WP_340236287.1	2027878	g19757	i0	41.6	3.7710843373494	77	45	92.8	0	235	5	806	882	WP_340236287.1 penicillin-binding transpeptidase domain-containing protein [Emticicia soli]	diamond	939	68.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia soli

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