metadata: contig_metadata: 8 rows where bioproject = "PRJNA981359" and tax

8 rows where bioproject = "PRJNA981359" 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_species
13716143	13716143	PRJNA981359_S_NODE_38591_length_305_cov_4.469828_g38491_i0	PRJNA981359	38591	305	4.469828	13.6329754	uncultured Poseidoniia archaeon	1697135	Archaea	Archaea	52.8	0.028	NTclustered	gi\|730903793\|gb\|KP211874.1\|	1697135	g38491	i0	100	0.0918032786885246	28	0	9	0	98	125	17103	17130	Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-OCT2007-C2085 genomic sequence	blastn	28	52.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	uncultured Poseidoniia archaeon
13716163	13716163	PRJNA981359_S_NODE_39191_length_304_cov_2.329004_g39091_i0	PRJNA981359	39191	304	2.329004	7.08017216	Promethearchaeia archaeon	3067280	Archaea	Archaea	104	1.8299999999999994e-23	NR	MFO7795213.1	3067280	g39091	i0	76.3	0.582236842105263	59	14	58.2	0	128	304	306	364	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	177	104	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
27942445	27942445	PRJNA981359_S_NODE_46485_length_288_cov_1.567442_g46385_i0	PRJNA981359	46485	288	1.567442	4.51423296	Promethearchaeia archaeon	3067280	Archaea	Archaea	67.8	4.2e-11	NR	MFO7797710.1	3067280	g46385	i0	71.4	0.4375	42	12	43.8	0	127	2	70	111	MFO7797710.1 hypothetical protein [Promethearchaeia archaeon]	diamond	126	67.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
28068589	28068589	PRJNA981359_S_NODE_44945_length_291_cov_2.711009_g44845_i0	PRJNA981359	44945	291	2.711009	7.88903619	Promethearchaeia archaeon	3067280	Archaea	Archaea	140	2.26e-36	NR	MFO7795213.1	3067280	g44845	i0	76	0.989690721649485	96	23	99	0	3	290	916	1011	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	288	140	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
29678558	29678558	PRJNA981359_S_NODE_34170_length_316_cov_3.082305_g34070_i0	PRJNA981359	34170	316	3.082305	9.7400838	Promethearchaeia archaeon	3067280	Archaea	Archaea	80.9	3.57e-15	NR	MFO7795213.1	3067280	g34070	i0	69.6	0.531645569620253	56	17	53.2	0	209	42	696	751	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	168	80.9	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
29994879	29994879	PRJNA981359_S_NODE_58571_length_264_cov_1.225131_g58471_i0	PRJNA981359	58571	264	1.225131	3.23434584	Promethearchaeia archaeon	3067280	Archaea	Archaea	45.4	0.00543	NR	MFO7795213.1	3067280	g58471	i0	72.4	0.329545454545455	29	8	33	0	158	244	813	841	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	87	45.4	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
31226838	31226838	PRJNA981359_S_NODE_46835_length_287_cov_2.532710_g46735_i0	PRJNA981359	46835	287	2.53271	7.2688777	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.1	0.00952	NR	MDH7507601.1	2806419	g46735	i0	34.5	0.574912891986063	55	29	51.2	2	15	161	42	95	MDH7507601.1 aldehyde:ferredoxin oxidoreductase [Thermoplasmatota archaeon]	diamond	165	43.1	1	Archaea	Methanobacteriati	Thermoplasmatota		Thermoplasmatota archaeon
31416755	31416755	PRJNA981359_S_NODE_24436_length_344_cov_2.708487_g24336_i0	PRJNA981359	24436	344	2.708487	9.31719528	Promethearchaeia archaeon	3067280	Archaea	Archaea	209	4.4e-60	NR	MFO7795213.1	3067280	g24336	i0	86.8	0.994186046511628	114	15	99.4	0	343	2	235	348	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	342	209	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia 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);;