metadata: contig_metadata: 10 rows where bioproject = "PRJNA1123436", tax_kingdom = "Methanobacteriati" and tax

10 rows where bioproject = "PRJNA1123436", 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_species
5382164	5382164	PRJNA1123436_P_NODE_116665_length_244_cov_0.900585_g115451_i0	PRJNA1123436	116665	244	0.900585	2.1974274	Thermoplasmata archaeon	1906666	Archaea	Archaea	130	6.1e-36	NR	NIP35398.1	1906666	g115451	i0	84.4	1.89344262295082	77	12	94.7	0	3	233	97	173	NIP35398.1 ABC transporter ATP-binding protein [Thermoplasmata archaeon]	diamond	462	130	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon
19404572	19404572	PRJNA1123436_P_NODE_100936_length_249_cov_0.914773_g99722_i0	PRJNA1123436	100936	249	0.914773	2.27778477	uncultured Thermoplasmata archaeon	376542	Archaea	Archaea	156	1.67e-33	NTclustered	gi\|2874253934\|emb\|OY970259.1\|	376542	g99722	i0	83.432	21.7349397590361	169	26	67	2	82	249	271415	271248	MAG: uncultured Thermoplasmata archaeon isolate MFD00991.bin.2.14 genome assembly, chromosome: 1	blastn	5412	156	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	uncultured Thermoplasmata archaeon
23981535	23981535	PRJNA1123436_P_NODE_121739_length_243_cov_0.905882_g120525_i0	PRJNA1123436	121739	243	0.905882	2.20129326	Thermoplasmata archaeon	1906666	Archaea	Archaea	164	1.0199999999999999e-47	NR	MCI4354463.1	1906666	g120525	i0	91.4	1	81	7	100	0	1	243	155	235	MCI4354463.1 histidinol-phosphate transaminase [Thermoplasmata archaeon]	diamond	243	164	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon
26911927	26911927	PRJNA1123436_P_NODE_100242_length_250_cov_0.870056_g99028_i0	PRJNA1123436	100242	250	0.870056	2.17514	Thermoplasmatota archaeon	2806419	Archaea	Archaea	160	1.25e-46	NR	MBU0623543.1	2806419	g99028	i0	92.7	1.968	82	6	98.4	0	3	248	178	259	MBU0623543.1 acetyl-CoA decarbonylase/synthase complex subunit delta [Thermoplasmatota archaeon]	diamond	492	160	1	Archaea	Methanobacteriati	Thermoplasmatota		Thermoplasmatota archaeon
27323109	27323109	PRJNA1123436_P_NODE_104663_length_248_cov_0.880000_g103449_i0	PRJNA1123436	104663	248	0.88	2.1824	Thermoplasmatota archaeon	2806419	Archaea	Archaea	106	1.32e-24	NR	MDH7516786.1	2806419	g103449	i0	59.8	0.991935483870968	82	33	99.2	0	1	246	600	681	MDH7516786.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	246	106	1	Archaea	Methanobacteriati	Thermoplasmatota		Thermoplasmatota archaeon
27354852	27354852	PRJNA1123436_P_NODE_104683_length_248_cov_0.880000_g103469_i0	PRJNA1123436	104683	248	0.88	2.1824	Thermoplasmata archaeon	1906666	Archaea	Archaea	50.8	4.86e-6	NR	MCK4265954.1	1906666	g103469	i0	82.6	0.278225806451613	23	4	27.8	0	1	69	63	85	MCK4265954.1 hypothetical protein [Thermoplasmata archaeon]	diamond	69	50.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon
27923039	27923039	PRJNA1123436_P_NODE_95405_length_251_cov_0.865169_g94191_i0	PRJNA1123436	95405	251	0.865169	2.17157419	Thermoplasmata archaeon	1906666	Archaea	Archaea	56.6	5.18e-7	NR	MCK5548251.1	1906666	g94191	i0	35	0.956175298804781	80	49	92	2	232	2	59	138	MCK5548251.1 hypothetical protein [Thermoplasmata archaeon]	diamond	240	56.6	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon
28238585	28238585	PRJNA1123436_P_NODE_119446_length_243_cov_1.200000_g118232_i0	PRJNA1123436	119446	243	1.2	2.916	Thermoplasmata archaeon M9B1D	1933279	Archaea	Archaea	104	5.31e-25	NR	PNX45730.1	1933279	g118232	i0	55.6	1	81	36	100	0	243	1	114	194	PNX45730.1 MAG: hypothetical protein BV457_09005, partial [Thermoplasmata archaeon M9B1D]	diamond	243	104	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon M9B1D
32315192	32315192	PRJNA1123436_P_NODE_108879_length_247_cov_0.885057_g107665_i0	PRJNA1123436	108879	247	0.885057	2.18609079	Thermoplasmata archaeon	1906666	Archaea	Archaea	45.4	0.00312	NR	MCI4354555.1	1906666	g107665	i0	41.5	0.643724696356275	53	30	64.4	1	170	12	1	52	MCI4354555.1 hypothetical protein [Thermoplasmata archaeon]	diamond	159	45.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmata archaeon
32882716	32882716	PRJNA1123436_P_NODE_124560_length_242_cov_0.911243_g123346_i0	PRJNA1123436	124560	242	0.911243	2.20520806	Thermoplasmata archaeon	1906666	Archaea	Archaea	117	1.17e-28	NR	UCF07596.1	1906666	g123346	i0	67.9	1.93388429752066	78	25	96.7	0	4	237	343	420	UCF07596.1 MAG: hypothetical protein JSW28_08100, partial [Thermoplasmata archaeon]	diamond	468	117	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);;