metadata: contig_metadata: 20 rows where bioproject = "PRJNA631119" and tax

20 rows where bioproject = "PRJNA631119" 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
1879496	1879496	PRJNA631119_P_NODE_9222_length_395_cov_1.990683_g9104_i0	PRJNA631119	9222	395	1.990683	7.86319785	Methanosarcinales archaeon	2250255	Archaea	Archaea	256	4.31e-82	NR	RYE83110.1	2250255	g9104	i0	93.1	0.994936708860759	131	9	99.5	0	395	3	226	356	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	393	256	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
9531750	9531750	PRJNA631119_P_NODE_30428_length_252_cov_1.720670_g30310_i0	PRJNA631119	30428	252	1.72067	4.3360884	Halomontanus rarus	3034020	Archaea	Archaea	63.9	1.06e-5	NTclustered	gi\|2463595547\|gb\|CP119796.1\|	3034020	g30310	i0	100	64.0595238095238	34	0	14	0	35	68	1348235	1348202	Halomontanus rarus strain TS33 chromosome, complete genome	blastn	16143	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halomontanus	Halomontanus rarus
17181242	17181242	PRJNA631119_P_NODE_32034_length_250_cov_0.870056_g31916_i0	PRJNA631119	32034	250	0.870056	2.17514	Natrinema longum	370324	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2006040148\|gb\|CP071463.1\|	370324	g31916	i0	100	0.456	30	0	12	0	66	95	1318130	1318101	Natrinema longum strain ABH32 chromosome, complete genome	blastn	114	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema longum
19729790	19729790	PRJNA631119_P_NODE_18836_length_303_cov_2.413043_g18718_i0	PRJNA631119	18836	303	2.413043	7.31152029	Thermoplasmatales archaeon	2268204	Archaea	Archaea	52.8	0.028	NTclustered	gi\|2108144344\|gb\|CP070724.1\|	2268204	g18718	i0	100	0.0924092409240924	28	0	9	0	18	45	1642403	1642376	MAG: Thermoplasmatales archaeon isolate bin45 chromosome	blastn	28	52.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
26605868	26605868	PRJNA631119_P_NODE_3241_length_608_cov_2.291589_g3129_i0	PRJNA631119	3241	608	2.291589	13.93286112	Thermoplasmatota archaeon	2806419	Archaea	Archaea	46.6	0.029	NR	MED6306090.1	2806419	g3129	i0	42.4	0.291118421052632	59	32	28.1	1	172	2	219	277	MED6306090.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	177	46.6	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27049368	27049368	PRJNA631119_P_NODE_342_length_1456_cov_3.096168_g308_i0	PRJNA631119	342	1456	3.096168	45.08020608	Methanobacteriota archaeon	2026739	Archaea	Archaea	58.9	2.47e-5	NR	NDB66069.1	2026739	g308	i0	36.1	0.274038461538462	133	64	25.3	7	338	706	10	131	NDB66069.1 hypothetical protein [Methanobacteriota archaeon]	diamond	399	58.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27143667	27143667	PRJNA631119_P_NODE_11042_length_369_cov_1.327703_g10924_i0	PRJNA631119	11042	369	1.327703	4.89922407	Thermoplasmatota archaeon	2806419	Archaea	Archaea	68.9	7.3e-12	NR	MBN1539331.1	2806419	g10924	i0	39.6	0.780487804878049	96	54	77.2	3	353	69	37	129	MBN1539331.1 GNAT family N-acetyltransferase [Thermoplasmatota archaeon]	diamond	288	68.9	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27630694	27630694	PRJNA631119_P_NODE_28944_length_257_cov_1.940217_g28826_i0	PRJNA631119	28944	257	1.940217	4.98635769	root	1	Root_unresolved	Root_unresolved	63.9	1.51e-9	NR	WP_406533356.1	66852	g28826	i0	39.1	9.45525291828794	69	42	80.5	0	244	38	572	640	WP_406533356.1 IGHMBP2 family helicase [Methanobrevibacter sp.]	diamond	2430	64.3	0.993779160186625	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27776041	27776041	PRJNA631119_P_NODE_27384_length_263_cov_1.805263_g27266_i0	PRJNA631119	27384	263	1.805263	4.74784169	Halobacteriales archaeon	1904752	Archaea	Archaea	45.1	0.00692	NR	MDX1748068.1	1904752	g27266	i0	78.6	0.319391634980989	28	6	31.9	0	260	177	3	30	MDX1748068.1 LamG-like jellyroll fold domain-containing protein [Halobacteriales archaeon]	diamond	84	45.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon
27933723	27933723	PRJNA631119_P_NODE_24425_length_276_cov_1.187192_g24307_i0	PRJNA631119	24425	276	1.187192	3.27664992	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	52	1.16e-5	NR	HIA39298.1	2163009	g24307	i0	36.4	0.597826086956522	55	35	59.8	0	2	166	110	164	HIA39298.1 NUDIX hydrolase [Candidatus Poseidoniales archaeon]	diamond	165	52	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
28186046	28186046	PRJNA631119_P_NODE_26726_length_266_cov_1.476684_g26608_i0	PRJNA631119	26726	266	1.476684	3.92797944	Thermoplasmatota archaeon	2806419	Archaea	Archaea	41.6	0.0495	NR	MBU3902509.1	2806419	g26608	i0	37.5	0.721804511278195	64	37	69.9	2	71	256	39	101	MBU3902509.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	192	41.6	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29007583	29007583	PRJNA631119_P_NODE_37768_length_243_cov_0.905882_g37650_i0	PRJNA631119	37768	243	0.905882	2.20129326	Haloprofundus salilacus	2876190	Archaea	Archaea	44.3	0.01	NR	WP_224447457.1	2876190	g37650	i0	30.7	0.925925925925926	75	47	86.4	2	32	241	16	90	WP_224447457.1 amidohydrolase family protein [Haloprofundus salilacus]	diamond	225	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus salilacus
29828072	29828072	PRJNA631119_P_NODE_39791_length_238_cov_3.696970_g39673_i0	PRJNA631119	39791	238	3.69697	8.7987886	Methanobrevibacter sp. 87.7	387957	Archaea	Archaea	57.4	2.48e-7	NR	WP_143744798.1	387957	g39673	i0	56.5	1.27310924369748	46	20	58	0	177	40	252	297	WP_143744798.1 hypothetical protein, partial [Methanobrevibacter sp. 87.7]	diamond	303	57.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. 87.7
29954540	29954540	PRJNA631119_P_NODE_22671_length_283_cov_2.690476_g22553_i0	PRJNA631119	22671	283	2.690476	7.61404708	Methanobrevibacter sp.	66852	Archaea	Archaea	51.6	4.38e-5	NR	MBP3226884.1	66852	g22553	i0	39.3	0.593639575971731	56	34	59.4	0	87	254	105	160	MBP3226884.1 hypothetical protein [Methanobrevibacter sp.]	diamond	168	51.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30315118	30315118	PRJNA631119_P_NODE_7092_length_438_cov_1.643836_g6974_i0	PRJNA631119	7092	438	1.643836	7.20000168	root	1	Root_unresolved	Root_unresolved	102	6.1300000000000005e-22	NR	HPJ84988.1	90426	g6974	i0	38.9	7.07534246575342	131	75	87	2	387	7	417	546	HPJ84988.1 VWA domain-containing protein [Methanothrix sp.]	diamond	3099	102	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30586225	30586225	PRJNA631119_P_NODE_13333_length_344_cov_1.697417_g13215_i0	PRJNA631119	13333	344	1.697417	5.83911448	Methanocaldococcus jannaschii	2190	Archaea	Archaea	68.2	1.46e-10	NR	WP_010870556.1	2190	g13215	i0	33.6	2.07558139534884	119	69	99.4	3	342	1	154	267	WP_010870556.1 DNA-directed RNA polymerase subunit A'' [Methanocaldococcus jannaschii]	diamond	714	68.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus jannaschii
30662148	30662148	PRJNA631119_P_NODE_313_length_1495_cov_2.886076_g283_i0	PRJNA631119	313	1495	2.886076	43.1468362	root	1	Root_unresolved	Root_unresolved	66.6	1.76e-7	NR	HOI13930.1	90427	g283	i0	35	2.24147157190635	160	80	31.1	7	1494	1030	119	259	HOI13930.1 kelch repeat-containing protein [Methanoculleus sp.]	diamond	3351	66.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
31028946	31028946	PRJNA631119_P_NODE_22275_length_285_cov_2.254717_g22157_i0	PRJNA631119	22275	285	2.254717	6.42594345	Methanobacteriota archaeon	2026739	Archaea	Archaea	144	1.74e-37	NR	MAD56215.1	2026739	g22157	i0	76.3	0.978947368421053	93	22	97.9	0	3	281	875	967	MAD56215.1 hypothetical protein [Methanobacteriota archaeon]	diamond	279	144	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31629561	31629561	PRJNA631119_P_NODE_35716_length_245_cov_0.895349_g35598_i0	PRJNA631119	35716	245	0.895349	2.19360505	Methanothrix sp.	90426	Archaea	Archaea	73.2	4.4e-13	NR	HPS91780.1	90426	g35598	i0	46.8	5.86530612244898	79	40	96.7	1	1	237	57	133	HPS91780.1 C39 family peptidase [Methanothrix sp.]	diamond	1437	73.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
32893305	32893305	PRJNA631119_P_NODE_14780_length_331_cov_3.027132_g14662_i0	PRJNA631119	14780	331	3.027132	10.01980692	Halorussus limi	2938695	Archaea	Archaea	44.3	0.0252	NR	WP_248652383.1	2938695	g14662	i0	26.6	0.987915407854985	109	75	95.2	3	15	329	121	228	WP_248652383.1 DUF5602 domain-containing protein [Halorussus limi]	diamond	327	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus limi

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