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

5 rows where analysis = "blastn", bioproject = "PRJNA835051" 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
4654697	4654697	PRJNA835051_S_NODE_60884_length_203_cov_2.387500_g60588_i0	PRJNA835051	60884	203	2.3875	4.846625	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	52.8	0.018	NTclustered	gi\|2258811197\|gb\|CP060218.1\|	2026803	g60588	i0	100	0.413793103448276	28	0	14	0	130	157	118899	118926	MAG: Candidatus Woesearchaeota archaeon isolate HK-STAS-Nano-1 chromosome, complete genome	blastn	84	52.8	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
13983383	13983383	PRJNA835051_S_NODE_51751_length_214_cov_2.701754_g51455_i0	PRJNA835051	51751	214	2.701754	5.78175356	Methanosarcina	2207	Archaea	Archaea	52.8	0.019	NTclustered	gi\|2515741548\|gb\|CP117271.1\|	2209	g51455	i0	88.636	2.67289719626168	44	3	21	1	48	91	465414	465373	Mutant Methanosarcina mazei strain Mm Mut 208, complete genome	blastn	572	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
19952085	19952085	PRJNA835051_S_NODE_133956_length_150_cov_0.887850_g133660_i0	PRJNA835051	133956	150	0.88785	1.331775	Natrialba magadii	13769	Archaea	Archaea	63.9	5.64e-6	NTclustered	gi\|289529249\|gb\|CP001932.1\|	547559	g133660	i0	100	51.5533333333333	34	0	23	0	45	78	3095408	3095375	Natrialba magadii ATCC 43099, complete sequence	blastn	7733	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba magadii
23778385	23778385	PRJNA835051_S_NODE_38679_length_233_cov_47.389474_g38383_i0	PRJNA835051	38679	233	47.389474	110.41747442	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.021	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g38383	i0	100	0.120171673819742	28	0	12	0	76	103	336127	336100	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
23779095	23779095	PRJNA835051_S_NODE_9819_length_327_cov_1.637324_g9523_i0	PRJNA835051	9819	327	1.637324	5.35404948	Candidatus Nanopusillus acidilobi	1577684	Archaea	Archaea	52.8	0.031	NTclustered	gi\|985630447\|gb\|CP010514.1\|	1577684	g9523	i0	100	0.0856269113149847	28	0	9	0	140	167	237711	237684	Candidatus Nanopusillus acidilobi strain 7A chromosome, complete genome	blastn	28	52.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Nanoarchaeales	Nanopusillaceae	Candidatus Nanopusillus	Candidatus Nanopusillus acidilobi

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