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

8 rows where bioproject = "PRJNA603943" 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
8229949	8229949	PRJNA603943_P_NODE_22887_length_364_cov_1.587629_g22695_i0	PRJNA603943	22887	364	1.587629	5.77896956	Methanobrevibacter sp.	66852	Archaea	Archaea	216	4.89e-68	NR	MBO7696889.1	66852	g22695	i0	79.3	0.997252747252747	121	25	99.7	0	363	1	158	278	MBO7696889.1 hypothetical protein [Methanobrevibacter sp.]	diamond	363	216	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
25369397	25369397	PRJNA603943_P_NODE_30500_length_327_cov_1.074803_g30308_i0	PRJNA603943	30500	327	1.074803	3.51460581	root	1	Root_unresolved	Root_unresolved	466	9.27e-127	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g30308	i0	92.447	294.296636085627	331	17	100	7	1	327	3116108	3115782	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	96235	470	0.991489361702128	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
26649871	26649871	PRJNA603943_P_NODE_27981_length_338_cov_1.086792_g27789_i0	PRJNA603943	27981	338	1.086792	3.67335696	root	1	Root_unresolved	Root_unresolved	213	1.1699999999999999e-68	NR	WP_400206037.1	1291540	g27789	i0	99	2.66272189349112	100	1	88.8	0	338	39	56	155	WP_400206037.1 group II intron maturase-specific domain-containing protein [Methanomethylophilus alvi]	diamond	900	215	0.990697674418605	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus alvi
27977583	27977583	PRJNA603943_P_NODE_33325_length_316_cov_1.267490_g33133_i0	PRJNA603943	33325	316	1.26749	4.0052684	root	1	Root_unresolved	Root_unresolved	104	2.08e-24	NR	MBO7733115.1	66852	g33133	i0	49	2.99050632911392	104	51	96.8	2	10	315	198	301	MBO7733115.1 DUF2184 domain-containing protein [Methanobrevibacter sp.]	diamond	945	104	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28374771	28374771	PRJNA603943_P_NODE_58446_length_248_cov_0.880000_g58254_i0	PRJNA603943	58446	248	0.88	2.1824	Methanobrevibacter sp.	66852	Archaea	Archaea	83.6	1.69e-16	NR	MBQ6628522.1	66852	g58254	i0	49.4	0.979838709677419	81	38	98	1	248	6	282	359	MBQ6628522.1 tail fiber protein [Methanobrevibacter sp.]	diamond	243	83.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29146224	29146224	PRJNA603943_P_NODE_64989_length_244_cov_0.900585_g64797_i0	PRJNA603943	64989	244	0.900585	2.1974274	Halarchaeum	744724	Archaea	Archaea	43.1	0.0276	NR	WP_188882153.1	1193105	g64797	i0	49	1.25409836065574	51	24	62.7	1	62	214	355	403	WP_188882153.1 BCCT family transporter [Halarchaeum grantii]	diamond	306	43.5	0.990804597701149	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halarchaeum	Halarchaeum grantii
30079794	30079794	PRJNA603943_P_NODE_35632_length_307_cov_1.316239_g35440_i0	PRJNA603943	35632	307	1.316239	4.04085373	Methanobrevibacter sp.	66852	Archaea	Archaea	172	3.78e-51	NR	MBO7696889.1	66852	g35440	i0	78.8	0.96742671009772	99	21	96.7	0	3	299	30	128	MBO7696889.1 hypothetical protein [Methanobrevibacter sp.]	diamond	297	172	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31691828	31691828	PRJNA603943_P_NODE_14177_length_438_cov_1.282192_g13985_i0	PRJNA603943	14177	438	1.282192	5.61600096	Thermoplasmatota archaeon	2806419	Archaea	Archaea	83.6	7.28e-16	NR	MEM4258088.1	2806419	g13985	i0	70	0.684931506849315	50	15	34.2	0	437	288	183	232	MEM4258088.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	300	83.6	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);;