metadata: contig_metadata: 5 rows where bioproject = "PRJNA1011844", tax_kingdom = "Methanobacteriati" and tax

5 rows where bioproject = "PRJNA1011844", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

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_order	tax_species
3983444	3983444	PRJNA1011844_P_NODE_32644_length_899_cov_7.952785_g25606_i0	PRJNA1011844	32644	899	7.952785	71.49553715	Thermoplasmata archaeon	1906666	Archaea	Archaea	155	3.34e-38	NR	MCX8173375.1	1906666	g25606	i0	42.2	0.70411568409343706	211	110	67.7	4	644	36	215	421	MCX8173375.1 S8 family serine peptidase [Thermoplasmata archaeon]	diamond	633	155	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		Thermoplasmata archaeon
26717780	26717780	PRJNA1011844_P_NODE_125321_length_276_cov_1.330049_g116744_i0	PRJNA1011844	125321	276	1.330049	3.67093524	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	63.2	3.51e-9	NR	MEK9698547.1	2163009	g116744	i0	43.8	0.869565217391304	80	40	81.5	2	30	254	478	557	MEK9698547.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	240	63.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniales archaeon
30634994	30634994	PRJNA1011844_P_NODE_75553_length_422_cov_2.713467_g67055_i0	PRJNA1011844	75553	422	2.713467	11.45083074	Thermoplasmata archaeon	1906666	Archaea	Archaea	62	4.71e-8	NR	HIG98952.1	1906666	g67055	i0	36.9	3.66824644549763	130	64	79.6	5	409	74	151	280	HIG98952.1 PKD domain-containing protein [Thermoplasmata archaeon]	diamond	1548	62	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		Thermoplasmata archaeon
31267135	31267135	PRJNA1011844_P_NODE_41775_length_735_cov_5.413897_g33892_i0	PRJNA1011844	41775	735	5.413897	39.79214295	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	130	2.37e-33	NR	GIQ98137.1	2163009	g33892	i0	37.4	3.89795918367347	198	89	78.8	4	28	606	25	192	GIQ98137.1 MAG: hypothetical protein CM15mP3_11710 [Candidatus Poseidoniales archaeon]	diamond	2865	130	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniales archaeon
32627014	32627014	PRJNA1011844_P_NODE_40840_length_750_cov_5.456425_g33010_i0	PRJNA1011844	40840	750	5.456425	40.9231875	Thermoplasmata archaeon	1906666	Archaea	Archaea	72	2.06e-10	NR	HZY71117.1	1906666	g33010	i0	30.8	2.512	211	112	79.6	8	73	669	240	428	HZY71117.1 tRNA pseudouridine(13) synthase TruD [Thermoplasmata archaeon]	diamond	1884	72	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		Thermoplasmata 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);;