metadata: contig_metadata: 5 rows where bioproject = "PRJNA1215813", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA1215813", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

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
26901826	26901826	PRJNA1215813_P_NODE_10201_length_250_cov_0.881356_g10121_i0	PRJNA1215813	10201	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	114	2.22e-28	NR	WP_013162705.1	427923	g10121	i0	69.9	28.296	83	22	97.2	2	6	248	108	189	WP_013162705.1 class 1 fructose-bisphosphatase [Desulfurivibrio alkaliphilus]	diamond	7074	115	0.991304347826087	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
28241066	28241066	PRJNA1215813_P_NODE_11626_length_245_cov_0.906977_g11546_i0	PRJNA1215813	11626	245	0.906977	2.22209365	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	73.2	7.14e-13	NR	MFC1834884.1	2202153	g11546	i0	41.5	1.00408163265306	82	47	99.2	1	1	243	283	364	MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	246	73.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30420592	30420592	PRJNA1215813_P_NODE_12033_length_244_cov_0.912281_g11953_i0	PRJNA1215813	12033	244	0.912281	2.22596564	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	86.7	7.43e-18	NR	MDK2955567.1	2448050	g11953	i0	55.7	1.91803278688525	79	34	97.1	1	239	3	218	295	MDK2955567.1 basic rane protein [Desulfovibrionales bacterium]	diamond	468	86.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
31463357	31463357	PRJNA1215813_P_NODE_10916_length_248_cov_0.891429_g10836_i0	PRJNA1215813	10916	248	0.891429	2.21074392	Syntrophales bacterium	2928017	Bacteria	Bacteria	57	3.64e-7	NR	MDO9558300.1	2928017	g10836	i0	39.5	0.919354838709677	76	44	89.5	1	26	247	126	201	MDO9558300.1 arginine deiminase family protein [Syntrophales bacterium]	diamond	228	57	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
32178113	32178113	PRJNA1215813_P_NODE_2858_length_447_cov_2.991979_g2778_i0	PRJNA1215813	2858	447	2.991979	13.37414613	Bacteria	2	Bacteria	Bacteria	51.6	3.75e-5	NR	MEJ2102355.1	2044940	g2778	i0	38.9	1.25503355704698	90	48	60.4	2	439	170	4	86	MEJ2102355.1 DUF86 domain-containing protein [Desulfobacterales bacterium]	diamond	561	52	0.992307692307692	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium

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