metadata: contig_metadata: 25 rows where bioproject = "PRJNA312107" and tax

25 rows where bioproject = "PRJNA312107" 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
6755221	6755221	PRJNA312107_P_NODE_16166_length_182_cov_1.406015_g16000_i0	PRJNA312107	16166	182	1.406015	2.5589473	Nanobdellati	1783276	Archaea	Archaea	115	5.47e-28	NR	MEM4239643.1	2026803	g16000	i0	86.7	6.90659340659341	60	8	98.9	0	180	1	56	115	MEM4239643.1 valine--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	1257	115	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
9305620	9305620	PRJNA312107_P_NODE_19608_length_168_cov_0.873950_g19442_i0	PRJNA312107	19608	168	0.87395	1.468236	Natrinema versiforme	88724	Archaea	Archaea	52.8	0.014	NTclustered	gi\|1657691899\|gb\|CP040330.1\|	88724	g19442	i0	100	0.166666666666667	28	0	17	0	119	146	2253550	2253523	Natrinema versiforme strain BOL5-4 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema versiforme
26725660	26725660	PRJNA312107_P_NODE_23581_length_164_cov_0.904348_g23415_i0	PRJNA312107	23581	164	0.904348	1.48313072	Promethearchaeota archaeon	2053489	Archaea	Archaea	56.2	1.68e-7	NR	TXT66111.1	2053489	g23415	i0	71.8	0.713414634146341	39	11	71.3	0	119	3	146	184	TXT66111.1 MAG: hypothetical protein BAJALOKI3v1_50111 [Promethearchaeota archaeon]	diamond	117	56.2	1	Archaea		Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
27010882	27010882	PRJNA312107_P_NODE_18542_length_169_cov_1.300000_g18376_i0	PRJNA312107	18542	169	1.3	2.197	Methanobacteriota archaeon	2026739	Archaea	Archaea	74.3	3.25e-14	NR	MAF88893.1	2026739	g18376	i0	58.2	0.976331360946746	55	23	97.6	0	1	165	17	71	MAF88893.1 hypothetical protein [Methanobacteriota archaeon]	diamond	165	74.3	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27453705	27453705	PRJNA312107_P_NODE_22143_length_166_cov_0.888889_g21977_i0	PRJNA312107	22143	166	0.888889	1.47555574	Methanosarcina sp.	2213	Archaea	Archaea	53.9	1.35e-6	NR	HET8685954.1	2213	g21977	i0	80	1.08433734939759	30	6	54.2	0	6	95	279	308	HET8685954.1 Mu-like prophage major head subunit gpT family protein [Methanosarcina sp.]	diamond	180	53.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28007972	28007972	PRJNA312107_P_NODE_19565_length_168_cov_0.873950_g19399_i0	PRJNA312107	19565	168	0.87395	1.468236	Archaea	2157	Archaea	Archaea	70.9	1.6e-12	NR	MBI3639254.1	2026795	g19399	i0	61.5	1.85714285714286	52	20	92.9	0	160	5	753	804	MBI3639254.1 SBBP repeat-containing protein [Nitrososphaerota archaeon]	diamond	312	71.2	0.995786516853933	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28053295	28053295	PRJNA312107_P_NODE_20985_length_167_cov_0.881356_g20819_i0	PRJNA312107	20985	167	0.881356	1.47186452	Promethearchaeati archaeon	2591838	Archaea	Archaea	52	7.24e-6	NR	NHJ40456.1	2591838	g20819	i0	57.1	0.880239520958084	49	17	88	1	149	3	621	665	NHJ40456.1 hypothetical protein [Promethearchaeati archaeon]	diamond	147	52	1	Archaea		Promethearchaeati						Promethearchaeati archaeon
28337577	28337577	PRJNA312107_P_NODE_17866_length_172_cov_1.691057_g17700_i0	PRJNA312107	17866	172	1.691057	2.90861804	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.7	0.0138	NR	HEV2429800.1	1906666	g17700	i0	43.2	0.645348837209302	37	21	64.5	0	167	57	43	79	HEV2429800.1 DNA methyltransferase [Thermoplasmata archaeon]	diamond	111	42.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28495564	28495564	PRJNA312107_P_NODE_24367_length_163_cov_1.570175_g24201_i0	PRJNA312107	24367	163	1.570175	2.55938525	Methanosarcina sp.	2213	Archaea	Archaea	67	3.33e-11	NR	HET8685110.1	2213	g24201	i0	75	1.91411042944785	52	13	95.7	0	161	6	345	396	HET8685110.1 hypothetical protein [Methanosarcina sp.]	diamond	312	67	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28590318	28590318	PRJNA312107_P_NODE_18327_length_170_cov_1.462810_g18161_i0	PRJNA312107	18327	170	1.46281	2.486777	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	48.5	1.15e-4	NR	TRO51923.1	2026714	g18161	i0	48.1	0.917647058823529	52	26	90	1	18	170	104	155	TRO51923.1 hypothetical protein E2P63_04395 [Candidatus Bathyarchaeota archaeon]	diamond	156	48.5	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
28874234	28874234	PRJNA312107_P_NODE_23868_length_164_cov_0.904348_g23702_i0	PRJNA312107	23868	164	0.904348	1.48313072	uncultured archaeon	115547	Archaea	Archaea	42.7	0.00991	NR	VVB57606.1	115547	g23702	i0	40.4	1.04268292682927	57	30	98.8	2	2	163	65	120	VVB57606.1 Uncharacterised protein [uncultured archaeon]	diamond	171	42.7	1	Archaea								uncultured archaeon
28923338	28923338	PRJNA312107_P_NODE_21088_length_167_cov_0.881356_g20922_i0	PRJNA312107	21088	167	0.881356	1.47186452	root	1	Root_unresolved	Root_unresolved	45.1	0.00206	NR	MFP4567654.1	2026803	g20922	i0	38.5	1.92215568862275	52	32	93.4	0	157	2	843	894	MFP4567654.1 uridine diphosphate-N-acetylglucosamine-binding protein YvcK [Candidatus Woesearchaeota archaeon]	diamond	321	45.1	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
28937564	28937564	PRJNA312107_P_NODE_24508_length_163_cov_0.912281_g24342_i0	PRJNA312107	24508	163	0.912281	1.48701803	archaeon	1906665	Archaea	Archaea	79	3.27e-17	NR	NCQ51864.1	1906665	g24342	i0	59.3	0.993865030674847	54	22	99.4	0	163	2	46	99	NCQ51864.1 hypothetical protein [archaeon]	diamond	162	79	1	Archaea								archaeon
29252948	29252948	PRJNA312107_P_NODE_21289_length_166_cov_1.777778_g21123_i0	PRJNA312107	21289	166	1.777778	2.95111148	Nitrosopumilus sp.	2024843	Archaea	Archaea	77.4	6.68e-15	NR	MEK0324821.1	2024843	g21123	i0	63.6	2.98192771084337	55	20	99.4	0	2	166	131	185	MEK0324821.1 hypothetical protein [Nitrosopumilus sp.]	diamond	495	77.4	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
29316338	29316338	PRJNA312107_P_NODE_22729_length_165_cov_0.896552_g22563_i0	PRJNA312107	22729	165	0.896552	1.4793108	archaeon	1906665	Archaea	Archaea	43.9	0.0048	NR	RYG94396.1	1906665	g22563	i0	43.5	0.836363636363636	46	26	83.6	0	3	140	163	208	RYG94396.1 MAG: hypothetical protein EON65_57560, partial [archaeon]	diamond	138	43.9	1	Archaea								archaeon
29821268	29821268	PRJNA312107_P_NODE_14671_length_191_cov_0.760563_g14505_i0	PRJNA312107	14671	191	0.760563	1.45267533	Haloarchaeobius amylolyticus	1198296	Archaea	Archaea	42.7	0.0186	NR	WP_267639183.1	1198296	g14505	i0	54.1	0.581151832460733	37	17	58.1	0	7	117	342	378	WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus]	diamond	111	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Haloarchaeobius	Haloarchaeobius amylolyticus
30485054	30485054	PRJNA312107_P_NODE_25933_length_162_cov_0.920354_g25767_i0	PRJNA312107	25933	162	0.920354	1.49097348	Nanobdellota archaeon	2026764	Archaea	Archaea	91.3	9.94e-20	NR	MEK6893559.1	2026764	g25767	i0	81.1	2.94444444444444	53	10	98.1	0	1	159	398	450	MEK6893559.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	477	91.3	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
30755385	30755385	PRJNA312107_P_NODE_21774_length_166_cov_0.888889_g21608_i0	PRJNA312107	21774	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	89	6.39e-19	NR	VVB52914.1	115547	g21608	i0	73.6	3.83132530120482	53	14	95.8	0	161	3	227	279	VVB52914.1 Vitamin B12-dependent ribonucleoside-diphosphate reductase [uncultured archaeon]	diamond	636	89	1	Archaea								uncultured archaeon
30769429	30769429	PRJNA312107_P_NODE_18634_length_169_cov_0.866667_g18468_i0	PRJNA312107	18634	169	0.866667	1.46466723	Candidatus Nitrosotenuis sp.	2507556	Archaea	Archaea	52	6.84e-6	NR	MEM3077620.1	2507556	g18468	i0	46.3	0.958579881656805	54	29	95.9	0	164	3	24	77	MEM3077620.1 hypothetical protein [Candidatus Nitrosotenuis sp.]	diamond	162	52	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp.
31654322	31654322	PRJNA312107_P_NODE_24657_length_163_cov_0.912281_g24491_i0	PRJNA312107	24657	163	0.912281	1.48701803	Thermoplasmata archaeon	1906666	Archaea	Archaea	75.1	4.84e-14	NR	MEA3198869.1	1906666	g24491	i0	64.2	0.975460122699387	53	19	97.5	0	4	162	272	324	MEA3198869.1 inorganic phosphate transporter, PiT family [Thermoplasmata archaeon]	diamond	159	75.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31686000	31686000	PRJNA312107_P_NODE_26217_length_162_cov_0.920354_g26051_i0	PRJNA312107	26217	162	0.920354	1.49097348	archaeon	1906665	Archaea	Archaea	90.1	8.83e-21	NR	RYG94702.1	1906665	g26051	i0	77.4	1.96296296296296	53	12	98.1	0	3	161	111	163	RYG94702.1 MAG: Mob1/phocein family protein [archaeon]	diamond	318	90.1	1	Archaea								archaeon
31956663	31956663	PRJNA312107_P_NODE_20877_length_167_cov_0.881356_g20711_i0	PRJNA312107	20877	167	0.881356	1.47186452	root	1	Root_unresolved	Root_unresolved	45.8	0.00107	NR	MBU0959566.1	2026764	g20711	i0	42	1.8502994011976	50	27	89.8	1	160	11	196	243	MBU0959566.1 HTH domain-containing protein [Nanoarchaeota archaeon]	diamond	309	45.8	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
32477268	32477268	PRJNA312107_P_NODE_5619_length_299_cov_1.060000_g5453_i0	PRJNA312107	5619	299	1.06	3.1694	Halobacterium hubeiense	1407499	Archaea	Archaea	43.1	0.0458	NR	WP_143416443.1	1407499	g5453	i0	30.4	0.692307692307692	69	46	67.2	1	18	218	112	180	WP_143416443.1 hypothetical protein [Halobacterium hubeiense]	diamond	207	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium hubeiense
32823925	32823925	PRJNA312107_P_NODE_20900_length_167_cov_0.881356_g20734_i0	PRJNA312107	20900	167	0.881356	1.47186452	Methanobacteriota archaeon	2026739	Archaea	Archaea	47	4.26e-4	NR	NDB94291.1	2026739	g20734	i0	44.7	1.76047904191617	47	26	84.4	0	164	24	380	426	NDB94291.1 hypothetical protein [Methanobacteriota archaeon]	diamond	294	47	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32823926	32823926	PRJNA312107_P_NODE_22060_length_166_cov_0.888889_g21894_i0	PRJNA312107	22060	166	0.888889	1.47555574	Nanobdellota archaeon	2026764	Archaea	Archaea	48.1	1.63e-4	NR	MFH1400334.1	2026764	g21894	i0	41.8	0.993975903614458	55	28	99.4	1	166	2	14	64	MFH1400334.1 ribose-phosphate diphosphokinase [Nanoarchaeota archaeon]	diamond	165	48.1	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota 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);;