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

15 rows where bioproject = "PRJNA1047749" 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
1449582	1449582	PRJNA1047749_P_NODE_17082_length_312_cov_5.121339_g16815_i0	PRJNA1047749	17082	312	5.121339	15.97857768	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	126	1.69e-24	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g16815	i0	83.582	10.8076923076923	134	22	43	0	162	295	867518	867651	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	3372	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
4838446	4838446	PRJNA1047749_P_NODE_39544_length_251_cov_2.129213_g39277_i0	PRJNA1047749	39544	251	2.129213	5.34432463	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	132	1.32e-35	NR	MCF8030949.1	2683721	g39277	i0	85.4	0.9800796812749	82	12	98	0	1	246	24	105	MCF8030949.1 calcium/sodium antiporter [Desulfohalobiaceae bacterium]	diamond	246	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
23127255	23127255	PRJNA1047749_P_NODE_23079_length_301_cov_7.245614_g22812_i0	PRJNA1047749	23079	301	7.245614	21.80929814	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	67.6	1e-6	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g22812	i0	95.349	0.142857142857143	43	1	14	1	78	119	270073	270115	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	43	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
27319864	27319864	PRJNA1047749_P_NODE_33563_length_272_cov_7.331658_g33296_i0	PRJNA1047749	33563	272	7.331658	19.94210976	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	43.9	0.0174	NR	HYS42777.1	2282154	g33296	i0	66.7	0.264705882352941	24	8	26.5	0	79	8	1	24	HYS42777.1 phosphatidylserine decarboxylase [Geobacteraceae bacterium]	diamond	72	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
27635698	27635698	PRJNA1047749_P_NODE_18764_length_312_cov_3.594142_g18497_i0	PRJNA1047749	18764	312	3.594142	11.21372304	Citrifermentans bremense	60035	Bacteria	Bacteria	127	1.2099999999999999e-31	NR	WP_185245229.1	60035	g18497	i0	66.7	1.03846153846154	108	28	96.2	2	13	312	617	724	WP_185245229.1 VPA1269 family protein [Citrifermentans bremense]	diamond	324	127	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
27793560	27793560	PRJNA1047749_P_NODE_51284_length_201_cov_4.203125_g51017_i0	PRJNA1047749	51284	201	4.203125	8.44828125	Desulfovibrio gilichinskyi	1519643	Bacteria	Bacteria	42	0.0415	NR	WP_085101111.1	1519643	g51017	i0	38.6	0.850746268656716	57	31	85.1	1	10	180	318	370	WP_085101111.1 type VI secretion system baseplate subunit TssF [Desulfovibrio gilichinskyi]	diamond	171	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio gilichinskyi
28038036	28038036	PRJNA1047749_P_NODE_20405_length_312_cov_2.686192_g20138_i0	PRJNA1047749	20405	312	2.686192	8.38091904	Bacteria	2	Bacteria	Bacteria	91.3	1.21e-20	NR	GLI34600.1	40218	g20138	i0	61.8	3.68269230769231	68	26	65.4	0	311	108	94	161	GLI34600.1 hypothetical protein DAMNIGENAA_20330 [Desulforhabdus amnigena]	diamond	1149	91.7	0.995637949836423	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus amnigena
28606245	28606245	PRJNA1047749_P_NODE_40727_length_248_cov_1.742857_g40460_i0	PRJNA1047749	40727	248	1.742857	4.32228536	Pseudomonadati	3379134	Bacteria	Bacteria	79.3	3.71e-15	NR	WP_072697861.1	466107	g40460	i0	55.7	14.6370967741935	61	27	73.8	0	246	64	315	375	WP_072697861.1 ABC transporter permease [Desulfovibrio litoralis]	diamond	3630	80.1	0.990012484394507	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio litoralis
28740665	28740665	PRJNA1047749_P_NODE_27327_length_297_cov_2.933036_g27060_i0	PRJNA1047749	27327	297	2.933036	8.71111692	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	93.2	5.46e-21	NR	MEF8889383.1	2683721	g27060	i0	94.1	1.03030303030303	51	3	51.5	0	2	154	12	62	MEF8889383.1 NAD(P)/FAD-dependent oxidoreductase [Desulfohalobiaceae bacterium]	diamond	306	93.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
29434993	29434993	PRJNA1047749_P_NODE_18610_length_312_cov_3.690377_g18343_i0	PRJNA1047749	18610	312	3.690377	11.51397624	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	94.7	4.51e-20	NR	MEF8824560.1	2683721	g18343	i0	100	0.451923076923077	47	0	45.2	0	151	11	351	397	MEF8824560.1 aldehyde ferredoxin oxidoreductase family protein [Desulfohalobiaceae bacterium]	diamond	141	94.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
29655872	29655872	PRJNA1047749_P_NODE_10270_length_390_cov_8.208202_g10006_i0	PRJNA1047749	10270	390	8.208202	32.0119878	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	50.8	2.78e-4	NR	MCL7487090.1	2053307	g10006	i0	38.2	0.584615384615385	76	38	56.2	3	389	171	581	650	MCL7487090.1 glycosyltransferase [Desulfobulbaceae bacterium]	diamond	228	50.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29972103	29972103	PRJNA1047749_P_NODE_7831_length_443_cov_7.189189_g7569_i0	PRJNA1047749	7831	443	7.189189	31.84810727	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	162	4.89e-44	NR	HSC35060.1	2202153	g7569	i0	63.3	5.68171557562077	139	35	83.3	2	412	44	419	557	HSC35060.1 thiamine pyrophosphate-binding protein [Thermodesulfobacteriota bacterium]	diamond	2517	162	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30256842	30256842	PRJNA1047749_P_NODE_39632_length_251_cov_1.275281_g39365_i0	PRJNA1047749	39632	251	1.275281	3.20095531	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	65.1	5.51e-10	NR	HEX9079684.1	2099677	g39365	i0	48.1	1.91235059760956	77	37	88.4	1	5	226	496	572	HEX9079684.1 protease pro-enzyme activation domain-containing protein [Desulfuromonadaceae bacterium]	diamond	480	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
31449370	31449370	PRJNA1047749_P_NODE_23336_length_301_cov_5.811404_g23069_i0	PRJNA1047749	23336	301	5.811404	17.49232604	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	1.57e-12	NR	OGU17869.1	1798316	g23069	i0	80.5	4.55481727574751	41	8	40.9	0	299	177	325	365	OGU17869.1 MAG: cell filamentation protein Fic [Geobacteraceae bacterium GWC2_53_11]	diamond	1371	73.2	0.994535519125683	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium GWC2_53_11
32902809	32902809	PRJNA1047749_P_NODE_15840_length_312_cov_8.728033_g15573_i0	PRJNA1047749	15840	312	8.728033	27.231462960000002	Bacteria	2	Bacteria	Bacteria	85.1	1.13e-16	NR	WP_035239582.1	34031	g15573	i0	85.4	5.51923076923077	41	6	39.4	0	285	163	1	41	WP_035239582.1 GmrSD restriction endonuclease domain-containing protein [Desulfobacter vibrioformis]	diamond	1722	85.5	0.9953216374269	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter vibrioformis

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