metadata: contig_metadata: 22 rows where bioproject = "PRJNA376117" and tax

22 rows where bioproject = "PRJNA376117" 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
2950620	2950620	PRJNA376117_P_NODE_36483_length_249_cov_0.875000_g36181_i0	PRJNA376117	36483	249	0.875	2.17875	archaeon	1906665	Archaea	Archaea	109	1.48e-25	NR	MDP2439644.1	1906665	g36181	i0	64.3	1.01204819277108	84	28	98.8	1	248	3	413	496	MDP2439644.1 hypothetical protein [archaeon]	diamond	252	109	1	Archaea								archaeon
8052922	8052922	PRJNA376117_P_NODE_15327_length_350_cov_1.667870_g15025_i0	PRJNA376117	15327	350	1.66787	5.837545	archaeon	1906665	Archaea	Archaea	181	1.4299999999999996e-52	NR	MDP2436838.1	1906665	g15025	i0	69.8	5.96571428571429	116	35	99.4	0	349	2	72	187	MDP2436838.1 inorganic diphosphatase [archaeon]	diamond	2088	181	1	Archaea								archaeon
13153729	13153729	PRJNA376117_P_NODE_34851_length_250_cov_0.870056_g34549_i0	PRJNA376117	34851	250	0.870056	2.17514	Natronomonas halophila	2747817	Archaea	Archaea	449	6.87e-122	NTclustered	gi\|1865516082\|gb\|CP058334.1\|	2747817	g34549	i0	99.197	2.284	249	2	99	0	2	250	978647	978399	Natronomonas halophila strain C90 chromosome, complete genome	blastn	571	449	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas halophila
15702537	15702537	PRJNA376117_P_NODE_23433_length_288_cov_1.293023_g23131_i0	PRJNA376117	23433	288	1.293023	3.72390624	archaeon	1906665	Archaea	Archaea	167	3.69e-50	NR	MCQ2821492.1	1906665	g23131	i0	87.6	5.5625	89	11	92.7	0	13	279	1	89	MCQ2821492.1 50S ribosomal protein L15e [archaeon]	diamond	1602	167	1	Archaea								archaeon
18925292	18925292	PRJNA376117_P_NODE_5255_length_593_cov_2.019231_g4960_i0	PRJNA376117	5255	593	2.019231	11.97403983	Thermococcus	2263	Archaea	Archaea	1020	0	NTclustered	gi\|189908859\|gb\|EU571472.1\|	342948	g4960	i0	100	14.2428330522766	552	0	93	0	33	584	555	4	Thermococcus onnurineus dITPase gene, complete cds	blastn	8446	1020	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus onnurineus
24025329	24025329	PRJNA376117_P_NODE_15639_length_347_cov_1.503650_g15337_i0	PRJNA376117	15639	347	1.50365	5.2176655	Promethearchaeia archaeon	3067280	Archaea	Archaea	160	5.649999999999999e-45	NR	HMF32030.1	3067280	g15337	i0	67	0.968299711815562	112	37	96.8	0	3	338	109	220	HMF32030.1 acetyl-CoA C-acyltransferase [Promethearchaeia archaeon]	diamond	336	160	1	Archaea		Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia archaeon
27154765	27154765	PRJNA376117_P_NODE_14262_length_363_cov_0.989655_g13960_i0	PRJNA376117	14262	363	0.989655	3.59244765	Archaea	2157	Archaea	Archaea	168	1.69e-49	NR	MBD3185947.1	2026714	g13960	i0	62	4	121	46	100	0	363	1	125	245	MBD3185947.1 acetyl-CoA C-acyltransferase [Candidatus Bathyarchaeota archaeon]	diamond	1452	168	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
27201120	27201120	PRJNA376117_P_NODE_42602_length_243_cov_0.905882_g42300_i0	PRJNA376117	42602	243	0.905882	2.20129326	Nitrososphaerota archaeon	2026795	Archaea	Archaea	58.2	1.11e-7	NR	RZD32614.1	2026795	g42300	i0	42.4	0.814814814814815	66	34	81.5	2	6	203	68	129	RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon]	diamond	198	58.2	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
27454316	27454316	PRJNA376117_P_NODE_23183_length_289_cov_1.138889_g22881_i0	PRJNA376117	23183	289	1.138889	3.29138921	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	52.4	2.36e-5	NR	MBI2135937.1	2026803	g22881	i0	33.9	1.16262975778547	59	39	61.2	0	216	40	1	59	MBI2135937.1 transcription initiation factor IIB [Candidatus Woesearchaeota archaeon]	diamond	336	52.4	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
27643767	27643767	PRJNA376117_P_NODE_37024_length_248_cov_0.880000_g36722_i0	PRJNA376117	37024	248	0.88	2.1824	archaeon	1906665	Archaea	Archaea	50.4	6.88e-5	NR	MDP2437918.1	1906665	g36722	i0	32.9	0.883064516129032	73	42	88.3	1	10	228	224	289	MDP2437918.1 eukaryotic translation initiation factor 3 subunit F [archaeon]	diamond	219	50.4	1	Archaea								archaeon
27927738	27927738	PRJNA376117_P_NODE_37025_length_248_cov_0.880000_g36723_i0	PRJNA376117	37025	248	0.88	2.1824	Methanosphaera sp.	2666342	Archaea	Archaea	101	6.29e-23	NR	MEE3419334.1	2666342	g36723	i0	74.7	0.955645161290323	79	18	95.6	1	244	8	154	230	MEE3419334.1 hypothetical protein [Methanosphaera sp.]	diamond	237	101	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
28085488	28085488	PRJNA376117_P_NODE_14165_length_364_cov_1.058419_g13863_i0	PRJNA376117	14165	364	1.058419	3.85264516	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	43.9	0.0069	NR	MCK5615262.1	2026773	g13863	i0	35.3	0.700549450549451	85	45	70.1	3	53	307	2	76	MCK5615262.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	255	43.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
28386798	28386798	PRJNA376117_P_NODE_33286_length_252_cov_1.720670_g32984_i0	PRJNA376117	33286	252	1.72067	4.3360884	root	1	Root_unresolved	Root_unresolved	49.7	9.78e-5	NR	WP_080510819.1	416585	g32984	i0	47.7	3.3452380952381	44	23	52.4	0	188	57	129	172	WP_080510819.1 protein kinase domain-containing protein [Halorubrum californiense]	diamond	843	49.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum californiense
29253583	29253583	PRJNA376117_P_NODE_27189_length_275_cov_1.524752_g26887_i0	PRJNA376117	27189	275	1.524752	4.193068	Methanosphaera sp. rholeuAM27	2666342	Archaea	Archaea	47.4	0.00127	NR	RAP51212.1	1945577	g26887	i0	52.3	1.24363636363636	44	20	46.9	1	3	131	60	103	RAP51212.1 MAG: hypothetical protein BZ138_05740 [Methanosphaera sp. rholeuAM270]	diamond	342	47.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. rholeuAM270
30801483	30801483	PRJNA376117_P_NODE_8374_length_463_cov_3.071795_g8072_i0	PRJNA376117	8374	463	3.071795	14.22241085	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	125	4.73e-31	NR	MCY3413445.1	2026747	g8072	i0	43.8	0.991360691144708	153	81	99.1	2	461	3	127	274	MCY3413445.1 VWA domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	459	125	1	Archaea		Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
30959635	30959635	PRJNA376117_P_NODE_28894_length_269_cov_1.301020_g28592_i0	PRJNA376117	28894	269	1.30102	3.4997438	archaeon	1906665	Archaea	Archaea	157	1.42e-45	NR	RYH15647.1	1906665	g28592	i0	79.5	1.95167286245353	88	18	98.1	0	265	2	131	218	RYH15647.1 MAG: hypothetical protein EON65_31420 [archaeon]	diamond	525	157	1	Archaea								archaeon
31749871	31749871	PRJNA376117_P_NODE_33057_length_253_cov_1.711111_g32755_i0	PRJNA376117	33057	253	1.711111	4.32911083	Nanobdellota archaeon	2026764	Archaea	Archaea	52	7.51e-6	NR	MEK6940883.1	2026764	g32755	i0	42.6	1.89723320158103	54	29	61.7	2	1	156	83	136	MEK6940883.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	480	52	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
31908175	31908175	PRJNA376117_P_NODE_17757_length_328_cov_1.184314_g17455_i0	PRJNA376117	17757	328	1.184314	3.88454992	archaeon	1906665	Archaea	Archaea	46.2	0.00596	NR	MDP2437542.1	1906665	g17455	i0	33.3	1.01524390243902	111	57	93.3	5	328	23	416	518	MDP2437542.1 hypothetical protein [archaeon]	diamond	333	46.2	1	Archaea								archaeon
32003156	32003156	PRJNA376117_P_NODE_32638_length_255_cov_1.269231_g32336_i0	PRJNA376117	32638	255	1.269231	3.23653905	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	61.6	8.62e-9	NR	MCJ7637429.1	2169593	g32336	i0	40.7	2.74117647058824	81	44	95.3	1	6	248	159	235	MCJ7637429.1 site-specific DNA-methyltransferase [Nitrososphaeraceae archaeon]	diamond	699	61.6	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32477931	32477931	PRJNA376117_P_NODE_36659_length_248_cov_2.331429_g36357_i0	PRJNA376117	36659	248	2.331429	5.78194392	archaeon	1906665	Archaea	Archaea	65.1	5.25e-10	NR	MDP2436352.1	1906665	g36357	i0	44.9	0.834677419354839	69	38	83.5	0	211	5	5	73	MDP2436352.1 Rho GTPase-activating protein [archaeon]	diamond	207	65.1	1	Archaea								archaeon
32495003	32495003	PRJNA376117_P_NODE_10719_length_411_cov_1.366864_g10417_i0	PRJNA376117	10719	411	1.366864	5.61781104	Promethearchaeum	3366645	Archaea	Archaea	197	1.11e-58	NR	OLS14603.1	1849166	g10417	i0	68.4	5.95620437956204	136	43	99.3	0	410	3	270	405	OLS14603.1 MAG: acetyl-CoA acetyltransferase [Promethearchaeota archaeon CR_4]	diamond	2448	197	1	Archaea		Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon CR_4
32604126	32604126	PRJNA376117_P_NODE_27440_length_274_cov_1.532338_g27138_i0	PRJNA376117	27440	274	1.532338	4.19860612	archaeon	1906665	Archaea	Archaea	61.6	1.44e-9	NR	RYG64736.1	1906665	g27138	i0	37.8	0.985401459854015	90	54	98.5	1	1	270	51	138	RYG64736.1 MAG: hypothetical protein EON64_13380, partial [archaeon]	diamond	270	61.6	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);;