metadata: contig_metadata: 18 rows where bioproject = "PRJNA415636" and tax

18 rows where bioproject = "PRJNA415636" and tax_kingdom = "Pseudomonadati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
419115	419115	PRJNA415636_S_NODE_6561_length_202_cov_2.025806_g6514_i0	PRJNA415636	6561	202	2.025806	4.09212812	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	302	1.5800000000000001e-77	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g6514	i0	93.564	314.282178217822	202	13	100	0	1	202	1529646	1529445	Undibacterium sp. YM2 DNA, complete genome	blastn	63485	302	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
1083270	1083270	PRJNA415636_S_NODE_2701_length_289_cov_1.475207_g2654_i0	PRJNA415636	2701	289	1.475207	4.26334823	root	1	Root_unresolved	Root_unresolved	534	2.18e-147	NTclustered	gi\|2566177108\|gb\|CP132594.1\|	562	g2654	i0	100	88.3044982698962	289	0	100	0	1	289	3914871	3914583	Escherichia coli strain SIJ488 chromosome, complete genome	blastn	25520	534	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4246170	4246170	PRJNA415636_S_NODE_1884_length_330_cov_2.491166_g1837_i0	PRJNA415636	1884	330	2.491166	8.2208478	Phyllobacterium zundukense	1867719	Bacteria	Bacteria	344	4.58e-90	NTclustered	gi\|1276680390\|gb\|CP017940.1\|	1867719	g1837	i0	85.455	2.88787878787879	330	48	100	0	1	330	2250094	2250423	Phyllobacterium zundukense strain Tri-48, complete sequence.	blastn	953	344	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium zundukense
8736134	8736134	PRJNA415636_S_NODE_4927_length_229_cov_4.236264_g4880_i0	PRJNA415636	4927	229	4.236264	9.70104456	Pseudomonas	286	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|858972107\|gb\|KT215485.1\|	294	g4880	i0	99.563	116	229	1	100	0	1	229	1094	1322	Pseudomonas fluorescens strain IC7 16S ribosomal RNA gene, partial sequence	blastn	26564	418	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
11897952	11897952	PRJNA415636_S_NODE_2610_length_293_cov_1.902439_g2563_i0	PRJNA415636	2610	293	1.902439	5.57414627	Paucibacter sediminis	3019553	Bacteria	Bacteria	481	2.92e-131	NTclustered	gi\|2517185782\|gb\|CP116346.1\|	3019553	g2563	i0	96.259	309.696245733788	294	9	100	2	1	293	899448	899740	Paucibacter sediminis strain S2-9 chromosome, complete genome	blastn	90741	481	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Paucibacter sediminis
17660803	17660803	PRJNA415636_S_NODE_4734_length_233_cov_1.370968_g4687_i0	PRJNA415636	4734	233	1.370968	3.19435544	Pasteurella	745	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|2488138257\|gb\|CP121788.1\|	747	g4687	i0	99.571	99.7682403433476	233	1	100	0	1	233	547695	547927	Pasteurella multocida strain PM-3 chromosome, complete genome	blastn	23246	425	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Pasteurella	Pasteurella multocida
22095533	22095533	PRJNA415636_S_NODE_4658_length_234_cov_3.053476_g4611_i0	PRJNA415636	4658	234	3.053476	7.14513384	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g4611	i0	100	0.128205128205128	30	0	13	0	11	40	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
22760242	22760242	PRJNA415636_S_NODE_4198_length_244_cov_1.167513_g4151_i0	PRJNA415636	4198	244	1.167513	2.84873172	Undibacterium	401469	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|2634174434\|gb\|CP133779.1\|	3048609	g4151	i0	95.902	438.483606557377	244	10	100	0	1	244	1462454	1462211	Undibacterium sp. CCC3.4 chromosome, complete genome	blastn	106990	399	0.992481203007519	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. CCC3.4
24645516	24645516	PRJNA415636_S_NODE_4260_length_242_cov_3.923077_g4213_i0	PRJNA415636	4260	242	3.923077	9.49384634	Roseateles sp. DAIF2	2714952	Bacteria	Bacteria	58.4	4.69e-4	NTclustered	gi\|1934957904\|gb\|CP049919.1\|	2714952	g4213	i0	97.059	0.264462809917355	34	1	14	0	111	144	2008680	2008713	Roseateles sp. DAIF2 chromosome, complete genome	blastn	64	58.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles sp. DAIF2
25309422	25309422	PRJNA415636_S_NODE_560_length_490_cov_6.668172_g515_i0	PRJNA415636	560	490	6.668172	32.6740428	Pseudomonas	286	Bacteria	Bacteria	826	0	NTclustered	gi\|1877575224\|dbj\|AP022227.1\|	303	g515	i0	98.71	636.812244897959	465	6	95	0	1	465	188722	188258	Pseudomonas putida DNA, complete genome, strain: WP8-W18-CRE-01	blastn	312038	826	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida
26980584	26980584	PRJNA415636_S_NODE_6242_length_208_cov_4.950311_g6195_i0	PRJNA415636	6242	208	4.950311	10.29664688	Horticoccus luteus	2862869	Bacteria	Bacteria	42.4	0.0279	NR	WP_220165494.1	2862869	g6195	i0	41.1	0.807692307692308	56	28	73.6	1	19	171	55	110	WP_220165494.1 ThuA domain-containing protein [Horticoccus luteus]	diamond	168	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
28717847	28717847	PRJNA415636_S_NODE_5327_length_222_cov_1.902857_g5280_i0	PRJNA415636	5327	222	1.902857	4.22434254	Treponema sp.	166	Bacteria	Bacteria	56.6	2.92e-7	NR	MBR5402350.1	166	g5280	i0	42.9	1.63513513513514	63	35	85.1	1	10	198	204	265	MBR5402350.1 FkbM family methyltransferase [Treponema sp.]	diamond	363	56.6	1	Bacteria		Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30201701	30201701	PRJNA415636_S_NODE_6132_length_210_cov_1.484663_g6085_i0	PRJNA415636	6132	210	1.484663	3.1177923	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.8	2.03e-9	NR	MBI4878578.1	2026780	g6085	i0	44.3	0.871428571428571	61	34	87.1	0	184	2	348	408	MBI4878578.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30233538	30233538	PRJNA415636_S_NODE_4732_length_233_cov_1.370968_g4685_i0	PRJNA415636	4732	233	1.370968	3.19435544	Solemya velum gill symbiont	2340	Bacteria	Bacteria	43.1	0.0232	NR	WP_078456856.1	2340	g4685	i0	70.8	0.309012875536481	24	7	30.9	0	99	28	328	351	WP_078456856.1 reverse transcriptase domain-containing protein [Solemya velum gill symbiont]	diamond	72	43.1	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Solemya velum gill symbiont
30360394	30360394	PRJNA415636_S_NODE_5272_length_223_cov_1.448864_g5225_i0	PRJNA415636	5272	223	1.448864	3.23096672	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	46.2	0.00151	NR	TNE61774.1	1913988	g5225	i0	53.8	2.21973094170404	39	18	52.5	0	37	153	210	248	TNE61774.1 MAG: electron transfer flavoprotein subunit beta/FixA family protein [Alphaproteobacteria bacterium]	diamond	495	46.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
30360395	30360395	PRJNA415636_S_NODE_5772_length_215_cov_1.410714_g5725_i0	PRJNA415636	5772	215	1.410714	3.0330351	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.1	0.0186	NR	TMA74746.1	2026735	g5725	i0	48.8	0.6	43	22	60	0	148	20	68	110	TMA74746.1 MAG: alpha/beta fold hydrolase [Deltaproteobacteria bacterium]	diamond	129	43.1	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30612546	30612546	PRJNA415636_S_NODE_3833_length_253_cov_1.766990_g3786_i0	PRJNA415636	3833	253	1.76699	4.4704847	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	51.2	1.86e-5	NR	HIA48344.1	2030809	g3786	i0	47.3	1.30434782608696	55	24	65.2	1	219	55	101	150	HIA48344.1 hypothetical protein [Candidatus Hydrogenedentota bacterium]	diamond	330	51.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota bacterium
31624133	31624133	PRJNA415636_S_NODE_5836_length_214_cov_1.526946_g5789_i0	PRJNA415636	5836	214	1.526946	3.26766444	Escherichia coli	562	Bacteria	Bacteria	80.5	1.16e-17	NR	WP_329792810.1	562	g5789	i0	57.4	2.56542056074766	61	26	85.5	0	196	14	23	83	WP_329792810.1 hypothetical protein, partial [Escherichia coli]	diamond	549	80.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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