metadata: contig_metadata: 6 rows where bioproject = "PRJNA672101" and tax

6 rows where bioproject = "PRJNA672101" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5745545	5745545	PRJNA672101_S_NODE_35425_length_201_cov_49.367188_g35394_i0	PRJNA672101	35425	201	49.367188	99.22804788	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.017	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g35394	i0	100	0.139303482587065	28	0	14	0	22	49	336127	336100	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
27587374	27587374	PRJNA672101_S_NODE_17304_length_298_cov_4.800000_g17273_i0	PRJNA672101	17304	298	4.8	14.304	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	99	8.28e-22	NR	MCW4044179.1	2026714	g17273	i0	48.5	0.976510067114094	97	49	97.7	1	1	291	361	456	MCW4044179.1 SLC13 family permease [Candidatus Bathyarchaeota archaeon]	diamond	291	99	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
27630917	27630917	PRJNA672101_S_NODE_24604_length_266_cov_1.196891_g24573_i0	PRJNA672101	24604	266	1.196891	3.18373006	root	1	Root_unresolved	Root_unresolved	46.6	0.0021	NR	WP_148313062.1	1580092	g24573	i0	37.5	1.31954887218045	72	43	78.9	1	255	46	38	109	WP_148313062.1 YncE family protein [Nitrosopumilus adriaticus]	diamond	351	46.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus adriaticus
27871352	27871352	PRJNA672101_S_NODE_13405_length_322_cov_3.755020_g13374_i0	PRJNA672101	13405	322	3.75502	12.0911644	archaeon	1906665	Archaea	Archaea	79.7	1.49e-16	NR	NCQ52385.1	1906665	g13374	i0	57.8	0.596273291925466	64	27	59.6	0	123	314	18	81	NCQ52385.1 hypothetical protein [archaeon]	diamond	192	79.7	1	Archaea							archaeon
31187254	31187254	PRJNA672101_S_NODE_27215_length_255_cov_4.230769_g27184_i0	PRJNA672101	27215	255	4.230769	10.78846095	archaeon	1906665	Archaea	Archaea	82.4	2.38e-16	NR	MDP2439154.1	1906665	g27184	i0	49.2	3.8	65	33	76.5	0	254	60	215	279	MDP2439154.1 DENN domain-containing protein [archaeon]	diamond	969	83.2	0.990384615384615	Archaea							archaeon
32010037	32010037	PRJNA672101_S_NODE_27498_length_254_cov_6.662983_g27467_i0	PRJNA672101	27498	254	6.662983	16.92397682	archaeon RBG_16_5	1906665	Archaea	Archaea	43.5	0.0214	NR	OFX15113.1	1797286	g27467	i0	36.1	0.850393700787402	72	37	82.7	2	32	241	98	162	OFX15113.1 MAG: hypothetical protein A3K71_01555 [archaeon RBG_16_50_20]	diamond	216	43.5	1	Archaea							archaeon RBG_16_50_20

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