metadata: contig_metadata: 14 rows where bioproject = "PRJNA494251", tax_clade = "Stenosarchaea group" and tax

14 rows where bioproject = "PRJNA494251", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

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
6210350	6210350	PRJNA494251_P_NODE_49265_length_241_cov_0.916667_g48951_i0	PRJNA494251	49265	241	0.916667	2.20916747	Methanomicrobiales	2191	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2006650972\|gb\|CP036172.1\|	126734	g48951	i0	100	0.37344398340249	30	0	12	0	160	189	59530	59559	Methanofollis aquaemaris strain N2F9704 chromosome, complete genome	blastn	90	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis aquaemaris
8128447	8128447	PRJNA494251_P_NODE_38187_length_250_cov_0.870056_g37873_i0	PRJNA494251	38187	250	0.870056	2.17514	Natronomonas salina	1710540	Archaea	Archaea	52.8	0.023	NTclustered	gi\|1865519430\|gb\|CP058335.1\|	1710540	g37873	i0	94.118	0.136	34	2	14	0	98	131	739519	739486	Natronomonas salina strain YPL13 chromosome, complete genome	blastn	34	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas salina
9403423	9403423	PRJNA494251_P_NODE_40328_length_248_cov_1.320000_g40014_i0	PRJNA494251	40328	248	1.32	3.2736	Haloglomus halophilum	2962672	Archaea	Archaea	62.1	3.73e-5	NTclustered	gi\|2273560679\|gb\|CP101166.1\|	2962672	g40014	i0	89.583	0.193548387096774	48	5	19	0	125	172	614724	614771	Haloglomus halophilum strain ZY41 chromosome, complete genome	blastn	48	62.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Haloglomus	Haloglomus halophilum
11954180	11954180	PRJNA494251_P_NODE_39630_length_249_cov_0.875000_g39316_i0	PRJNA494251	39630	249	0.875	2.17875	Natrinema pallidum	69527	Archaea	Archaea	56.5	0.002	NTclustered	gi\|1674549330\|gb\|CP040637.1\|	69527	g39316	i0	100	0.240963855421687	30	0	12	0	29	58	813772	813743	Natrinema pallidum strain BOL6-1 chromosome, complete genome	blastn	60	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema pallidum
17052531	17052531	PRJNA494251_P_NODE_20194_length_316_cov_1.522634_g19880_i0	PRJNA494251	20194	316	1.522634	4.81152344	Halospeciosus flavus	3032283	Archaea	Archaea	54.7	0.008	NTclustered	gi\|2490484842\|gb\|CP122312.1\|	3032283	g19880	i0	100	0.0917721518987342	29	0	9	0	65	93	3051262	3051234	Halospeciosus flavus strain XZGYJ-43 chromosome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halospeciosus	Halospeciosus flavus
19601076	19601076	PRJNA494251_P_NODE_18736_length_326_cov_1.739130_g18422_i0	PRJNA494251	18736	326	1.73913	5.6695638	Natronococcus wangiae	3068275	Archaea	Archaea	58.4	6.59e-4	NTclustered	gi\|2563036162\|gb\|CP132294.1\|	3068275	g18422	i0	92.5	0.331288343558282	40	3	12	0	258	297	4001600	4001561	Natronococcus wangiae strain AD-5 chromosome, complete genome	blastn	108	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus wangiae
24701412	24701412	PRJNA494251_P_NODE_40540_length_248_cov_0.880000_g40226_i0	PRJNA494251	40540	248	0.88	2.1824	halophilic archaeon DL31	756883	Archaea	Archaea	52.8	0.022	NTclustered	gi\|344319636\|gb\|CP002988.1\|	756883	g40226	i0	100	0.225806451612903	28	0	11	0	185	212	171503	171476	Halophilic archaeon DL31 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			halophilic archaeon DL31
26649174	26649174	PRJNA494251_P_NODE_5161_length_561_cov_1.262295_g4867_i0	PRJNA494251	5161	561	1.262295	7.08147495	Methanoregula	395331	Archaea	Archaea	79.7	1.73e-14	NR	HSQ94182.1	2052170	g4867	i0	26.2	9.77540106951872	191	129	99.5	4	3	560	47	230	HSQ94182.1 aquaporin Z [Methanoregula sp.]	diamond	5484	80.1	0.995006242197254	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
26776180	26776180	PRJNA494251_P_NODE_34741_length_257_cov_1.103261_g34427_i0	PRJNA494251	34741	257	1.103261	2.83538077	Stenosarchaea group	2290931	Archaea	Archaea	48.1	5.14e-4	NR	WP_199233658.1	1537267	g34427	i0	31.2	6.18677042801556	77	53	89.9	0	10	240	29	105	WP_199233658.1 NAD-dependent epimerase/dehydratase family protein, partial [Halorubrum sp. SP9]	diamond	1590	48.5	0.991752577319588	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. SP9
26887322	26887322	PRJNA494251_P_NODE_7721_length_471_cov_1.298995_g7418_i0	PRJNA494251	7721	471	1.298995	6.11826645	Methanosarcinales archaeon	2250255	Archaea	Archaea	51.6	2.4e-4	NR	RYE84638.1	2250255	g7418	i0	38	0.452229299363057	71	41	45.2	1	259	471	75	142	RYE84638.1 MAG: hypothetical protein EOO65_01930 [Methanosarcinales archaeon]	diamond	213	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
30393352	30393352	PRJNA494251_P_NODE_4233_length_612_cov_4.812616_g3943_i0	PRJNA494251	4233	612	4.812616	29.45320992	Haloplanus salinus	1126245	Archaea	Archaea	84.7	2.01e-16	NR	WP_114450628.1	1126245	g3943	i0	32.6	2.07843137254902	138	88	67.6	1	14	427	48	180	WP_114450628.1 DUF4397 domain-containing protein [Haloplanus salinus]	diamond	1272	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus salinus
30835175	30835175	PRJNA494251_P_NODE_2914_length_717_cov_1.739130_g2645_i0	PRJNA494251	2914	717	1.73913	12.4695621	Haladaptatus caseinilyticus	2993314	Archaea	Archaea	79.7	4.29e-13	NR	WP_266077698.1	2993314	g2645	i0	30.4	1.88284518828452	148	99	60.7	3	22	456	123	269	WP_266077698.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus]	diamond	1350	79.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus caseinilyticus
30929989	30929989	PRJNA494251_P_NODE_10474_length_415_cov_1.798246_g10168_i0	PRJNA494251	10474	415	1.798246	7.4627209	Haloarculaceae archaeon	2497615	Archaea	Archaea	45.4	0.0167	NR	MEF8842997.1	2497615	g10168	i0	40	0.650602409638554	90	46	60.7	3	19	270	60	147	MEF8842997.1 MBL fold metallo-hydrolase [Haloarculaceae archaeon]	diamond	270	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae		Haloarculaceae archaeon
31546421	31546421	PRJNA494251_P_NODE_20136_length_316_cov_2.432099_g19822_i0	PRJNA494251	20136	316	2.432099	7.68543284	Methanomicrobiales	2191	Archaea	Archaea	60.5	4.82e-8	NR	WP_318622147.1	394967	g19822	i0	39.4	3.9493670886076	104	52	98.7	3	314	3	33	125	WP_318622147.1 peptide chain release factor aRF-1 [Methanoculleus receptaculi]	diamond	1248	60.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus receptaculi

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