metadata: contig_metadata: 15 rows where bioproject = "PRJNA1160211" and tax

15 rows where bioproject = "PRJNA1160211" 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
3589145	3589145	PRJNA1160211_S_NODE_254883_length_258_cov_1.243243_g253650_i0	PRJNA1160211	254883	258	1.243243	3.20756694	root	1	Root_unresolved	Root_unresolved	80.5	1.08e-10	NTclustered	gi\|2874253795\|emb\|OY969779.1\|	176233	g253650	i0	92.982	34.1627906976744	57	0	22	3	179	235	158776	158828	MAG: uncultured Methanobacteriaceae archaeon isolate MFD04716.bin.c.1 genome assembly, chromosome: 1	blastn	8814	80.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
6686916	6686916	PRJNA1160211_S_NODE_109166_length_440_cov_3.708447_g107938_i0	PRJNA1160211	109166	440	3.708447	16.3171668	uncultured Methanoregula sp.	1005933	Archaea	Archaea	196	1.86e-45	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g107938	i0	82.511	4.32954545454545	223	39	51	0	189	411	3121383	3121605	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	1905	196	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
7416341	7416341	PRJNA1160211_S_NODE_191566_length_320_cov_8.603239_g190333_i0	PRJNA1160211	191566	320	8.603239	27.5303648	Methanococcus	2184	Archaea	Archaea	121	8.11e-23	NTclustered	gi\|2891706660\|gb\|CP178162.1\|	39152	g190333	i0	98.529	33.45625	68	1	21	0	234	301	796799	796866	Methanococcus maripaludis strain LL chromosome, complete genome	blastn	10706	121	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanococcaceae	Methanococcus	Methanococcus maripaludis
9966185	9966185	PRJNA1160211_S_NODE_100848_length_455_cov_16.837696_g99622_i0	PRJNA1160211	100848	455	16.837696	76.6115168	Halococcus	2249	Archaea	Archaea	608	2.0899999999999995e-169	NTclustered	gi\|2221489803\|gb\|CP095005.1\|	179637	g99622	i0	92.111	142.863736263736	431	34	95	0	24	454	212451	212021	Halococcus dombrowskii strain H4 chromosome, complete genome	blastn	65003	608	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
9966706	9966706	PRJNA1160211_S_NODE_240888_length_269_cov_18.295918_g239655_i0	PRJNA1160211	240888	269	18.295918	49.21601942	Methanocaldococcaceae	196117	Archaea	Archaea	82.4	3.14e-11	NTclustered	gi\|2891700162\|gb\|CP178165.1\|	213231	g239655	i0	97.872	28.5130111524164	47	1	17	0	22	68	710545	710499	Methanocaldococcus indicus strain SL43 chromosome, complete genome	blastn	7670	82.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus indicus
20165431	20165431	PRJNA1160211_S_NODE_90356_length_476_cov_10.434243_g89133_i0	PRJNA1160211	90356	476	10.434243	49.66699668	Halalkalicoccus	332246	Archaea	Archaea	846	0	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g89133	i0	98.739	165.321428571429	476	6	100	0	1	476	1307	832	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	78693	846	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
22715204	22715204	PRJNA1160211_S_NODE_150558_length_374_cov_2.059801_g149325_i0	PRJNA1160211	150558	374	2.059801	7.70365574	Methanobacteriaceae	2159	Archaea	Archaea	102	3.48e-17	NTclustered	gi\|333824386\|gb\|CP002772.1\|	868131	g149325	i0	91.892	39.8689839572192	74	5	20	1	302	374	814199	814126	Methanobacterium paludis strain SWAN1, complete genome	blastn	14911	102	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium paludis
27533687	27533687	PRJNA1160211_S_NODE_58923_length_550_cov_7.807128_g57739_i0	PRJNA1160211	58923	550	7.807128	42.939204	root	1	Root_unresolved	Root_unresolved	77	8.77e-13	NR	MBJ35148.1	2026739	g57739	i0	44.7	2.04545454545455	94	43	46.4	3	453	199	320	413	MBJ35148.1 hypothetical protein [Methanobacteriota archaeon]	diamond	1125	77	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27861576	27861576	PRJNA1160211_S_NODE_274605_length_245_cov_1.924419_g273372_i0	PRJNA1160211	274605	245	1.924419	4.71482655	Halospeciosus flavus	3032283	Archaea	Archaea	152	1.0299999999999998e-43	NR	WP_382267974.1	3032283	g273372	i0	88.6	0.96734693877551	79	9	96.7	0	8	244	38	116	WP_382267974.1 replication initiation factor domain-containing protein [Halospeciosus flavus]	diamond	237	152	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halospeciosus	Halospeciosus flavus
28745766	28745766	PRJNA1160211_S_NODE_12547_length_779_cov_4.957507_g11695_i0	PRJNA1160211	12547	779	4.957507	38.61897953	Methanobacteriota archaeon	2026739	Archaea	Archaea	184	8.11e-49	NR	MAD56215.1	2026739	g11695	i0	73.2	0.489088575096277	127	33	48.9	1	778	398	895	1020	MAD56215.1 hypothetical protein [Methanobacteriota archaeon]	diamond	381	184	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28935294	28935294	PRJNA1160211_S_NODE_209648_length_300_cov_2.590308_g208415_i0	PRJNA1160211	209648	300	2.590308	7.770924	Methanobacteriota archaeon	2026739	Archaea	Archaea	44.3	0.00245	NR	MBN74715.1	2026739	g208415	i0	58.8	0.34	34	14	34	0	28	129	36	69	MBN74715.1 hypothetical protein [Methanobacteriota archaeon]	diamond	102	44.3	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30451402	30451402	PRJNA1160211_S_NODE_18893_length_717_cov_15.989130_g17911_i0	PRJNA1160211	18893	717	15.98913	114.6420621	Halosimplex aquaticum	3026162	Archaea	Archaea	121	1.83e-27	NR	WP_274325319.1	3026162	g17911	i0	30	0.97489539748954	233	152	94.6	2	7	684	259	487	WP_274325319.1 PAS domain-containing sensor histidine kinase [Halosimplex aquaticum]	diamond	699	121	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex aquaticum
31430804	31430804	PRJNA1160211_S_NODE_249136_length_262_cov_6.312169_g247903_i0	PRJNA1160211	249136	262	6.312169	16.53788278	Candidatus Poseidoniia archaeon	2666348	Archaea	Archaea	41.6	0.022	NR	MDP6275084.1	2666348	g247903	i0	40.4	0.595419847328244	52	26	58.4	2	39	191	4	51	MDP6275084.1 hypothetical protein [Candidatus Poseidoniia archaeon]	diamond	156	41.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia				Candidatus Poseidoniia archaeon
32190169	32190169	PRJNA1160211_S_NODE_45818_length_590_cov_2.456480_g44662_i0	PRJNA1160211	45818	590	2.45648	14.493232	Methanobacteriota archaeon	2026739	Archaea	Archaea	84.7	2.93e-15	NR	RMG30411.1	2026739	g44662	i0	35.8	0.823728813559322	162	90	76.8	5	137	589	363	521	RMG30411.1 MAG: hypothetical protein D6732_16280 [Methanobacteriota archaeon]	diamond	486	84.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32209463	32209463	PRJNA1160211_S_NODE_126458_length_410_cov_21.916914_g125226_i0	PRJNA1160211	126458	410	21.916914	89.8593474	root	1	Root_unresolved	Root_unresolved	130	4.1e-32	NR	TLZ55728.1	2026739	g125226	i0	61	3.3	105	40	76.1	1	344	33	58	162	TLZ55728.1 MAG: PKD domain-containing protein [Methanobacteriota archaeon]	diamond	1353	130	1	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);;