metadata: contig_metadata: 8 rows where bioproject = "PRJNA352850" and tax

8 rows where bioproject = "PRJNA352850" 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
13148393	13148393	PRJNA352850_P_NODE_13291_length_876_cov_13.438936_g10763_i0	PRJNA352850	13291	876	13.438936	117.72507936	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	441	1.81e-146	NR	WP_295614768.1	253161	g10763	i0	76.7	1.82191780821918	266	62	91.1	0	1	798	555	820	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	1596	441	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
23348090	23348090	PRJNA352850_P_NODE_58579_length_305_cov_2.140625_g55746_i0	PRJNA352850	58579	305	2.140625	6.52890625	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	142	1.02e-36	NR	WP_295614768.1	253161	g55746	i0	69.1	1.84918032786885	94	29	92.5	0	304	23	727	820	WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.]	diamond	564	142	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29096010	29096010	PRJNA352850_P_NODE_5888_length_1624_cov_8.551746_g4124_i0	PRJNA352850	5888	1624	8.551746	138.88035504	Methanobrevibacter sp.	66852	Archaea	Archaea	875	1.94999999999874e-293	NR	WP_405277409.1	66852	g4124	i0	81.3	0.977216748768473	529	95	97.5	2	1622	39	304	829	WP_405277409.1 AAA family ATPase [Methanobrevibacter sp.]	diamond	1587	875	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29222361	29222361	PRJNA352850_P_NODE_18969_length_675_cov_5.266773_g16233_i0	PRJNA352850	18969	675	5.266773	35.55071775	Methanobrevibacter sp.	66852	Archaea	Archaea	251	1.6999999999999996e-75	NR	WP_405306311.1	66852	g16233	i0	67.4	1.64888888888889	184	60	81.8	0	675	124	456	639	WP_405306311.1 HAD-IC family P-type ATPase, partial [Methanobrevibacter sp.]	diamond	1113	251	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29821837	29821837	PRJNA352850_P_NODE_43811_length_374_cov_2.612308_g40978_i0	PRJNA352850	43811	374	2.612308	9.77003192	Methanobrevibacter sp.	66852	Archaea	Archaea	106	2.06e-26	NR	MEE3444538.1	66852	g40978	i0	49.5	0.82620320855615	103	51	81.8	1	8	313	61	163	MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.]	diamond	309	106	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30169433	30169433	PRJNA352850_P_NODE_31872_length_468_cov_3.315036_g29042_i0	PRJNA352850	31872	468	3.315036	15.51436848	Methanobacteriota archaeon	2026739	Archaea	Archaea	57.4	2.52e-6	NR	MBV06856.1	2026739	g29042	i0	34.5	0.743589743589744	116	74	73.1	1	123	464	2	117	MBV06856.1 hypothetical protein [Methanobacteriota archaeon]	diamond	348	57.4	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31338700	31338700	PRJNA352850_P_NODE_73896_length_261_cov_0.962264_g71063_i0	PRJNA352850	73896	261	0.962264	2.51150904	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	43.1	0.032	NR	MDP6912354.1	2670411	g71063	i0	39.6	0.551724137931034	48	29	55.2	0	224	81	240	287	MDP6912354.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Thalassarchaeaceae archaeon]	diamond	144	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae		Candidatus Thalassarchaeaceae archaeon
32477862	32477862	PRJNA352850_P_NODE_50559_length_338_cov_3.148789_g47726_i0	PRJNA352850	50559	338	3.148789	10.64290682	Methanobrevibacter sp.	66852	Archaea	Archaea	94.4	8.86e-22	NR	MEE3444538.1	66852	g47726	i0	51.6	0.825443786982249	93	44	81.7	1	337	62	71	163	MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.]	diamond	279	94.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.

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