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

5 rows where analysis = "diamond", bioproject = "PRJNA615175" 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
26763774	26763774	PRJNA615175_P_NODE_2821_length_923_cov_11.580000_g2688_i0	PRJNA615175	2821	923	11.58	106.8834	Nitrosopumilus sp.	2024843	Archaea	Archaea	105	2.5e-24	NR	MBA3285058.1	2024843	g2688	i0	76.5	0.221018418201517	68	16	22.1	0	64	267	27	94	MBA3285058.1 hypothetical protein [Nitrosopumilus sp.]	diamond	204	105	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
26763776	26763776	PRJNA615175_P_NODE_35821_length_237_cov_3.518293_g35653_i0	PRJNA615175	35821	237	3.518293	8.33835441	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	143	4.069999999999999e-41	NR	HYP43440.1	2109671	g35653	i0	100	4.48101265822785	71	0	89.9	0	235	23	63	133	HYP43440.1 deoxyhypusine synthase family protein [Candidatus Nitrosocosmicus sp.]	diamond	1062	143	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
27535751	27535751	PRJNA615175_P_NODE_26563_length_259_cov_2.935484_g26395_i0	PRJNA615175	26563	259	2.935484	7.60290356	root	1	Root_unresolved	Root_unresolved	105	1.06e-24	NR	HEU0143677.1	1971748	g26395	i0	56.6	1.92277992277992	83	36	96.1	0	250	2	19	101	HEU0143677.1 IS4 family transposase [Nitrososphaera sp.]	diamond	498	106	0.990566037735849	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30143136	30143136	PRJNA615175_P_NODE_2892_length_914_cov_18.868014_g2688_i1	PRJNA615175	2892	914	18.868014	172.45364796	Nitrosopumilus sp.	2024843	Archaea	Archaea	105	2.35e-24	NR	MBA3285058.1	2024843	g2688	i1	76.5	0.223194748358862	68	16	22.3	0	851	648	27	94	MBA3285058.1 hypothetical protein [Nitrosopumilus sp.]	diamond	204	105	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31913621	31913621	PRJNA615175_P_NODE_14297_length_375_cov_3.105960_g14129_i0	PRJNA615175	14297	375	3.10596	11.64735	Thermofilaceae archaeon	2268203	Archaea	Archaea	95.5	1.49e-20	NR	MEM0307463.1	2268203	g14129	i0	38.6	8.312	132	65	94.4	2	20	373	77	206	MEM0307463.1 ribosome biogenesis/translation initiation ATPase RLI [Thermofilaceae archaeon]	diamond	3117	95.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae		Thermofilaceae 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);;