metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA951810" 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_species
22613750	22613750	PRJNA951810_P_NODE_181998_length_229_cov_10.737179_g181653_i0	PRJNA951810	181998	229	10.737179	24.58813991	root	1	Root_unresolved	Root_unresolved	84.7	5.24e-17	NR	MCI4330366.1	1906666	g181653	i0	53.9	4.97816593886463	76	35	99.6	0	2	229	1337	1412	MCI4330366.1 PAS domain S-box protein [Thermoplasmata archaeon]	diamond	1140	85.1	0.995299647473561	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
26842508	26842508	PRJNA951810_P_NODE_90421_length_297_cov_4.620536_g90077_i0	PRJNA951810	90421	297	4.620536	13.72299192	root	1	Root_unresolved	Root_unresolved	54.7	4.78e-6	NR	MFO7991861.1	1906666	g90077	i0	45	2.50505050505051	60	28	55.6	1	16	180	498	557	MFO7991861.1 PQQ-binding-like beta-propeller repeat protein [Thermoplasmata archaeon]	diamond	744	54.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
27000334	27000334	PRJNA951810_P_NODE_61282_length_310_cov_3.375527_g60939_i0	PRJNA951810	61282	310	3.375527	10.4641337	root	1	Root_unresolved	Root_unresolved	58.2	3.36e-7	NR	MCK5772193.1	1906666	g60939	i0	57.1	2.30322580645161	49	21	47.4	0	309	163	1052	1100	MCK5772193.1 hypothetical protein [Thermoplasmata archaeon]	diamond	714	58.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
27285000	27285000	PRJNA951810_P_NODE_140043_length_265_cov_7.395833_g139698_i0	PRJNA951810	140043	265	7.395833	19.59895745	root	1	Root_unresolved	Root_unresolved	53.9	2.68e-6	NR	HTW77837.1	1906666	g139698	i0	67.7	2.04905660377359	31	10	35.1	0	1	93	164	194	HTW77837.1 pyridoxal 5'-phosphate synthase glutaminase subunit PdxT [Thermoplasmata archaeon]	diamond	543	54.3	0.992633517495396	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
28232061	28232061	PRJNA951810_P_NODE_163926_length_247_cov_2.212644_g163581_i0	PRJNA951810	163926	247	2.212644	5.46523068	Archaea	2157	Archaea	Archaea	67.8	2.88e-11	NR	OPX59792.1	1811728	g163581	i0	45.1	3.01214574898785	82	45	99.6	0	246	1	80	161	OPX59792.1 MAG: putative ABC transporter ATP-binding protein [Methanomassiliicoccales archaeon PtaB.Bin215]	diamond	744	67.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales		Methanomassiliicoccales archaeon PtaB.Bin215
28579762	28579762	PRJNA951810_P_NODE_133007_length_271_cov_1.878788_g132662_i0	PRJNA951810	133007	271	1.878788	5.09151548	Thermoplasmatota	2283796	Archaea	Archaea	44.7	0.0112	NR	HIM86438.1	2163009	g132662	i0	34.2	7.02952029520295	73	46	80.8	2	238	20	253	323	HIM86438.1 exo-alpha-sialidase [Candidatus Poseidoniales archaeon]	diamond	1905	44.7	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales		Candidatus Poseidoniales archaeon
29109981	29109981	PRJNA951810_P_NODE_106508_length_289_cov_2.782407_g106164_i0	PRJNA951810	106508	289	2.782407	8.04115623	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	45.4	0.00728	NR	MBR3476572.1	2517205	g106164	i0	52.9	0.705882352941177	34	16	35.3	0	107	6	9	42	MBR3476572.1 cobaltochelatase subunit CobN [Candidatus Methanomethylophilaceae archaeon]	diamond	204	45.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Candidatus Methanomethylophilaceae archaeon
29330871	29330871	PRJNA951810_P_NODE_139749_length_266_cov_1.590674_g139404_i0	PRJNA951810	139749	266	1.590674	4.23119284	Thermoplasmata archaeon	1906666	Archaea	Archaea	58.5	1.46e-8	NR	MCI4331325.1	1906666	g139404	i0	46	2.00751879699248	63	34	71.1	0	75	263	6	68	MCI4331325.1 nuclear transport factor 2 family protein [Thermoplasmata archaeon]	diamond	534	58.5	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata			Thermoplasmata archaeon
29836179	29836179	PRJNA951810_P_NODE_82731_length_299_cov_3.123894_g82387_i0	PRJNA951810	82731	299	3.123894	9.34044306	Candidatus Lutacidiplasmatales archaeon	3345206	Archaea	Archaea	89	4.18e-18	NR	MFI5417823.1	3345206	g82387	i0	45.7	2.05685618729097	105	46	94.3	1	283	2	43	147	MFI5417823.1 ATP-binding protein [Candidatus Lutacidiplasmatales archaeon]	diamond	615	89	1	Archaea	Methanobacteriati	Thermoplasmatota		Candidatus Lutacidiplasmatales		Candidatus Lutacidiplasmatales archaeon
31953737	31953737	PRJNA951810_P_NODE_153977_length_255_cov_1.291209_g153632_i0	PRJNA951810	153977	255	1.291209	3.29258295	Thermoplasmatota archaeon	2806419	Archaea	Archaea	42.7	0.0438	NR	MDP6155504.1	2806419	g153632	i0	32.2	0.694117647058824	59	39	69.4	1	36	212	189	246	MDP6155504.1 PKD domain-containing protein [Thermoplasmatota archaeon]	diamond	177	42.7	1	Archaea	Methanobacteriati	Thermoplasmatota				Thermoplasmatota 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);;