metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA446034" 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
2988825	2988825	PRJNA446034_S_NODE_3203_length_339_cov_8.407285_g3166_i0	PRJNA446034	3203	339	8.407285	28.50069615	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	70.9	8.99e-12	NR	MEK9698159.1	2163009	g3166	i0	52.3	1.38938053097345	65	31	57.5	0	2	196	29	93	MEK9698159.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	471	70.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
9366229	9366229	PRJNA446034_S_NODE_62008_length_174_cov_5.014599_g61971_i0	PRJNA446034	62008	174	5.014599	8.72540226	root	1	Root_unresolved	Root_unresolved	89.4	2.5e-19	NR	HIH96087.1	1906666	g61971	i0	62.1	54.948275862069	58	22	100	0	1	174	139	196	HIH96087.1 modification methylase [Thermoplasmata archaeon]	diamond	9561	90.1	0.992230854605993	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28686903	28686903	PRJNA446034_S_NODE_5327_length_303_cov_2.135338_g5290_i0	PRJNA446034	5327	303	2.135338	6.47007414	Methanosarcina sp.	2213	Archaea	Archaea	125	2.5699999999999997e-32	NR	HET8689160.1	2213	g5290	i0	62.9	2.71287128712871	89	33	88.1	0	295	29	19	107	HET8689160.1 ribonucleotide-diphosphate reductase subunit beta [Methanosarcina sp.]	diamond	822	125	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
32099138	32099138	PRJNA446034_S_NODE_51858_length_182_cov_2.544828_g51821_i0	PRJNA446034	51858	182	2.544828	4.63158696	Methanobacterium sp.	2164	Archaea	Archaea	67.4	5.89e-12	NR	MEN6290762.1	2164	g51821	i0	56.4	0.906593406593407	55	21	90.7	1	3	167	68	119	MEN6290762.1 HNH endonuclease signature motif containing protein [Methanobacterium sp.]	diamond	165	67.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium 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);;