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

5 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax_kingdom = "Thermoproteati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27573109	27573109	PRJNA1092581_P_NODE_47744_length_390_cov_10.447950_g47211_i0	PRJNA1092581	47744	390	10.44795	40.747005	Candidatus Methanomethylicaceae archaeon	2282146	Archaea	Archaea	196	2.539999999999999e-55	NR	MEM2002060.1	3058293	g47211	i0	68.5	0.953846153846154	124	38	94.6	1	381	13	665	788	MEM2002060.1 RNase H-like domain-containing protein [Candidatus Methanomethylicaceae archaeon]	diamond	372	196	1	Archaea	Thermoproteati	Candidatus Methanomethylicota	Candidatus Methanomethylicia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae		Candidatus Methanomethylicaceae archaeon
29277929	29277929	PRJNA1092581_P_NODE_53769_length_364_cov_7.731959_g53236_i0	PRJNA1092581	53769	364	7.731959	28.14433076	Nitrososphaerales archaeon	2268197	Archaea	Archaea	127	2.91e-31	NR	HEY6282667.1	2268197	g53236	i0	54.6	1.78846153846154	108	49	89	0	21	344	355	462	HEY6282667.1 RNase H-like domain-containing protein [Nitrososphaerales archaeon]	diamond	651	127	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales archaeon
29372826	29372826	PRJNA1092581_P_NODE_113449_length_234_cov_4.385093_g112916_i0	PRJNA1092581	113449	234	4.385093	10.26111762	Nitrososphaera sp.	1971748	Archaea	Archaea	74.7	1.83e-13	NR	HEY9406945.1	1971748	g112916	i0	89.1	0.58974358974359	46	5	59	0	73	210	402	447	HEY9406945.1 multicopper oxidase domain-containing protein [Nitrososphaera sp.]	diamond	138	74.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
29688246	29688246	PRJNA1092581_P_NODE_55590_length_358_cov_2.126316_g55057_i0	PRJNA1092581	55590	358	2.126316	7.61221128	Nitrososphaerota archaeon	2026795	Archaea	Archaea	84	4.64e-17	NR	MDG7000370.1	2026795	g55057	i0	58.5	2.19553072625698	65	27	54.5	0	163	357	3	67	MDG7000370.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	786	84	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31553204	31553204	PRJNA1092581_P_NODE_76896_length_296_cov_2.757848_g76363_i0	PRJNA1092581	76896	296	2.757848	8.16323008	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	145	5.81e-40	NR	MDW0137090.1	2169593	g76363	i0	79.3	4.15540540540541	82	17	83.1	0	266	21	239	320	MDW0137090.1 polysaccharide deacetylase family protein [Nitrososphaeraceae archaeon]	diamond	1230	145	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae 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);;