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

14 rows where analysis = "diamond", bioproject = "PRJNA1074407" 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
188405	188405	PRJNA1074407_P_NODE_121341_length_284_cov_1.080569_g117503_i0	PRJNA1074407	121341	284	1.080569	3.06881596	Cupriavidus	106589	Bacteria	Bacteria	196	1.08e-61	NR	WP_029700394.1	106589	g117503	i0	98.9	0.992957746478873	94	1	99.3	0	282	1	125	218	WP_029700394.1 MULTISPECIES: hypothetical protein [Cupriavidus]	diamond	282	196	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus
2739033	2739033	PRJNA1074407_P_NODE_122043_length_282_cov_1.186603_g118205_i0	PRJNA1074407	122043	282	1.186603	3.34622046	Hyphomicrobiales	356	Bacteria	Bacteria	162	2.5e-47	NR	WP_261519346.1	515947	g118205	i0	82.8	17.8085106382979	93	16	98.9	0	2	280	167	259	WP_261519346.1 DUF692 domain-containing protein [Chelativorans intermedius]	diamond	5022	162	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Chelativorans	Chelativorans intermedius
26687544	26687544	PRJNA1074407_P_NODE_90161_length_386_cov_1.597444_g86324_i0	PRJNA1074407	90161	386	1.597444	6.16613384	Hyphomicrobiales bacterium	1909294	Bacteria	Bacteria	45.8	0.0134	NR	MBN8976055.1	1909294	g86324	i0	30.4	0.613989637305699	79	54	60.6	1	303	70	111	189	MBN8976055.1 outer membrane beta-barrel protein [Hyphomicrobiales bacterium]	diamond	237	45.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales			Hyphomicrobiales bacterium
27067361	27067361	PRJNA1074407_P_NODE_72982_length_472_cov_1.428571_g69148_i0	PRJNA1074407	72982	472	1.428571	6.74285512	Halioglobus sp.	2024834	Bacteria	Bacteria	45.1	0.0497	NR	MFT6337409.1	2024834	g69148	i0	33.3	0.533898305084746	84	52	52.1	2	339	94	252	333	MFT6337409.1 hypothetical protein [Halioglobus sp.]	diamond	252	45.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Halieaceae	Halioglobus	Halioglobus sp.
27731129	27731129	PRJNA1074407_P_NODE_99584_length_350_cov_0.989170_g95746_i0	PRJNA1074407	99584	350	0.98917	3.462095	Cupriavidus	106589	Bacteria	Bacteria	138	7.64e-39	NR	WP_024569826.1	106589	g95746	i0	98.7	0.66	77	1	66	0	119	349	1	77	WP_024569826.1 MULTISPECIES: helix-turn-helix domain-containing protein [Cupriavidus]	diamond	231	138	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus
28393802	28393802	PRJNA1074407_P_NODE_148206_length_228_cov_3.477419_g144368_i0	PRJNA1074407	148206	228	3.477419	7.92851532	Ralstonia thomasii	3058596	Bacteria	Bacteria	147	3.22e-40	NR	CAJ0873079.1	3058596	g144368	i0	93.4	2	76	5	100	0	228	1	138	213	CAJ0873079.1 hypothetical protein R6138_01897 [Ralstonia thomasii]	diamond	456	147	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia thomasii
30004324	30004324	PRJNA1074407_P_NODE_136951_length_248_cov_0.868571_g133113_i0	PRJNA1074407	136951	248	0.868571	2.15405608	Cupriavidus taiwanensis	164546	Bacteria	Bacteria	139	3.3e-39	NR	WP_116369713.1	164546	g133113	i0	74.4	0.991935483870968	82	21	99.2	0	1	246	92	173	WP_116369713.1 hypothetical protein [Cupriavidus taiwanensis]	diamond	246	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus taiwanensis
30572698	30572698	PRJNA1074407_P_NODE_140773_length_244_cov_2.959064_g136935_i0	PRJNA1074407	140773	244	2.959064	7.22011616	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	43.9	0.00659	NR	MDD9818740.1	1913989	g136935	i0	41.9	0.528688524590164	43	25	52.9	0	219	91	50	92	MDD9818740.1 hypothetical protein [Gammaproteobacteria bacterium]	diamond	129	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
31015272	31015272	PRJNA1074407_P_NODE_125395_length_273_cov_1.270000_g121557_i0	PRJNA1074407	125395	273	1.27	3.4671	Cupriavidus	106589	Bacteria	Bacteria	140	1.86e-39	NR	WP_024569832.1	106589	g121557	i0	98.6	0.769230769230769	70	1	76.9	0	271	62	151	220	WP_024569832.1 MULTISPECIES: DUF2612 domain-containing protein [Cupriavidus]	diamond	210	140	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus
31363142	31363142	PRJNA1074407_P_NODE_125536_length_273_cov_1.055000_g121698_i0	PRJNA1074407	125536	273	1.055	2.88015	Xylella fastidiosa	2371	Bacteria	Bacteria	43.5	0.00947	NR	WP_140189372.1	2371	g121698	i0	50	0.923076923076923	42	20	46.2	1	129	4	68	108	WP_140189372.1 hypothetical protein, partial [Xylella fastidiosa]	diamond	252	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xylella	Xylella fastidiosa
31647507	31647507	PRJNA1074407_P_NODE_142537_length_243_cov_0.894118_g138699_i0	PRJNA1074407	142537	243	0.894118	2.17270674	Mesorhizobium sp. DCY119	2108445	Bacteria	Bacteria	43.5	0.0193	NR	WP_119921772.1	2108445	g138699	i0	80	0.617283950617284	25	5	30.9	0	75	1	1	25	WP_119921772.1 hypothetical protein [Mesorhizobium sp. DCY119]	diamond	150	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium	Mesorhizobium sp. DCY119
32027306	32027306	PRJNA1074407_P_NODE_122398_length_281_cov_1.264423_g118560_i0	PRJNA1074407	122398	281	1.264423	3.55302863	Escherichia coli	562	Bacteria	Bacteria	42	0.0135	NR	MFK9312080.1	562	g118560	i0	46.3	0.576512455516014	54	27	55.5	1	184	29	14	67	MFK9312080.1 hypothetical protein [Escherichia coli]	diamond	162	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32470493	32470493	PRJNA1074407_P_NODE_97739_length_356_cov_1.530035_g93901_i0	PRJNA1074407	97739	356	1.530035	5.4469246	Cupriavidus metallidurans	119219	Bacteria	Bacteria	234	4.23e-77	NR	WP_035835132.1	119219	g93901	i0	100	0.960674157303371	114	0	96.1	0	2	343	41	154	WP_035835132.1 HNH endonuclease [Cupriavidus metallidurans]	diamond	342	234	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus metallidurans
32682460	32682460	PRJNA1074407_P_NODE_128180_length_266_cov_1.088083_g124342_i0	PRJNA1074407	128180	266	1.088083	2.89430078	root	1	Root_unresolved	Root_unresolved	45.4	0.00531	NR	WP_267339125.1	670	g124342	i0	95	0.902255639097744	20	1	22.6	0	100	41	59	78	WP_267339125.1 RNA-directed DNA polymerase, partial [Vibrio parahaemolyticus]	diamond	240	45.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio parahaemolyticus

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