metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax_kingdom = "Methanobacteriati"

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
3195303	3195303	PRJNA674050_P_NODE_6723_length_328_cov_0.917647_g6520_i0	PRJNA674050	6723	328	0.917647	3.00988216	Halorubrum sp. PV6	634157	Archaea	Archaea	496	1.19e-135	NTclustered	gi\|1717503818\|gb\|CP030065.1\|	634157	g6520	i0	93.902	13.0365853658537	328	20	100	0	1	328	260058	260385	Halorubrum sp. PV6 plasmid pHrrPV6, complete sequence	blastn	4276	496	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. PV6
8297357	8297357	PRJNA674050_P_NODE_32987_length_246_cov_0.867052_g32784_i0	PRJNA674050	32987	246	0.867052	2.13294792	Natronomonas moolapensis	416273	Archaea	Archaea	350	7.04e-92	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g32784	i0	92.276	79.2317073170732	246	19	100	0	1	246	2808127	2807882	Natronomonas moolapensis 8.8.11 complete genome	blastn	19491	350	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
9572220	9572220	PRJNA674050_P_NODE_24208_length_251_cov_0.876404_g24005_i0	PRJNA674050	24208	251	0.876404	2.19977404	Halorubrum lacusprofundi	2247	Archaea	Archaea	322	1.57e-83	NTclustered	gi\|222451341\|gb\|CP001365.1\|	416348	g24005	i0	90.04	15.1673306772908	251	22	100	2	1	251	2306170	2306417	Halorubrum lacusprofundi ATCC 49239 chromosome 1, complete sequence	blastn	3807	322	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum lacusprofundi
9572303	9572303	PRJNA674050_P_NODE_26368_length_250_cov_0.870056_g26165_i0	PRJNA674050	26368	250	0.870056	2.17514	Natronomonas moolapensis	416273	Archaea	Archaea	211	3.53e-50	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g26165	i0	81.928	0.996	249	45	99	0	1	249	1986347	1986099	Natronomonas moolapensis 8.8.11 complete genome	blastn	249	211	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
10848271	10848271	PRJNA674050_P_NODE_37329_length_243_cov_0.917647_g37126_i0	PRJNA674050	37329	243	0.917647	2.22988221	Natronomonas moolapensis	416273	Archaea	Archaea	196	9.56e-46	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g37126	i0	81.818	0.995884773662551	242	36	98	8	1	239	355634	355870	Natronomonas moolapensis 8.8.11 complete genome	blastn	242	196	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
10848369	10848369	PRJNA674050_P_NODE_40049_length_242_cov_0.905325_g39846_i0	PRJNA674050	40049	242	0.905325	2.1908865	Natrinema sp. J7-2	406552	Archaea	Archaea	254	5.57e-63	NTclustered	gi\|397680883\|gb\|CP003412.1\|	406552	g39846	i0	85.537	2.01239669421488	242	35	100	0	1	242	838895	839136	Natrinema sp. J7-2, complete genome	blastn	487	254	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. J7-2
12123668	12123668	PRJNA674050_P_NODE_4230_length_366_cov_1.064846_g4027_i0	PRJNA674050	4230	366	1.064846	3.89733636	Salinarchaeum sp. IM2453	2862870	Archaea	Archaea	532	1.02e-146	NTclustered	gi\|2082835402\|gb\|CP081183.1\|	2862870	g4027	i0	92.896	28.6748633879781	366	26	100	0	1	366	2527986	2527621	Salinarchaeum sp. IM2453 chromosome, complete genome	blastn	10495	532	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Salinarchaeum	Salinarchaeum sp. IM2453
12645667	12645667	PRJNA674050_P_NODE_35490_length_244_cov_0.912281_g35287_i0	PRJNA674050	35490	244	0.912281	2.22596564	Halobacteriales	2235	Archaea	Archaea	350	6.969999999999998e-92	NTclustered	gi\|1646146345\|gb\|CP039134.1\|	272569	g35287	i0	92.593	23.9959016393443	243	18	99	0	2	244	52125	52367	Haloarcula marismortui ATCC 43049 plasmid pHMA155, complete sequence	blastn	5855	351	0.997150997150997	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula marismortui
13920300	13920300	PRJNA674050_P_NODE_30471_length_247_cov_0.896552_g30268_i0	PRJNA674050	30471	247	0.896552	2.21448344	Natronomonadaceae	3402413	Archaea	Archaea	440	4.079999999999999e-119	NTclustered	gi\|2273574516\|gb\|CP101155.1\|	2961939	g30268	i0	98.785	2	247	3	100	0	1	247	56259	56505	Natronomonas marina strain ZY43 plasmid unnamed1, complete sequence	blastn	494	440	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas marina
14672905	14672905	PRJNA674050_P_NODE_28492_length_248_cov_0.891429_g28289_i0	PRJNA674050	28492	248	0.891429	2.21074392	Halorientalis sp. IM1011	1932360	Archaea	Archaea	243	1.24e-59	NTclustered	gi\|1142895524\|gb\|CP019067.1\|	1932360	g28289	i0	84.4	4.42741935483871	250	35	100	4	1	248	402686	402439	Halorientalis sp. IM1011 chromosome, complete genome	blastn	1098	243	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorientalis	Halorientalis sp. IM1011
15194871	15194871	PRJNA674050_P_NODE_24472_length_251_cov_0.870787_g24269_i0	PRJNA674050	24472	251	0.870787	2.18567537	Halobacteriales	2235	Archaea	Archaea	412	9.06e-111	NTclustered	gi\|222454053\|gb\|CP001366.1\|	416348	g24269	i0	96.414	13.5099601593625	251	8	100	1	1	251	372262	372511	Halorubrum lacusprofundi ATCC 49239 chromosome 2, complete sequence	blastn	3391	412	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum lacusprofundi
15946364	15946364	PRJNA674050_P_NODE_23813_length_251_cov_1.584270_g23610_i0	PRJNA674050	23813	251	1.58427	3.9765177	Natronorubrum bangense	61858	Archaea	Archaea	207	4.59e-49	NTclustered	gi\|1621081954\|gb\|CP031305.1\|	61858	g23610	i0	81.6	16.4143426294821	250	46	99	0	2	251	1637551	1637800	Natronorubrum bangense strain JCM 10635 chromosome, complete genome	blastn	4120	207	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum bangense
15946937	15946937	PRJNA674050_P_NODE_38993_length_242_cov_0.923077_g38790_i0	PRJNA674050	38993	242	0.923077	2.23384634	Halorubrum sp. PV6	634157	Archaea	Archaea	171	5.77e-38	NTclustered	gi\|1717503818\|gb\|CP030065.1\|	634157	g38790	i0	90.152	3.31818181818182	132	11	54	2	1	131	261004	260874	Halorubrum sp. PV6 plasmid pHrrPV6, complete sequence	blastn	803	171	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. PV6
17744263	17744263	PRJNA674050_P_NODE_39634_length_242_cov_0.917160_g39431_i0	PRJNA674050	39634	242	0.91716	2.2195272	Halobacteriales	2235	Archaea	Archaea	363	8.869999999999999e-96	NTclustered	gi\|2269315400\|gb\|CP100355.1\|	2953753	g39431	i0	95.197	33.7644628099174	229	11	95	0	6	234	1369063	1368835	Natronosalvus rutilus strain WLHS1 chromosome, complete genome	blastn	8171	363	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronosalvus	Natronosalvus rutilus
19018062	19018062	PRJNA674050_P_NODE_5935_length_337_cov_1.151515_g5732_i0	PRJNA674050	5935	337	1.151515	3.88060555	Natrialbaceae	1644061	Archaea	Archaea	540	5.569999999999999e-149	NTclustered	gi\|1149031894\|gb\|KX833946.1\|	68911	g5732	i0	95.562	101.569732937685	338	14	100	1	1	337	338	1	Natrialba chahannaoensis strain YLD-32 16S ribosomal RNA gene, partial sequence	blastn	34229	540	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba chahannaoensis
19770130	19770130	PRJNA674050_P_NODE_11376_length_291_cov_1.688073_g11173_i0	PRJNA674050	11376	291	1.688073	4.91229243	Natrinema caseinilyticum	2961570	Archaea	Archaea	449	8.180000000000001e-122	NTclustered	gi\|2270264148\|gb\|CP100445.1\|	2961570	g11173	i0	94.502	187.615120274914	291	16	100	0	1	291	238250	237960	Natrinema caseinilyticum strain ZJ2 chromosome, complete genome	blastn	54596	449	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema caseinilyticum
21046526	21046526	PRJNA674050_P_NODE_31417_length_246_cov_1.786127_g31214_i0	PRJNA674050	31417	246	1.786127	4.39387242	Halorussus vallis	2953749	Archaea	Archaea	309	1.19e-79	NTclustered	gi\|2263971171\|gb\|CP100004.1\|	2953749	g31214	i0	96.277	0.764227642276423	188	7	76	0	33	220	76377	76190	Halorussus vallis strain XZYJT10 plasmid unnamed4, complete sequence	blastn	188	309	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus vallis
24118273	24118273	PRJNA674050_P_NODE_32839_length_246_cov_0.884393_g32636_i0	PRJNA674050	32839	246	0.884393	2.17560678	Haloarculaceae	1963268	Archaea	Archaea	207	4.48e-49	NTclustered	gi\|749699433\|gb\|CP010529.1\|	1592728	g32636	i0	85.714	70.3821138211382	196	28	80	0	51	246	2147035	2146840	Haloarcula sp. CBA1115, complete genome	blastn	17314	207	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula sp. CBA1115

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