metadata: contig_metadata: 25 rows where bioproject = "PRJNA690592", tax_clade = "Stenosarchaea group" and tax

25 rows where bioproject = "PRJNA690592", 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
671111	671111	PRJNA690592_S_NODE_161761_length_268_cov_1.092308_g160747_i0	PRJNA690592	161761	268	1.092308	2.92738544	Halomarina rubra	2071873	Archaea	Archaea	105	2.99e-24	NR	WP_250872889.1	2071873	g160747	i0	47.1	1.92537313432836	87	46	97.4	0	268	8	421	507	WP_250872889.1 AMP-dependent synthetase/ligase [Halomarina rubra]	diamond	516	105	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina rubra
671285	671285	PRJNA690592_S_NODE_185221_length_251_cov_1.707865_g184207_i0	PRJNA690592	185221	251	1.707865	4.28674115	Haloferacaceae archaeon 50	3384156	Archaea	Archaea	80.5	1.04e-10	NTclustered	gi\|2869714876\|gb\|CP175567.1\|	3384156	g184207	i0	83.333	0.621513944223108	90	12	40	3	70	158	294056	294143	Haloferacaceae archaeon 50 chromosome, complete genome	blastn	156	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae		Haloferacaceae archaeon 50
671500	671500	PRJNA690592_S_NODE_210221_length_243_cov_0.905882_g209207_i0	PRJNA690592	210221	243	0.905882	2.20129326	Halobellus limi	699433	Archaea	Archaea	54.7	0.006	NTclustered	gi\|1621075116\|gb\|CP031311.1\|	699433	g209207	i0	100	0.119341563786008	29	0	12	0	86	114	2657109	2657137	Halobellus limi strain CGMCC 1.10331 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus limi
1948102	1948102	PRJNA690592_S_NODE_90902_length_340_cov_2.074906_g89888_i0	PRJNA690592	90902	340	2.074906	7.0546804	Methanosarcinales archaeon Met12	1914862	Archaea	Archaea	58.4	6.9e-4	NTclustered	gi\|2647574341\|gb\|CP017966.2\|	1914862	g89888	i0	81.944	0.952941176470588	72	10	21	3	58	127	620810	620740	MAG: Methanosarcinales archaeon Met12 chromosome, complete genome	blastn	324	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon Met12
3221756	3221756	PRJNA690592_S_NODE_133863_length_291_cov_1.059633_g132849_i0	PRJNA690592	133863	291	1.059633	3.08353203	Methanosarcina lacustris	170861	Archaea	Archaea	58.4	5.79e-4	NTclustered	gi\|805377189\|gb\|CP009515.1\|	1434111	g132849	i0	94.595	0.127147766323024	37	2	13	0	52	88	1659170	1659134	Methanosarcina lacustris Z-7289, complete genome	blastn	37	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina lacustris
3222659	3222659	PRJNA690592_S_NODE_4703_length_1225_cov_16.095486_g4224_i0	PRJNA690592	4703	1225	16.095486	197.1697035	Methanosarcinales archaeon	2250255	Archaea	Archaea	490	2.149999999999999e-169	NR	RYE83110.1	2250255	g4224	i0	63	0.95265306122449	389	126	95.3	4	2	1168	46	416	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	1167	490	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
9600240	9600240	PRJNA690592_S_NODE_47868_length_448_cov_1.573333_g46854_i0	PRJNA690592	47868	448	1.573333	7.04853184	Methanosarcinales archaeon	2250255	Archaea	Archaea	184	1.0599999999999999e-53	NR	RYE83110.1	2250255	g46854	i0	68.8	0.857142857142857	128	40	85.7	0	2	385	289	416	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	384	184	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
10874892	10874892	PRJNA690592_S_NODE_121269_length_303_cov_1.317391_g120255_i0	PRJNA690592	121269	303	1.317391	3.99169473	Haloprofundus salinisoli	2876193	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2099489100\|gb\|CP083663.1\|	2876193	g120255	i0	96.97	0.108910891089109	33	1	11	0	2	34	2766829	2766861	Haloprofundus salinisoli strain SQT7-1 chromosome, complete genome	blastn	33	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus salinisoli
15973788	15973788	PRJNA690592_S_NODE_15173_length_757_cov_1.440058_g14280_i0	PRJNA690592	15173	757	1.440058	10.90123906	Methanosarcinales archaeon	2250255	Archaea	Archaea	427	5.91e-147	NR	RYE83110.1	2250255	g14280	i0	92	0.887714663143989	224	18	88.8	0	1	672	192	415	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	672	427	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
18523957	18523957	PRJNA690592_S_NODE_71155_length_377_cov_2.368421_g70141_i0	PRJNA690592	71155	377	2.368421	8.92894717	halophilic archaeon DL31	756883	Archaea	Archaea	52.8	0.036	NTclustered	gi\|344322453\|gb\|CP002989.1\|	756883	g70141	i0	100	0.0742705570291777	28	0	7	0	165	192	171086	171059	Halophilic archaeon DL31 plasmid phalar01, complete sequence	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			halophilic archaeon DL31
26639341	26639341	PRJNA690592_S_NODE_65221_length_392_cov_1.376176_g64207_i0	PRJNA690592	65221	392	1.376176	5.39460992	Haladaptatus pallidirubidus	1008152	Archaea	Archaea	47.4	0.0043	NR	WP_227778257.1	1008152	g64207	i0	33	0.76530612244898	100	56	76.5	3	323	24	130	218	WP_227778257.1 3-keto-disaccharide hydrolase [Haladaptatus pallidirubidus]	diamond	300	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus pallidirubidus
26892773	26892773	PRJNA690592_S_NODE_119421_length_305_cov_1.250000_g118407_i0	PRJNA690592	119421	305	1.25	3.8125	Methanotrichaceae archaeon	2595067	Archaea	Archaea	66.2	2.61e-10	NR	MCJ7443602.1	2595067	g118407	i0	38.2	2.07540983606557	110	56	98.4	5	300	1	46	153	MCJ7443602.1 hypothetical protein [Methanotrichaceae archaeon]	diamond	633	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae		Methanotrichaceae archaeon
27145224	27145224	PRJNA690592_S_NODE_142542_length_283_cov_1.466667_g141528_i0	PRJNA690592	142542	283	1.466667	4.15066761	Halococcus thailandensis	335952	Archaea	Archaea	45.1	8.32e-4	NR	WP_007741106.1	335952	g141528	i0	48.1	1.886925795053	52	23	55.1	3	188	33	6	53	WP_007741106.1 hypothetical protein [Halococcus thailandensis]	diamond	534	45.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus thailandensis
27398622	27398622	PRJNA690592_S_NODE_12683_length_820_cov_3.564926_g11847_i0	PRJNA690592	12683	820	3.564926	29.2323932	Methanomicrobium sp. W14	2817839	Archaea	Archaea	79	1.06e-12	NR	WP_209690807.1	2817839	g11847	i0	47.2	1.03170731707317	72	38	26.3	0	152	367	1	72	WP_209690807.1 molecular chaperone DnaJ [Methanomicrobium sp. W14]	diamond	846	79	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanomicrobium	Methanomicrobium sp. W14
27441763	27441763	PRJNA690592_S_NODE_203143_length_245_cov_1.139535_g202129_i0	PRJNA690592	203143	245	1.139535	2.79186075	root	1	Root_unresolved	Root_unresolved	66.6	1.45e-10	NR	MFB3766139.1	2595067	g202129	i0	46.3	1.99591836734694	82	40	95.5	1	244	11	477	558	MFB3766139.1 response regulator [Methanotrichaceae archaeon]	diamond	489	67	0.994029850746269	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae		Methanotrichaceae archaeon
27714712	27714712	PRJNA690592_S_NODE_189264_length_250_cov_0.870056_g188250_i0	PRJNA690592	189264	250	0.870056	2.17514	Natranaeroarchaeum sulfidigenes	2784880	Archaea	Archaea	44.7	0.00882	NR	WP_238479568.1	2784880	g188250	i0	33.3	0.864	72	41	78	1	196	2	649	720	WP_238479568.1 cobaltochelatase subunit CobN [Natranaeroarchaeum sulfidigenes]	diamond	216	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natranaeroarchaeum	Natranaeroarchaeum sulfidigenes
27935439	27935439	PRJNA690592_S_NODE_47985_length_447_cov_2.561497_g46971_i0	PRJNA690592	47985	447	2.561497	11.44989159	Methanocalculus sp.	2004547	Archaea	Archaea	50.8	4.31e-4	NR	WP_300329989.1	2004547	g46971	i0	35.4	0.530201342281879	79	51	53	0	406	170	52	130	WP_300329989.1 SulP family inorganic anion transporter [Methanocalculus sp.]	diamond	237	50.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocalculaceae	Methanocalculus	Methanocalculus sp.
28630160	28630160	PRJNA690592_S_NODE_212807_length_242_cov_0.911243_g211793_i0	PRJNA690592	212807	242	0.911243	2.20520806	Methanoregula sp.	2052170	Archaea	Archaea	54.7	2.22e-6	NR	HUH79427.1	2052170	g211793	i0	45.6	3.32231404958678	68	36	83.1	1	212	12	73	140	HUH79427.1 hypothetical protein [Methanoregula sp.]	diamond	804	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
29072212	29072212	PRJNA690592_S_NODE_67828_length_385_cov_1.759615_g66814_i0	PRJNA690592	67828	385	1.759615	6.77451775	Methanoregula sp.	2052170	Archaea	Archaea	65.1	2.74e-9	NR	MDD1700180.1	2052170	g66814	i0	35.8	2.35324675324675	95	42	74	1	57	341	288	363	MDD1700180.1 PKD domain-containing protein [Methanoregula sp.]	diamond	906	65.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
29450620	29450620	PRJNA690592_S_NODE_49750_length_440_cov_1.877384_g48736_i0	PRJNA690592	49750	440	1.877384	8.2604896	Methanoregulaceae archaeon	2485498	Archaea	Archaea	69.7	1.2e-10	NR	HNJ81026.1	2485498	g48736	i0	53.3	0.409090909090909	60	26	40.9	1	228	407	603	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	180	69.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
29671487	29671487	PRJNA690592_S_NODE_137090_length_288_cov_1.130233_g136076_i0	PRJNA690592	137090	288	1.130233	3.25507104	Halobacteriales archaeon QH_1	1904752	Archaea	Archaea	44.7	0.00731	NR	PSP25076.1	1919147	g136076	i0	54.1	2.03125	37	16	37.5	1	216	109	50	86	PSP25076.1 MAG: methyltransferase [Halobacteriales archaeon QH_10_65_19]	diamond	585	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon QH_10_65_19
29734775	29734775	PRJNA690592_S_NODE_6050_length_1114_cov_3.606148_g5488_i0	PRJNA690592	6050	1114	3.606148	40.17248872	Methanosarcinales archaeon	2250255	Archaea	Archaea	301	2.56e-94	NR	RYE85578.1	2250255	g5488	i0	48.8	0.867145421903052	322	143	85.1	7	1	948	223	528	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	966	301	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
30050754	30050754	PRJNA690592_S_NODE_195651_length_248_cov_0.880000_g194637_i0	PRJNA690592	195651	248	0.88	2.1824	Methanolobus sp.	1874737	Archaea	Archaea	49.3	1.92e-4	NR	MDY0387614.1	1874737	g194637	i0	33.3	3.93145161290323	81	53	96.8	1	246	7	385	465	MDY0387614.1 histidine kinase N-terminal 7TM domain-containing protein [Methanolobus sp.]	diamond	975	49.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus sp.
31409752	31409752	PRJNA690592_S_NODE_197076_length_247_cov_1.327586_g196062_i0	PRJNA690592	197076	247	1.327586	3.27913742	Methanothrix sp.	90426	Archaea	Archaea	45.8	0.00325	NR	MDD1761689.1	90426	g196062	i0	37.5	0.777327935222672	64	35	71.7	1	17	193	424	487	MDD1761689.1 PQQ-binding-like beta-propeller repeat protein [Methanothrix sp.]	diamond	192	45.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
32073970	32073970	PRJNA690592_S_NODE_136518_length_288_cov_1.874419_g135504_i0	PRJNA690592	136518	288	1.874419	5.39832672	Methanospirillum sp.	45200	Archaea	Archaea	45.1	0.0103	NR	WP_300036836.1	45200	g135504	i0	38.2	0.791666666666667	76	45	77.1	1	285	64	856	931	WP_300036836.1 serine/threonine-protein kinase [Methanospirillum sp.]	diamond	228	45.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum sp.

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