metadata: contig_metadata: 5 rows where bioproject = "PRJNA793147" and tax

5 rows where bioproject = "PRJNA793147" and tax_superkingdom = "Archaea"

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
4606673	4606673	PRJNA793147_P_NODE_62044_length_226_cov_0.917197_g61778_i0	PRJNA793147	62044	226	0.917197	2.07286522	Natronomonas pharaonis	2257	Archaea	Archaea	281	2.36e-71	NTclustered	gi\|76556520\|emb\|CR936257.1\|	348780	g61778	i0	96.491	16.3628318584071	171	5	100	1	57	226	1414845	1414675	Natronomonas pharaonis DSM 2160 complete genome	blastn	3698	281	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas pharaonis
14806742	14806742	PRJNA793147_P_NODE_54992_length_232_cov_0.883436_g54726_i0	PRJNA793147	54992	232	0.883436	2.04957152	Halorubrum vacuolatum	63740	Archaea	Archaea	131	4.16e-34	NR	WP_089383787.1	63740	g54726	i0	75.3	2.98706896551724	77	19	99.6	0	232	2	155	231	WP_089383787.1 4-alpha-glucanotransferase [Halorubrum vacuolatum]	diamond	693	131	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum vacuolatum
17355970	17355970	PRJNA793147_P_NODE_28754_length_311_cov_1.545455_g28488_i0	PRJNA793147	28754	311	1.545455	4.80636505	uncultured archaeon	115547	Archaea	Archaea	547	3.0399999999999987e-151	NTclustered	gi\|283837223\|dbj\|AB541780.1\|	115547	g28488	i0	98.392	104.627009646302	311	5	100	0	1	311	44	354	Uncultured archaeon gene for 16S rRNA, partial sequence, clone: K09_10_18	blastn	32539	547	1	Archaea								uncultured archaeon
22455366	22455366	PRJNA793147_P_NODE_54538_length_232_cov_0.883436_g54272_i0	PRJNA793147	54538	232	0.883436	2.04957152	Haloparvum sedimenti	1678448	Archaea	Archaea	124	2.49e-32	NR	WP_058366639.1	1678448	g54272	i0	75	0.982758620689655	76	19	98.3	0	228	1	237	312	WP_058366639.1 alpha/beta fold hydrolase [Haloparvum sedimenti]	diamond	228	124	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloparvum	Haloparvum sedimenti
31476025	31476025	PRJNA793147_P_NODE_60196_length_227_cov_1.797468_g59930_i0	PRJNA793147	60196	227	1.797468	4.08025236	archaeon	1906665	Archaea	Archaea	82	2.86e-18	NR	RYH05204.1	1906665	g59930	i0	60.3	0.898678414096916	68	27	89.9	0	6	209	28	95	RYH05204.1 MAG: hypothetical protein EON65_45345 [archaeon]	diamond	204	82	1	Archaea								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);;