metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA326068" 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
19515329	19515329	PRJNA326068_P_NODE_8836_length_347_cov_1.833333_g7882_i0	PRJNA326068	8836	347	1.833333	6.36166551	Aquincola	391952	Bacteria	Bacteria	124	9.61e-34	NR	WP_046112008.1	391952	g7882	i0	87.3	0.68299711815562	79	6	64.8	1	225	1	21	99	WP_046112008.1 MULTISPECIES: hypothetical protein [Aquincola]	diamond	237	124	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Aquincola
27137372	27137372	PRJNA326068_P_NODE_5802_length_457_cov_9.481308_g4940_i0	PRJNA326068	5802	457	9.481308	43.32957756	Sphingomonadaceae bacterium PASS1	2015579	Bacteria	Bacteria	120	4.4899999999999997e-32	NR	OYU02204.1	2015579	g4940	i0	70.6	0.557986870897155	85	25	55.8	0	293	39	16	100	OYU02204.1 MAG: hypothetical protein CFE36_06940 [Sphingomonadaceae bacterium PASS1]	diamond	255	120	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae		Sphingomonadaceae bacterium PASS1
27927462	27927462	PRJNA326068_P_NODE_11065_length_290_cov_15.045977_g10104_i0	PRJNA326068	11065	290	15.045977	43.6333333	Sphingomonadaceae bacterium PASS1	2015579	Bacteria	Bacteria	118	3.28e-32	NR	OYU02204.1	2015579	g10104	i0	71.8	0.879310344827586	85	24	87.9	0	6	260	16	100	OYU02204.1 MAG: hypothetical protein CFE36_06940 [Sphingomonadaceae bacterium PASS1]	diamond	255	118	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae		Sphingomonadaceae bacterium PASS1
28053608	28053608	PRJNA326068_P_NODE_12585_length_259_cov_3.139130_g11622_i0	PRJNA326068	12585	259	3.13913	8.1303467	Novosphingobium sp.	1874826	Bacteria	Bacteria	65.5	2.43e-11	NR	WP_296676571.1	1874826	g11622	i0	68.8	0.555984555984556	48	15	55.6	0	108	251	40	87	WP_296676571.1 hypothetical protein [Novosphingobium sp.]	diamond	144	65.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp.
28306319	28306319	PRJNA326068_P_NODE_9706_length_324_cov_4.813559_g8747_i0	PRJNA326068	9706	324	4.813559	15.59593116	Klebsiella pneumoniae	573	Bacteria	Bacteria	85.1	9.33e-19	NR	WP_416532572.1	573	g8747	i0	79.2	1.93518518518519	53	11	49.1	0	160	2	53	105	WP_416532572.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	627	85.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
28906005	28906005	PRJNA326068_P_NODE_19788_length_154_cov_1.176000_g18825_i0	PRJNA326068	19788	154	1.176	1.81104	Bradyrhizobium	374	Bacteria	Bacteria	86.3	3.37e-18	NR	WP_043855259.1	374	g18825	i0	84	0.974025974025974	50	8	97.4	0	152	3	90	139	WP_043855259.1 MULTISPECIES: hypothetical protein [Bradyrhizobium]	diamond	150	86.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium
30028841	30028841	PRJNA326068_P_NODE_11191_length_288_cov_2.332046_g10229_i0	PRJNA326068	11191	288	2.332046	6.71629248	Alphaproteobacteria	28211	Bacteria	Bacteria	45.8	0.00525	NR	MBU6497845.1	2026786	g10229	i0	46.2	3.25	52	16	54.2	1	288	133	493	532	MBU6497845.1 cytochrome c oxidase subunit I [Rhodospirillales bacterium]	diamond	936	45.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales			Rhodospirillales bacterium
30042934	30042934	PRJNA326068_P_NODE_19411_length_159_cov_1.076923_g18448_i0	PRJNA326068	19411	159	1.076923	1.71230757	Bradyrhizobium roseum	3056648	Bacteria	Bacteria	55.5	2.83e-7	NR	WP_300945270.1	3056648	g18448	i0	92.6	1.0188679245283	27	2	50.9	0	77	157	1	27	WP_300945270.1 F0F1 ATP synthase subunit A [Bradyrhizobium roseum]	diamond	162	55.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium roseum
30200729	30200729	PRJNA326068_P_NODE_18052_length_180_cov_1.536424_g17089_i0	PRJNA326068	18052	180	1.536424	2.7655632	Rhizobacter sp. Root4	1909292	Bacteria	Bacteria	56.2	2.34e-8	NR	WP_056465771.1	1736528	g17089	i0	58.3	1	60	22	100	1	180	1	40	96	WP_056465771.1 hypothetical protein [Rhizobacter sp. Root404]	diamond	180	56.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Rhizobacter	Rhizobacter sp. Root404
32824254	32824254	PRJNA326068_P_NODE_16940_length_199_cov_1.711765_g15977_i0	PRJNA326068	16940	199	1.711765	3.40641235	Bradyrhizobium japonicum	375	Bacteria	Bacteria	42	0.00711	NR	WP_024342609.1	375	g15977	i0	60.7	0.693467336683417	28	11	42.2	0	184	101	52	79	WP_024342609.1 PilZ domain-containing protein [Bradyrhizobium japonicum]	diamond	138	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium japonicum

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