metadata: contig_metadata: 26 rows where bioproject = "PRJNA438111" and tax

26 rows where bioproject = "PRJNA438111" 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
434424	434424	PRJNA438111_P_NODE_62561_length_169_cov_4.764286_g61936_i0	PRJNA438111	62561	169	4.764286	8.05164334	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	82.4	1.8e-11	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g61936	i0	86.076	0.467455621301775	79	7	46	4	20	96	2364427	2364503	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	79	82.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
1090648	1090648	PRJNA438111_P_NODE_51881_length_179_cov_5.146667_g51256_i0	PRJNA438111	51881	179	5.146667	9.21253393	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	114	1.3999999999999996e-29	NR	HEX8385381.1	2838334	g51256	i0	89.8	0.988826815642458	59	6	98.9	0	1	177	87	145	HEX8385381.1 aldo/keto reductase [Rubricoccaceae bacterium]	diamond	177	114	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
4918868	4918868	PRJNA438111_P_NODE_62724_length_169_cov_3.842857_g62099_i0	PRJNA438111	62724	169	3.842857	6.49442833	Salinibacter	146918	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g62099	i0	100	0.828402366863905	28	0	17	0	124	151	602763	602790	Salinibacter ruber strain P13 chromosome, complete genome	blastn	140	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
6193921	6193921	PRJNA438111_P_NODE_87905_length_152_cov_2.528455_g87280_i0	PRJNA438111	87905	152	2.528455	3.8432516	Rhodothermales	1853224	Bacteria	Bacteria	167	4.2499999999999995e-37	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g87280	i0	89.63	131.822368421053	135	8	88	5	15	146	2838263	2838394	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	20037	167	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
6811931	6811931	PRJNA438111_P_NODE_42606_length_190_cov_4.521739_g41981_i0	PRJNA438111	42606	190	4.521739	8.5913041	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	200	5.51e-47	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g41981	i0	87.151	1.88947368421053	179	19	93	4	1	177	3170418	3170242	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	359	200	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8087880	8087880	PRJNA438111_P_NODE_77687_length_159_cov_5.392308_g77062_i0	PRJNA438111	77687	159	5.392308	8.57376972	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	196	5.75e-46	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g77062	i0	90.196	94.503144654088	153	12	95	3	4	154	4062876	4062725	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	15026	196	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
8743547	8743547	PRJNA438111_P_NODE_38307_length_196_cov_6.245509_g37682_i0	PRJNA438111	38307	196	6.245509	12.24119764	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	93.2	3.23e-20	NR	HEX9952639.1	2838334	g37682	i0	66.2	1.13265306122449	74	16	99.5	1	195	1	294	367	HEX9952639.1 endonuclease [Rubricoccaceae bacterium]	diamond	222	93.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
10018904	10018904	PRJNA438111_P_NODE_70188_length_164_cov_3.592593_g69563_i0	PRJNA438111	70188	164	3.592593	5.89185252	Rhodothermus	29548	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|262333112\|gb\|CP001807.1\|	518766	g69563	i0	87.705	11.7439024390244	122	15	74	0	1	122	1048475	1048596	Rhodothermus marinus DSM 4252, complete genome	blastn	1926	143	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
10637702	10637702	PRJNA438111_P_NODE_11709_length_301_cov_5.297794_g11084_i0	PRJNA438111	11709	301	5.297794	15.94635994	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	134	9.73e-35	NR	HEX8298547.1	2838334	g11084	i0	92.2	0.637873754152824	64	5	63.8	0	1	192	305	368	HEX8298547.1 family 1 glycosylhydrolase [Rubricoccaceae bacterium]	diamond	192	134	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
10638309	10638309	PRJNA438111_P_NODE_59189_length_172_cov_2.881119_g58564_i0	PRJNA438111	59189	172	2.881119	4.95552468	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	207	2.91e-49	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g58564	i0	88.372	2.97093023255814	172	20	100	0	1	172	1178812	1178983	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	511	207	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
17011237	17011237	PRJNA438111_P_NODE_28354_length_210_cov_5.668508_g27729_i0	PRJNA438111	28354	210	5.668508	11.9038668	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	126	1.07e-24	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g27729	i0	89.796	0.466666666666667	98	10	47	0	3	100	1059954	1060051	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	98	126	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
17011288	17011288	PRJNA438111_P_NODE_31514_length_210_cov_3.690608_g30889_i0	PRJNA438111	31514	210	3.690608	7.7502768	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	99	2.33e-16	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g30889	i0	85.87	2.13809523809524	92	13	44	0	113	204	597403	597494	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	449	99	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
18286158	18286158	PRJNA438111_P_NODE_68815_length_165_cov_2.992647_g68190_i0	PRJNA438111	68815	165	2.992647	4.93786755	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	178	2.18e-40	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g68190	i0	86.42	1.69090909090909	162	22	98	0	1	162	3838522	3838683	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	279	178	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
23386216	23386216	PRJNA438111_P_NODE_32839_length_209_cov_6.822222_g32214_i0	PRJNA438111	32839	209	6.822222	14.25844398	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	112	4.11e-27	NR	HEX8298547.1	2838334	g32214	i0	53.6	1.60765550239234	112	9	99	1	209	3	305	416	HEX8298547.1 family 1 glycosylhydrolase [Rubricoccaceae bacterium]	diamond	336	112	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27423815	27423815	PRJNA438111_P_NODE_28463_length_210_cov_5.491713_g27838_i0	PRJNA438111	28463	210	5.491713	11.5325973	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	59.7	2.41e-8	NR	HEX9950225.1	2838334	g27838	i0	84.4	0.457142857142857	32	5	45.7	0	113	208	186	217	HEX9950225.1 DNA polymerase III subunit delta' [Rubricoccaceae bacterium]	diamond	96	59.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27423847	27423847	PRJNA438111_P_NODE_57483_length_174_cov_1.758621_g56858_i0	PRJNA438111	57483	174	1.758621	3.06000054	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	65.1	6.31e-11	NR	HEX9950230.1	2838334	g56858	i0	66.1	0.96551724137931	56	16	96.6	1	168	1	99	151	HEX9950230.1 dTMP kinase [Rubricoccaceae bacterium]	diamond	168	65.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27692798	27692798	PRJNA438111_P_NODE_60444_length_171_cov_2.246479_g59819_i0	PRJNA438111	60444	171	2.246479	3.84147909	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	7.84e-6	NR	WP_094545663.1	716817	g59819	i0	100	9.82456140350877	28	0	49.1	0	84	1	1	28	WP_094545663.1 hypothetical protein [Rubricoccus marinus]	diamond	1680	50.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
28181134	28181134	PRJNA438111_P_NODE_59706_length_171_cov_6.422535_g59081_i0	PRJNA438111	59706	171	6.422535	10.98253485	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	83.6	5.25e-18	NR	HEX8386896.1	2838334	g59081	i0	77.2	1	57	13	100	0	171	1	122	178	HEX8386896.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	171	83.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
28812520	28812520	PRJNA438111_P_NODE_63608_length_169_cov_1.014286_g62983_i0	PRJNA438111	63608	169	1.014286	1.71414334	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	117	4.7e-29	NR	HEX8384737.1	2838334	g62983	i0	98.2	0.994082840236686	56	1	99.4	0	168	1	292	347	HEX8384737.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Rubricoccaceae bacterium]	diamond	168	117	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29601858	29601858	PRJNA438111_P_NODE_28630_length_210_cov_5.303867_g28005_i0	PRJNA438111	28630	210	5.303867	11.1381207	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	62.8	2.2e-10	NR	HEX9953283.1	2838334	g28005	i0	90.6	0.457142857142857	32	3	45.7	0	206	111	84	115	HEX9953283.1 MaoC family dehydratase [Rubricoccaceae bacterium]	diamond	96	62.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30360796	30360796	PRJNA438111_P_NODE_68152_length_166_cov_1.036496_g67527_i0	PRJNA438111	68152	166	1.036496	1.72058336	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	57.4	2.19e-8	NR	HEX9950866.1	2838334	g67527	i0	87.5	1.24698795180723	32	4	57.8	0	166	71	122	153	HEX9950866.1 redoxin domain-containing protein [Rubricoccaceae bacterium]	diamond	207	57.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30486786	30486786	PRJNA438111_P_NODE_64793_length_168_cov_1.870504_g64168_i0	PRJNA438111	64793	168	1.870504	3.14244672	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	90.5	1.42e-20	NR	HEX8299067.1	2838334	g64168	i0	87.9	2.03571428571429	58	5	100	1	168	1	137	194	HEX8299067.1 phasin family protein [Rubricoccaceae bacterium]	diamond	342	90.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
31624510	31624510	PRJNA438111_P_NODE_40496_length_193_cov_4.756098_g39871_i0	PRJNA438111	40496	193	4.756098	9.17926914	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	64.7	3.12e-10	NR	HEX9952802.1	2838334	g39871	i0	87.9	0.512953367875648	33	4	51.3	0	100	2	40	72	HEX9952802.1 3-deoxy-7-phosphoheptulonate synthase [Rubricoccaceae bacterium]	diamond	99	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32067374	32067374	PRJNA438111_P_NODE_81558_length_156_cov_6.519685_g80933_i0	PRJNA438111	81558	156	6.519685	10.1707086	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	114	2.35e-28	NR	HEX9950949.1	2838334	g80933	i0	96.2	2	52	2	100	0	1	156	353	404	HEX9950949.1 M2 family metallopeptidase [Rubricoccaceae bacterium]	diamond	312	114	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32383850	32383850	PRJNA438111_P_NODE_56079_length_175_cov_3.342466_g55454_i0	PRJNA438111	56079	175	3.342466	5.8493155	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	47.8	1.92e-4	NR	HEX9950358.1	2838334	g55454	i0	81.8	0.565714285714286	33	5	56.6	1	77	175	1	32	HEX9950358.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	99	47.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32542348	32542348	PRJNA438111_P_NODE_87599_length_152_cov_3.357724_g86974_i0	PRJNA438111	87599	152	3.357724	5.10374048	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	94	9.63e-21	NR	HEX8297668.1	2838334	g86974	i0	86	1.97368421052632	50	7	98.7	0	151	2	779	828	HEX8297668.1 phospholipase D-like domain-containing protein [Rubricoccaceae bacterium]	diamond	300	94	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae 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);;