metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA322517" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA322517" 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
2344411	2344411	PRJNA322517_P_NODE_1022_length_506_cov_1.474836_g1000_i0	PRJNA322517	1022	506	1.474836	7.46267016	root	1	Root_unresolved	Root_unresolved	259	2.09e-81	NR	WP_346288562.1	49181	g1000	i0	82.1	2.54940711462451	151	27	89.5	0	454	2	1	151	WP_346288562.1 cytochrome c oxidase subunit 1 [Zoogloea sp.]	diamond	1290	259	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Zoogloeaceae	Zoogloea	Zoogloea sp.
10592994	10592994	PRJNA322517_P_NODE_4889_length_176_cov_1.464567_g4867_i0	PRJNA322517	4889	176	1.464567	2.57763792	Sphingomonas	13687	Bacteria	Bacteria	108	5.23e-27	NR	WP_167301447.1	13687	g4867	i0	100	0.988636363636364	58	0	98.9	0	3	176	56	113	WP_167301447.1 MULTISPECIES: conjugal transfer protein TraF [Sphingomonas]	diamond	174	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas
22065712	22065712	PRJNA322517_P_NODE_4278_length_189_cov_2.257143_g4256_i0	PRJNA322517	4278	189	2.257143	4.26600027	Rhodanobacteraceae bacterium	2052182	Bacteria	Bacteria	92.4	5.66e-20	NR	HET7162352.1	2052182	g4256	i0	72.6	4.88888888888889	62	17	98.4	0	187	2	821	882	HET7162352.1 EAL domain-containing protein [Rhodanobacteraceae bacterium]	diamond	924	92.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae		Rhodanobacteraceae bacterium
24615437	24615437	PRJNA322517_P_NODE_5800_length_164_cov_1.773913_g5778_i0	PRJNA322517	5800	164	1.773913	2.90921732	Brevundimonas sp.	1871086	Bacteria	Bacteria	79.3	1.58e-15	NR	WP_305760250.1	1871086	g5778	i0	87.5	2.92682926829268	40	5	73.2	0	163	44	501	540	WP_305760250.1 M28 family peptidase [Brevundimonas sp.]	diamond	480	79.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas sp.
28179769	28179769	PRJNA322517_P_NODE_4406_length_186_cov_2.540146_g4384_i0	PRJNA322517	4406	186	2.540146	4.72467156	Klebsiella pneumoniae	573	Bacteria	Bacteria	41.2	0.0111	NR	WP_416493070.1	573	g4384	i0	53.7	0.661290322580645	41	19	66.1	0	1	123	34	74	WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	123	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
28860270	28860270	PRJNA322517_P_NODE_5308_length_168_cov_1.705882_g5286_i0	PRJNA322517	5308	168	1.705882	2.86588176	Methylobacterium	407	Bacteria	Bacteria	100	8.229999999999999e-23	NR	WP_238179290.1	560405	g5286	i0	85.5	2.94642857142857	55	8	98.2	0	2	166	420	474	WP_238179290.1 TonB-dependent siderophore receptor [Methylobacterium dankookense]	diamond	495	101	0.99009900990099	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium dankookense
29064212	29064212	PRJNA322517_P_NODE_5248_length_169_cov_2.108333_g5226_i0	PRJNA322517	5248	169	2.108333	3.56308277	Delftia sp. HK171	1920191	Bacteria	Bacteria	44.3	4.73e-4	NR	WP_156898013.1	1920191	g5226	i0	68.8	2.27218934911243	32	9	55	1	120	28	22	53	WP_156898013.1 hypothetical protein [Delftia sp. HK171]	diamond	384	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia sp. HK171
29663628	29663628	PRJNA322517_P_NODE_6030_length_163_cov_0.894737_g6008_i0	PRJNA322517	6030	163	0.894737	1.45842131	Acinetobacter venetianus	52133	Bacteria	Bacteria	84.3	2.77e-17	NR	WP_061518851.1	52133	g6008	i0	73.6	0.975460122699387	53	14	97.5	0	2	160	494	546	WP_061518851.1 Ig-like domain-containing protein [Acinetobacter venetianus]	diamond	159	84.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter venetianus
30218222	30218222	PRJNA322517_P_NODE_3492_length_219_cov_1.200000_g3470_i0	PRJNA322517	3492	219	1.2	2.628	Bacteria	2	Bacteria	Bacteria	70.5	4.72e-12	NR	MBN8509657.1	1891238	g3470	i0	54.2	4.95890410958904	72	30	98.6	1	216	1	167	235	MBN8509657.1 S8 family serine peptidase [Burkholderiales bacterium]	diamond	1086	70.9	0.994358251057828	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
30579863	30579863	PRJNA322517_P_NODE_6073_length_163_cov_0.894737_g6051_i0	PRJNA322517	6073	163	0.894737	1.45842131	Fluviicoccus keumensis	1435465	Bacteria	Bacteria	103	5.57e-24	NR	WP_130411539.1	1435465	g6051	i0	96.2	0.975460122699387	53	2	97.5	0	161	3	285	337	WP_130411539.1 cation acetate symporter [Fluviicoccus keumensis]	diamond	159	103	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Fluviicoccus	Fluviicoccus keumensis
30643149	30643149	PRJNA322517_P_NODE_5893_length_164_cov_0.886957_g5871_i0	PRJNA322517	5893	164	0.886957	1.45460948	Bradyrhizobium sp.	376	Bacteria	Bacteria	108	5.7900000000000005e-27	NR	MEA2912736.1	376	g5871	i0	96.3	1.97560975609756	54	2	98.8	0	163	2	46	99	MEA2912736.1 NitT/TauT family transport system substrate-binding protein [Bradyrhizobium sp.]	diamond	324	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp.
30769793	30769793	PRJNA322517_P_NODE_2634_length_286_cov_1.075949_g2612_i0	PRJNA322517	2634	286	1.075949	3.07721414	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	42.4	0.019	NR	MBO0739645.1	1913988	g2612	i0	39.5	0.451048951048951	43	26	45.1	0	158	30	52	94	MBO0739645.1 GNAT family N-acetyltransferase [Alphaproteobacteria bacterium]	diamond	129	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
31654674	31654674	PRJNA322517_P_NODE_6057_length_163_cov_0.894737_g6035_i0	PRJNA322517	6057	163	0.894737	1.45842131	Rhodanobacteraceae bacterium	2052182	Bacteria	Bacteria	51.6	9.34e-6	NR	MBL0029147.1	2052182	g6035	i0	55.6	1.52760736196319	45	20	82.8	0	29	163	261	305	MBL0029147.1 Clp protease ClpP [Rhodanobacteraceae bacterium]	diamond	249	51.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae		Rhodanobacteraceae bacterium
32256325	32256325	PRJNA322517_P_NODE_3978_length_199_cov_2.460000_g3956_i0	PRJNA322517	3978	199	2.46	4.8954	Bradyrhizobium valentinum	1518501	Bacteria	Bacteria	57.8	9.95e-8	NR	WP_057901025.1	1518501	g3956	i0	62.5	3.45226130653266	48	11	61.8	1	194	72	403	450	WP_057901025.1 IS1380 family transposase [Bradyrhizobium valentinum]	diamond	687	57.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium valentinum
32256326	32256326	PRJNA322517_P_NODE_5598_length_166_cov_0.871795_g5576_i0	PRJNA322517	5598	166	0.871795	1.4471797	Microvirga sp.	1873136	Bacteria	Bacteria	90.1	2.4900000000000004e-21	NR	HZH10847.1	1873136	g5576	i0	80	0.903614457831325	50	10	90.4	0	2	151	38	87	HZH10847.1 PilZ domain-containing protein [Microvirga sp.]	diamond	150	90.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Microvirga	Microvirga sp.
32446012	32446012	PRJNA322517_P_NODE_4919_length_175_cov_2.507937_g4897_i0	PRJNA322517	4919	175	2.507937	4.38888975	Rhizobium favelukesii	348824	Bacteria	Bacteria	100	5.079999999999999e-23	NR	WP_037069416.1	348824	g4897	i0	80.4	0.96	56	11	96	0	170	3	389	444	WP_037069416.1 hypothetical protein [Rhizobium favelukesii]	diamond	168	100	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium favelukesii

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