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

5 rows where bioproject = "PRJNA1195551" 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
1597202	1597202	PRJNA1195551_S_NODE_29482_length_186_cov_17.576642_g29129_i0	PRJNA1195551	29482	186	17.576642	32.69255412	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.016	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g29129	i0	100	0.150537634408602	28	0	15	0	157	184	336100	336127	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
5425801	5425801	PRJNA1195551_S_NODE_7965_length_320_cov_9.335793_g7612_i0	PRJNA1195551	7965	320	9.335793	29.8745376	Nitrosopumilus adriaticus	1580092	Archaea	Archaea	62.1	4.99e-5	NTclustered	gi\|2790751567\|gb\|CP167059.1\|	1580092	g7612	i0	97.222	0.1125	36	1	11	0	240	275	882923	882958	Nitrosopumilus adriaticus strain CCS1 chromosome	blastn	36	62.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus adriaticus
11801057	11801057	PRJNA1195551_S_NODE_16030_length_246_cov_2.659898_g15677_i0	PRJNA1195551	16030	246	2.659898	6.54334908	Methanosphaera sp. ISO3-F5	1452353	Archaea	Archaea	52.8	0.022	NTclustered	gi\|2695672541\|gb\|CP118754.2\|	1452353	g15677	i0	100	0.113821138211382	28	0	11	0	160	187	141713	141740	Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. ISO3-F5
21999321	21999321	PRJNA1195551_S_NODE_20198_length_222_cov_11.560694_g19845_i0	PRJNA1195551	20198	222	11.560694	25.66474068	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.02	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g19845	i0	100	0.126126126126126	28	0	13	0	66	93	336127	336100	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
24548695	24548695	PRJNA1195551_S_NODE_26080_length_198_cov_1.395973_g25727_i0	PRJNA1195551	26080	198	1.395973	2.76402654	Halorarum halophilum	2743090	Archaea	Archaea	58.4	3.69e-4	NTclustered	gi\|1868817999\|gb\|CP058529.1\|	2743090	g25727	i0	94.737	0.191919191919192	38	1	19	1	135	171	2677631	2677594	Halorarum halophilum strain Gai3-2 chromosome, complete genome	blastn	38	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorarum	Halorarum halophilum

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