metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA888104" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA888104" 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
8515136	8515136	PRJNA888104_P_NODE_19547_length_235_cov_0.879518_g19478_i0	PRJNA888104	19547	235	0.879518	2.0668673	Vogesella mureinivorans	657276	Bacteria	Bacteria	159	6.499999999999998e-44	NR	WP_206208781.1	657276	g19478	i0	94.8	0.982978723404255	77	4	98.3	0	233	3	227	303	WP_206208781.1 sensor histidine kinase [Vogesella mureinivorans]	diamond	231	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella mureinivorans
12341457	12341457	PRJNA888104_P_NODE_23310_length_228_cov_0.899371_g23241_i0	PRJNA888104	23310	228	0.899371	2.05056588	Undibacterium luofuense	2828733	Bacteria	Bacteria	155	2.9399999999999998e-43	NR	WP_212688740.1	2828733	g23241	i0	100	0.986842105263158	75	0	98.7	0	3	227	65	139	WP_212688740.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Undibacterium luofuense]	diamond	225	155	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium luofuense
13995416	13995416	PRJNA888104_P_NODE_21231_length_232_cov_0.883436_g21162_i0	PRJNA888104	21231	232	0.883436	2.04957152	Sphingomonas	13687	Bacteria	Bacteria	76.3	1.13e-15	NR	WP_203308804.1	13687	g21162	i0	100	0.452586206896552	35	0	45.3	0	107	3	1	35	WP_203308804.1 MULTISPECIES: hypothetical protein [Sphingomonas]	diamond	105	76.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas
26612113	26612113	PRJNA888104_P_NODE_15721_length_260_cov_1.261780_g15652_i0	PRJNA888104	15721	260	1.26178	3.280628	Oceanisphaera marina	2017550	Bacteria	Bacteria	43.9	0.00949	NR	WP_188629267.1	2017550	g15652	i0	32.4	0.784615384615385	68	46	78.5	0	31	234	17	84	WP_188629267.1 hypothetical protein [Oceanisphaera marina]	diamond	204	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Oceanisphaera	Oceanisphaera marina
26928932	26928932	PRJNA888104_P_NODE_22942_length_228_cov_0.918239_g22873_i0	PRJNA888104	22942	228	0.918239	2.09358492	Chromobacterium fluminis	3044269	Bacteria	Bacteria	102	3.07e-26	NR	WP_166453542.1	3044269	g22873	i0	64	0.986842105263158	75	27	98.7	0	3	227	3	77	WP_166453542.1 helix-turn-helix domain-containing protein [Chromobacterium fluminis]	diamond	225	102	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Chromobacterium	Chromobacterium fluminis
27087157	27087157	PRJNA888104_P_NODE_10202_length_315_cov_1.154472_g10133_i0	PRJNA888104	10202	315	1.154472	3.6365868	Pseudomonas syringae	317	Bacteria	Bacteria	43.5	0.0416	NR	WP_349345699.1	317	g10133	i0	35.6	0.695238095238095	73	43	69.5	2	55	273	134	202	WP_349345699.1 aldose 1-epimerase [Pseudomonas syringae]	diamond	219	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae
29013738	29013738	PRJNA888104_P_NODE_17408_length_246_cov_4.050847_g17339_i0	PRJNA888104	17408	246	4.050847	9.96508362	Pantoea vagans	470934	Bacteria	Bacteria	77	2.92e-16	NR	WP_222707108.1	470934	g17339	i0	55.8	1.04878048780488	86	25	95.1	3	8	241	14	94	WP_222707108.1 hypothetical protein, partial [Pantoea vagans]	diamond	258	77	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea vagans
29360780	29360780	PRJNA888104_P_NODE_23149_length_228_cov_0.918239_g23080_i0	PRJNA888104	23149	228	0.918239	2.09358492	Undibacterium luofuense	2828733	Bacteria	Bacteria	145	8.849999999999997e-42	NR	WP_212688268.1	2828733	g23080	i0	96.1	1	76	3	100	0	1	228	52	127	WP_212688268.1 PulJ/GspJ family protein [Undibacterium luofuense]	diamond	228	145	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium luofuense
29707584	29707584	PRJNA888104_P_NODE_3110_length_543_cov_1.478903_g3043_i0	PRJNA888104	3110	543	1.478903	8.03044329	uncultured Marinobacter sp.	187379	Bacteria	Bacteria	69.3	3.05e-10	NR	WP_288993288.1	187379	g3043	i0	41.9	0.513812154696133	93	51	51.4	1	363	85	124	213	WP_288993288.1 hypothetical protein [uncultured Marinobacter sp.]	diamond	279	69.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	uncultured Marinobacter sp.
29929279	29929279	PRJNA888104_P_NODE_18691_length_237_cov_0.869048_g18622_i0	PRJNA888104	18691	237	0.869048	2.05964376	Vogesella urethralis	2592656	Bacteria	Bacteria	100	1.71e-24	NR	WP_144371743.1	2592656	g18622	i0	76.9	0.987341772151899	78	18	98.7	0	237	4	81	158	WP_144371743.1 hypothetical protein [Vogesella urethralis]	diamond	234	100	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella urethralis
30340378	30340378	PRJNA888104_P_NODE_16772_length_251_cov_3.082418_g16703_i0	PRJNA888104	16772	251	3.082418	7.73686918	Vogesella mureinivorans	657276	Bacteria	Bacteria	50.1	4.17e-6	NR	WP_206209029.1	657276	g16703	i0	65.2	0.549800796812749	46	16	55	0	18	155	1	46	WP_206209029.1 hypothetical protein [Vogesella mureinivorans]	diamond	138	50.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella mureinivorans
30750656	30750656	PRJNA888104_P_NODE_20574_length_233_cov_0.890244_g20505_i0	PRJNA888104	20574	233	0.890244	2.07426852	Pectobacterium brasiliense	180957	Bacteria	Bacteria	119	5.03e-29	NR	WP_268198261.1	180957	g20505	i0	72.7	7.931330472103	77	21	99.1	0	1	231	462	538	WP_268198261.1 hypothetical protein [Pectobacterium brasiliense]	diamond	1848	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Pectobacteriaceae	Pectobacterium	Pectobacterium brasiliense
31105873	31105873	PRJNA888104_P_NODE_11555_length_298_cov_1.912664_g11486_i0	PRJNA888104	11555	298	1.912664	5.69973872	Sphingopyxis	165697	Bacteria	Bacteria	80.9	4.16e-16	NR	MBL8648820.1	1908224	g11486	i0	48.7	7.31879194630872	76	38	75.5	1	226	2	1	76	MBL8648820.1 NRDE family protein [Sphingopyxis sp.]	diamond	2181	80.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis sp.
31770069	31770069	PRJNA888104_P_NODE_2417_length_609_cov_1.833333_g2350_i0	PRJNA888104	2417	609	1.833333	11.16499797	Pseudomonadota	1224	Bacteria	Bacteria	74.3	1.82e-13	NR	WP_028024190.1	91359	g2350	i0	36.8	2.46305418719212	95	60	46.8	0	174	458	4	98	WP_028024190.1 hypothetical protein [Enterovibrio calviensis]	diamond	1500	74.7	0.994645247657296	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Enterovibrio	Enterovibrio calviensis

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