metadata: contig_metadata: 19 rows where bioproject = "PRJNA615175" and tax

19 rows where bioproject = "PRJNA615175" 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
8248393	8248393	PRJNA615175_P_NODE_8547_length_510_cov_2.466819_g8379_i0	PRJNA615175	8547	510	2.466819	12.5807769	uncultured archaeon	115547	Archaea	Archaea	859	0	NTclustered	gi\|388254672\|gb\|JQ768092.1\|	115547	g8379	i0	97.059	62.0039215686275	510	15	100	0	1	510	29208	29717	Uncultured archaeon clone 02j05, complete sequence	blastn	31622	859	1	Archaea								uncultured archaeon
13349064	13349064	PRJNA615175_P_NODE_21471_length_298_cov_1.368889_g21303_i0	PRJNA615175	21471	298	1.368889	4.07928922	Halalkalicoccus jeotgali	413810	Archaea	Archaea	398	3.0899999999999995e-106	NTclustered	gi\|299126090\|gb\|CP002063.1\|	795797	g21303	i0	91.379	0.973154362416107	290	25	97	0	1	290	66675	66386	Halalkalicoccus jeotgali B3 plasmid 1, complete sequence	blastn	290	398	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
19001188	19001188	PRJNA615175_P_NODE_10595_length_449_cov_2.109043_g10427_i0	PRJNA615175	10595	449	2.109043	9.46960307	Halobellus	1073986	Archaea	Archaea	135	4.2e-34	NR	WP_049986121.1	1448860	g10427	i0	50.7	2.96659242761693	148	69	98.9	3	6	449	361	504	WP_049986121.1 GMC family oxidoreductase [Halobellus rufus]	diamond	1332	135	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus rufus
24101620	24101620	PRJNA615175_P_NODE_20779_length_304_cov_1.264069_g20611_i0	PRJNA615175	20779	304	1.264069	3.84276976	Methanobrevibacter	2172	Archaea	Archaea	551	2.289999999999999e-152	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g20611	i0	99.342	136.411184210526	304	2	100	0	1	304	542581	542278	Methanobrevibacter millerae strain SM9, complete genome	blastn	41469	551	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
25376118	25376118	PRJNA615175_P_NODE_10280_length_457_cov_2.497396_g10112_i0	PRJNA615175	10280	457	2.497396	11.41309972	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	822	0	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g10112	i0	99.125	99.0065645514223	457	4	100	0	1	457	850189	850645	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	45246	828	0.992753623188406	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
26763774	26763774	PRJNA615175_P_NODE_2821_length_923_cov_11.580000_g2688_i0	PRJNA615175	2821	923	11.58	106.8834	Nitrosopumilus sp.	2024843	Archaea	Archaea	105	2.5e-24	NR	MBA3285058.1	2024843	g2688	i0	76.5	0.221018418201517	68	16	22.1	0	64	267	27	94	MBA3285058.1 hypothetical protein [Nitrosopumilus sp.]	diamond	204	105	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
26763776	26763776	PRJNA615175_P_NODE_35821_length_237_cov_3.518293_g35653_i0	PRJNA615175	35821	237	3.518293	8.33835441	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	143	4.069999999999999e-41	NR	HYP43440.1	2109671	g35653	i0	100	4.48101265822785	71	0	89.9	0	235	23	63	133	HYP43440.1 deoxyhypusine synthase family protein [Candidatus Nitrosocosmicus sp.]	diamond	1062	143	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
27535751	27535751	PRJNA615175_P_NODE_26563_length_259_cov_2.935484_g26395_i0	PRJNA615175	26563	259	2.935484	7.60290356	root	1	Root_unresolved	Root_unresolved	105	1.06e-24	NR	HEU0143677.1	1971748	g26395	i0	56.6	1.92277992277992	83	36	96.1	0	250	2	19	101	HEU0143677.1 IS4 family transposase [Nitrososphaera sp.]	diamond	498	106	0.990566037735849	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
28059382	28059382	PRJNA615175_P_NODE_9965_length_465_cov_4.581633_g9797_i0	PRJNA615175	9965	465	4.581633	21.30459345	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	52	4.58e-5	NR	MFL2965254.1	2670411	g9797	i0	37.3	0.658064516129032	102	52	64.5	5	304	5	32	123	MFL2965254.1 glycine-rich domain-containing protein-like [Candidatus Thalassarchaeaceae archaeon]	diamond	306	52	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae		Candidatus Thalassarchaeaceae archaeon
28122594	28122594	PRJNA615175_P_NODE_25125_length_270_cov_2.324873_g24957_i0	PRJNA615175	25125	270	2.324873	6.2771571	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	94.4	3.69e-20	NR	WP_296886270.1	253161	g24957	i0	63.5	2.8	85	24	86.7	1	236	3	1	85	WP_296886270.1 C1 family peptidase, partial [uncultured Methanobrevibacter sp.]	diamond	756	94.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29101459	29101459	PRJNA615175_P_NODE_6148_length_615_cov_4.345018_g5983_i0	PRJNA615175	6148	615	4.345018	26.7218607	archaeon	1906665	Archaea	Archaea	50.1	5.6e-4	NR	NCP98466.1	1906665	g5983	i0	40.5	0.409756097560976	84	45	39.5	3	501	259	38	119	NCP98466.1 hypothetical protein [archaeon]	diamond	252	50.1	1	Archaea								archaeon
30124701	30124701	PRJNA615175_P_NODE_10032_length_463_cov_6.694872_g9864_i0	PRJNA615175	10032	463	6.694872	30.99725736	Candidatus Harpocratesius	3049169	Archaea	Archaea	206	2.22e-64	NR	MBD3214868.1	2053489	g9864	i0	68.9	8.81209503239741	148	45	95.9	1	462	19	85	231	MBD3214868.1 ribose 5-phosphate isomerase A [Promethearchaeota archaeon]	diamond	4080	206	1	Archaea		Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
30143136	30143136	PRJNA615175_P_NODE_2892_length_914_cov_18.868014_g2688_i1	PRJNA615175	2892	914	18.868014	172.45364796	Nitrosopumilus sp.	2024843	Archaea	Archaea	105	2.35e-24	NR	MBA3285058.1	2024843	g2688	i1	76.5	0.223194748358862	68	16	22.3	0	851	648	27	94	MBA3285058.1 hypothetical protein [Nitrosopumilus sp.]	diamond	204	105	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
30743835	30743835	PRJNA615175_P_NODE_1194_length_1335_cov_3.888273_g1104_i0	PRJNA615175	1194	1335	3.888273	51.90844455	Thermoplasmata archaeon	1906666	Archaea	Archaea	377	7.059999999999999e-124	NR	RLF41482.1	1906666	g1104	i0	44.2	4.72584269662921	419	218	91	4	1	1215	6	422	RLF41482.1 MAG: spermidine synthase [Thermoplasmata archaeon]	diamond	6309	377	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31154195	31154195	PRJNA615175_P_NODE_5675_length_642_cov_8.502636_g5510_i0	PRJNA615175	5675	642	8.502636	54.58692312	archaeon	1906665	Archaea	Archaea	78.6	2.84e-13	NR	MDP2437906.1	1906665	g5510	i0	35.5	0.710280373831776	152	68	71	3	641	186	198	319	MDP2437906.1 OSTA/TMEM184 family protein [archaeon]	diamond	456	78.6	1	Archaea								archaeon
31786910	31786910	PRJNA615175_P_NODE_2077_length_1061_cov_4.596154_g1962_i0	PRJNA615175	2077	1061	4.596154	48.76519394	Candidatus Helarchaeota archaeon	2719382	Archaea	Archaea	75.5	9.03e-11	NR	NVM30603.1	2719382	g1962	i0	24.1	0.808671065032988	286	200	77.2	6	928	110	446	727	NVM30603.1 elongation factor EF-2 [Candidatus Helarchaeota archaeon]	diamond	858	75.5	1	Archaea		Promethearchaeati	Candidatus Helarchaeota					Candidatus Helarchaeota archaeon
31786921	31786921	PRJNA615175_P_NODE_7277_length_560_cov_2.505133_g7112_i0	PRJNA615175	7277	560	2.505133	14.0287448	Candidatus Micrarchaeia archaeon	3018267	Archaea	Archaea	73.9	1.79e-13	NR	MEM3771991.1	3018267	g7112	i0	50.7	0.814285714285714	75	37	40.2	0	438	214	9	83	MEM3771991.1 hypothetical protein [Candidatus Micrarchaeia archaeon]	diamond	456	73.9	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia				Candidatus Micrarchaeia archaeon
31913621	31913621	PRJNA615175_P_NODE_14297_length_375_cov_3.105960_g14129_i0	PRJNA615175	14297	375	3.10596	11.64735	Thermofilaceae archaeon	2268203	Archaea	Archaea	95.5	1.49e-20	NR	MEM0307463.1	2268203	g14129	i0	38.6	8.312	132	65	94.4	2	20	373	77	206	MEM0307463.1 ribosome biogenesis/translation initiation ATPase RLI [Thermofilaceae archaeon]	diamond	3117	95.5	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae		Thermofilaceae archaeon
32053142	32053142	PRJNA615175_P_NODE_6498_length_597_cov_3.007634_g6333_i0	PRJNA615175	6498	597	3.007634	17.95557498	root	1	Root_unresolved	Root_unresolved	53.1	2.57e-4	NR	WP_292729902.1	90427	g6333	i0	39.7	3.49748743718593	78	38	38.2	3	351	124	312	382	WP_292729902.1 NosD domain-containing protein, partial [Methanoculleus sp.]	diamond	2088	53.5	0.992523364485981	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus 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);;