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

15 rows where bioproject = "PRJNA940501" and tax_clade = "Stenosarchaea group"

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
1257707	1257707	PRJNA940501_S_NODE_243001_length_180_cov_3.014599_g242183_i0	PRJNA940501	243001	180	3.014599	5.4262782	Haloarcula	2237	Archaea	Archaea	52.8	0.015	NTclustered	gi\|1822681844\|gb\|CP050014.1\|	2716717	g242183	i0	100	0.311111111111111	28	0	16	0	41	68	1603196	1603169	Haloarcula sp. JP-L23 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula sp. JP-L23
6024531	6024531	PRJNA940501_S_NODE_401185_length_150_cov_0.878505_g400367_i0	PRJNA940501	401185	150	0.878505	1.3177575	uncultured Methanoregulaceae archaeon	1392423	Archaea	Archaea	54.7	0.003	NTclustered	gi\|2874254018\|emb\|OY970343.1\|	1392423	g400367	i0	94.444	0.24	36	1	23	1	57	91	1284585	1284620	MAG: uncultured Methanoregulaceae archaeon isolate MFD00082.bin.c.4 genome assembly, chromosome: 1	blastn	36	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		uncultured Methanoregulaceae archaeon
7296699	7296699	PRJNA940501_S_NODE_16866_length_383_cov_5.411765_g16050_i0	PRJNA940501	16866	383	5.411765	20.72705995	Halovivax cerinus	1487865	Archaea	Archaea	52.8	0.037	NTclustered	gi\|2279709464\|gb\|CP101824.1\|	1487865	g16050	i0	100	0.0731070496083551	28	0	7	0	262	289	1011176	1011203	Halovivax cerinus strain IBRC-M 10256 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax cerinus
9847200	9847200	PRJNA940501_S_NODE_209548_length_190_cov_1.278912_g208730_i0	PRJNA940501	209548	190	1.278912	2.4299328	Methanosarcinales archaeon Met12	1914862	Archaea	Archaea	54.7	0.005	NTclustered	gi\|2647574341\|gb\|CP017966.2\|	1914862	g208730	i0	96.97	0.468421052631579	33	0	17	1	139	171	198103	198134	MAG: Methanosarcinales archaeon Met12 chromosome, complete genome	blastn	89	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon Met12
9847477	9847477	PRJNA940501_S_NODE_227588_length_185_cov_0.992958_g226770_i0	PRJNA940501	227588	185	0.992958	1.8369723	Natrialba magadii	13769	Archaea	Archaea	63.9	7.3e-6	NTclustered	gi\|289529249\|gb\|CP001932.1\|	547559	g226770	i0	100	41.8	34	0	18	0	73	106	3095408	3095375	Natrialba magadii ATCC 43099, complete sequence	blastn	7733	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba magadii
10185950	10185950	PRJNA940501_S_NODE_132968_length_219_cov_2.085227_g132150_i0	PRJNA940501	132968	219	2.085227	4.56664713	root	1	Root_unresolved	Root_unresolved	80.5	8.89e-11	NTclustered	gi\|2515741548\|gb\|CP117271.1\|	2209	g132150	i0	100	7.78538812785388	43	0	20	0	1	43	275528	275570	Mutant Methanosarcina mazei strain Mm Mut 208, complete genome	blastn	1705	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
10187303	10187303	PRJNA940501_S_NODE_98208_length_239_cov_1.724490_g97390_i0	PRJNA940501	98208	239	1.72449	4.1215311	root	1	Root_unresolved	Root_unresolved	99.4	4.16e-22	NR	WP_015300700.1	387341	g97390	i0	79	7.07949790794979	62	13	77.8	0	50	235	574	635	WP_015300700.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Halovivax ruber]	diamond	1692	100	0.994	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax ruber
11124971	11124971	PRJNA940501_S_NODE_40969_length_299_cov_4.265625_g40151_i0	PRJNA940501	40969	299	4.265625	12.75421875	Haloprofundus halobius	2876194	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2099489103\|gb\|CP083666.1\|	2876194	g40151	i0	100	0.100334448160535	30	0	10	0	164	193	2092621	2092592	Haloprofundus halobius strain SEDH52 chromosome, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus halobius
14947255	14947255	PRJNA940501_S_NODE_222232_length_186_cov_1.643357_g221414_i0	PRJNA940501	222232	186	1.643357	3.05664402	Haloarcula litorea	3032579	Archaea	Archaea	161	2.53e-35	NTclustered	gi\|2463595526\|gb\|CP119779.1\|	3032579	g221414	i0	84.118	7.78494623655914	170	23	90	4	1	168	301873	301706	Haloarcula litorea strain GDY20 chromosome, complete genome	blastn	1448	161	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula litorea
22595668	22595668	PRJNA940501_S_NODE_180298_length_199_cov_3.852564_g179480_i0	PRJNA940501	180298	199	3.852564	7.66660236	Methanosalsum zhilinae	39669	Archaea	Archaea	56.5	0.001	NTclustered	gi\|335929340\|gb\|CP002101.1\|	679901	g179480	i0	100	0.150753768844221	30	0	15	0	87	116	1665138	1665167	Methanosalsum zhilinae DSM 4017, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosalsum	Methanosalsum zhilinae
28604277	28604277	PRJNA940501_S_NODE_23227_length_348_cov_2.049180_g22409_i0	PRJNA940501	23227	348	2.04918	7.1311464	Haloferax sp. Atlit-12N	2077203	Archaea	Archaea	62	1.68e-8	NR	WP_115883272.1	2077203	g22409	i0	38.8	1.35344827586207	85	46	69.8	3	14	256	228	310	WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N]	diamond	471	62	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-12N
30909982	30909982	PRJNA940501_S_NODE_100734_length_237_cov_2.592784_g99916_i0	PRJNA940501	100734	237	2.592784	6.14489808	Methanofollis sp.	2052835	Archaea	Archaea	42.7	0.0359	NR	MDK2974911.1	2052835	g99916	i0	30.6	0.784810126582278	62	36	69.6	2	40	204	483	544	MDK2974911.1 hypothetical protein [Methanofollis sp.]	diamond	186	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis sp.
31068057	31068057	PRJNA940501_S_NODE_5635_length_634_cov_4.622673_g4995_i0	PRJNA940501	5635	634	4.622673	29.30774682	Methanosarcinales archaeon	2250255	Archaea	Archaea	122	6.57e-29	NR	RYE84491.1	2250255	g4995	i0	55.4	2.69242902208202	112	47	51.6	1	27	353	124	235	RYE84491.1 MAG: hypothetical protein EOO65_02170 [Methanosarcinales archaeon]	diamond	1707	122	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31858355	31858355	PRJNA940501_S_NODE_322217_length_163_cov_1.175000_g321399_i0	PRJNA940501	322217	163	1.175	1.91525	Methanosarcinales archaeon	2250255	Archaea	Archaea	100	6.839999999999999e-23	NR	RYE85578.1	2250255	g321399	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	46	99	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	162	100	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32428047	32428047	PRJNA940501_S_NODE_129499_length_221_cov_1.584270_g128681_i0	PRJNA940501	129499	221	1.58427	3.5012367	Methanoregula sp.	2052170	Archaea	Archaea	42	0.0331	NR	MDD1680356.1	2052170	g128681	i0	37.2	1.05882352941176	78	30	82.8	3	208	26	56	131	MDD1680356.1 hypothetical protein [Methanoregula sp.]	diamond	234	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula 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);;