metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA488043" 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
27170970	27170970	PRJNA488043_P_NODE_20482_length_167_cov_1.963768_g18240_i0	PRJNA488043	20482	167	1.963768	3.27949256	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	70.5	2.17e-12	NR	RLI37484.1	2026714	g18240	i0	66	1.86826347305389	53	18	95.2	0	161	3	170	222	RLI37484.1 MAG: hypothetical protein DRO66_03775 [Candidatus Bathyarchaeota archaeon]	diamond	312	70.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
27250395	27250395	PRJNA488043_P_NODE_15243_length_224_cov_2.312821_g13001_i0	PRJNA488043	15243	224	2.312821	5.18071904	root	1	Root_unresolved	Root_unresolved	71.6	6.62e-14	NR	MDX1532587.1	2202732	g13001	i0	51.4	1.94196428571429	72	35	96.4	0	224	9	23	94	MDX1532587.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	435	71.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
30076222	30076222	PRJNA488043_P_NODE_2112_length_1066_cov_3.185149_g621_i2	PRJNA488043	2112	1066	3.185149	33.95368834	Candidatus Methanomethylicaceae archaeon	2282146	Archaea	Archaea	52.4	4.83e-5	NR	MEM2002118.1	3058293	g621	i2	42.2	0.180112570356473	64	35	18	2	882	691	1	62	MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon]	diamond	192	52.4	1	Archaea	Thermoproteati	Candidatus Methanomethylicota	Candidatus Methanomethylicia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae		Candidatus Methanomethylicaceae archaeon
30613335	30613335	PRJNA488043_P_NODE_20613_length_166_cov_1.518248_g18371_i0	PRJNA488043	20613	166	1.518248	2.52029168	Nitrosarchaeum koreense	1088740	Archaea	Archaea	52	7.25e-6	NR	WP_007550483.1	1088740	g18371	i0	56.4	2.02409638554217	55	20	94	3	8	163	516	569	WP_007550483.1 hypothetical protein [Nitrosarchaeum koreense]	diamond	336	52	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum koreense
31024251	31024251	PRJNA488043_P_NODE_2055_length_1087_cov_3.140832_g621_i1	PRJNA488043	2055	1087	3.140832	34.14084384	Candidatus Methanomethylicaceae archaeon	2282146	Archaea	Archaea	52.4	4.94e-5	NR	MEM2002118.1	3058293	g621	i1	42.2	0.176632934682613	64	35	17.7	2	903	712	1	62	MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon]	diamond	192	52.4	1	Archaea	Thermoproteati	Candidatus Methanomethylicota	Candidatus Methanomethylicia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae		Candidatus Methanomethylicaceae archaeon
31719839	31719839	PRJNA488043_P_NODE_2157_length_1053_cov_3.283203_g621_i3	PRJNA488043	2157	1053	3.283203	34.57212759	Candidatus Methanomethylicaceae archaeon	2282146	Archaea	Archaea	52.4	4.77e-5	NR	MEM2002118.1	3058293	g621	i3	42.2	0.182336182336182	64	35	18.2	2	864	673	1	62	MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon]	diamond	192	52.4	1	Archaea	Thermoproteati	Candidatus Methanomethylicota	Candidatus Methanomethylicia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae		Candidatus Methanomethylicaceae 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);;