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

5 rows where analysis = "blastn", bioproject = "PRJNA715462" 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
1982090	1982090	PRJNA715462_P_NODE_47002_length_260_cov_1.647059_g46206_i0	PRJNA715462	47002	260	1.647059	4.2823534	Halosimplex aquaticum	3026162	Archaea	Archaea	52.8	0.024	NTclustered	gi\|2446562039\|gb\|CP118159.1\|	3026162	g46206	i0	100	0.107692307692308	28	0	11	0	85	112	97193	97220	Halosimplex aquaticum strain XZYJT29 plasmid unnamed1, complete sequence	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex aquaticum
4534580	4534580	PRJNA715462_P_NODE_53784_length_249_cov_1.488636_g52988_i0	PRJNA715462	53784	249	1.488636	3.70670364	Methanobrevibacter sp. AbM4	224719	Archaea	Archaea	54.7	0.006	NTclustered	gi\|509083678\|gb\|CP004050.1\|	224719	g52988	i0	100	0.116465863453815	29	0	12	0	78	106	1653229	1653201	Methanobrevibacter sp. AbM4, complete genome	blastn	29	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. AbM4
4534595	4534595	PRJNA715462_P_NODE_54804_length_249_cov_0.875000_g54008_i0	PRJNA715462	54804	249	0.875	2.17875	Methanobacterium paludis	868131	Archaea	Archaea	52.8	0.023	NTclustered	gi\|333824386\|gb\|CP002772.1\|	868131	g54008	i0	96.774	0.124497991967871	31	1	12	0	70	100	1720585	1720615	Methanobacterium paludis strain SWAN1, complete genome	blastn	31	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium paludis
8359732	8359732	PRJNA715462_P_NODE_66547_length_242_cov_0.911243_g65751_i0	PRJNA715462	66547	242	0.911243	2.20520806	Haloferax volcanii	2246	Archaea	Archaea	442	1.1099999999999995e-119	NTclustered	gi\|291370026\|gb\|CP001956.1\|	309800	g65751	i0	99.587	15.603305785124	242	1	100	0	1	242	1516369	1516128	Haloferax volcanii DS2, complete sequence	blastn	3776	442	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax volcanii
18558322	18558322	PRJNA715462_P_NODE_68495_length_241_cov_0.916667_g67699_i0	PRJNA715462	68495	241	0.916667	2.20916747	Candidatus Nitrososphaera evergladensis	1459637	Archaea	Archaea	206	1.57e-48	NTclustered	gi\|665992324\|gb\|CP007174.1\|	1459636	g67699	i0	82.158	4	241	41	99	2	2	241	1519047	1518808	Candidatus Nitrososphaera evergladensis SR1, complete genome	blastn	964	206	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera evergladensis

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