metadata: contig_metadata: 10 rows where bioproject = "PRJNA407886" and tax

10 rows where bioproject = "PRJNA407886" 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
16995214	16995214	PRJNA407886_P_NODE_57874_length_280_cov_1.487923_g56180_i0	PRJNA407886	57874	280	1.487923	4.1661844	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	157	6.4999999999999985e-47	NR	GJM17675.1	2202153	g56180	i0	78.5	1.99285714285714	93	20	99.6	0	279	1	10	102	GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium]	diamond	558	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
26663686	26663686	PRJNA407886_P_NODE_55261_length_287_cov_4.060748_g53567_i0	PRJNA407886	55261	287	4.060748	11.65434676	Desulfovibrio subterraneus	2718620	Bacteria	Bacteria	43.9	0.0251	NR	WP_243452140.1	2718620	g53567	i0	52.8	0.376306620209059	36	17	37.6	0	108	215	252	287	WP_243452140.1 PD-(D/E)XK nuclease family protein [Desulfovibrio subterraneus]	diamond	108	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio subterraneus
27423394	27423394	PRJNA407886_P_NODE_43283_length_331_cov_1.046512_g41589_i0	PRJNA407886	43283	331	1.046512	3.46395472	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	45.4	0.0107	NR	MEW5736450.1	2202153	g41589	i0	33.8	0.589123867069486	65	43	58.9	0	6	200	355	419	MEW5736450.1 phosphotransferase [Thermodesulfobacteriota bacterium]	diamond	195	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28686383	28686383	PRJNA407886_P_NODE_82207_length_241_cov_0.863095_g80513_i0	PRJNA407886	82207	241	0.863095	2.08005895	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.9	0.0114	NR	MDY7032750.1	2202153	g80513	i0	35	0.746887966804979	60	39	74.7	0	62	241	8	67	MDY7032750.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	180	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28875553	28875553	PRJNA407886_P_NODE_63428_length_265_cov_2.109375_g61734_i0	PRJNA407886	63428	265	2.109375	5.58984375	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	102	4.8799999999999997e-23	NR	HAO22905.1	2049433	g61734	i0	52.4	0.928301886792453	82	38	91.7	1	2	244	377	458	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	246	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
28938832	28938832	PRJNA407886_P_NODE_74108_length_247_cov_1.528736_g72414_i0	PRJNA407886	74108	247	1.528736	3.77597792	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	58.9	1.89e-8	NR	HJX60397.1	2202153	g72414	i0	45.5	0.801619433198381	66	36	80.2	0	42	239	104	169	HJX60397.1 biotin/lipoyl-containing protein [Thermodesulfobacteriota bacterium]	diamond	198	58.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29002293	29002293	PRJNA407886_P_NODE_50868_length_301_cov_1.350877_g49174_i0	PRJNA407886	50868	301	1.350877	4.06613977	Pelobacter seleniigenes	407188	Bacteria	Bacteria	84.3	7.59e-19	NR	WP_029917353.1	407188	g49174	i0	46.6	0.877076411960133	88	42	87.7	1	301	38	10	92	WP_029917353.1 YciI family protein [Pelobacter seleniigenes]	diamond	264	84.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter seleniigenes
30517862	30517862	PRJNA407886_P_NODE_74533_length_247_cov_0.885057_g72839_i0	PRJNA407886	74533	247	0.885057	2.18609079	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	47.8	6.84e-4	NR	MCY4378980.1	2080303	g72839	i0	52.8	0.874493927125506	36	17	43.7	0	7	114	70	105	MCY4378980.1 leucine-rich repeat domain-containing protein [Candidatus Dadabacteria bacterium]	diamond	216	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
31940278	31940278	PRJNA407886_P_NODE_52137_length_297_cov_1.366071_g50443_i0	PRJNA407886	52137	297	1.366071	4.05723087	Syntrophus sp. (in: bacteria)	48412	Bacteria	Bacteria	64.7	1.24e-9	NR	WP_367360148.1	48412	g50443	i0	50.8	3.81818181818182	65	32	65.7	0	35	229	197	261	WP_367360148.1 hypothetical protein [Syntrophus sp. (in: bacteria)]	diamond	1134	64.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus sp. (in: bacteria)
31972049	31972049	PRJNA407886_P_NODE_67858_length_255_cov_1.500000_g66164_i0	PRJNA407886	67858	255	1.5	3.825	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	76.6	3.21e-14	NR	MCB2228670.1	2528248	g66164	i0	42.9	0.988235294117647	84	48	98.8	0	252	1	16	99	MCB2228670.1 class 1 fructose-bisphosphatase [Desulfarculaceae bacterium]	diamond	252	76.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae 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);;