metadata: contig_metadata: 27 rows where bioproject = "PRJNA893346" and tax

27 rows where bioproject = "PRJNA893346" 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
868480	868480	PRJNA893346_P_NODE_37301_length_245_cov_0.895349_g36811_i0	PRJNA893346	37301	245	0.895349	2.19360505	archaeon	1906665	Archaea	Archaea	153	6.449999999999999e-45	NR	MDP2436279.1	1906665	g36811	i0	93.8	0.991836734693878	81	5	99.2	0	244	2	106	186	MDP2436279.1 hypothetical protein [archaeon]	diamond	243	153	1	Archaea								archaeon
5971539	5971539	PRJNA893346_P_NODE_30485_length_268_cov_2.205128_g29995_i0	PRJNA893346	30485	268	2.205128	5.90974304	Nitrosopumilus maritimus	338192	Archaea	Archaea	496	9.429999999999999e-136	NTclustered	gi\|160338813\|gb\|CP000866.1\|	436308	g29995	i0	100	1.98880597014925	268	0	100	0	1	268	1414030	1414297	Nitrosopumilus maritimus SCM1, complete genome	blastn	533	496	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus maritimus
6347280	6347280	PRJNA893346_P_NODE_19165_length_352_cov_2.207885_g18676_i0	PRJNA893346	19165	352	2.207885	7.7717552	archaeon	1906665	Archaea	Archaea	150	2.81e-44	NR	MDP2439821.1	1906665	g18676	i0	80.9	0.980113636363636	115	21	97.2	1	10	351	1	115	MDP2439821.1 eS25 family ribosomal protein [archaeon]	diamond	345	150	1	Archaea								archaeon
8896167	8896167	PRJNA893346_P_NODE_36867_length_245_cov_2.046512_g36377_i0	PRJNA893346	36867	245	2.046512	5.0139544	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|313674020\|gb\|HQ340613.1\|	29281	g36377	i0	100	100	245	0	100	0	1	245	450	206	Uncultured crenarchaeote clone Sapelo_2 16S ribosomal RNA gene, partial sequence	blastn	24500	453	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
11072054	11072054	PRJNA893346_P_NODE_39569_length_241_cov_0.916667_g39079_i0	PRJNA893346	39569	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	135	1.5199999999999996e-38	NR	MDP2438822.1	1906665	g39079	i0	88.6	0.983402489626556	79	9	98.3	0	3	239	16	94	MDP2438822.1 50S ribosomal protein L11 [archaeon]	diamond	237	135	1	Archaea								archaeon
16545827	16545827	PRJNA893346_P_NODE_40093_length_240_cov_2.293413_g39603_i0	PRJNA893346	40093	240	2.293413	5.5041912	Nitrosopumilus	338191	Archaea	Archaea	444	3.05e-120	NTclustered	gi\|507148339\|ref\|NR_103142.1\|	338192	g39603	i0	100	60.2208333333333	240	0	100	0	1	240	853	614	Nitrosopumilus maritimus strain SCM1 23S ribosomal RNA gene, complete sequence	blastn	14453	444	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus maritimus
22545174	22545174	PRJNA893346_P_NODE_31758_length_260_cov_1.235294_g31268_i0	PRJNA893346	31758	260	1.235294	3.2117644	archaeon	1906665	Archaea	Archaea	142	6.94e-41	NR	MDP2434782.1	1906665	g31268	i0	84.9	0.992307692307692	86	13	99.2	0	2	259	33	118	MDP2434782.1 V-type proton ATPase proteolipid subunit family protein [archaeon]	diamond	258	142	1	Archaea								archaeon
23820479	23820479	PRJNA893346_P_NODE_30139_length_271_cov_1.025253_g29649_i0	PRJNA893346	30139	271	1.025253	2.77843563	Natronorubrum daqingense	588898	Archaea	Archaea	69.4	2.47e-7	NTclustered	gi\|1134979927\|gb\|CP019327.1\|	588898	g29649	i0	85.294	0.250922509225092	68	8	25	2	108	174	592885	592951	Natronorubrum daqingense strain JX313, complete sequence	blastn	68	69.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum daqingense
28413741	28413741	PRJNA893346_P_NODE_34786_length_249_cov_0.875000_g34296_i0	PRJNA893346	34786	249	0.875	2.17875	Candidatus Sigynarchaeota archaeon	3036967	Archaea	Archaea	71.6	2.78e-12	NR	MEX2719049.1	3036967	g34296	i0	42.6	1.63855421686747	68	39	81.9	0	246	43	255	322	MEX2719049.1 SIR2 family protein [Candidatus Sigynarchaeota archaeon]	diamond	408	71.6	1	Archaea		Promethearchaeati	Candidatus Sigynarchaeota					Candidatus Sigynarchaeota archaeon
28571445	28571445	PRJNA893346_P_NODE_34907_length_249_cov_0.875000_g34417_i0	PRJNA893346	34907	249	0.875	2.17875	archaeon	1906665	Archaea	Archaea	126	2.84e-33	NR	MDP2439249.1	1906665	g34417	i0	70.7	0.987951807228916	82	24	98.8	0	1	246	144	225	MDP2439249.1 MC/SLC25 family protein [archaeon]	diamond	246	126	1	Archaea								archaeon
28571446	28571446	PRJNA893346_P_NODE_37447_length_245_cov_0.895349_g36957_i0	PRJNA893346	37447	245	0.895349	2.19360505	archaeon	1906665	Archaea	Archaea	90.1	2.4e-20	NR	MDP2434254.1	1906665	g36957	i0	50.6	0.991836734693878	81	39	99.2	1	2	244	15	94	MDP2434254.1 hypothetical protein [archaeon]	diamond	243	90.1	1	Archaea								archaeon
28666347	28666347	PRJNA893346_P_NODE_23847_length_313_cov_0.962500_g23357_i0	PRJNA893346	23847	313	0.9625	3.012625	archaeon	1906665	Archaea	Archaea	157	1.32e-47	NR	MDP2434118.1	1906665	g23357	i0	79.6	2.80830670926518	98	19	93	1	1	291	15	112	MDP2434118.1 30S ribosomal protein S17 [archaeon]	diamond	879	157	1	Archaea								archaeon
28697971	28697971	PRJNA893346_P_NODE_16667_length_380_cov_1.000000_g16179_i0	PRJNA893346	16667	380	1	3.8	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	88.6	1.66e-17	NR	RJU93967.1	2163009	g16179	i0	40.3	0.939473684210526	119	60	93.9	2	360	4	614	721	RJU93967.1 MAG: hypothetical protein DWC08_02800, partial [Candidatus Poseidoniales archaeon]	diamond	357	88.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
28729415	28729415	PRJNA893346_P_NODE_22947_length_320_cov_1.242915_g22457_i0	PRJNA893346	22947	320	1.242915	3.977328	archaeon	1906665	Archaea	Archaea	63.9	5.04e-10	NR	MDP2435168.1	1906665	g22457	i0	37.6	1.021875	109	55	99.4	4	1	318	5	103	MDP2435168.1 hypothetical protein [archaeon]	diamond	327	63.9	1	Archaea								archaeon
28729424	28729424	PRJNA893346_P_NODE_36767_length_246_cov_0.890173_g36277_i0	PRJNA893346	36767	246	0.890173	2.18982558	archaeon	1906665	Archaea	Archaea	54.3	7.9e-7	NR	MDP2436403.1	1906665	g36277	i0	44.9	0.597560975609756	49	27	59.8	0	245	99	44	92	MDP2436403.1 hypothetical protein [archaeon]	diamond	147	54.3	1	Archaea								archaeon
29053023	29053023	PRJNA893346_P_NODE_34708_length_249_cov_0.875000_g34218_i0	PRJNA893346	34708	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	117	9.679999999999999e-30	NR	MDP2437106.1	1906665	g34218	i0	62.7	1.98795180722892	83	30	98.8	1	248	3	53	135	MDP2437106.1 NADPH:quinone reductase [archaeon]	diamond	495	117	1	Archaea								archaeon
29203184	29203184	PRJNA893346_P_NODE_38309_length_243_cov_0.905882_g37819_i0	PRJNA893346	38309	243	0.905882	2.20129326	archaeon	1906665	Archaea	Archaea	68.2	1.23e-11	NR	MDP2439637.1	1906665	g37819	i0	45.3	0.925925925925926	75	37	87.7	1	15	227	54	128	MDP2439637.1 hypothetical protein [archaeon]	diamond	225	68.2	1	Archaea								archaeon
29771177	29771177	PRJNA893346_P_NODE_8871_length_531_cov_1.008734_g8389_i0	PRJNA893346	8871	531	1.008734	5.35637754	archaeon	1906665	Archaea	Archaea	127	2.62e-33	NR	MDP2435371.1	1906665	g8389	i0	43.1	0.774011299435028	137	77	77.4	1	432	22	36	171	MDP2435371.1 hypothetical protein [archaeon]	diamond	411	127	1	Archaea								archaeon
29992467	29992467	PRJNA893346_P_NODE_34291_length_250_cov_0.870056_g33801_i0	PRJNA893346	34291	250	0.870056	2.17514	archaeon	1906665	Archaea	Archaea	63.5	8.99e-11	NR	MDP2437694.1	1906665	g33801	i0	52.9	0.612	51	24	61.2	0	95	247	37	87	MDP2437694.1 hypothetical protein [archaeon]	diamond	153	63.5	1	Archaea								archaeon
30308856	30308856	PRJNA893346_P_NODE_30692_length_267_cov_1.530928_g30202_i0	PRJNA893346	30692	267	1.530928	4.08757776	archaeon	1906665	Archaea	Archaea	108	3.76e-25	NR	MDP2435053.1	1906665	g30202	i0	53.5	1.1123595505618	99	36	100	2	267	1	531	629	MDP2435053.1 hypothetical protein [archaeon]	diamond	297	108	1	Archaea								archaeon
30529448	30529448	PRJNA893346_P_NODE_21593_length_331_cov_1.189922_g21104_i0	PRJNA893346	21593	331	1.189922	3.93864182	archaeon	1906665	Archaea	Archaea	93.2	2.31e-20	NR	MDP2439131.1	1906665	g21104	i0	61.6	2.03021148036254	73	22	63.4	3	301	92	112	181	MDP2439131.1 zinc finger CCCH domain-containing protein [archaeon]	diamond	672	93.2	1	Archaea								archaeon
30655837	30655837	PRJNA893346_P_NODE_31733_length_260_cov_1.358289_g31243_i0	PRJNA893346	31733	260	1.358289	3.5315514	archaeon	1906665	Archaea	Archaea	110	1.42e-26	NR	MDP2437063.1	1906665	g31243	i0	47.2	1.02692307692308	89	44	99.2	1	2	259	187	275	MDP2437063.1 hypothetical protein [archaeon]	diamond	267	110	1	Archaea								archaeon
30719023	30719023	PRJNA893346_P_NODE_36194_length_247_cov_0.885057_g35704_i0	PRJNA893346	36194	247	0.885057	2.18609079	archaeon	1906665	Archaea	Archaea	57.8	3.22e-8	NR	MDP2438315.1	1906665	g35704	i0	88.6	0.425101214574899	35	4	42.5	0	223	119	1	35	MDP2438315.1 HMG-box domain-containing protein [archaeon]	diamond	105	57.8	1	Archaea								archaeon
30908814	30908814	PRJNA893346_P_NODE_7314_length_592_cov_1.186898_g6841_i0	PRJNA893346	7314	592	1.186898	7.02643616	archaeon	1906665	Archaea	Archaea	95.5	7.04e-19	NR	MDP2435053.1	1906665	g6841	i0	34	0.998310810810811	197	118	97.3	7	585	10	2155	2344	MDP2435053.1 hypothetical protein [archaeon]	diamond	591	95.5	1	Archaea								archaeon
32047149	32047149	PRJNA893346_P_NODE_33678_length_251_cov_0.865169_g33188_i0	PRJNA893346	33678	251	0.865169	2.17157419	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	65.5	4.03e-10	NR	MDH5390957.1	2026714	g33188	i0	45.1	1.74501992031873	71	39	84.9	0	229	17	324	394	MDH5390957.1 multicopper oxidase domain-containing protein [Candidatus Bathyarchaeota archaeon]	diamond	438	65.5	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
32173894	32173894	PRJNA893346_P_NODE_38818_length_242_cov_1.366864_g38328_i0	PRJNA893346	38818	242	1.366864	3.30781088	archaeon	1906665	Archaea	Archaea	92	2.41e-20	NR	MDP2435546.1	1906665	g38328	i0	65.1	0.78099173553719	63	22	78.1	0	53	241	1	63	MDP2435546.1 30S ribosomal protein S2 [archaeon]	diamond	189	92	1	Archaea								archaeon
32836725	32836725	PRJNA893346_P_NODE_9480_length_513_cov_2.006818_g8996_i0	PRJNA893346	9480	513	2.006818	10.29497634	Candidatus Pacearchaeota archaeon CG1_	2026773	Archaea	Archaea	47	0.0135	NR	OIO41421.1	1805294	g8996	i0	31	0.736842105263158	126	70	70.2	6	469	110	175	289	OIO41421.1 MAG: hypothetical protein AUJ10_01015 [Candidatus Pacearchaeota archaeon CG1_02_31_27]	diamond	378	47	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon CG1_02_31_27

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);;