metadata: contig_metadata: 13 rows where bioproject = "PRJNA401346" and tax

13 rows where bioproject = "PRJNA401346" 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_kingdom	tax_phylum	tax_class	tax_species
1689174	1689174	PRJNA401346_P_NODE_7942_length_204_cov_0.895105_g7921_i0	PRJNA401346	7942	204	0.895105	1.8260142	archaeon	1906665	Archaea	Archaea	110	2.63e-29	NR	RYG63904.1	1906665	g7921	i0	83.6	0.985294117647059	67	11	98.5	0	201	1	40	106	RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon]	diamond	201	110	1	Archaea				archaeon
16991716	16991716	PRJNA401346_P_NODE_3274_length_287_cov_0.849558_g3253_i0	PRJNA401346	3274	287	0.849558	2.43823146	archaeon	1906665	Archaea	Archaea	145	1.99e-42	NR	RYH03712.1	1906665	g3253	i0	87.5	0.836236933797909	80	10	83.6	0	9	248	78	157	RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon]	diamond	240	145	1	Archaea				archaeon
26917249	26917249	PRJNA401346_P_NODE_5382_length_229_cov_1.142857_g5361_i0	PRJNA401346	5382	229	1.142857	2.61714253	archaeon	1906665	Archaea	Archaea	104	4.61e-24	NR	RYG70422.1	1906665	g5361	i0	61.3	0.982532751091703	75	29	98.3	0	3	227	664	738	RYG70422.1 MAG: hypothetical protein EON64_00215 [archaeon]	diamond	225	104	1	Archaea				archaeon
26948783	26948783	PRJNA401346_P_NODE_8102_length_203_cov_0.901408_g8081_i0	PRJNA401346	8102	203	0.901408	1.82985824	archaeon	1906665	Archaea	Archaea	73.9	1.88e-13	NR	RYG67589.1	1906665	g8081	i0	52.5	0.87192118226601	59	28	87.2	0	25	201	302	360	RYG67589.1 MAG: tetratricopeptide repeat protein [archaeon]	diamond	177	73.9	1	Archaea				archaeon
27360032	27360032	PRJNA401346_P_NODE_8823_length_201_cov_0.914286_g8802_i0	PRJNA401346	8823	201	0.914286	1.83771486	archaeon	1906665	Archaea	Archaea	128	2.77e-35	NR	RYH20542.1	1906665	g8802	i0	91	1	67	6	100	0	1	201	156	222	RYH20542.1 MAG: hypothetical protein EON65_23120 [archaeon]	diamond	201	128	1	Archaea				archaeon
27612660	27612660	PRJNA401346_P_NODE_7464_length_205_cov_0.888889_g7443_i0	PRJNA401346	7464	205	0.888889	1.82222245	archaeon	1906665	Archaea	Archaea	71.2	1.59e-12	NR	RYH08995.1	1906665	g7443	i0	69	0.614634146341463	42	13	61.5	0	1	126	111	152	RYH08995.1 MAG: hypothetical protein EON65_40490 [archaeon]	diamond	126	71.2	1	Archaea				archaeon
27739172	27739172	PRJNA401346_P_NODE_1144_length_441_cov_0.823684_g1123_i0	PRJNA401346	1144	441	0.823684	3.63244644	archaeon	1906665	Archaea	Archaea	146	1.5499999999999998e-37	NR	RYG70375.1	1906665	g1123	i0	45.7	1.19047619047619	175	60	95.2	2	422	3	800	974	RYG70375.1 MAG: ATP-binding cassette domain-containing protein [archaeon]	diamond	525	146	1	Archaea				archaeon
30201561	30201561	PRJNA401346_P_NODE_3292_length_286_cov_1.137778_g3271_i0	PRJNA401346	3292	286	1.137778	3.25404508	Thermoplasmatota archaeon	2806419	Archaea	Archaea	68.9	2.75e-13	NR	MDD5503110.1	2806419	g3271	i0	64.3	0.440559440559441	42	15	44.1	0	286	161	10	51	MDD5503110.1 30S ribosomal protein S27ae [Thermoplasmatota archaeon]	diamond	126	68.9	1	Archaea	Methanobacteriati	Thermoplasmatota		Thermoplasmatota archaeon
30580739	30580739	PRJNA401346_P_NODE_4673_length_246_cov_1.335135_g4652_i0	PRJNA401346	4673	246	1.335135	3.2844321	archaeon	1906665	Archaea	Archaea	81.3	1.01e-15	NR	RYH13265.1	1906665	g4652	i0	81.3	0.585365853658537	48	9	58.5	0	246	103	431	478	RYH13265.1 MAG: F0F1 ATP synthase subunit alpha [archaeon]	diamond	144	81.3	1	Archaea				archaeon
31592599	31592599	PRJNA401346_P_NODE_3516_length_278_cov_1.474654_g3495_i0	PRJNA401346	3516	278	1.474654	4.09953812	archaeon	1906665	Archaea	Archaea	44.3	0.00457	NR	RYY73917.1	1906665	g3495	i0	78.6	0.302158273381295	28	6	30.2	0	92	175	91	118	RYY73917.1 MAG: 50S ribosomal protein P1 [archaeon]	diamond	84	44.3	1	Archaea				archaeon
31687237	31687237	PRJNA401346_P_NODE_6997_length_207_cov_0.876712_g6976_i0	PRJNA401346	6997	207	0.876712	1.81479384	archaeon	1906665	Archaea	Archaea	110	3.87e-27	NR	RYG68823.1	1906665	g6976	i0	76.5	0.985507246376812	68	15	98.6	1	205	2	174	240	RYG68823.1 MAG: hypothetical protein EON64_04280 [archaeon]	diamond	204	110	1	Archaea				archaeon
32351939	32351939	PRJNA401346_P_NODE_6299_length_209_cov_0.864865_g6278_i0	PRJNA401346	6299	209	0.864865	1.80756785	archaeon	1906665	Archaea	Archaea	69.7	5.75e-14	NR	RYY87159.1	1906665	g6278	i0	69.6	0.660287081339713	46	14	66	0	38	175	6	51	RYY87159.1 MAG: hypothetical protein EON63_04530 [archaeon]	diamond	138	69.7	1	Archaea				archaeon
32510184	32510184	PRJNA401346_P_NODE_6679_length_208_cov_0.870748_g6658_i0	PRJNA401346	6679	208	0.870748	1.81115584	Candidatus Micrarchaeia archaeon	3018267	Archaea	Archaea	95.9	1.6299999999999994e-23	NR	MEM3771988.1	3018267	g6658	i0	64.2	0.966346153846154	67	24	96.6	0	2	202	55	121	MEM3771988.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Candidatus Micrarchaeia archaeon]	diamond	201	95.9	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeia 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);;