metadata: contig_metadata: 15 rows where bioproject = "PRJNA610520" and tax

15 rows where bioproject = "PRJNA610520" 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
4416008	4416008	PRJNA610520_S_NODE_42404_length_289_cov_1.782407_g42314_i0	PRJNA610520	42404	289	1.782407	5.15115623	Ralstonia pickettii	329	Bacteria	Bacteria	503	6.139999999999998e-138	NTclustered	gi\|2556944802\|gb\|CP104381.1\|	329	g42314	i0	98.592	98.4186851211073	284	4	98	0	1	284	2240175	2240458	Ralstonia pickettii strain MCR chromosome 1, complete sequence	blastn	28443	503	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
4975553	4975553	PRJNA610520_S_NODE_46484_length_280_cov_1.115942_g46394_i0	PRJNA610520	46484	280	1.115942	3.1246376	Psychrobacter	497	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|2565764499\|gb\|CP132595.1\|	3064892	g46394	i0	98.929	35.6214285714286	280	3	100	0	1	280	2945658	2945937	Psychrobacter sp. van23A chromosome, complete genome	blastn	9974	501	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp. van23A
5692006	5692006	PRJNA610520_S_NODE_32745_length_314_cov_11.423237_g32655_i0	PRJNA610520	32745	314	11.423237	35.86896418	Eleftheria terrae	1597781	Bacteria	Bacteria	159	1.68e-34	NTclustered	gi\|2533425405\|gb\|CP106951.1\|	1597781	g32655	i0	82.258	6.45541401273885	186	31	59	2	128	312	4460414	4460598	Eleftheria terrae strain P9846-PB chromosome, complete genome	blastn	2027	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Eleftheria	Eleftheria terrae
8241468	8241468	PRJNA610520_S_NODE_39087_length_297_cov_4.160714_g38997_i0	PRJNA610520	39087	297	4.160714	12.35732058	Sphingomonas leidyi	68569	Bacteria	Bacteria	80.5	1.27e-10	NTclustered	gi\|2814041301\|gb\|CP170557.1\|	68569	g38997	i0	91.379	16.010101010101	58	5	20	0	240	297	1856210	1856153	Sphingomonas leidyi strain UC122_23 chromosome, complete genome	blastn	4755	80.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas leidyi
15891430	15891430	PRJNA610520_S_NODE_51573_length_269_cov_1.571429_g51483_i0	PRJNA610520	51573	269	1.571429	4.22714401	Ralstonia pickettii	329	Bacteria	Bacteria	475	1.2299999999999999e-129	NTclustered	gi\|2556944802\|gb\|CP104381.1\|	329	g51483	i0	98.513	99.7323420074349	269	4	100	0	1	269	1156129	1156397	Ralstonia pickettii strain MCR chromosome 1, complete sequence	blastn	26828	475	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
18440493	18440493	PRJNA610520_S_NODE_50915_length_270_cov_2.345178_g50825_i0	PRJNA610520	50915	270	2.345178	6.3319806	Psychrobacter sp. G	571800	Bacteria	Bacteria	200	8.349999999999999e-47	NTclustered	gi\|521014486\|gb\|CP006265.1\|	571800	g50825	i0	81.526	1.6962962962963	249	41	92	3	1	248	1838348	1838592	Psychrobacter sp. G, complete genome	blastn	458	200	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp. G
19715120	19715120	PRJNA610520_S_NODE_72056_length_222_cov_4.114094_g71966_i0	PRJNA610520	72056	222	4.114094	9.13328868	Microvirga ossetica	1882682	Bacteria	Bacteria	82.4	2.51e-11	NTclustered	gi\|1049766302\|gb\|CP016616.1\|	1882682	g71966	i0	80.531	1.36036036036036	113	16	50	5	110	219	1052218	1052327	Microvirga ossetica strain V5/3M, complete sequence.	blastn	302	82.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Microvirga	Microvirga ossetica
22265697	22265697	PRJNA610520_S_NODE_69738_length_239_cov_2.638554_g69648_i0	PRJNA610520	69738	239	2.638554	6.30614406	Acinetobacter baumannii	470	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2470454228\|gb\|CP113071.1\|	470	g69648	i0	100	0.702928870292887	28	0	12	0	162	189	2016407	2016380	Acinetobacter baumannii strain A118 DeltaH0N27_10830::kan chromosome, complete genome	blastn	168	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
26605113	26605113	PRJNA610520_S_NODE_70221_length_236_cov_2.834356_g70131_i0	PRJNA610520	70221	236	2.834356	6.68908016	Pleionea sediminis	2569479	Bacteria	Bacteria	64.3	5.05e-10	NR	WP_144392370.1	2569479	g70131	i0	41.6	2.9364406779661	77	45	97.9	0	6	236	23	99	WP_144392370.1 TatD family hydrolase [Pleionea sediminis]	diamond	693	64.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Pleioneaceae	Pleionea	Pleionea sediminis
26921962	26921962	PRJNA610520_S_NODE_22622_length_349_cov_1.094203_g22532_i0	PRJNA610520	22622	349	1.094203	3.81876847	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	113	3.18e-28	NR	MBP5215296.1	1913988	g22532	i0	60	3.30085959885387	100	39	86	1	347	48	150	248	MBP5215296.1 chaperonin GroEL [Alphaproteobacteria bacterium]	diamond	1152	113	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
27838081	27838081	PRJNA610520_S_NODE_47564_length_277_cov_2.882353_g47474_i0	PRJNA610520	47564	277	2.882353	7.98411781	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	61.2	1.49e-8	NR	MCH9845700.1	1913988	g47474	i0	44.6	0.703971119133574	65	36	70.4	0	4	198	89	153	MCH9845700.1 thioredoxin [Alphaproteobacteria bacterium]	diamond	195	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28059197	28059197	PRJNA610520_S_NODE_65925_length_245_cov_0.895349_g65835_i0	PRJNA610520	65925	245	0.895349	2.19360505	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	47	4.71e-4	NR	WP_395515008.1	251699	g65835	i0	42.1	1.82448979591837	76	42	90.6	1	21	242	48	123	WP_395515008.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	447	47	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7
28103799	28103799	PRJNA610520_S_NODE_54825_length_262_cov_9.142857_g54735_i0	PRJNA610520	54825	262	9.142857	23.95428534	root	1	Root_unresolved	Root_unresolved	41.6	0.0185	NR	WP_143213185.1	470	g54735	i0	100	87.9389312977099	20	0	22.9	0	262	203	55	74	WP_143213185.1 hypothetical protein, partial [Acinetobacter baumannii]	diamond	23040	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
31217190	31217190	PRJNA610520_S_NODE_60195_length_252_cov_2.553073_g60105_i0	PRJNA610520	60195	252	2.553073	6.43374396	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	47.8	6.78e-4	NR	RMH17565.1	1913989	g60105	i0	35.7	0.666666666666667	56	36	66.7	0	30	197	336	391	RMH17565.1 MAG: DUF4124 domain-containing protein [Gammaproteobacteria bacterium]	diamond	168	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
31723588	31723588	PRJNA610520_S_NODE_61937_length_250_cov_1.056497_g61847_i0	PRJNA610520	61937	250	1.056497	2.6412425	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	42.7	0.0325	NR	WP_395569333.1	251699	g61847	i0	44.4	0.756	63	16	74.4	3	54	239	153	197	WP_395569333.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	189	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7

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