metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA994052" 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
27152456	27152456	PRJNA994052_P_NODE_47702_length_245_cov_9.244186_g46451_i0	PRJNA994052	47702	245	9.244186	22.6482557	Methanobacterium sp.	2164	Archaea	Archaea	58.5	8.11e-8	NR	MEN6294369.1	2164	g46451	i0	34.5	1.42040816326531	116	39	96.7	1	5	241	80	195	MEN6294369.1 hypothetical protein [Methanobacterium sp.]	diamond	348	58.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
28510862	28510862	PRJNA994052_P_NODE_72787_length_209_cov_16.536765_g71531_i0	PRJNA994052	72787	209	16.536765	34.56183885	Methanoculleus sp.	90427	Archaea	Archaea	114	4.01e-28	NR	WP_292561231.1	90427	g71531	i0	76.9	0.933014354066986	65	15	93.3	0	2	196	178	242	WP_292561231.1 PBSX family phage terminase large subunit [Methanoculleus sp.]	diamond	195	114	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
31891362	31891362	PRJNA994052_P_NODE_29997_length_282_cov_5.899522_g28755_i0	PRJNA994052	29997	282	5.899522	16.63665204	Candidatus Poseidonia alphae	1915863	Archaea	Archaea	72.8	6.03e-13	NR	MDA7464330.1	1915863	g28755	i0	42.4	0.904255319148936	85	42	83	1	234	1	61	145	MDA7464330.1 alpha-1,2-fucosyltransferase [Candidatus Poseidonia alphae]	diamond	255	72.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidonia	Candidatus Poseidonia alphae
32239689	32239689	PRJNA994052_P_NODE_78938_length_202_cov_9.038760_g77681_i0	PRJNA994052	78938	202	9.03876	18.2582952	Halomarina salina	1872699	Archaea	Archaea	55.8	1.36e-7	NR	WP_247415064.1	1872699	g77681	i0	62.2	0.668316831683168	45	13	60.9	2	127	5	1	45	WP_247415064.1 hypothetical protein [Halomarina salina]	diamond	135	55.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina salina
32902107	32902107	PRJNA994052_P_NODE_64400_length_220_cov_4.884354_g63144_i0	PRJNA994052	64400	220	4.884354	10.7455788	Natronobeatus ordinarius	2963433	Archaea	Archaea	42	0.0482	NR	WP_255191692.1	2963433	g63144	i0	50	0.381818181818182	28	14	38.2	0	101	18	193	220	WP_255191692.1 esterase/lipase family protein [Natronobeatus ordinarius]	diamond	84	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronobeatus	Natronobeatus ordinarius

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