metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB4632" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB4632" 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
9918226	9918226	PRJEB4632_P_NODE_768_length_251_cov_0.865169_g730_i0	PRJEB4632	768	251	0.865169	2.17157419	Curvibacter lanceolatus	86182	Bacteria	Bacteria	166	1.64e-45	NR	WP_019575978.1	86182	g730	i0	98.8	0.99203187250996006	83	1	99.2	0	251	3	526	608	WP_019575978.1 multidrug efflux RND transporter permease subunit [Curvibacter lanceolatus]	diamond	249	166	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Curvibacter	Curvibacter lanceolatus
11539804	11539804	PRJEB4632_P_NODE_770_length_251_cov_0.865169_g732_i0	PRJEB4632	770	251	0.865169	2.17157419	Rubrivivax albus	2499835	Bacteria	Bacteria	148	9.21e-42	NR	WP_199232348.1	2499835	g732	i0	84.3	2.97609561752988	83	13	99.2	0	250	2	111	193	WP_199232348.1 relaxase/mobilization nuclease domain-containing protein [Rubrivivax albus]	diamond	747	148	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Rubrivivax	Rubrivivax albus
11539807	11539807	PRJEB4632_P_NODE_950_length_243_cov_0.905882_g912_i0	PRJEB4632	950	243	0.905882	2.20129326	Simplicispira psychrophila	80882	Bacteria	Bacteria	159	5.4e-47	NR	WP_027995927.1	80882	g912	i0	96.3	0.987654320987654	80	3	98.8	0	2	241	24	103	WP_027995927.1 heavy metal response regulator transcription factor [Simplicispira psychrophila]	diamond	240	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Simplicispira	Simplicispira psychrophila
27033440	27033440	PRJEB4632_P_NODE_982_length_241_cov_0.916667_g944_i0	PRJEB4632	982	241	0.916667	2.20916747	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	160	8.98e-46	NR	MBS0422071.1	1977087	g944	i0	92.4	0.983402489626556	79	6	98.3	0	1	237	244	322	MBS0422071.1 beta-lactamase family protein [Pseudomonadota bacterium]	diamond	237	160	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
28770366	28770366	PRJEB4632_P_NODE_827_length_248_cov_0.880000_g789_i0	PRJEB4632	827	248	0.88	2.1824	Novosphingobium sp. BL-8A	3127639	Bacteria	Bacteria	48.1	5.15e-4	NR	WP_395392807.1	3127639	g789	i0	59	0.943548387096774	39	16	47.2	0	248	132	201	239	WP_395392807.1 Ig-like domain-containing protein [Novosphingobium sp. BL-8A]	diamond	234	48.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp. BL-8A
28896589	28896589	PRJEB4632_P_NODE_948_length_243_cov_0.905882_g910_i0	PRJEB4632	948	243	0.905882	2.20129326	Curvibacter gracilis	230310	Bacteria	Bacteria	155	3.3299999999999996e-45	NR	WP_027476396.1	230310	g910	i0	98.8	1	81	1	100	0	243	1	130	210	WP_027476396.1 flagellar basal-body rod protein FlgF [Curvibacter gracilis]	diamond	243	155	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Curvibacter	Curvibacter gracilis
28960103	28960103	PRJEB4632_P_NODE_988_length_241_cov_0.916667_g950_i0	PRJEB4632	988	241	0.916667	2.20916747	unclassified Sphingomonas	196159	Bacteria	Bacteria	172	3.23e-53	NR	WP_033965179.1	196159	g950	i0	100	0.983402489626556	79	0	98.3	0	3	239	49	127	WP_033965179.1 MULTISPECIES: rod shape-determining protein MreD [unclassified Sphingomonas]	diamond	237	172	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas
30286682	30286682	PRJEB4632_P_NODE_972_length_242_cov_0.911243_g934_i0	PRJEB4632	972	242	0.911243	2.20520806	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	143	2.71e-42	NR	HEX4888938.1	1913988	g934	i0	82.3	2.93801652892562	79	14	97.9	0	237	1	10	88	HEX4888938.1 hypothetical protein [Alphaproteobacteria bacterium]	diamond	711	143	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
31417254	31417254	PRJEB4632_P_NODE_896_length_245_cov_0.895349_g858_i0	PRJEB4632	896	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	125	4.2499999999999996e-32	NR	HBA09945.1	359408	g858	i0	73.8	4.9469387755102	80	20	98	1	244	5	118	196	HBA09945.1 PBSX family phage terminase large subunit [Methylotenera mobilis]	diamond	1212	125	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylotenera	Methylotenera mobilis

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