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

7 rows where bioproject = "PRJNA900028" and tax_kingdom = "Thermoproteati"

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_species
5073097	5073097	PRJNA900028_P_NODE_188064_length_161_cov_1.366071_g187315_i0	PRJNA900028	188064	161	1.366071	2.19937431	root	1	Root_unresolved	Root_unresolved	292	7.24e-75	NTclustered	gi\|18996831\|gb\|AF473887.1\|	29281	g187315	i0	99.379	99.8136645962733	161	1	100	0	1	161	213	373	Uncultured crenarchaeote r-5_08K 16S ribosomal RNA gene, partial sequence	blastn	16070	292	1	Archaea	Thermoproteati	Thermoproteota				uncultured crenarchaeote
16178343	16178343	PRJNA900028_P_NODE_4933_length_484_cov_1.466667_g4197_i0	PRJNA900028	4933	484	1.466667	7.09866828	uncultured crenarchaeote	29281	Archaea	Archaea	750	0	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g4197	i0	94.628	104.473140495868	484	26	100	0	1	484	42481	42964	Uncultured crenarchaeote genomic fragment 54d9	blastn	50565	750	1	Archaea	Thermoproteati	Thermoproteota				uncultured crenarchaeote
26612431	26612431	PRJNA900028_P_NODE_112761_length_170_cov_1.107438_g112012_i0	PRJNA900028	112761	170	1.107438	1.8826446	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	89	7.16e-19	NR	MDW3645339.1	2169593	g112012	i0	76.4	0.970588235294118	55	13	97.1	0	166	2	410	464	MDW3645339.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	165	89	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaeraceae archaeon
28729553	28729553	PRJNA900028_P_NODE_110727_length_171_cov_1.008197_g109978_i0	PRJNA900028	110727	171	1.008197	1.72401687	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	97.4	1.55e-22	NR	HVD08304.1	2169593	g109978	i0	78.9	2	57	12	100	0	1	171	92	148	HVD08304.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon]	diamond	342	97.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaeraceae archaeon
30656033	30656033	PRJNA900028_P_NODE_172873_length_163_cov_0.894737_g172124_i0	PRJNA900028	172873	163	0.894737	1.45842131	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	68.2	1.34e-11	NR	HUK43305.1	3045160	g172124	i0	65.4	2.79754601226994	52	18	95.7	0	8	163	81	132	HUK43305.1 VWA domain-containing protein [Candidatus Bathyarchaeia archaeon]	diamond	456	68.2	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia			Candidatus Bathyarchaeia archaeon
31604482	31604482	PRJNA900028_P_NODE_60776_length_196_cov_1.387755_g60027_i0	PRJNA900028	60776	196	1.387755	2.7199998	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	124	3.92e-31	NR	MDW0150286.1	2169593	g60027	i0	98.5	0.994897959183674	65	1	99.5	0	2	196	26	90	MDW0150286.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	195	124	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaeraceae archaeon
31604493	31604493	PRJNA900028_P_NODE_90596_length_180_cov_1.549618_g89847_i0	PRJNA900028	90596	180	1.549618	2.7893124	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	82.4	1.63e-16	NR	HEY8522856.1	2169593	g89847	i0	76.4	0.916666666666667	55	12	91.7	1	167	3	463	516	HEY8522856.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	165	82.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaeraceae 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);;