metadata: contig_metadata: 9 rows where bioproject = "PRJNA643700" and tax

9 rows where bioproject = "PRJNA643700" 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
4445957	4445957	PRJNA643700_P_NODE_408904_length_165_cov_0.896552_g407348_i0	PRJNA643700	408904	165	0.896552	1.4793108	Methanobrevibacter olleyae	294671	Archaea	Archaea	58.4	2.97e-4	NTclustered	gi\|998157363\|gb\|CP014265.1\|	294671	g407348	i0	100	0.187878787878788	31	0	19	0	65	95	382332	382362	Methanobrevibacter olleyae strain YLM1 chromosome, complete genome	blastn	31	58.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter olleyae
6996658	6996658	PRJNA643700_P_NODE_203606_length_275_cov_1.840708_g202050_i0	PRJNA643700	203606	275	1.840708	5.061947	Methanobrevibacter arboriphilus	39441	Archaea	Archaea	54.7	0.007	NTclustered	gi\|2047640843\|dbj\|AP019779.1\|	39441	g202050	i0	100	0.105454545454545	29	0	11	0	62	90	2275136	2275108	Methanobrevibacter arboriphilus SA DNA, complete genome	blastn	29	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter arboriphilus
6996874	6996874	PRJNA643700_P_NODE_413126_length_164_cov_1.191304_g411570_i0	PRJNA643700	413126	164	1.191304	1.95373856	Methanocaldococcus fervens	83171	Archaea	Archaea	52.8	0.014	NTclustered	gi\|256793173\|gb\|CP001696.1\|	573064	g411570	i0	100	0.170731707317073	28	0	17	0	92	119	1360328	1360355	Methanocaldococcus fervens AG86, complete genome	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus fervens
10822495	10822495	PRJNA643700_P_NODE_400689_length_166_cov_2.487179_g399133_i0	PRJNA643700	400689	166	2.487179	4.12871714	Methanobacterium sp. BAmetb5	2025351	Archaea	Archaea	52.8	0.014	NTclustered	gi\|1473089901\|gb\|CP022706.1\|	2025351	g399133	i0	100	0.168674698795181	28	0	17	0	109	136	770463	770436	MAG: Methanobacterium sp. BAmetb5 chromosome, complete genome	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. BAmetb5
16461412	16461412	PRJNA643700_P_NODE_248233_length_241_cov_1.078125_g246677_i0	PRJNA643700	248233	241	1.078125	2.59828125	Halalkalicoccus	332246	Archaea	Archaea	351	1.91e-92	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g246677	i0	92.946	108.336099585062	241	17	100	0	1	241	1440	1680	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	26109	351	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
19744901	19744901	PRJNA643700_P_NODE_118276_length_381_cov_1.825301_g116721_i0	PRJNA643700	118276	381	1.825301	6.95439681	uncultured Thermoplasmata archaeon	376542	Archaea	Archaea	52.8	0.036	NTclustered	gi\|2874253895\|emb\|OY970070.1\|	376542	g116721	i0	100	0.073490813648294	28	0	7	0	338	365	1484957	1484930	MAG: uncultured Thermoplasmata archaeon isolate MFD04408.bin.c.5 genome assembly, chromosome: 1	blastn	28	52.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				uncultured Thermoplasmata archaeon
28912632	28912632	PRJNA643700_P_NODE_225748_length_257_cov_1.389423_g224192_i0	PRJNA643700	225748	257	1.389423	3.57081711	Methanobacteriota archaeon	2026739	Archaea	Archaea	42.7	0.0443	NR	MBI4394391.1	2026739	g224192	i0	35.9	0.455252918287938	39	25	45.5	0	176	60	250	288	MBI4394391.1 ATP-dependent DNA helicase [Methanobacteriota archaeon]	diamond	117	42.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29304015	29304015	PRJNA643700_P_NODE_386429_length_169_cov_1.300000_g384873_i0	PRJNA643700	386429	169	1.3	2.197	Thermococcus	2263	Archaea	Archaea	116	1.74e-28	NR	WP_167728776.1	163002	g384873	i0	100	11.715976331360901	55	0	97.6	0	3	167	1753	1807	WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3]	diamond	1980	116	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. 9N3
31281850	31281850	PRJNA643700_P_NODE_303575_length_208_cov_1.283019_g302019_i0	PRJNA643700	303575	208	1.283019	2.66867952	Thermoplasmatota archaeon	2806419	Archaea	Archaea	42.4	0.0322	NR	MCL4325535.1	2806419	g302019	i0	35.5	0.894230769230769	62	38	86.5	1	18	197	1152	1213	MCL4325535.1 protease pro-enzyme activation domain-containing protein [Thermoplasmatota archaeon]	diamond	186	42.4	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);;