metadata: contig_metadata: 34 rows where bioproject = "PRJNA1237347" and tax

34 rows where bioproject = "PRJNA1237347" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
344401	344401	PRJNA1237347_P_NODE_508781_length_246_cov_3.248555_g502208_i0	PRJNA1237347	508781	246	3.248555	7.9914453	Rhodothermales bacterium	2306054	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621702557\|emb\|OY760427.1\|	2306054	g502208	i0	100	0.117886178861789	29	0	12	0	206	234	1156397	1156369	MAG: Rhodothermales bacterium isolate 1504ddc0-b432-43e2-af37-a45191a88aeb genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
1618628	1618628	PRJNA1237347_P_NODE_480822_length_250_cov_0.870056_g474249_i0	PRJNA1237347	480822	250	0.870056	2.17514	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	158	4.650000000000001e-44	NR	HEX8384717.1	2838334	g474249	i0	90.4	6.948	83	8	99.6	0	1	249	29	111	HEX8384717.1 cysteine--tRNA ligase [Rubricoccaceae bacterium]	diamond	1737	158	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
4876702	4876702	PRJNA1237347_P_NODE_376504_length_290_cov_0.834101_g369931_i0	PRJNA1237347	376504	290	0.834101	2.4188929	Rhodothermales bacterium	2306054	Bacteria	Bacteria	104	1.36e-24	NR	HUF10969.1	2306054	g369931	i0	53.7	2.94827586206897	95	36	98.3	2	3	287	145	231	HUF10969.1 2-oxoglutarate and iron-dependent oxygenase domain-containing protein [Rhodothermales bacterium]	diamond	855	104	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
6720118	6720118	PRJNA1237347_P_NODE_392426_length_283_cov_1.100000_g385853_i0	PRJNA1237347	392426	283	1.1	3.113	Pseudomonadati	3379134	Bacteria	Bacteria	160	2.23e-45	NR	MCA1803421.1	2026787	g385853	i0	82.8	5.93639575971731	93	16	98.6	0	279	1	278	370	MCA1803421.1 hypothetical protein [Rhodothermaceae bacterium]	diamond	1680	160	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
13095703	13095703	PRJNA1237347_P_NODE_372951_length_291_cov_1.766055_g366378_i0	PRJNA1237347	372951	291	1.766055	5.13922005	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	160	4.84e-44	NR	MCA1803155.1	2026787	g366378	i0	87.8	2.61855670103093	82	10	84.5	0	46	291	4	85	MCA1803155.1 MFS transporter [Rhodothermaceae bacterium]	diamond	762	160	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
13097874	13097874	PRJNA1237347_P_NODE_485191_length_249_cov_2.590909_g478618_i0	PRJNA1237347	485191	249	2.590909	6.45136341	Rhodothermales bacterium	2306054	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|2893358395\|emb\|OZ220686.1\|	2306054	g478618	i0	93.574	737.586345381526	249	16	100	0	1	249	1666331	1666579	MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1	blastn	183659	372	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
15077135	15077135	PRJNA1237347_P_NODE_567572_length_220_cov_12.653061_g560998_i0	PRJNA1237347	567572	220	12.653061	27.8367342	Bacteria	2	Bacteria	Bacteria	213	8.44e-51	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g560998	i0	84.404	174.890909090909	218	33	99	1	3	220	2903916	2904132	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	38476	213	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
15648595	15648595	PRJNA1237347_P_NODE_61033_length_933_cov_3.951163_g55524_i0	PRJNA1237347	61033	933	3.951163	36.86435079	Rhodothermus marinus	29549	Bacteria	Bacteria	403	6.47e-135	NR	WP_029933085.1	29549	g55524	i0	73	18.1350482315113	252	68	81	0	756	1	11	262	WP_029933085.1 phosphoenolpyruvate carboxykinase (ATP) [Rhodothermus marinus]	diamond	16920	403	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
18196711	18196711	PRJNA1237347_P_NODE_540235_length_243_cov_0.905882_g533662_i0	PRJNA1237347	540235	243	0.905882	2.20129326	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	261	3.34e-65	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g533662	i0	86.122	42.4938271604938	245	30	100	4	1	243	3196160	3196402	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	10326	261	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
22019270	22019270	PRJNA1237347_P_NODE_401518_length_279_cov_1.286408_g394945_i0	PRJNA1237347	401518	279	1.286408	3.58907832	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	200	8.67e-47	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g394945	i0	79.787	16.0824372759857	282	51	100	5	1	279	2833798	2833520	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	4487	200	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26946402	26946402	PRJNA1237347_P_NODE_320342_length_320_cov_3.473684_g313769_i0	PRJNA1237347	320342	320	3.473684	11.1157888	Rhodothermales bacterium	2306054	Bacteria	Bacteria	100	1.94e-24	NR	HMB94299.1	2306054	g313769	i0	49.4	2.521875	85	43	79.7	0	60	314	17	101	HMB94299.1 DUF2147 domain-containing protein [Rhodothermales bacterium]	diamond	807	100	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27104800	27104800	PRJNA1237347_P_NODE_545042_length_242_cov_0.911243_g538469_i0	PRJNA1237347	545042	242	0.911243	2.20520806	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	119	4.2e-29	NR	HEX8385994.1	2838334	g538469	i0	72	0.929752066115702	75	21	93	0	225	1	371	445	HEX8385994.1 TonB-dependent receptor [Rubricoccaceae bacterium]	diamond	225	119	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27483726	27483726	PRJNA1237347_P_NODE_228543_length_397_cov_1.648148_g221971_i0	PRJNA1237347	228543	397	1.648148	6.54314756	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	45.4	0.0215	NR	GIV61107.1	2026787	g221971	i0	31.9	0.687657430730479	91	60	68	2	359	90	98	187	GIV61107.1 MAG: polyphosphate kinase [Rhodothermaceae bacterium]	diamond	273	45.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
27830895	27830895	PRJNA1237347_P_NODE_144124_length_538_cov_1.316129_g137581_i0	PRJNA1237347	144124	538	1.316129	7.08077402	Rhodothermales bacterium	2306054	Bacteria	Bacteria	53.9	7.16e-5	NR	MDZ4698886.1	2306054	g137581	i0	23.6	1.01486988847584	182	125	98.1	4	9	536	188	361	MDZ4698886.1 MFS transporter [Rhodothermales bacterium]	diamond	546	53.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28147263	28147263	PRJNA1237347_P_NODE_460605_length_255_cov_1.500000_g454032_i0	PRJNA1237347	460605	255	1.5	3.825	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	128	4.83e-33	NR	HEX8298541.1	2838334	g454032	i0	72	0.964705882352941	82	23	96.5	0	248	3	286	367	HEX8298541.1 ferrochelatase [Rubricoccaceae bacterium]	diamond	246	128	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
28259959	28259959	PRJNA1237347_P_NODE_363426_length_296_cov_1.381166_g356853_i0	PRJNA1237347	363426	296	1.381166	4.08825136	Pseudomonadati	3379134	Bacteria	Bacteria	89.4	2.85e-18	NR	WP_084660566.1	633813	g356853	i0	56.1	8.36148648648649	82	36	83.1	0	6	251	195	276	WP_084660566.1 amidohydrolase [Rhodothermus profundi]	diamond	2475	90.1	0.992230854605993	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus profundi
28575804	28575804	PRJNA1237347_P_NODE_234207_length_391_cov_1.163522_g227635_i0	PRJNA1237347	234207	391	1.163522	4.54937102	Pseudomonadati	3379134	Bacteria	Bacteria	204	5.62e-58	NR	WP_304187478.1	29549	g227635	i0	72.9	9.86700767263427	129	35	99	0	389	3	450	578	WP_304187478.1 VPS10 domain-containing protein [Rhodothermus marinus]	diamond	3858	204	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
28652349	28652349	PRJNA1237347_P_NODE_499607_length_248_cov_0.880000_g493034_i0	PRJNA1237347	499607	248	0.88	2.1824	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.5	0.0191	NR	NNE69657.1	2306054	g493034	i0	37.3	0.713709677419355	59	37	71.4	0	201	25	16	74	NNE69657.1 flagellar motor protein MotA [Rhodothermales bacterium]	diamond	177	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29175955	29175955	PRJNA1237347_P_NODE_330869_length_314_cov_1.556017_g324296_i0	PRJNA1237347	330869	314	1.556017	4.88589338	FCB group	1783270	Bacteria	Bacteria	55.1	4.19e-6	NR	MBO6577208.1	2306054	g324296	i0	37.9	6.3343949044586	95	54	89.8	3	300	19	1029	1119	MBO6577208.1 tandem-95 repeat protein [Rhodothermales bacterium]	diamond	1989	55.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29220410	29220410	PRJNA1237347_P_NODE_201269_length_432_cov_1.072423_g194697_i0	PRJNA1237347	201269	432	1.072423	4.63286736	Salinibacter ruber	146919	Bacteria	Bacteria	72.4	4.68e-13	NR	WP_259115244.1	146919	g194697	i0	30.6	1.77777777777778	124	85	86.1	1	392	21	14	136	WP_259115244.1 nuclear transport factor 2 family protein [Salinibacter ruber]	diamond	768	72.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
29220650	29220650	PRJNA1237347_P_NODE_360029_length_298_cov_1.026667_g353456_i0	PRJNA1237347	360029	298	1.026667	3.05946766	Salinibacter sp.	2065818	Bacteria	Bacteria	49.7	2.34e-4	NR	WP_263789500.1	2065818	g353456	i0	32	1.00671140939597	100	66	98.7	1	296	3	9	108	WP_263789500.1 DUF4363 family protein [Salinibacter sp.]	diamond	300	49.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter sp.
29283363	29283363	PRJNA1237347_P_NODE_294729_length_338_cov_0.950943_g288156_i0	PRJNA1237347	294729	338	0.950943	3.21418734	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	160	1.32e-45	NR	HEX8387133.1	2838334	g288156	i0	71.4	0.994082840236686	112	32	99.4	0	338	3	155	266	HEX8387133.1 NAD-dependent DNA ligase LigA [Rubricoccaceae bacterium]	diamond	336	160	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29630916	29630916	PRJNA1237347_P_NODE_83850_length_763_cov_1.265217_g77689_i0	PRJNA1237347	83850	763	1.265217	9.65360571	Rhodothermia bacterium	2497633	Bacteria	Bacteria	70.1	4.45e-11	NR	MBT8401086.1	2497633	g77689	i0	35.6	0.707732634338139	90	54	35.4	1	482	751	44	129	MBT8401086.1 hypothetical protein [Rhodothermia bacterium]	diamond	540	70.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
29915577	29915577	PRJNA1237347_P_NODE_544831_length_242_cov_0.911243_g538258_i0	PRJNA1237347	544831	242	0.911243	2.20520806	Rhodothermales bacterium	2306054	Bacteria	Bacteria	79	3.27e-15	NR	HYE57625.1	2306054	g538258	i0	49.4	0.954545454545455	77	39	95.5	0	5	235	71	147	HYE57625.1 ATP-binding protein [Rhodothermales bacterium]	diamond	231	79	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30421063	30421063	PRJNA1237347_P_NODE_386793_length_285_cov_1.617925_g380220_i0	PRJNA1237347	386793	285	1.617925	4.61108625	Rhodothermales bacterium	2306054	Bacteria	Bacteria	47	0.00204	NR	MFT5140990.1	2306054	g380220	i0	38.6	0.6	57	34	60	1	273	103	22	77	MFT5140990.1 OPA family glycerol-3-phosphate transporter-like MFS transporter [Rhodothermales bacterium]	diamond	171	47	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
31260641	31260641	PRJNA1237347_P_NODE_191475_length_446_cov_1.938338_g184903_i0	PRJNA1237347	191475	446	1.938338	8.64498748	FCB group	1783270	Bacteria	Bacteria	49.7	8.27e-4	NR	WP_251964085.1	146919	g184903	i0	32.9	2.08520179372197	76	44	51.1	1	235	8	50	118	WP_251964085.1 sulfotransferase family protein [Salinibacter ruber]	diamond	930	50.1	0.992015968063872	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
31621903	31621903	PRJNA1237347_P_NODE_57396_length_970_cov_2.426979_g52055_i0	PRJNA1237347	57396	970	2.426979	23.5416963	Rhodothermus sp.	2591385	Bacteria	Bacteria	50.8	0.0078	NR	MDQ7040445.1	2591385	g52055	i0	38.1	0.519587628865979	84	47	26	2	566	817	1310	1388	MDQ7040445.1 VWD domain-containing protein [Rhodothermus sp.]	diamond	504	50.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus sp.
31842959	31842959	PRJNA1237347_P_NODE_327237_length_316_cov_1.880658_g320664_i0	PRJNA1237347	327237	316	1.880658	5.94287928	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	64.7	1.56e-9	NR	ARA95094.1	1779382	g320664	i0	55	2.86708860759494	60	27	57	0	135	314	2	61	ARA95094.1 4-hydroxybutyrate CoA-transferase [Rhodothermaceae bacterium RA]	diamond	906	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
31843287	31843287	PRJNA1237347_P_NODE_66257_length_886_cov_2.537515_g60566_i0	PRJNA1237347	66257	886	2.537515	22.4823829	Rhodothermia bacterium	2497633	Bacteria	Bacteria	486	3.399999999999998e-169	NR	MBN8589105.1	2497633	g60566	i0	78.9	5.96952595936795	294	62	99.5	0	4	885	14	307	MBN8589105.1 O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase [Rhodothermia bacterium]	diamond	5289	486	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
31861511	31861511	PRJNA1237347_P_NODE_520917_length_245_cov_0.895349_g514344_i0	PRJNA1237347	520917	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	40.4	0.0478	NR	MFK7847716.1	2306054	g514344	i0	33.3	1.08979591836735	48	32	58.8	0	71	214	30	77	MFK7847716.1 PLD nuclease N-terminal domain-containing protein [Rhodothermales bacterium]	diamond	267	40.8	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32159959	32159959	PRJNA1237347_P_NODE_543018_length_242_cov_1.455621_g536445_i0	PRJNA1237347	543018	242	1.455621	3.52260282	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	117	1.35e-28	NR	HEX8385226.1	2838334	g536445	i0	79.5	0.966942148760331	78	16	96.7	0	4	237	70	147	HEX8385226.1 DNA internalization-related competence protein ComEC/Rec2 [Rubricoccaceae bacterium]	diamond	234	117	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32286628	32286628	PRJNA1237347_P_NODE_508459_length_247_cov_0.885057_g501886_i0	PRJNA1237347	508459	247	0.885057	2.18609079	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	140	3.47e-38	NR	HEX8385705.1	2838334	g501886	i0	84	0.983805668016194	81	13	98.4	0	244	2	172	252	HEX8385705.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	243	140	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32368147	32368147	PRJNA1237347_P_NODE_51659_length_1034_cov_2.630593_g46637_i0	PRJNA1237347	51659	1034	2.630593	27.20033162	Bacteria	2	Bacteria	Bacteria	356	6.069999999999999e-118	NR	WP_243664138.1	29549	g46637	i0	69.4	55.5754352030948	252	77	73.1	0	756	1	24	275	WP_243664138.1 acetate--CoA ligase family protein [Rhodothermus marinus]	diamond	57465	358	0.994413407821229	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
32557948	32557948	PRJNA1237347_P_NODE_191399_length_446_cov_2.160858_g184827_i0	PRJNA1237347	191399	446	2.160858	9.63742668	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	9.11e-19	NR	WP_011403833.1	146919	g184827	i0	50	2.87219730941704	84	42	56.5	0	193	444	4	87	WP_011403833.1 nucleoside-diphosphate kinase [Salinibacter ruber]	diamond	1281	87.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber

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