metadata: contig_metadata: 7 rows where bioproject = "PRJNA674048" and tax

7 rows where bioproject = "PRJNA674048" and tax_kingdom = "Methanobacteriati"

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
6270001	6270001	PRJNA674048_P_NODE_29445_length_166_cov_0.888889_g29242_i0	PRJNA674048	29445	166	0.888889	1.47555574	Halalkalicoccus	332246	Archaea	Archaea	292	7.52e-75	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g29242	i0	98.78	178.030120481928	164	2	99	0	3	166	1262	1099	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	29553	292	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
6270036	6270036	PRJNA674048_P_NODE_31645_length_163_cov_0.912281_g31442_i0	PRJNA674048	31645	163	0.912281	1.48701803	Haloarcula	2237	Archaea	Archaea	132	1.7e-26	NTclustered	gi\|343781660\|gb\|CP002921.1\|	634497	g31442	i0	84.733	5.77914110429448	131	20	80	0	30	160	2336111	2336241	Haloarcula hispanica ATCC 33960 chromosome I, complete sequence	blastn	942	132	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula hispanica
22843268	22843268	PRJNA674048_P_NODE_10418_length_291_cov_0.979339_g10215_i0	PRJNA674048	10418	291	0.979339	2.84987649	Halalkalicoccus	332246	Archaea	Archaea	483	8.069999999999998e-132	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g10215	i0	96.564	77.7938144329897	291	10	100	0	1	291	383	93	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	22638	483	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
27883289	27883289	PRJNA674048_P_NODE_29805_length_165_cov_1.793103_g29602_i0	PRJNA674048	29805	165	1.793103	2.95861995	root	1	Root_unresolved	Root_unresolved	50.4	2.91e-6	NR	WP_048102805.1	2208	g29602	i0	52.2	2.32727272727273	46	22	83.6	0	27	164	3	48	WP_048102805.1 hypothetical protein [Methanosarcina barkeri]	diamond	384	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
31946531	31946531	PRJNA674048_P_NODE_29497_length_166_cov_0.888889_g29294_i0	PRJNA674048	29497	166	0.888889	1.47555574	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	94	3.0300000000000003e-21	NR	MEK9694268.1	2163009	g29294	i0	77.8	0.975903614457831	54	12	97.6	0	164	3	277	330	MEK9694268.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	162	94	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
31978279	31978279	PRJNA674048_P_NODE_19418_length_200_cov_2.721854_g19215_i0	PRJNA674048	19418	200	2.721854	5.443708	Methanobacteriota archaeon	2026739	Archaea	Archaea	44.7	0.00452	NR	MAQ04991.1	2026739	g19215	i0	39.6	0.795	53	30	79.5	1	186	28	530	580	MAQ04991.1 hypothetical protein [Methanobacteriota archaeon]	diamond	159	44.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32041677	32041677	PRJNA674048_P_NODE_32838_length_162_cov_0.920354_g32635_i0	PRJNA674048	32838	162	0.920354	1.49097348	Methanobacteriota archaeon	2026739	Archaea	Archaea	100	1.29e-23	NR	MCH7660952.1	2026739	g32635	i0	94.2	0.962962962962963	52	3	96.3	0	160	5	190	241	MCH7660952.1 type II glyceraldehyde-3-phosphate dehydrogenase [Methanobacteriota archaeon]	diamond	156	100	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota 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);;