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

18 rows where bioproject = "PRJNA1002570" 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
2702569	2702569	PRJNA1002570_P_NODE_28343_length_271_cov_2.742424_g28148_i0	PRJNA1002570	28343	271	2.742424	7.43196904	Methanocella sp.	2052833	Archaea	Archaea	67	1.54e-10	NR	HMK45342.1	2052833	g28148	i0	39.3	0.985239852398524	89	53	98.5	1	2	268	528	615	HMK45342.1 hypothetical protein [Methanocella sp.]	diamond	267	67	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales	Methanocellaceae	Methanocella	Methanocella sp.
10355259	10355259	PRJNA1002570_P_NODE_13069_length_332_cov_1.154440_g12874_i0	PRJNA1002570	13069	332	1.15444	3.8327408	Pyrococcus furiosus	2261	Archaea	Archaea	225	3.94e-67	NR	4AHC_A	2261	g12874	i0	100	5.96385542168675	110	0	99.4	0	3	332	190	299	4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus]	diamond	1980	225	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
18852255	18852255	PRJNA1002570_P_NODE_13335_length_329_cov_1.304688_g13140_i0	PRJNA1002570	13335	329	1.304688	4.29242352	root	1	Root_unresolved	Root_unresolved	584	2.469999999999999e-162	NTclustered	gi\|436492\|gb\|U00707.1\|PSU00707	33866	g13140	i0	100	7.65957446808511	316	0	96	0	14	329	362	677	Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds	blastn	2520	584	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus sp.
26646887	26646887	PRJNA1002570_P_NODE_3041_length_613_cov_3.831481_g1959_i1	PRJNA1002570	3041	613	3.831481	23.48697853	root	1	Root_unresolved	Root_unresolved	199	5.889999999999999e-57	NR	MEA2075079.1	2026739	g1959	i1	58.1	3.9347471451876	155	60	73.4	2	613	164	351	505	MEA2075079.1 DNA methyltransferase [Methanobacteriota archaeon]	diamond	2412	201	0.990049751243781	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27128762	27128762	PRJNA1002570_P_NODE_11102_length_354_cov_3.032028_g10907_i0	PRJNA1002570	11102	354	3.032028	10.73337912	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	66.2	7.33e-10	NR	HEY9247135.1	2032688	g10907	i0	36.2	2.66101694915254	116	73	97.5	1	5	349	91	206	HEY9247135.1 PAS domain-containing protein [Candidatus Methanoperedens sp.]	diamond	942	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
27160578	27160578	PRJNA1002570_P_NODE_8862_length_385_cov_2.416667_g8667_i0	PRJNA1002570	8862	385	2.416667	9.30416795	Methanothrix soehngenii	2223	Archaea	Archaea	115	1.0600000000000002e-27	NR	WP_342474883.1	2223	g8667	i0	58.5	1.78441558441558	106	42	81	1	384	73	290	395	WP_342474883.1 restriction endonuclease subunit S, partial [Methanothrix soehngenii]	diamond	687	115	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix soehngenii
27382208	27382208	PRJNA1002570_P_NODE_3723_length_558_cov_1.352577_g3531_i0	PRJNA1002570	3723	558	1.352577	7.54737966	Halobacteriota archaeon	3100168	Archaea	Archaea	75.9	2.25e-14	NR	MDY6958323.1	3100168	g3531	i0	50	0.951612903225806	90	40	48.4	3	335	66	1	85	MDY6958323.1 hypothetical protein [Halobacteriota archaeon]	diamond	531	75.9	1	Archaea		Methanobacteriati	Halobacteriota					Halobacteriota archaeon
27943143	27943143	PRJNA1002570_P_NODE_3765_length_555_cov_1.958506_g3573_i0	PRJNA1002570	3765	555	1.958506	10.8697083	root	1	Root_unresolved	Root_unresolved	366	1.1699999999999995e-119	NR	4AHC_A	2261	g3573	i0	99.5	2.96756756756757	183	1	98.9	0	5	553	495	677	4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus]	diamond	1647	368	0.994565217391304	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
28385020	28385020	PRJNA1002570_P_NODE_12226_length_341_cov_1.436567_g12031_i0	PRJNA1002570	12226	341	1.436567	4.89869347	root	1	Root_unresolved	Root_unresolved	166	2.6099999999999997e-47	NR	WP_206539401.1	1550566	g12031	i0	75.5	10.574780058651	106	26	93.3	0	336	19	72	177	WP_206539401.1 class I SAM-dependent methyltransferase [Methanoculleus sediminis]	diamond	3606	166	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sediminis
28676760	28676760	PRJNA1002570_P_NODE_3147_length_603_cov_2.873585_g2957_i0	PRJNA1002570	3147	603	2.873585	17.32771755	Thermoplasmatota archaeon	2806419	Archaea	Archaea	122	1.18e-29	NR	MFO8050666.1	2806419	g2957	i0	39.7	2.04477611940298	204	110	99	8	6	602	63	258	MFO8050666.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	1233	122	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
28897534	28897534	PRJNA1002570_P_NODE_35748_length_251_cov_1.713483_g35553_i0	PRJNA1002570	35748	251	1.713483	4.30084233	Thermoplasmata archaeon	1906666	Archaea	Archaea	115	1.87e-28	NR	HEV8049819.1	1906666	g35553	i0	67.9	4.82868525896414	81	26	96.8	0	246	4	123	203	HEV8049819.1 hypothetical protein [Thermoplasmata archaeon]	diamond	1212	115	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29813195	29813195	PRJNA1002570_P_NODE_3351_length_585_cov_2.648438_g3160_i0	PRJNA1002570	3351	585	2.648438	15.4933623	Haloparvum sedimenti	1678448	Archaea	Archaea	170	1.38e-50	NR	WP_080508407.1	1678448	g3160	i0	54.3	0.707692307692308	138	57	70.8	1	56	469	11	142	WP_080508407.1 CHY zinc finger protein [Haloparvum sedimenti]	diamond	414	170	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloparvum	Haloparvum sedimenti
30192331	30192331	PRJNA1002570_P_NODE_5712_length_458_cov_2.898701_g5518_i0	PRJNA1002570	5712	458	2.898701	13.27605058	Pyrococcus furiosus	2261	Archaea	Archaea	304	2.0499999999999993e-96	NR	4AHC_A	2261	g5518	i0	98	0.995633187772926	152	3	99.6	0	3	458	6	157	4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus]	diamond	456	304	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
31290781	31290781	PRJNA1002570_P_NODE_16495_length_309_cov_1.216102_g16300_i0	PRJNA1002570	16495	309	1.216102	3.75775518	root	1	Root_unresolved	Root_unresolved	129	3.27e-33	NR	WP_342474883.1	2223	g16300	i0	58.4	4.80582524271845	101	42	98.1	0	7	309	220	320	WP_342474883.1 restriction endonuclease subunit S, partial [Methanothrix soehngenii]	diamond	1485	129	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix soehngenii
32429875	32429875	PRJNA1002570_P_NODE_37399_length_249_cov_1.704545_g37204_i0	PRJNA1002570	37399	249	1.704545	4.24431705	root	1	Root_unresolved	Root_unresolved	48.9	2.74e-4	NR	MAE79749.1	2026739	g37204	i0	34.5	2.39759036144578	84	54	100	1	1	249	503	586	MAE79749.1 hypothetical protein [Methanobacteriota archaeon]	diamond	597	48.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32532324	32532324	PRJNA1002570_P_NODE_11099_length_354_cov_3.313167_g10904_i0	PRJNA1002570	11099	354	3.313167	11.72861118	Candidatus Methanofastidiosum methylothiophilum	1705564	Archaea	Archaea	66.2	3.89e-11	NR	KYC52810.1	1705564	g10904	i0	59.6	0.398305084745763	47	19	39.8	0	4	144	78	124	KYC52810.1 MAG: hypothetical protein AMQ22_00601 [Candidatus Methanofastidiosum methylothiophilum]	diamond	141	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Candidatus Methanofastidiosum methylothiophilum
32808244	32808244	PRJNA1002570_P_NODE_40280_length_246_cov_0.890173_g40085_i0	PRJNA1002570	40280	246	0.890173	2.18982558	Archaea	2157	Archaea	Archaea	55.5	9.47e-7	NR	OGS43146.1	1797977	g40085	i0	40.3	2.26829268292683	62	37	75.6	0	245	60	203	264	OGS43146.1 MAG: hypothetical protein A3K76_01510 [Euryarchaeota archaeon RBG_13_57_23]	diamond	558	55.8	0.99462365591397806	Archaea		Methanobacteriati	Methanobacteriota					Euryarchaeota archaeon RBG_13_57_23
32839647	32839647	PRJNA1002570_P_NODE_2140_length_747_cov_3.391691_g1959_i0	PRJNA1002570	2140	747	3.391691	25.33593177	root	1	Root_unresolved	Root_unresolved	200	2.0999999999999996e-56	NR	MEA2075079.1	2026739	g1959	i0	58.1	2.50602409638554	155	60	60.2	2	747	298	351	505	MEA2075079.1 DNA methyltransferase [Methanobacteriota archaeon]	diamond	1872	201	0.995024875621891	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon

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