metadata: contig_metadata: 7 rows where bioproject = "PRJNA560932" and tax

7 rows where bioproject = "PRJNA560932" 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_class	tax_order	tax_family	tax_genus	tax_species
22221626	22221626	PRJNA560932_P_NODE_21598_length_380_cov_1.368078_g21242_i0	PRJNA560932	21598	380	1.368078	5.1986964	Candidatus Lokiarchaeum ossiferum	2951803	Archaea	Archaea	56.5	0.003	NTclustered	gi\|2321196112\|gb\|CP104013.1\|	2951803	g21242	i0	100	0.0789473684210526	30	0	8	0	19	48	5843216	5843245	Candidatus Lokiarchaeum ossiferum isolate Loki-B35 chromosome, complete genome	blastn	30	56.5	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Lokiarchaeum	Candidatus Lokiarchaeum ossiferum
27282738	27282738	PRJNA560932_P_NODE_47383_length_265_cov_1.489583_g47027_i0	PRJNA560932	47383	265	1.489583	3.94739495	root	1	Root_unresolved	Root_unresolved	83.2	5.7e-17	NR	MBN1330218.1	2026747	g47027	i0	54.7	5.87547169811321	86	36	96.2	2	3	257	5	88	MBN1330218.1 VIT1/CCC1 transporter family protein [Candidatus Heimdallarchaeota archaeon]	diamond	1557	83.6	0.995215311004785	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
28247426	28247426	PRJNA560932_P_NODE_32066_length_320_cov_0.931174_g31710_i0	PRJNA560932	32066	320	0.931174	2.9797568	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	77.8	7.51e-15	NR	MDH5401859.1	2026747	g31710	i0	40.6	0.99375	106	61	98.4	2	1	315	67	171	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	318	77.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
29226670	29226670	PRJNA560932_P_NODE_60029_length_246_cov_0.890173_g59673_i0	PRJNA560932	60029	246	0.890173	2.18982558	Candidatus Thorarchaeota archaeon SMTZ1-83	1706445	Archaea	Archaea	126	2.41e-33	NR	KXH71080.1	1706445	g59673	i0	70.4	2.96341463414634	81	24	98.8	0	245	3	218	298	KXH71080.1 MAG: hypothetical protein AM324_09205 [Candidatus Thorarchaeota archaeon SMTZ1-83]	diamond	729	126	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon SMTZ1-83
30110598	30110598	PRJNA560932_P_NODE_59172_length_246_cov_1.277457_g58816_i0	PRJNA560932	59172	246	1.277457	3.14254422	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	62	6.18e-9	NR	MBD3190299.1	2026747	g58816	i0	39.5	0.926829268292683	76	45	91.5	1	12	236	365	440	MBD3190299.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	228	62	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
30914619	30914619	PRJNA560932_P_NODE_23134_length_369_cov_1.000000_g22778_i0	PRJNA560932	23134	369	1	3.69	Promethearchaeati	1935183	Archaea	Archaea	52.8	4.64e-5	NR	MBD3157852.1	2053489	g22778	i0	26.8	2.95934959349594	127	77	91.1	5	18	353	462	587	MBD3157852.1 hypothetical protein [Promethearchaeota archaeon]	diamond	1092	52.8	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32576916	32576916	PRJNA560932_P_NODE_38519_length_293_cov_1.050000_g38163_i0	PRJNA560932	38519	293	1.05	3.0765	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	55.8	1.6e-6	NR	MCE7735885.1	2026747	g38163	i0	36.8	0.778156996587031	76	44	76.8	2	20	244	357	429	MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon]	diamond	228	55.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon

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