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

15 rows where analysis = "diamond", bioproject = "PRJNA1242190" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2901662	2901662	PRJNA1242190_S_NODE_1123_length_583_cov_3.756863_g1116_i0	PRJNA1242190	1123	583	3.756863	21.90251129	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	208	1.76e-65	NR	MEL6702587.1	1977087	g1116	i0	69.5	2.1663807890223	141	43	72.6	0	87	509	19	159	MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium]	diamond	1263	208	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
11829454	11829454	PRJNA1242190_S_NODE_1230_length_570_cov_3.438632_g1223_i0	PRJNA1242190	1230	570	3.438632	19.6002024	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	237	5.02e-77	NR	MEL6702562.1	1977087	g1223	i0	68.8	3.30526315789474	157	49	82.6	0	555	85	1	157	MEL6702562.1 30S ribosomal protein S17 [Pseudomonadota bacterium]	diamond	1884	237	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
12529662	12529662	PRJNA1242190_S_NODE_2390_length_480_cov_2.616708_g2383_i0	PRJNA1242190	2390	480	2.616708	12.5601984	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	199	1.28e-62	NR	MEL6702598.1	1977087	g2383	i0	68.1	1.8	144	45	90	1	480	49	3	145	MEL6702598.1 uL15 family ribosomal protein [Pseudomonadota bacterium]	diamond	864	199	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
21452825	21452825	PRJNA1242190_S_NODE_2177_length_493_cov_3.976190_g2170_i0	PRJNA1242190	2177	493	3.97619	19.6026167	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	198	7.42e-62	NR	MEL6702587.1	1977087	g2170	i0	72.7	0.803245436105477	132	36	80.3	0	4	399	28	159	MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium]	diamond	396	198	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
26788876	26788876	PRJNA1242190_S_NODE_13041_length_246_cov_0.901734_g13034_i0	PRJNA1242190	13041	246	0.901734	2.21826564	Providencia sp. PROV	589	Bacteria	Bacteria	43.1	0.00775	NR	WP_272664213.1	2949751	g13034	i0	58.1	0.524390243902439	43	15	48.8	2	188	69	43	85	WP_272664213.1 hypothetical protein, partial [Providencia sp. PROV016]	diamond	129	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Providencia	Providencia sp. PROV016
27105026	27105026	PRJNA1242190_S_NODE_5382_length_355_cov_2.925532_g5375_i0	PRJNA1242190	5382	355	2.925532	10.3856386	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	45.1	0.0203	NR	MFO1189048.1	1913988	g5375	i0	37.3	0.430985915492958	51	32	43.1	0	89	241	568	618	MFO1189048.1 tetratricopeptide repeat protein [Alphaproteobacteria bacterium]	diamond	153	45.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28526503	28526503	PRJNA1242190_S_NODE_13867_length_237_cov_2.030488_g13860_i0	PRJNA1242190	13867	237	2.030488	4.81225656	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	116	4e-31	NR	MEL6702587.1	1977087	g13860	i0	74	0.974683544303797	77	20	97.5	0	236	6	30	106	MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium]	diamond	231	116	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
29536688	29536688	PRJNA1242190_S_NODE_2250_length_488_cov_3.240964_g2243_i0	PRJNA1242190	2250	488	3.240964	15.81590432	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	161	6.05e-48	NR	MEL6702586.1	1977087	g2243	i0	55.9	0.780737704918033	127	56	78.1	0	39	419	1	127	MEL6702586.1 uL14 family ribosomal protein [Pseudomonadota bacterium]	diamond	381	161	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
29789119	29789119	PRJNA1242190_S_NODE_6251_length_334_cov_1.758621_g6244_i0	PRJNA1242190	6251	334	1.758621	5.87379414	Nevskiales bacterium	2026766	Bacteria	Bacteria	92	9.12e-22	NR	HXG27613.1	2026766	g6244	i0	57.1	1.3562874251497	84	28	73.7	2	327	82	1	78	HXG27613.1 acyl-CoA-binding protein [Nevskiales bacterium]	diamond	453	92	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales			Nevskiales bacterium
30199723	30199723	PRJNA1242190_S_NODE_12692_length_248_cov_0.874286_g12685_i0	PRJNA1242190	12692	248	0.874286	2.16822928	Rhizobium sp.	391	Bacteria	Bacteria	91.3	1.56e-20	NR	WP_407766259.1	391	g12685	i0	61.3	1.80241935483871	75	27	89.5	2	246	25	140	213	WP_407766259.1 glycoside hydrolase family 19 protein [Rhizobium sp.]	diamond	447	91.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium sp.
31084664	31084664	PRJNA1242190_S_NODE_3375_length_429_cov_0.997191_g3368_i0	PRJNA1242190	3375	429	0.997191	4.27794939	Undibacterium jejuense	1344949	Bacteria	Bacteria	89.4	9.55e-18	NR	WP_246447504.1	1344949	g3368	i0	53.3	1.26573426573427	92	40	62.2	1	163	429	270	361	WP_246447504.1 Wzz/FepE/Etk N-terminal domain-containing protein [Undibacterium jejuense]	diamond	543	89.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium jejuense
31464287	31464287	PRJNA1242190_S_NODE_11436_length_256_cov_1.732240_g11429_i0	PRJNA1242190	11436	256	1.73224	4.4345344	Colwellia sp.	56799	Bacteria	Bacteria	44.3	0.00285	NR	MCP4991253.1	56799	g11429	i0	38.2	0.796875	68	41	79.7	1	33	236	40	106	MCP4991253.1 hypothetical protein [Colwellia sp.]	diamond	204	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Colwelliaceae	Colwellia	Colwellia sp.
31622101	31622101	PRJNA1242190_S_NODE_3976_length_402_cov_1.319149_g3969_i0	PRJNA1242190	3976	402	1.319149	5.30297898	Lysobacterales bacterium	2006849	Bacteria	Bacteria	61.6	5.52e-8	NR	HKJ19006.1	2006849	g3969	i0	35.5	0.694029850746269	93	56	67.2	2	393	124	125	216	HKJ19006.1 hypothetical protein [Lysobacterales bacterium]	diamond	279	61.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales			Lysobacterales bacterium
31748597	31748597	PRJNA1242190_S_NODE_13397_length_244_cov_0.912281_g13390_i0	PRJNA1242190	13397	244	0.912281	2.22596564	Escherichia coli	562	Bacteria	Bacteria	102	4.67e-24	NR	MCI3325462.1	562	g13390	i0	61.3	0.983606557377049	80	31	98.4	0	3	242	214	293	MCI3325462.1 cathepsin B family protein [Escherichia coli]	diamond	240	102	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31812011	31812011	PRJNA1242190_S_NODE_8757_length_290_cov_1.152074_g8750_i0	PRJNA1242190	8757	290	1.152074	3.3410146	Roseiarcus sp.	1969460	Bacteria	Bacteria	58.2	8.03e-8	NR	HEY6519662.1	1969460	g8750	i0	53.7	0.558620689655172	54	24	54.8	1	54	212	128	181	HEY6519662.1 glycoside hydrolase family 19 protein [Roseiarcus sp.]	diamond	162	58.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Roseiarcaceae	Roseiarcus	Roseiarcus 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);;