metadata: contig_metadata: 24 rows where bioproject = "PRJEB64798" and tax

24 rows where bioproject = "PRJEB64798" 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
1401840	1401840	PRJEB64798_P_NODE_164422_length_181_cov_4.893939_g162656_i0	PRJEB64798	164422	181	4.893939	8.85802959	Salinibacter ruber	146919	Bacteria	Bacteria	104	4.18e-18	NTclustered	gi\|1473073668\|gb\|CP030356.1\|	146919	g162656	i0	80.282	10.0220994475138	142	24	77	4	3	142	3537105	3537244	Salinibacter ruber strain P18 chromosome, complete genome	blastn	1814	104	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
2678609	2678609	PRJEB64798_P_NODE_244163_length_153_cov_41.576923_g242397_i0	PRJEB64798	244163	153	41.576923	63.61269219	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	69.4	1.24e-7	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g242397	i0	95.349	10.7058823529412	43	2	28	0	110	152	808453	808411	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1638	69.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
6096357	6096357	PRJEB64798_P_NODE_211465_length_164_cov_4.504348_g209699_i0	PRJEB64798	211465	164	4.504348	7.38713072	Rubrivirga	1434037	Bacteria	Bacteria	102	1.34e-17	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g209699	i0	79.333	9.99390243902439	150	28	90	3	9	156	808236	808088	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1639	102	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
7370807	7370807	PRJEB64798_P_NODE_232846_length_157_cov_15.018519_g231080_i0	PRJEB64798	232846	157	15.018519	23.57907483	Rubrivirga	1434037	Bacteria	Bacteria	204	3.38e-48	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g231080	i0	90.85	384.101910828025	153	12	97	2	6	157	805855	806006	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	60304	204	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
9921373	9921373	PRJEB64798_P_NODE_214388_length_163_cov_11.754386_g212622_i0	PRJEB64798	214388	163	11.754386	19.15964918	Rubrivirga	1434037	Bacteria	Bacteria	265	1.6e-66	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g212622	i0	96.835	408.588957055215	158	5	97	0	3	160	806632	806789	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	66600	265	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
10330279	10330279	PRJEB64798_P_NODE_154749_length_186_cov_2.562044_g152983_i0	PRJEB64798	154749	186	2.562044	4.76540184	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	281	1.86e-71	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g152983	i0	94.505	194.44623655914	182	10	98	0	5	186	805344	805525	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	36167	281	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
11606778	11606778	PRJEB64798_P_NODE_229650_length_159_cov_2.372727_g227884_i0	PRJEB64798	229650	159	2.372727	3.77263593	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	172	9.689999999999999e-39	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g227884	i0	87.333	313.207547169811	150	19	94	0	9	158	1309431	1309282	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	49800	172	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
15021485	15021485	PRJEB64798_P_NODE_53792_length_266_cov_13.847926_g52027_i0	PRJEB64798	53792	266	13.847926	36.83548316	Rhodothermus	29548	Bacteria	Bacteria	178	3.849999999999999e-40	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g52027	i0	79.478	144.003759398496	268	42	98	13	6	266	258	519	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	38305	178	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
16295842	16295842	PRJEB64798_P_NODE_204213_length_166_cov_3.555556_g202447_i0	PRJEB64798	204213	166	3.555556	5.90222296	Rubrivirga	1434037	Bacteria	Bacteria	117	4.86e-22	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g202447	i0	80.921	88.066265060241	152	26	90	3	7	156	808238	808088	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	14619	117	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
17978472	17978472	PRJEB64798_P_NODE_139735_length_193_cov_10.152778_g137969_i0	PRJEB64798	139735	193	10.152778	19.59486154	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	141	3.45e-29	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g137969	i0	92.784	115.414507772021	97	7	50	0	97	193	1309288	1309192	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	22275	141	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
19253235	19253235	PRJEB64798_P_NODE_187556_length_171_cov_4.557377_g185790_i0	PRJEB64798	187556	171	4.557377	7.79311467	Rhodothermus marinus	29549	Bacteria	Bacteria	195	2.25e-45	NTclustered	gi\|345113873\|gb\|CP003030.1\|	762570	g185790	i0	87.135	1.22222222222222	171	22	100	0	1	171	16148	15978	Rhodothermus marinus SG0.5JP17-172 plasmid pRHOM17201, complete sequence	blastn	209	195	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
21395318	21395318	PRJEB64798_P_NODE_211317_length_164_cov_4.973913_g209551_i0	PRJEB64798	211317	164	4.973913	8.15721732	Rhodothermus	29548	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g209551	i0	96.914	221.853658536585	162	3	98	2	1	161	1341	1181	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	36384	270	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
23078680	23078680	PRJEB64798_P_NODE_122459_length_204_cov_15.851613_g120693_i0	PRJEB64798	122459	204	15.851613	32.33729052	Rhodothermales bacterium	2306054	Bacteria	Bacteria	257	3.51e-64	NTclustered	gi\|2518540634\|emb\|OX638295.1\|	2306054	g120693	i0	90	146.495098039216	200	19	98	1	6	204	370297	370496	MAG: Rhodothermales bacterium isolate 379627e8-994f-481d-907a-dd5b185e1f88 genome assembly, chromosome: 1	blastn	29885	257	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
24353083	24353083	PRJEB64798_P_NODE_159580_length_183_cov_14.559701_g157814_i0	PRJEB64798	159580	183	14.559701	26.64425283	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	174	3.19e-39	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g157814	i0	85.976	56.9071038251366	164	21	89	2	18	180	1309274	1309436	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	10414	174	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26622117	26622117	PRJEB64798_P_NODE_163961_length_181_cov_8.537879_g162195_i0	PRJEB64798	163961	181	8.537879	15.45356099	Rhodothermales bacterium	2306054	Bacteria	Bacteria	66.6	6.2e-11	NR	MFT5516759.1	2306054	g162195	i0	50.9	1.85635359116022	55	27	91.2	0	8	172	60	114	MFT5516759.1 hypothetical protein [Rhodothermales bacterium]	diamond	336	66.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27508051	27508051	PRJEB64798_P_NODE_55883_length_261_cov_3.731132_g54118_i0	PRJEB64798	55883	261	3.731132	9.73825452	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52	1.76e-5	NR	MDX1529966.1	2306054	g54118	i0	51	2.54022988505747	49	23	56.3	1	202	56	99	146	MDX1529966.1 T9SS type A sorting domain-containing protein [Rhodothermales bacterium]	diamond	663	52	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28328689	28328689	PRJEB64798_P_NODE_83086_length_213_cov_7.554878_g81320_i0	PRJEB64798	83086	213	7.554878	16.09189014	Rhodothermia bacterium	2497633	Bacteria	Bacteria	45.4	0.00267	NR	MBN8588274.1	2497633	g81320	i0	52.6	0.535211267605634	38	18	53.5	0	95	208	39	76	MBN8588274.1 hypothetical protein [Rhodothermia bacterium]	diamond	114	45.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
28543042	28543042	PRJEB64798_P_NODE_97567_length_212_cov_3.625767_g95801_i0	PRJEB64798	97567	212	3.625767	7.68662604	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	3.14e-7	NR	MCA1803179.1	2026787	g95801	i0	75.9	3.41037735849057	29	7	41	0	8	94	225	253	MCA1803179.1 primosomal protein N' [Rhodothermaceae bacterium]	diamond	723	56.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
28833867	28833867	PRJEB64798_P_NODE_238448_length_155_cov_15.433962_g236682_i0	PRJEB64798	238448	155	15.433962	23.9226411	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52.8	3.22e-6	NR	HMB93905.1	2306054	g236682	i0	47.9	0.929032258064516	48	25	92.9	0	148	5	13	60	HMB93905.1 3-phosphoglycerate dehydrogenase family protein [Rhodothermales bacterium]	diamond	144	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29213046	29213046	PRJEB64798_P_NODE_57449_length_257_cov_5.269231_g55684_i0	PRJEB64798	57449	257	5.2692310000000004	13.54192367	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	68.2	5e-11	NR	WP_412061153.1	3391614	g55684	i0	61.5	0.607003891050584	52	20	60.7	0	163	8	96	147	WP_412061153.1 CHRD domain-containing protein [Rubrivirga sp. IMCC45206]	diamond	156	68.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
29244446	29244446	PRJEB64798_P_NODE_47429_length_285_cov_4.033898_g45664_i0	PRJEB64798	47429	285	4.033898	11.4966093	Rhodothermia bacterium	2497633	Bacteria	Bacteria	53.5	6.92e-6	NR	MBN8587674.1	2497633	g45664	i0	42.9	0.663157894736842	63	36	66.3	0	191	3	47	109	MBN8587674.1 YARHG domain-containing protein [Rhodothermia bacterium]	diamond	189	53.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
30191572	30191572	PRJEB64798_P_NODE_142872_length_192_cov_2.454545_g141106_i0	PRJEB64798	142872	192	2.454545	4.7127264	Rhodothermales bacterium	2306054	Bacteria	Bacteria	41.6	0.0489	NR	MEZ4701686.1	2306054	g141106	i0	46.3	0.640625	41	21	62.5	1	121	2	26	66	MEZ4701686.1 choice-of-anchor D domain-containing protein [Rhodothermales bacterium]	diamond	123	41.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30191615	30191615	PRJEB64798_P_NODE_177232_length_175_cov_9.476190_g175466_i0	PRJEB64798	177232	175	9.47619	16.5833325	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	82	2.15e-16	NR	HEX9952616.1	2838334	g175466	i0	55.2	1.98857142857143	58	26	99.4	0	1	174	462	519	HEX9952616.1 peptidase S9 [Rubricoccaceae bacterium]	diamond	348	82	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30507754	30507754	PRJEB64798_P_NODE_213333_length_164_cov_0.904348_g211567_i0	PRJEB64798	213333	164	0.904348	1.48313072	Rhodothermales bacterium	2306054	Bacteria	Bacteria	91.7	4.71e-20	NR	MFT5129571.1	2306054	g211567	i0	95.3	0.786585365853659	43	2	78.7	0	36	164	82	124	MFT5129571.1 putative aminopeptidase FrvX [Rhodothermales bacterium]	diamond	129	91.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;