metadata: contig_metadata: 14 rows where bioproject = "PRJNA1144090", tax_kingdom = "Methanobacteriati" and tax

14 rows where bioproject = "PRJNA1144090", 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_family	tax_genus	tax_species
18139135	18139135	PRJNA1144090_P_NODE_49175_length_364_cov_1.917526_g48640_i0	PRJNA1144090	49175	364	1.917526	6.97979464	Thermoplasmatota archaeon	2806419	Archaea	Archaea	135	5.83e-35	NR	MEA3559730.1	2806419	g48640	i0	58.7	0.997252747252747	121	48	99.7	1	1	363	276	394	MEA3559730.1 pyruvate kinase [Thermoplasmatota archaeon]	diamond	363	135	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
26690646	26690646	PRJNA1144090_P_NODE_73161_length_295_cov_2.599099_g72626_i0	PRJNA1144090	73161	295	2.599099	7.66734205	Thermoplasmatota archaeon	2806419	Archaea	Archaea	55.8	1.75e-6	NR	MCL5665257.1	2806419	g72626	i0	58.7	1.0271186440678	46	18	45.8	1	294	160	637	682	MCL5665257.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	303	55.8	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27702644	27702644	PRJNA1144090_P_NODE_51704_length_354_cov_3.505338_g51169_i0	PRJNA1144090	51704	354	3.505338	12.40889652	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	87.8	2.2e-17	NR	MDG1549831.1	2666346	g51169	i0	41.6	1.78813559322034	113	61	94.1	3	22	354	236	345	MDG1549831.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	633	87.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
28523328	28523328	PRJNA1144090_P_NODE_39287_length_412_cov_1.876106_g38752_i0	PRJNA1144090	39287	412	1.876106	7.72955672	Thermoplasmata archaeon	1906666	Archaea	Archaea	105	4.8199999999999996e-24	NR	MCD6447829.1	1906666	g38752	i0	52.6	0.706310679611651	97	41	67	1	285	10	234	330	MCD6447829.1 bis-aminopropyl spermidine synthase family protein [Thermoplasmata archaeon]	diamond	291	105	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28606896	28606896	PRJNA1144090_P_NODE_63967_length_317_cov_1.651639_g63432_i0	PRJNA1144090	63967	317	1.651639	5.23569563	root	1	Root_unresolved	Root_unresolved	111	4.06e-27	NR	HIH98830.1	1906666	g63432	i0	56.9	4.81703470031546	102	44	96.5	0	1	306	38	139	HIH98830.1 ribokinase [Thermoplasmata archaeon]	diamond	1527	111	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28901941	28901941	PRJNA1144090_P_NODE_66808_length_310_cov_1.299578_g66273_i0	PRJNA1144090	66808	310	1.299578	4.0286918	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	79.3	1.23e-14	NR	MFL2961486.1	2666346	g66273	i0	41.6	3.68709677419355	89	50	85.2	2	303	40	1432	1519	MFL2961486.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	1143	79.3	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
29049067	29049067	PRJNA1144090_P_NODE_10268_length_880_cov_3.521685_g9837_i0	PRJNA1144090	10268	880	3.521685	30.990828	root	1	Root_unresolved	Root_unresolved	108	1.97e-22	NR	HEY7587764.1	1906666	g9837	i0	29.4	1.94318181818182	286	165	89	8	95	877	45	318	HEY7587764.1 PQQ-dependent sugar dehydrogenase [Thermoplasmata archaeon]	diamond	1710	108	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29249309	29249309	PRJNA1144090_P_NODE_50609_length_358_cov_3.978947_g50074_i0	PRJNA1144090	50609	358	3.978947	14.24463026	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	72	8.27e-12	NR	MDC3298163.1	2666346	g50074	i0	43.8	1.34078212290503	80	45	67	0	333	94	1716	1795	MDC3298163.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	480	72	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
29470148	29470148	PRJNA1144090_P_NODE_52350_length_352_cov_2.114695_g51815_i0	PRJNA1144090	52350	352	2.114695	7.4437264	Thermoplasmatota archaeon	2806419	Archaea	Archaea	55.1	5.2e-6	NR	MED5291146.1	2806419	g51815	i0	36.3	0.681818181818182	80	38	67.3	2	26	262	30	97	MED5291146.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	240	55.1	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29912740	29912740	PRJNA1144090_P_NODE_77091_length_287_cov_2.144860_g76556_i0	PRJNA1144090	77091	287	2.14486	6.1557482	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	47.8	0.00105	NR	HJM44501.1	2666346	g76556	i0	42.5	0.763066202090592	73	33	66.9	1	17	208	345	417	HJM44501.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	219	47.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
30344421	30344421	PRJNA1144090_P_NODE_90372_length_264_cov_1.607330_g89837_i0	PRJNA1144090	90372	264	1.60733	4.2433512	Archaea	2157	Archaea	Archaea	93.2	6.39e-20	NR	MFL2940038.1	2163009	g89837	i0	53.6	2.875	84	36	95.5	1	257	6	196	276	MFL2940038.1 purple acid phosphatase family protein [Candidatus Poseidoniales archaeon]	diamond	759	93.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
30860401	30860401	PRJNA1144090_P_NODE_40054_length_408_cov_1.367164_g39519_i0	PRJNA1144090	40054	408	1.367164	5.57802912	Poseidonia sp.	2666344	Archaea	Archaea	74.7	1.5e-12	NR	MDP6200215.1	2666344	g39519	i0	37.1	0.970588235294118	132	75	92.6	4	29	406	241	370	MDP6200215.1 hypothetical protein [Poseidonia sp.]	diamond	396	74.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidonia	Poseidonia sp.
32093630	32093630	PRJNA1144090_P_NODE_70998_length_300_cov_1.832599_g70463_i0	PRJNA1144090	70998	300	1.832599	5.497797	Thermoplasmata archaeon	1906666	Archaea	Archaea	49.7	2.02e-4	NR	MEM0353939.1	1906666	g70463	i0	32	1.86	97	40	97	3	9	299	23	93	MEM0353939.1 metallophosphoesterase [Thermoplasmata archaeon]	diamond	558	49.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32757187	32757187	PRJNA1144090_P_NODE_66380_length_311_cov_1.294118_g65845_i0	PRJNA1144090	66380	311	1.294118	4.02470698	Thermoplasmata archaeon	1906666	Archaea	Archaea	45.4	9.08e-4	NR	MEM3341939.1	1906666	g65845	i0	43.5	0.443729903536977	46	26	44.4	0	138	1	4	49	MEM3341939.1 hypothetical protein [Thermoplasmata archaeon]	diamond	138	45.4	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);;