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

21 rows where bioproject = "PRJNA716463" 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
3744342	3744342	PRJNA716463_P_NODE_111263_length_241_cov_4.428571_g110845_i0	PRJNA716463	111263	241	4.428571	10.67285611	Halobacteriales	2235	Archaea	Archaea	80.5	9.95e-11	NTclustered	gi\|2087953847\|gb\|CP081958.1\|	1017351	g110845	i0	84.81	18.2697095435685	79	12	33	0	1	79	2091181	2091259	Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome	blastn	4403	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum magnesiiphilum
5021103	5021103	PRJNA716463_P_NODE_21604_length_310_cov_3.430380_g21187_i0	PRJNA716463	21604	310	3.43038	10.634178	root	1	Root_unresolved	Root_unresolved	278	4.39e-70	NTclustered	gi\|27227784\|emb\|AJ535122.1\|	29281	g21187	i0	100	90.6903225806452	150	0	97	0	1	150	842	693	Uncultured crenarchaeote partial 16S rRNA gene, clone Gitt-GR-74	blastn	28114	278	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
11396414	11396414	PRJNA716463_P_NODE_29729_length_310_cov_2.489451_g29312_i0	PRJNA716463	29729	310	2.489451	7.7172981	root	1	Root_unresolved	Root_unresolved	568	2.3299999999999995e-157	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g29312	i0	99.677	99.8193548387097	310	1	100	0	1	310	39787	40096	Uncultured crenarchaeote genomic fragment 54d9	blastn	30944	573	0.991273996509599	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
12187081	12187081	PRJNA716463_P_NODE_30210_length_310_cov_2.274262_g29793_i0	PRJNA716463	30210	310	2.274262	7.0502122	Halopiger xanaduensis	387343	Archaea	Archaea	58.4	6.22e-4	NTclustered	gi\|335336085\|gb\|CP002839.1\|	797210	g29793	i0	94.737	0.22258064516129	38	1	12	1	259	295	2408386	2408349	Halopiger xanaduensis SH-6, complete genome	blastn	69	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halopiger	Halopiger xanaduensis
17286710	17286710	PRJNA716463_P_NODE_88074_length_262_cov_1.629630_g87657_i0	PRJNA716463	88074	262	1.62963	4.2696306	archaeon	1906665	Archaea	Archaea	150	5.76e-43	NR	MDP2434791.1	1906665	g87657	i0	83.9	7.95801526717557	87	14	99.6	0	261	1	151	237	MDP2434791.1 NSA2 family ribosome biogenesis protein [archaeon]	diamond	2085	150	1	Archaea								archaeon
17286718	17286718	PRJNA716463_P_NODE_88634_length_261_cov_3.031915_g88217_i0	PRJNA716463	88634	261	3.031915	7.91329815	uncultured crenarchaeote	29281	Archaea	Archaea	444	3.36e-120	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g88217	i0	97.318	102.486590038314	261	7	100	0	1	261	42215	42475	Uncultured crenarchaeote genomic fragment 54d9	blastn	26749	444	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
18559298	18559298	PRJNA716463_P_NODE_121215_length_226_cov_3.588235_g120797_i0	PRJNA716463	121215	226	3.588235	8.1094111	uncultured marine thaumarchaeote AD1000_100_C06	1455887	Archaea	Archaea	418	1.7199999999999998e-112	NTclustered	gi\|663500052\|gb\|KF900324.1\|	1455887	g120797	i0	100	1	226	0	100	0	1	226	35173	35398	Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence	blastn	226	418	1	Archaea		Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote AD1000_100_C06
21110993	21110993	PRJNA716463_P_NODE_71177_length_275_cov_2.693069_g70760_i0	PRJNA716463	71177	275	2.693069	7.40593975	Nitrososphaeria archaeon	2268198	Archaea	Archaea	178	3.419999999999999e-54	NR	NDB47524.1	2268198	g70760	i0	94.5	0.992727272727273	91	5	99.3	0	273	1	71	161	NDB47524.1 ABC transporter ATP-binding protein [Nitrososphaeria archaeon]	diamond	273	178	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
27241597	27241597	PRJNA716463_P_NODE_94263_length_256_cov_3.469945_g93846_i0	PRJNA716463	94263	256	3.469945	8.8830592	archaeon	1906665	Archaea	Archaea	70.1	9.27e-12	NR	MCQ2817599.1	1906665	g93846	i0	44	0.984375	84	45	96.1	2	7	252	256	339	MCQ2817599.1 hypothetical protein [archaeon]	diamond	252	70.1	1	Archaea								archaeon
27715821	27715821	PRJNA716463_P_NODE_75004_length_272_cov_3.231156_g74587_i0	PRJNA716463	75004	272	3.231156	8.78874432	Methanothrix sp.	90426	Archaea	Archaea	55.5	1.73e-6	NR	TFH48370.1	90426	g74587	i0	43.1	0.716911764705882	65	35	71.7	1	260	66	88	150	TFH48370.1 MAG: hypothetical protein E4G89_06400 [Methanothrix sp.]	diamond	195	55.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
27810313	27810313	PRJNA716463_P_NODE_105104_length_247_cov_1.758621_g104687_i0	PRJNA716463	105104	247	1.758621	4.34379387	Thermofilaceae archaeon	2268203	Archaea	Archaea	184	9.02e-58	NR	MEM2592530.1	2268203	g104687	i0	98.8	0.995951417004049	82	1	99.6	0	246	1	39	120	MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon]	diamond	246	184	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae		Thermofilaceae archaeon
28504751	28504751	PRJNA716463_P_NODE_41247_length_298_cov_2.631111_g40830_i0	PRJNA716463	41247	298	2.631111	7.84071078	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	76.3	1.1e-13	NR	HKG87688.1	2169593	g40830	i0	68	2.50671140939597	50	16	50.3	0	293	144	357	406	HKG87688.1 PQQ-dependent sugar dehydrogenase [Nitrososphaeraceae archaeon]	diamond	747	76.3	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28788774	28788774	PRJNA716463_P_NODE_85107_length_264_cov_3.099476_g84690_i0	PRJNA716463	85107	264	3.099476	8.1826166400000009	Nitrosopumilales archaeon	2026768	Archaea	Archaea	169	5.58e-49	NR	RPJ31745.1	2026768	g84690	i0	100	0.988636363636364	87	0	98.9	0	263	3	216	302	RPJ31745.1 MAG: adenosylhomocysteinase [Nitrosopumilales archaeon]	diamond	261	169	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
29778118	29778118	PRJNA716463_P_NODE_42091_length_297_cov_3.191964_g41674_i0	PRJNA716463	42091	297	3.191964	9.48013308	root	1	Root_unresolved	Root_unresolved	59.3	9.35e-8	NR	WP_303346976.1	66852	g41674	i0	67.5	2.19191919191919	40	13	40.4	0	145	26	2	41	WP_303346976.1 DNA cytosine methyltransferase [Methanobrevibacter sp.]	diamond	651	59.7	0.993299832495812	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29862457	29862457	PRJNA716463_P_NODE_59031_length_284_cov_2.559242_g58614_i0	PRJNA716463	59031	284	2.559242	7.26824728	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	52	2.25e-6	NR	GIU69039.1	2026803	g58614	i0	57.6	0.887323943661972	33	14	34.9	0	105	7	29	61	GIU69039.1 MAG: hypothetical protein KatS3mg002_0275 [Candidatus Woesearchaeota archaeon]	diamond	252	52	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29925786	29925786	PRJNA716463_P_NODE_21231_length_310_cov_3.485232_g20814_i0	PRJNA716463	21231	310	3.485232	10.8042192	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	48.9	4.77e-4	NR	MBI3334363.1	2026773	g20814	i0	46.9	0.948387096774194	49	26	47.4	0	308	162	124	172	MBI3334363.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	294	48.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
30020595	30020595	PRJNA716463_P_NODE_54491_length_287_cov_3.341121_g54074_i0	PRJNA716463	54491	287	3.341121	9.58901727	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	66.2	3.12e-10	NR	MFH1064255.1	2026803	g54074	i0	35.6	0.940766550522648	90	54	93	2	272	6	186	272	MFH1064255.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	270	66.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
30841989	30841989	PRJNA716463_P_NODE_49314_length_291_cov_2.064220_g48897_i0	PRJNA716463	49314	291	2.06422	6.0068802	archaeon	1906665	Archaea	Archaea	97.8	3.0300000000000003e-21	NR	MCQ2815804.1	1906665	g48897	i0	52.3	0.88659793814433	86	36	83.5	2	288	46	126	211	MCQ2815804.1 50S ribosome-binding GTPase [archaeon]	diamond	258	97.8	1	Archaea								archaeon
30936824	30936824	PRJNA716463_P_NODE_46454_length_293_cov_3.118182_g46037_i0	PRJNA716463	46454	293	3.118182	9.13627326	archaeon	1906665	Archaea	Archaea	72	2.98e-12	NR	RYG98570.1	1906665	g46037	i0	60.4	0.491467576791809	48	19	49.1	0	5	148	330	377	RYG98570.1 MAG: hypothetical protein EON65_51280 [archaeon]	diamond	144	72	1	Archaea								archaeon
31379333	31379333	PRJNA716463_P_NODE_97656_length_253_cov_2.844444_g97239_i0	PRJNA716463	97656	253	2.844444	7.19644332	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	165	2.05e-45	NR	HEY9491973.1	2169593	g97239	i0	97.6	2.98814229249012	84	2	99.6	0	1	252	19	102	HEY9491973.1 GMC family oxidoreductase [Nitrososphaeraceae archaeon]	diamond	756	165	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32518381	32518381	PRJNA716463_P_NODE_45339_length_294_cov_3.248869_g44922_i0	PRJNA716463	45339	294	3.248869	9.55167486	archaeon	1906665	Archaea	Archaea	145	1.42e-39	NR	RYH05051.1	1906665	g44922	i0	69.9	1.91836734693878	93	28	94.9	0	5	283	160	252	RYH05051.1 MAG: DUF3508 domain-containing protein, partial [archaeon]	diamond	564	145	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);;