metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA994052" 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
26614793	26614793	PRJNA994052_P_NODE_82061_length_198_cov_65.256000_g80804_i0	PRJNA994052	82061	198	65.256	129.20688	archaeon	1906665	Archaea	Archaea	58.9	8.09e-9	NR	MDP2438463.1	1906665	g80804	i0	75.8	0.5	33	8	50	0	193	95	126	158	MDP2438463.1 MC/SLC25 family protein [archaeon]	diamond	99	58.9	1	Archaea								archaeon
27152456	27152456	PRJNA994052_P_NODE_47702_length_245_cov_9.244186_g46451_i0	PRJNA994052	47702	245	9.244186	22.6482557	Methanobacterium sp.	2164	Archaea	Archaea	58.5	8.11e-8	NR	MEN6294369.1	2164	g46451	i0	34.5	1.42040816326531	116	39	96.7	1	5	241	80	195	MEN6294369.1 hypothetical protein [Methanobacterium sp.]	diamond	348	58.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
27690304	27690304	PRJNA994052_P_NODE_49564_length_242_cov_11.005917_g48310_i0	PRJNA994052	49564	242	11.005917	26.63431914	Nanobdellota archaeon	2026764	Archaea	Archaea	41.2	0.0227	NR	MEK6878041.1	2026764	g48310	i0	37.2	0.533057851239669	43	27	53.3	0	48	176	17	59	MEK6878041.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	129	41.2	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
27721941	27721941	PRJNA994052_P_NODE_35064_length_269_cov_23.392857_g33819_i0	PRJNA994052	35064	269	23.392857	62.92678533	Nanobdellota archaeon	2026764	Archaea	Archaea	130	1.3399999999999996e-34	NR	MCH7568280.1	2026764	g33819	i0	69.9	2.7546468401487	83	25	92.6	0	7	255	143	225	MCH7568280.1 dTDP-glucose 4,6-dehydratase [Nanoarchaeota archaeon]	diamond	741	130	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
28479325	28479325	PRJNA994052_P_NODE_27646_length_288_cov_9.223256_g26405_i0	PRJNA994052	27646	288	9.223256	26.56297728	Candidatus Caldarchaeum sp.	2972665	Archaea	Archaea	47.8	0.00108	NR	MEM4168000.1	2972665	g26405	i0	54.8	0.875	42	19	43.8	0	286	161	411	452	MEM4168000.1 hypothetical protein [Candidatus Caldarchaeum sp.]	diamond	252	47.8	1	Archaea		Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum sp.
28510862	28510862	PRJNA994052_P_NODE_72787_length_209_cov_16.536765_g71531_i0	PRJNA994052	72787	209	16.536765	34.56183885	Methanoculleus sp.	90427	Archaea	Archaea	114	4.01e-28	NR	WP_292561231.1	90427	g71531	i0	76.9	0.933014354066986	65	15	93.3	0	2	196	178	242	WP_292561231.1 PBSX family phage terminase large subunit [Methanoculleus sp.]	diamond	195	114	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
29963375	29963375	PRJNA994052_P_NODE_39831_length_259_cov_21.129032_g38585_i0	PRJNA994052	39831	259	21.129032	54.72419288	archaeon	1906665	Archaea	Archaea	52.8	1.4e-5	NR	RYG69290.1	1906665	g38585	i0	35	1.63320463320463	80	49	92.7	2	258	19	1111	1187	RYG69290.1 MAG: hypothetical protein EON64_03095, partial [archaeon]	diamond	423	52.8	1	Archaea								archaeon
31891362	31891362	PRJNA994052_P_NODE_29997_length_282_cov_5.899522_g28755_i0	PRJNA994052	29997	282	5.899522	16.63665204	Candidatus Poseidonia alphae	1915863	Archaea	Archaea	72.8	6.03e-13	NR	MDA7464330.1	1915863	g28755	i0	42.4	0.904255319148936	85	42	83	1	234	1	61	145	MDA7464330.1 alpha-1,2-fucosyltransferase [Candidatus Poseidonia alphae]	diamond	255	72.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidonia	Candidatus Poseidonia alphae
32207871	32207871	PRJNA994052_P_NODE_70058_length_212_cov_54.870504_g68802_i0	PRJNA994052	70058	212	54.870504	116.32546848	Nitrosarchaeum sp.	2026886	Archaea	Archaea	45.1	0.00383	NR	NJL44544.1	2026886	g68802	i0	34.4	0.863207547169811	61	40	86.3	0	18	200	197	257	NJL44544.1 hypothetical protein [Nitrosarchaeum sp.]	diamond	183	45.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
32239689	32239689	PRJNA994052_P_NODE_78938_length_202_cov_9.038760_g77681_i0	PRJNA994052	78938	202	9.03876	18.2582952	Halomarina salina	1872699	Archaea	Archaea	55.8	1.36e-7	NR	WP_247415064.1	1872699	g77681	i0	62.2	0.668316831683168	45	13	60.9	2	127	5	1	45	WP_247415064.1 hypothetical protein [Halomarina salina]	diamond	135	55.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina salina
32713273	32713273	PRJNA994052_P_NODE_48680_length_243_cov_51.200000_g47428_i0	PRJNA994052	48680	243	51.2	124.416	Nanobdellota archaeon	2026764	Archaea	Archaea	46.2	0.00213	NR	MEK6883419.1	2026764	g47428	i0	30.9	1.81481481481481	68	45	84	1	219	16	26	91	MEK6883419.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	441	46.2	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
32902107	32902107	PRJNA994052_P_NODE_64400_length_220_cov_4.884354_g63144_i0	PRJNA994052	64400	220	4.884354	10.7455788	Natronobeatus ordinarius	2963433	Archaea	Archaea	42	0.0482	NR	WP_255191692.1	2963433	g63144	i0	50	0.381818181818182	28	14	38.2	0	101	18	193	220	WP_255191692.1 esterase/lipase family protein [Natronobeatus ordinarius]	diamond	84	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronobeatus	Natronobeatus ordinarius

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