metadata: contig_metadata: 21 rows where bioproject = "PRJEB39269" and tax

21 rows where bioproject = "PRJEB39269" and tax_superkingdom = "Archaea"

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
1331397	1331397	PRJEB39269_P_NODE_88062_length_152_cov_2.469027_g87657_i0	PRJEB39269	88062	152	2.469027	3.75292104	Haloferax volcanii	2246	Archaea	Archaea	148	1.54e-31	NTclustered	gi\|2460998611\|gb\|CP106970.1\|	2246	g87657	i0	100	24.5855263157895	80	0	53	0	73	152	42883	42962	Haloferax volcanii strain BNX82 plasmid pBNX82-4, complete sequence	blastn	3737	148	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax volcanii
7709428	7709428	PRJEB39269_P_NODE_35727_length_231_cov_1.223958_g35322_i0	PRJEB39269	35727	231	1.223958	2.82734298	uncultured Methanosaeta sp.	183756	Archaea	Archaea	377	3e-100	NTclustered	gi\|62512344\|gb\|AY899830.1\|	183756	g35322	i0	96.104	99.0822510822511	231	9	100	0	1	231	679	449	Uncultured Methanosaeta sp. clone Gran2M12 16S ribosomal RNA gene, partial sequence	blastn	22888	377	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	uncultured Methanosaeta sp.
9917438	9917438	PRJEB39269_P_NODE_66868_length_170_cov_2.992366_g66463_i0	PRJEB39269	66868	170	2.992366	5.0870222	Halobacterium	2239	Archaea	Archaea	54.7	0.004	NTclustered	gi\|966204314\|emb\|LN831302.1\|	1407499	g66463	i0	86	0.588235294117647	50	7	29	0	92	141	2134551	2134600	Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I	blastn	100	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium hubeiense
9917466	9917466	PRJEB39269_P_NODE_80588_length_158_cov_2.747899_g80183_i0	PRJEB39269	80588	158	2.747899	4.34168042	Halobacteriales	2235	Archaea	Archaea	76.8	7.75e-10	NTclustered	gi\|2006040148\|gb\|CP071463.1\|	370324	g80183	i0	97.778	3.93670886075949	45	0	28	1	19	63	407676	407633	Natrinema longum strain ABH32 chromosome, complete genome	blastn	622	76.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema longum
10259852	10259852	PRJEB39269_P_NODE_66309_length_170_cov_3.870229_g65904_i0	PRJEB39269	66309	170	3.870229	6.5793893	Halanaeroarchaeum sulfurireducens	1604004	Archaea	Archaea	110	8.32e-20	NTclustered	gi\|933677909\|gb\|CP011564.1\|	1604004	g65904	i0	91.358	0.952941176470588	81	5	47	2	1	80	1584436	1584357	Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome	blastn	162	110	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sulfurireducens
12468387	12468387	PRJEB39269_P_NODE_80530_length_158_cov_2.966387_g80125_i0	PRJEB39269	80530	158	2.966387	4.68689146	Natribaculum	1699375	Archaea	Archaea	93.5	7.69e-15	NTclustered	gi\|2224381021\|gb\|CP095390.1\|	1419050	g80125	i0	87.5	1.48101265822785	80	10	51	0	2	81	399201	399280	Natribaculum breve strain TRM20010 chromosome, complete genome	blastn	234	93.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natribaculum	Natribaculum breve
20457860	20457860	PRJEB39269_P_NODE_38077_length_223_cov_1.483696_g37672_i0	PRJEB39269	38077	223	1.483696	3.30864208	Methanothrix sp.	90426	Archaea	Archaea	407	3.67e-109	NTclustered	gi\|2626216449\|emb\|OY821645.1\|	90426	g37672	i0	99.552	55.3408071748879	223	1	100	0	1	223	824871	825093	MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1	blastn	12341	407	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
22666115	22666115	PRJEB39269_P_NODE_48278_length_197_cov_2.335443_g47873_i0	PRJEB39269	48278	197	2.335443	4.60082271	Archaea	2157	Archaea	Archaea	364	1.929999999999999e-96	NTclustered	gi\|955471768\|gb\|FJ968093.2\|	29281	g47873	i0	100	100	197	0	100	0	1	197	367	563	Uncultured crenarchaeote clone Arch_AE_D06 16S ribosomal RNA (rrnA) gene, partial sequence	blastn	19700	364	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
23941568	23941568	PRJEB39269_P_NODE_66419_length_170_cov_3.618321_g66014_i0	PRJEB39269	66419	170	3.618321	6.1511457	Halobacterium	2239	Archaea	Archaea	119	1.3800000000000001e-22	NTclustered	gi\|573484043\|gb\|CP007060.1\|	751944	g66014	i0	94.737	0.894117647058824	76	4	45	0	1	76	2141689	2141614	Halobacterium sp. DL1, complete genome	blastn	152	119	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium sp. DL1
26716401	26716401	PRJEB39269_P_NODE_55501_length_185_cov_0.787671_g55096_i0	PRJEB39269	55501	185	0.787671	1.45719135	Methanosarcinales archaeon	2250255	Archaea	Archaea	42.7	0.0174	NR	RLG35020.1	2250255	g55096	i0	39.6	0.778378378378378	48	28	76.2	1	45	185	512	559	RLG35020.1 MAG: hypothetical protein DRN98_01860 [Methanosarcinales archaeon]	diamond	144	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
26969936	26969936	PRJEB39269_P_NODE_70942_length_167_cov_1.281250_g70537_i0	PRJEB39269	70942	167	1.28125	2.1396875	Methanomicrobiales archaeon	2184052	Archaea	Archaea	42	0.0254	NR	HVP25139.1	2184052	g70537	i0	40	0.808383233532934	45	27	80.8	0	159	25	694	738	HVP25139.1 PQQ-dependent sugar dehydrogenase [Methanomicrobiales archaeon]	diamond	135	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
27159490	27159490	PRJEB39269_P_NODE_80622_length_158_cov_2.579832_g80217_i0	PRJEB39269	80622	158	2.579832	4.07613456	Haloferacaceae archaeon	2080321	Archaea	Archaea	55.1	3.56e-8	NR	MFB6154539.1	2080321	g80217	i0	100	0.512658227848101	27	0	51.3	0	81	1	2	28	MFB6154539.1 chorismate mutase [Haloferacaceae archaeon]	diamond	81	55.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae		Haloferacaceae archaeon
27728729	27728729	PRJEB39269_P_NODE_75984_length_162_cov_1.219512_g75579_i0	PRJEB39269	75984	162	1.219512	1.97560944	archaeon	1906665	Archaea	Archaea	85.1	5.53e-18	NR	RYH04926.1	1906665	g75579	i0	77.4	1.96296296296296	53	12	98.1	0	161	3	42	94	RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon]	diamond	318	85.1	1	Archaea								archaeon
28391386	28391386	PRJEB39269_P_NODE_78426_length_159_cov_5.916667_g78021_i0	PRJEB39269	78426	159	5.916667	9.40750053	Candidatus Nanohalobium sp.	3101483	Archaea	Archaea	51.6	8.47e-6	NR	MFB6158317.1	3101483	g78021	i0	85.2	0.509433962264151	27	4	50.9	0	77	157	92	118	MFB6158317.1 RNA 3'-terminal phosphate cyclase [Candidatus Nanohalobium sp.]	diamond	81	51.6	1	Archaea		Nanobdellati	Candidatus Nanohalarchaeota	Candidatus Nanohalobia	Candidatus Nanohalobiales	Candidatus Nanohalobiaceae	Candidatus Nanohalobium	Candidatus Nanohalobium sp.
29401765	29401765	PRJEB39269_P_NODE_83169_length_156_cov_2.435897_g82764_i0	PRJEB39269	83169	156	2.435897	3.79999932	Salinirubrum litoreum	1126234	Archaea	Archaea	51.6	7.85e-6	NR	WP_227230988.1	1126234	g82764	i0	78.6	0.538461538461538	28	6	53.8	0	85	2	56	83	WP_227230988.1 ABC transporter permease [Salinirubrum litoreum]	diamond	84	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Salinirubrum	Salinirubrum litoreum
29843813	29843813	PRJEB39269_P_NODE_21731_length_301_cov_0.938931_g21326_i0	PRJEB39269	21731	301	0.938931	2.82618231	archaeon	1906665	Archaea	Archaea	153	2.56e-46	NR	RYH28873.1	1906665	g21326	i0	79.5	0.877076411960133	88	18	87.7	0	294	31	1	88	RYH28873.1 MAG: hypothetical protein EON65_10550 [archaeon]	diamond	264	153	1	Archaea								archaeon
29970145	29970145	PRJEB39269_P_NODE_91511_length_150_cov_1.396396_g91106_i0	PRJEB39269	91511	150	1.396396	2.094594	Natronorubrum daqingense	588898	Archaea	Archaea	50.8	7.26e-6	NR	WP_076584130.1	588898	g91106	i0	52.2	1.7	46	22	92	0	150	13	113	158	WP_076584130.1 hypothetical protein [Natronorubrum daqingense]	diamond	255	50.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum daqingense
30216196	30216196	PRJEB39269_P_NODE_67352_length_170_cov_2.595420_g66947_i0	PRJEB39269	67352	170	2.59542	4.412214	Natrialbaceae	1644061	Archaea	Archaea	48.9	9.15e-5	NR	WP_228442368.1	2044521	g66947	i0	84.6	1.81764705882353	26	4	45.9	0	92	169	349	374	WP_228442368.1 MFS transporter [Natrarchaeobaculum sulfurireducens]	diamond	309	48.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrarchaeobaculum	Natrarchaeobaculum sulfurireducens
30791621	30791621	PRJEB39269_P_NODE_90674_length_150_cov_3.468468_g90269_i0	PRJEB39269	90674	150	3.468468	5.202702	Halobacteriales archaeon SW_9_67_25	1919210	Archaea	Archaea	105	8.45e-25	NR	PSQ58695.1	1919210	g90269	i0	90	3	50	5	100	0	1	150	292	341	PSQ58695.1 MAG: molybdopterin-binding oxidoreductase [Halobacteriales archaeon SW_9_67_25]	diamond	450	105	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon SW_9_67_25
31360675	31360675	PRJEB39269_P_NODE_88376_length_152_cov_1.619469_g87971_i0	PRJEB39269	88376	152	1.619469	2.46159288	Natronomonas sp.	2184060	Archaea	Archaea	73.6	6.34e-14	NR	WP_410321558.1	2184060	g87971	i0	80.5	2.42763157894737	41	8	80.9	0	1	123	64	104	WP_410321558.1 alpha/beta fold hydrolase [Natronomonas sp.]	diamond	369	73.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp.
31487263	31487263	PRJEB39269_P_NODE_46196_length_202_cov_1.006135_g45791_i0	PRJEB39269	46196	202	1.006135	2.0323927	archaeon	1906665	Archaea	Archaea	114	1.05e-29	NR	RYH25290.1	1906665	g45791	i0	93	0.846534653465347	57	4	84.7	0	200	30	34	90	RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon]	diamond	171	114	1	Archaea								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);;