metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA796639" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA796639" 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
16083075	16083075	PRJNA796639_P_NODE_6933_length_245_cov_0.895349_g6808_i0	PRJNA796639	6933	245	0.895349	2.19360505	Bradyrhizobium sp.	376	Bacteria	Bacteria	116	7.01e-30	NR	HEY3681296.1	376	g6808	i0	80	0.979591836734694	80	16	98	0	245	6	16	95	HEY3681296.1 SDR family oxidoreductase [Bradyrhizobium sp.]	diamond	240	116	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp.
27022248	27022248	PRJNA796639_P_NODE_7362_length_243_cov_0.905882_g7237_i0	PRJNA796639	7362	243	0.905882	2.20129326	Acidisoma sp.	1872115	Bacteria	Bacteria	68.6	3.09e-11	NR	WP_325355589.1	1872115	g7237	i0	42.5	0.987654320987654	80	46	98.8	0	1	240	435	514	WP_325355589.1 tetratricopeptide repeat protein [Acidisoma sp.]	diamond	240	68.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acidocellaceae	Acidisoma	Acidisoma sp.
28064525	28064525	PRJNA796639_P_NODE_3985_length_287_cov_0.714953_g3860_i0	PRJNA796639	3985	287	0.714953	2.05191511	Mesorhizobium caraganae	483206	Bacteria	Bacteria	41.6	0.036	NR	WP_352583011.1	483206	g3860	i0	46.3	0.564459930313589	54	24	53.3	2	129	281	38	89	WP_352583011.1 hypothetical protein [Mesorhizobium caraganae]	diamond	162	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium	Mesorhizobium caraganae
28727650	28727650	PRJNA796639_P_NODE_5007_length_264_cov_1.209424_g4882_i0	PRJNA796639	5007	264	1.209424	3.19287936	Bradyrhizobium sp. sGM-13	2831781	Bacteria	Bacteria	42	0.0294	NR	WP_213286996.1	2831781	g4882	i0	47.5	0.454545454545455	40	19	43.2	1	84	197	57	96	WP_213286996.1 hypothetical protein [Bradyrhizobium sp. sGM-13]	diamond	120	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. sGM-13
29106599	29106599	PRJNA796639_P_NODE_7668_length_241_cov_1.595238_g7543_i0	PRJNA796639	7668	241	1.595238	3.84452358	Falsiroseomonas oryzae	2766473	Bacteria	Bacteria	40.8	0.0415	NR	WP_270936135.1	2766473	g7543	i0	38.2	0.684647302904564	55	30	64.7	2	231	76	34	87	WP_270936135.1 (2Fe-2S)-binding protein [Falsiroseomonas oryzae]	diamond	165	40.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Roseomonadaceae	Falsiroseomonas	Falsiroseomonas oryzae
30085322	30085322	PRJNA796639_P_NODE_4572_length_274_cov_0.791045_g4447_i0	PRJNA796639	4572	274	0.791045	2.1674633	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	43.5	0.0283	NR	MEE9139708.1	1913988	g4447	i0	47.6	0.45985401459854	42	17	40.5	2	46	156	142	183	MEE9139708.1 MFS transporter [Alphaproteobacteria bacterium]	diamond	126	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
30843838	30843838	PRJNA796639_P_NODE_6134_length_249_cov_0.875000_g6009_i0	PRJNA796639	6134	249	0.875	2.17875	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	41.2	0.0365	NR	MBU6506961.1	1913988	g6009	i0	32.2	0.710843373493976	59	36	69.9	2	75	248	21	76	MBU6506961.1 hypothetical protein [Alphaproteobacteria bacterium]	diamond	177	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
31254469	31254469	PRJNA796639_P_NODE_5455_length_252_cov_1.435754_g5330_i0	PRJNA796639	5455	252	1.435754	3.61810008	Pseudomonadaceae bacterium	1914538	Bacteria	Bacteria	48.9	1.85e-4	NR	HHX83143.1	1914538	g5330	i0	62.5	0.857142857142857	32	12	38.1	0	24	119	149	180	HHX83143.1 hypothetical protein [Pseudomonadaceae bacterium]	diamond	216	48.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae		Pseudomonadaceae bacterium
32172104	32172104	PRJNA796639_P_NODE_5538_length_251_cov_0.865169_g5413_i0	PRJNA796639	5538	251	0.865169	2.17157419	Andreprevotia sp. IGB-42	2497473	Bacteria	Bacteria	42.7	0.0417	NR	WP_201800025.1	2497473	g5413	i0	43.5	0.549800796812749	46	24	55	1	11	148	55	98	WP_201800025.1 type VI secretion system Vgr family protein [Andreprevotia sp. IGB-42]	diamond	138	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chitinibacteraceae	Andreprevotia	Andreprevotia sp. IGB-42
32677363	32677363	PRJNA796639_P_NODE_7840_length_241_cov_0.916667_g7715_i0	PRJNA796639	7840	241	0.916667	2.20916747	Sphingomonas lenta	1141887	Bacteria	Bacteria	42.4	0.0284	NR	WP_095999663.1	1141887	g7715	i0	48.5	0.410788381742739	33	17	41.1	0	127	29	94	126	WP_095999663.1 hypothetical protein [Sphingomonas lenta]	diamond	99	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas lenta

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