metadata: contig_metadata: 9 rows where bioproject = "PRJNA841653", tax_kingdom = "Methanobacteriati" and tax

9 rows where bioproject = "PRJNA841653", tax_kingdom = "Methanobacteriati" 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
830832	830832	PRJNA841653_P_NODE_53161_length_246_cov_0.890173_g52487_i0	PRJNA841653	53161	246	0.890173	2.18982558	Halorubrum hochsteinianum	2949307	Archaea	Archaea	100	7.82e-17	NTclustered	gi\|2251941869\|gb\|CP098415.1\|	2949307	g52487	i0	89.744	0.317073170731707	78	8	32	0	169	246	1853616	1853539	Halorubrum hochsteinianum strain 1-13-28 chromosome, complete genome	blastn	78	100	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum hochsteinianum
4658909	4658909	PRJNA841653_P_NODE_35144_length_277_cov_1.411765_g34470_i0	PRJNA841653	35144	277	1.411765	3.91058905	Halorubrum salinarum	2739057	Archaea	Archaea	119	2.48e-22	NTclustered	gi\|1848526000\|gb\|CP053941.1\|	2739057	g34470	i0	81.818	0.516245487364621	143	24	51	2	113	254	2261089	2261230	Halorubrum salinarum strain RHB-C chromosome, complete genome	blastn	143	119	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum salinarum
19957115	19957115	PRJNA841653_P_NODE_43996_length_251_cov_0.865169_g43322_i0	PRJNA841653	43996	251	0.865169	2.17157419	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	198	2.76e-46	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g43322	i0	81.59	0.952191235059761	239	44	95	0	5	243	584731	584969	Methanobrevibacter sp. YE315, complete genome	blastn	239	198	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
22507626	22507626	PRJNA841653_P_NODE_50878_length_247_cov_0.885057_g50204_i0	PRJNA841653	50878	247	0.885057	2.18609079	Halovalidus salilacus	3075124	Archaea	Archaea	52.8	0.022	NTclustered	gi\|2581323319\|gb\|CP134700.1\|	3075124	g50204	i0	96.875	5.38866396761134	32	0	13	1	139	169	896898	896867	Halovalidus salilacus strain CCL63 chromosome, complete genome	blastn	1331	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovalidus	Halovalidus salilacus
25056320	25056320	PRJNA841653_P_NODE_19160_length_373_cov_1.016667_g18488_i0	PRJNA841653	19160	373	1.016667	3.79216791	uncultured Methanoregula sp.	1005933	Archaea	Archaea	508	1.75e-139	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g18488	i0	91.803	95.1447721179625	366	28	98	2	9	373	3146930	3147294	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	35489	508	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
28349553	28349553	PRJNA841653_P_NODE_49246_length_248_cov_0.880000_g48572_i0	PRJNA841653	49246	248	0.88	2.1824	Natronococcus sp.	35747	Archaea	Archaea	42.7	0.0193	NR	WP_416283822.1	35747	g48572	i0	53.5	0.520161290322581	43	19	50.8	1	248	123	96	138	WP_416283822.1 helix-turn-helix domain-containing protein [Natronococcus sp.]	diamond	129	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus sp.
31223563	31223563	PRJNA841653_P_NODE_56415_length_244_cov_0.900585_g55741_i0	PRJNA841653	56415	244	0.900585	2.1974274	Candidatus Poseidonia alphae	1915863	Archaea	Archaea	126	4.9099999999999996e-32	NR	MDA7464148.1	1915863	g55741	i0	75.9	0.971311475409836	79	19	97.1	0	2	238	132	210	MDA7464148.1 hypothetical protein [Candidatus Poseidonia alphae]	diamond	237	126	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidonia	Candidatus Poseidonia alphae
32204406	32204406	PRJNA841653_P_NODE_14558_length_431_cov_1.899441_g13887_i0	PRJNA841653	14558	431	1.899441	8.18659071	Halobacteriota archaeon	3100168	Archaea	Archaea	55.8	7.81e-6	NR	MDY6957599.1	3100168	g13887	i0	37.9	0.605568445475638	87	42	59.2	2	171	425	1046	1122	MDY6957599.1 hypothetical protein [Halobacteriota archaeon]	diamond	261	55.8	1	Archaea		Methanobacteriati	Halobacteriota					Halobacteriota archaeon
32299679	32299679	PRJNA841653_P_NODE_55419_length_244_cov_1.701754_g54745_i0	PRJNA841653	55419	244	1.701754	4.15227976	Methanocaldococcus villosus	667126	Archaea	Archaea	55.5	2.89e-7	NR	WP_004592618.1	667126	g54745	i0	42.5	3.9344262295082	80	28	98.4	2	2	241	69	130	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	960	55.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus

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