metadata: contig_metadata: 33 rows where bioproject = "PRJNA675331" and tax

33 rows where bioproject = "PRJNA675331" 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
647679	647679	PRJNA675331_P_NODE_20421_length_247_cov_0.885057_g20249_i0	PRJNA675331	20421	247	0.885057	2.18609079	archaeon	1906665	Archaea	Archaea	135	7.72e-38	NR	MDP2439237.1	1906665	g20249	i0	89	0.88663967611336	73	8	88.7	0	246	28	131	203	MDP2439237.1 50S ribosomal protein L15e [archaeon]	diamond	219	135	1	Archaea								archaeon
7026399	7026399	PRJNA675331_P_NODE_19286_length_249_cov_0.875000_g19114_i0	PRJNA675331	19286	249	0.875	2.17875	Archaea	2157	Archaea	Archaea	97.4	7.43e-22	NR	KAG2473838.1	2026768	g19114	i0	100	7.67469879518072	49	0	59	0	102	248	1	49	KAG2473838.1 MAG: Iron-sulfur cluster carrier protein [Nitrosopumilales archaeon]	diamond	1911	97.4	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
13401841	13401841	PRJNA675331_P_NODE_19531_length_249_cov_0.875000_g19359_i0	PRJNA675331	19531	249	0.875	2.17875	Stenosarchaea group	2290931	Archaea	Archaea	60.5	3.33e-9	NR	UCH01388.1	2026714	g19359	i0	36.1	2	83	49	100	1	1	249	34	112	UCH01388.1 MAG: ester cyclase [Candidatus Bathyarchaeota archaeon]	diamond	498	60.5	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
13401862	13401862	PRJNA675331_P_NODE_3431_length_505_cov_1.094907_g3261_i0	PRJNA675331	3431	505	1.094907	5.52928035	archaeon	1906665	Archaea	Archaea	201	7.52e-63	NR	MDP2437402.1	1906665	g3261	i0	82.3	0.837623762376238	141	23	83.8	1	83	505	18	156	MDP2437402.1 histone H2A family protein [archaeon]	diamond	423	201	1	Archaea								archaeon
16471300	16471300	PRJNA675331_P_NODE_15013_length_271_cov_1.373737_g14841_i0	PRJNA675331	15013	271	1.373737	3.72282727	archaeon	1906665	Archaea	Archaea	79	3.46e-16	NR	MDP2437401.1	1906665	g14841	i0	66.7	0.830258302583026	75	20	79.7	3	54	269	8	80	MDP2437401.1 NFYB/HAP3 family transcription factor subunit [archaeon]	diamond	225	79	1	Archaea								archaeon
21050306	21050306	PRJNA675331_P_NODE_23857_length_241_cov_0.916667_g23685_i0	PRJNA675331	23857	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	125	1.9099999999999998e-31	NR	MDP2437394.1	1906665	g23685	i0	80.8	0.908713692946058	73	14	90.9	0	21	239	19	91	MDP2437394.1 argininosuccinate lyase [archaeon]	diamond	219	125	1	Archaea								archaeon
25394913	25394913	PRJNA675331_P_NODE_10940_length_304_cov_1.000000_g10768_i0	PRJNA675331	10940	304	1	3.04	root	1	Root_unresolved	Root_unresolved	147	1.33e-40	NR	MBI2573596.1	2026803	g10768	i0	67	16.8157894736842	100	33	98.7	0	303	4	218	317	MBI2573596.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Candidatus Woesearchaeota archaeon]	diamond	5112	147	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
26765448	26765448	PRJNA675331_P_NODE_24101_length_241_cov_0.916667_g23929_i0	PRJNA675331	24101	241	0.916667	2.20916747	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.5	0.0172	NR	MDG6225782.1	2806419	g23929	i0	34.5	0.684647302904564	55	36	68.5	0	56	220	180	234	MDG6225782.1 metalloprotease family protein [Thermoplasmatota archaeon]	diamond	165	43.5	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
26923794	26923794	PRJNA675331_P_NODE_9922_length_316_cov_0.946502_g9750_i0	PRJNA675331	9922	316	0.946502	2.99094632	Geoglobus ahangari	113653	Archaea	Archaea	86.7	1.42e-17	NR	WP_048095167.1	113653	g9750	i0	42.9	0.996835443037975	105	57	99.7	2	315	1	45	146	WP_048095167.1 bis-aminopropyl spermidine synthase family protein [Geoglobus ahangari]	diamond	315	86.7	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae	Geoglobus	Geoglobus ahangari
27524300	27524300	PRJNA675331_P_NODE_19463_length_249_cov_0.875000_g19291_i0	PRJNA675331	19463	249	0.875	2.17875	archaeon	1906665	Archaea	Archaea	50.1	1.07e-4	NR	MDP2435171.1	1906665	g19291	i0	33.3	0.975903614457831	81	54	97.6	0	249	7	150	230	MDP2435171.1 hypothetical protein [archaeon]	diamond	243	50.1	1	Archaea								archaeon
27524303	27524303	PRJNA675331_P_NODE_23123_length_242_cov_2.414201_g22951_i0	PRJNA675331	23123	242	2.414201	5.84236642	Candidatus Pacearchaeota archaeon RBG_16_35_8	1801882	Archaea	Archaea	57	3.32e-7	NR	OGJ11970.1	1801882	g22951	i0	50.8	0.756198347107438	61	25	75.6	3	53	235	271	326	OGJ11970.1 MAG: hypothetical protein A3K62_02875 [Candidatus Pacearchaeota archaeon RBG_16_35_8]	diamond	183	57	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon RBG_16_35_8
27555647	27555647	PRJNA675331_P_NODE_21104_length_246_cov_0.890173_g20932_i0	PRJNA675331	21104	246	0.890173	2.18982558	archaeon	1906665	Archaea	Archaea	94.4	2.54e-20	NR	MDP2437916.1	1906665	g20932	i0	46.3	0.975609756097561	80	43	97.6	0	246	7	314	393	MDP2437916.1 hypothetical protein [archaeon]	diamond	240	94.4	1	Archaea								archaeon
27555653	27555653	PRJNA675331_P_NODE_8924_length_330_cov_0.894942_g8752_i0	PRJNA675331	8924	330	0.894942	2.9533086	archaeon	1906665	Archaea	Archaea	70.9	8.52e-13	NR	MDP2436403.1	1906665	g8752	i0	45	0.727272727272727	80	39	72.7	1	90	329	1	75	MDP2436403.1 hypothetical protein [archaeon]	diamond	240	70.9	1	Archaea								archaeon
27902973	27902973	PRJNA675331_P_NODE_13625_length_278_cov_1.204878_g13453_i0	PRJNA675331	13625	278	1.204878	3.34956084	archaeon	1906665	Archaea	Archaea	63.9	1.93e-9	NR	MDP2438356.1	1906665	g13453	i0	39.5	0.928057553956835	86	52	92.8	0	277	20	366	451	MDP2438356.1 hypothetical protein [archaeon]	diamond	258	63.9	1	Archaea								archaeon
27914848	27914848	PRJNA675331_P_NODE_24145_length_241_cov_0.916667_g23973_i0	PRJNA675331	24145	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	112	1.49e-26	NR	MEM3062467.1	2026795	g23973	i0	64.6	2.95020746887967	79	27	98.3	1	3	239	739	816	MEM3062467.1 helicase-related protein [Nitrososphaerota archaeon]	diamond	711	112	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
27998060	27998060	PRJNA675331_P_NODE_5825_length_398_cov_1.461538_g5653_i0	PRJNA675331	5825	398	1.461538	5.81692124	archaeon	1906665	Archaea	Archaea	72.8	1.61e-13	NR	MDP2434907.1	1906665	g5653	i0	52	0.753768844221106	100	45	75.4	1	6	305	18	114	MDP2434907.1 60S acidic ribosomal protein P2 [archaeon]	diamond	300	72.8	1	Archaea								archaeon
28060956	28060956	PRJNA675331_P_NODE_19005_length_250_cov_0.864407_g18833_i0	PRJNA675331	19005	250	0.864407	2.1610175	archaeon	1906665	Archaea	Archaea	119	2.87e-29	NR	MDP2437555.1	1906665	g18833	i0	76.5	0.972	81	19	97.2	0	1	243	39	119	MDP2437555.1 T-complex protein 1 subunit delta [archaeon]	diamond	243	119	1	Archaea								archaeon
28881882	28881882	PRJNA675331_P_NODE_16588_length_261_cov_0.957447_g16416_i0	PRJNA675331	16588	261	0.957447	2.49893667	archaeon	1906665	Archaea	Archaea	99.8	4.24e-22	NR	MDP2438449.1	1906665	g16416	i0	55.1	1.02298850574713	89	37	98.9	1	4	261	217	305	MDP2438449.1 ThiF family adenylyltransferase [archaeon]	diamond	267	99.8	1	Archaea								archaeon
30030630	30030630	PRJNA675331_P_NODE_21171_length_246_cov_0.890173_g20999_i0	PRJNA675331	21171	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	56.2	5.85e-7	NR	WP_196818247.1	1353260	g20999	i0	41.3	3.21951219512195	63	33	76.8	1	245	57	146	204	WP_196818247.1 Dyp-type peroxidase [Candidatus Nitrosocosmicus oleophilus]	diamond	792	56.2	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
30050158	30050158	PRJNA675331_P_NODE_8671_length_334_cov_0.881226_g8499_i0	PRJNA675331	8671	334	0.881226	2.94329484	archaeon	1906665	Archaea	Archaea	196	4.55e-61	NR	MDP2436279.1	1906665	g8499	i0	86.5	0.997005988023952	111	15	99.7	0	2	334	45	155	MDP2436279.1 hypothetical protein [archaeon]	diamond	333	196	1	Archaea								archaeon
30303554	30303554	PRJNA675331_P_NODE_21752_length_245_cov_0.895349_g21580_i0	PRJNA675331	21752	245	0.895349	2.19360505	archaeon	1906665	Archaea	Archaea	49.3	5.75e-5	NR	MDP2438870.1	1906665	g21580	i0	45.5	0.808163265306122	66	36	80.8	0	212	15	50	115	MDP2438870.1 insulinase family protein [archaeon]	diamond	198	49.3	1	Archaea								archaeon
31061636	31061636	PRJNA675331_P_NODE_15835_length_266_cov_0.948187_g15663_i0	PRJNA675331	15835	266	0.948187	2.52217742	archaeon	1906665	Archaea	Archaea	54.3	4.34e-6	NR	MDP2435053.1	1906665	g15663	i0	38.4	0.969924812030075	86	48	95.9	4	265	11	2136	2217	MDP2435053.1 hypothetical protein [archaeon]	diamond	258	54.3	1	Archaea								archaeon
31452748	31452748	PRJNA675331_P_NODE_8636_length_334_cov_1.931034_g8464_i0	PRJNA675331	8636	334	1.931034	6.44965356	root	1	Root_unresolved	Root_unresolved	65.9	8.26e-10	NR	HDP73556.1	2026803	g8464	i0	66.7	2.58682634730539	39	13	35	0	318	202	148	186	HDP73556.1 DUF4215 domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	864	66.2	0.995468277945619	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
31472569	31472569	PRJNA675331_P_NODE_23836_length_241_cov_1.232143_g23664_i0	PRJNA675331	23836	241	1.232143	2.96946463	archaeon	1906665	Archaea	Archaea	127	5.86e-32	NR	MDP2435572.1	1906665	g23664	i0	76.9	0.970954356846473	78	18	97.1	0	236	3	689	766	MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon]	diamond	234	127	1	Archaea								archaeon
31535878	31535878	PRJNA675331_P_NODE_10256_length_312_cov_0.941423_g10084_i0	PRJNA675331	10256	312	0.941423	2.93723976	archaeon	1906665	Archaea	Archaea	83.6	9.73e-17	NR	MDP2437927.1	1906665	g10084	i0	70.8	0.625	65	19	62.5	0	308	114	220	284	MDP2437927.1 50S ribosomal protein L10 [archaeon]	diamond	195	83.6	1	Archaea								archaeon
31535881	31535881	PRJNA675331_P_NODE_12896_length_284_cov_1.459716_g12724_i0	PRJNA675331	12896	284	1.459716	4.14559344	Methanomicrobiales archaeon HGW-Methanomicrobiales-4	2013820	Archaea	Archaea	47.4	0.00104	NR	PKL59616.1	2013820	g12724	i0	39.7	0.71830985915493	68	34	70.8	2	1	201	159	220	PKL59616.1 MAG: hypothetical protein CVV33_06900, partial [Methanomicrobiales archaeon HGW-Methanomicrobiales-4]	diamond	204	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon HGW-Methanomicrobiales-4
31788470	31788470	PRJNA675331_P_NODE_13957_length_276_cov_1.137931_g13785_i0	PRJNA675331	13957	276	1.137931	3.14068956	archaeon	1906665	Archaea	Archaea	134	5.07e-34	NR	MDP2435572.1	1906665	g13785	i0	69.1	1.02173913043478	94	26	98.9	1	273	1	545	638	MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon]	diamond	282	134	1	Archaea								archaeon
31820198	31820198	PRJNA675331_P_NODE_22917_length_243_cov_0.905882_g22745_i0	PRJNA675331	22917	243	0.905882	2.20129326	archaeon	1906665	Archaea	Archaea	117	1.51e-28	NR	MDP2435572.1	1906665	g22745	i0	69.5	1.01234567901235	82	23	98.8	1	240	1	276	357	MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon]	diamond	246	117	1	Archaea								archaeon
31820199	31820199	PRJNA675331_P_NODE_2317_length_606_cov_0.889306_g2151_i0	PRJNA675331	2317	606	0.889306	5.38919436	archaeon	1906665	Archaea	Archaea	55.5	4.75e-5	NR	MDP2435053.1	1906665	g2151	i0	29.9	0.910891089108911	184	94	83.2	13	19	522	901	1065	MDP2435053.1 hypothetical protein [archaeon]	diamond	552	55.5	1	Archaea								archaeon
32136825	32136825	PRJNA675331_P_NODE_4938_length_429_cov_1.997191_g4766_i0	PRJNA675331	4938	429	1.997191	8.56794939	archaeon	1906665	Archaea	Archaea	68.2	3.99e-10	NR	MDP2435053.1	1906665	g4766	i0	36.5	0.727272727272727	104	64	72.7	1	117	428	1839	1940	MDP2435053.1 hypothetical protein [archaeon]	diamond	312	68.2	1	Archaea								archaeon
32516676	32516676	PRJNA675331_P_NODE_9399_length_323_cov_0.924000_g9227_i0	PRJNA675331	9399	323	0.924	2.98452	archaeon	1906665	Archaea	Archaea	139	3.82e-37	NR	MDP2435612.1	1906665	g9227	i0	67.3	0.910216718266254	98	32	91	0	322	29	156	253	MDP2435612.1 hypothetical protein [archaeon]	diamond	294	139	1	Archaea								archaeon
32705448	32705448	PRJNA675331_P_NODE_7780_length_350_cov_0.866426_g7608_i0	PRJNA675331	7780	350	0.866426	3.032491	uncultured Methanospirillum sp.	262503	Archaea	Archaea	89	2.15e-19	NR	WP_319578547.1	262503	g7608	i0	44.5	3.63428571428571	110	60	94.3	1	21	350	15	123	WP_319578547.1 ferritin [uncultured Methanospirillum sp.]	diamond	1272	89	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	uncultured Methanospirillum sp.
32799873	32799873	PRJNA675331_P_NODE_20080_length_248_cov_0.880000_g19908_i0	PRJNA675331	20080	248	0.88	2.1824	archaeon	1906665	Archaea	Archaea	76.6	1.79e-15	NR	MDP2436403.1	1906665	g19908	i0	47.8	0.810483870967742	67	35	81	0	6	206	27	93	MDP2436403.1 hypothetical protein [archaeon]	diamond	201	76.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);;