metadata: contig_metadata: 18 rows where bioproject = "PRJNA615351" and tax

18 rows where bioproject = "PRJNA615351" 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
1871736	1871736	PRJNA615351_P_NODE_27142_length_1215_cov_3.303390_g19764_i0	PRJNA615351	27142	1215	3.30339	40.1361885	Pseudomonadati	3379134	Bacteria	Bacteria	494	5.979999999999999e-168	NR	WP_012843110.1	29549	g19764	i0	67.4	24.3382716049383	399	124	98.5	4	1	1197	219	611	WP_012843110.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Rhodothermus marinus]	diamond	29571	496	0.995967741935484	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
3146737	3146737	PRJNA615351_P_NODE_65723_length_539_cov_12.763889_g52058_i0	PRJNA615351	65723	539	12.763889	68.79736171	Rhodothermales bacterium	2306054	Bacteria	Bacteria	652	0	NTclustered	gi\|2621703415\|emb\|OY762508.1\|	2306054	g52058	i0	88.704	216.317254174397	540	54	99	6	1	537	2026131	2026666	MAG: Rhodothermales bacterium isolate 68d32973-4033-4094-87ac-516b823d41a0 genome assembly, chromosome: 1	blastn	116595	652	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
10078441	10078441	PRJNA615351_P_NODE_146628_length_195_cov_1.575000_g132528_i0	PRJNA615351	146628	195	1.575	3.07125	Salinibacter	146918	Bacteria	Bacteria	60.2	1.01e-4	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g132528	i0	100	1.64102564102564	32	0	16	0	5	36	681426	681457	Salinibacter ruber strain P13 chromosome, complete genome	blastn	320	60.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
12074804	12074804	PRJNA615351_P_NODE_116970_length_258_cov_27.695067_g102871_i0	PRJNA615351	116970	258	27.695067	71.45327286	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	375	1.2299999999999998e-99	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g102871	i0	93.676	368.143410852713	253	12	97	4	3	253	805928	806178	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	94981	375	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15898392	15898392	PRJNA615351_P_NODE_120593_length_248_cov_20.849765_g106493_i0	PRJNA615351	120593	248	20.849765	51.7074172	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	366	7.05e-97	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g106493	i0	93.852	468.173387096774	244	14	98	1	1	243	805935	806178	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	116107	366	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15898762	15898762	PRJNA615351_P_NODE_54133_length_669_cov_3.479495_g41502_i0	PRJNA615351	54133	669	3.479495	23.27782155	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g41502	i0	96.97	0.0493273542600897	33	0	5	1	281	312	2845458	2845426	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	33	54.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
20276370	20276370	PRJNA615351_P_NODE_140016_length_206_cov_1.912281_g125916_i0	PRJNA615351	140016	206	1.912281	3.93929886	Rubrivirga	1434037	Bacteria	Bacteria	289	1.26e-73	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g125916	i0	92.233	832.966019417476	206	13	99	3	1	205	807006	807209	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	171591	289	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25376336	25376336	PRJNA615351_P_NODE_158720_length_178_cov_1.776224_g144620_i0	PRJNA615351	158720	178	1.776224	3.16167872	Rubrivirga	1434037	Bacteria	Bacteria	235	1.39e-57	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g144620	i0	91.279	123.573033707865	172	15	97	0	1	172	805866	805695	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	21996	235	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26985405	26985405	PRJNA615351_P_NODE_18402_length_1535_cov_3.866000_g13303_i0	PRJNA615351	18402	1535	3.866	59.3431	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	64.7	8.05e-7	NR	WP_412060949.1	3391614	g13303	i0	29.8	0.420195439739414	215	121	41.4	9	94	729	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
28880280	28880280	PRJNA615351_P_NODE_111588_length_275_cov_1.641667_g97489_i0	PRJNA615351	111588	275	1.641667	4.51458425	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52.8	3.82e-6	NR	HLA63854.1	2306054	g97489	i0	45.6	1.25454545454545	57	30	62.2	1	12	182	77	132	HLA63854.1 LCCL domain-containing protein [Rhodothermales bacterium]	diamond	345	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28911894	28911894	PRJNA615351_P_NODE_9528_length_2081_cov_6.041544_g6329_i1	PRJNA615351	9528	2081	6.041544	125.72453064	Salisaeta longa	503170	Bacteria	Bacteria	66.2	3.04e-7	NR	WP_051141322.1	503170	g6329	i1	27.1	0.387794329649207	269	164	36.5	11	47	805	6	258	WP_051141322.1 ATP-binding protein [Salisaeta longa]	diamond	807	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Salisaeta	Salisaeta longa
29038608	29038608	PRJNA615351_P_NODE_19208_length_1497_cov_3.400137_g13303_i1	PRJNA615351	19208	1497	3.400137	50.90005089	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	64.7	7.67e-7	NR	WP_412060949.1	3391614	g13303	i1	29.8	0.430861723446894	215	121	42.5	9	94	729	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
29480167	29480167	PRJNA615351_P_NODE_8870_length_2144_cov_5.735894_g6329_i0	PRJNA615351	8870	2144	5.735894	122.97756736	Salisaeta longa	503170	Bacteria	Bacteria	66.2	3.18e-7	NR	WP_051141322.1	503170	g6329	i0	27.1	0.376399253731343	269	164	35.4	11	47	805	6	258	WP_051141322.1 ATP-binding protein [Salisaeta longa]	diamond	807	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Salisaeta	Salisaeta longa
31357435	31357435	PRJNA615351_P_NODE_5036_length_2666_cov_17.095781_g732_i6	PRJNA615351	5036	2666	17.095781	455.77352146	root	1	Root_unresolved	Root_unresolved	120	8.05e-24	NR	MEF8797405.1	1885341	g732	i6	36.1	1.77906976744186	255	145	27.7	8	2573	1836	506	751	MEF8797405.1 IGHMBP2 family helicase [Salinivenus sp.]	diamond	4743	121	0.991735537190083	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinivenus	Salinivenus sp.
31389117	31389117	PRJNA615351_P_NODE_73696_length_471_cov_2.628440_g59723_i0	PRJNA615351	73696	471	2.62844	12.3799524	root	1	Root_unresolved	Root_unresolved	50.1	8.02e-4	NR	WP_095511576.1	1196024	g59723	i0	56.3	1.80891719745223	48	21	30.6	0	469	326	222	269	WP_095511576.1 diaminopimelate epimerase [Rubrivirga marina]	diamond	852	50.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga marina
31976973	31976973	PRJNA615351_P_NODE_23138_length_1344_cov_3.708174_g13303_i2	PRJNA615351	23138	1344	3.708174	49.83785856	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	65.5	3.43e-7	NR	WP_412060949.1	3391614	g13303	i2	29.8	0.479910714285714	215	121	47.3	9	245	880	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	65.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
32420063	32420063	PRJNA615351_P_NODE_186999_length_150_cov_1.730435_g172899_i0	PRJNA615351	186999	150	1.730435	2.5956525	Rhodothermia bacterium	2497633	Bacteria	Bacteria	62.8	5.62e-10	NR	MBT8400481.1	2497633	g172899	i0	59.2	0.98	49	20	98	0	147	1	42	90	MBT8400481.1 hypothetical protein [Rhodothermia bacterium]	diamond	147	62.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
32609719	32609719	PRJNA615351_P_NODE_70840_length_494_cov_2.599129_g56934_i0	PRJNA615351	70840	494	2.599129	12.83969726	Rhodothermus sp.	2591385	Bacteria	Bacteria	66.2	3.17e-9	NR	MDQ7039768.1	2591385	g56934	i0	53.8	0.917004048582996	52	24	31.6	0	318	473	13	64	MDQ7039768.1 ATP-dependent DNA helicase RecQ [Rhodothermus sp.]	diamond	453	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus sp.

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