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

6 rows where bioproject = "PRJNA812715" and tax_kingdom = "Promethearchaeati"

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_species
29233392	29233392	PRJNA812715_P_NODE_24749_length_644_cov_1.702277_g23040_i0	PRJNA812715	24749	644	1.702277	10.96266388	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	115	1.91e-26	NR	MCY3413445.1	2026747	g23040	i0	36.6	0.954968944099379	205	119	94.1	5	642	37	154	350	MCY3413445.1 VWA domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	615	115	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
29706448	29706448	PRJNA812715_P_NODE_26890_length_602_cov_2.143667_g25149_i0	PRJNA812715	26890	602	2.143667	12.90487534	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	72.4	5.09e-11	NR	MCY3412321.1	2026747	g25149	i0	41.7	1.13621262458472	228	97	95.7	2	600	25	172	399	MCY3412321.1 SPFH domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	684	72.4	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
31517013	31517013	PRJNA812715_P_NODE_36696_length_475_cov_2.870647_g34908_i0	PRJNA812715	36696	475	2.870647	13.63557325	root	1	Root_unresolved	Root_unresolved	211	6.22e-64	NR	OLS15498.1	1849166	g34908	i0	67.1	6.61263157894737	149	49	94.1	0	474	28	260	408	OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4]	diamond	3141	211	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon CR_4
31539828	31539828	PRJNA812715_P_NODE_82576_length_280_cov_1.801932_g80776_i0	PRJNA812715	82576	280	1.801932	5.0454096	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	137	1.65e-36	NR	OLS15498.1	1849166	g80776	i0	69.9	0.996428571428571	93	28	99.6	0	2	280	242	334	OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4]	diamond	279	137	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon CR_4
32267482	32267482	PRJNA812715_P_NODE_57798_length_347_cov_1.295620_g55999_i0	PRJNA812715	57798	347	1.29562	4.4958014	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	167	8.559999999999999e-48	NR	OLS15498.1	1849166	g55999	i0	69.6	0.994236311239193	115	35	99.4	0	3	347	245	359	OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4]	diamond	345	167	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon CR_4
32677826	32677826	PRJNA812715_P_NODE_30640_length_545_cov_1.167373_g28875_i0	PRJNA812715	30640	545	1.167373	6.36218285	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	214	1.35e-64	NR	OLS15498.1	1849166	g28875	i0	60.4	1.98715596330275	182	69	99.6	2	544	2	78	257	OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4]	diamond	1083	214	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon CR_4

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