metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB39643" 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
3883261	3883261	PRJEB39643_P_NODE_101904_length_260_cov_1.647059_g101711_i0	PRJEB39643	101904	260	1.647059	4.2823534	Natrinema caseinilyticum	2961570	Archaea	Archaea	54.7	0.007	NTclustered	gi\|2270264148\|gb\|CP100445.1\|	2961570	g101711	i0	96.875	0.123076923076923	32	1	12	0	177	208	2004064	2004033	Natrinema caseinilyticum strain ZJ2 chromosome, complete genome	blastn	32	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema caseinilyticum
7710826	7710826	PRJEB39643_P_NODE_7727_length_732_cov_3.060698_g7559_i0	PRJEB39643	7727	732	3.060698	22.40430936	Methanobacterium sp. BRmetb2	2025350	Archaea	Archaea	54.7	0.02	NTclustered	gi\|1473087786\|gb\|CP022705.1\|	2025350	g7559	i0	94.444	0.0491803278688525	36	1	5	1	439	473	861936	861901	MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome	blastn	36	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. BRmetb2
17567292	17567292	PRJEB39643_P_NODE_28834_length_342_cov_3.635688_g28641_i0	PRJEB39643	28834	342	3.635688	12.43405296	Methanothrix	2222	Archaea	Archaea	326	1.73e-84	NTclustered	gi\|1361204214\|gb\|MH071177.1\|	115547	g28641	i0	98.901	95.1959064327485	182	2	94	0	161	342	235	416	Uncultured archaeon clone A5 16S ribosomal RNA gene, partial sequence	blastn	32557	326	1	Archaea								uncultured archaeon
18841296	18841296	PRJEB39643_P_NODE_99015_length_262_cov_1.629630_g98822_i0	PRJEB39643	99015	262	1.62963	4.2696306	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g98822	i0	100	0.248091603053435	29	0	11	0	169	197	1774954	1774926	Natronomonas moolapensis 8.8.11 complete genome	blastn	65	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
19182856	19182856	PRJEB39643_P_NODE_122776_length_251_cov_1.730337_g122583_i0	PRJEB39643	122776	251	1.730337	4.34314587	Haloplanus halophilus	2949993	Archaea	Archaea	52.8	0.023	NTclustered	gi\|2252468249\|gb\|CP098514.1\|	2949993	g122583	i0	100	0.111553784860558	28	0	11	0	142	169	2469130	2469103	Haloplanus sp. GDY1 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus halophilus

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