metadata: contig_metadata: 5 rows where bioproject = "PRJNA928559", tax_kingdom = "Thermoproteati" and tax

5 rows where bioproject = "PRJNA928559", tax_kingdom = "Thermoproteati" and tax_phylum = "Thermoproteota"

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
8906069	8906069	PRJNA928559_P_NODE_95087_length_365_cov_3.308219_g93518_i0	PRJNA928559	95087	365	3.308219	12.07499935	Archaea	2157	Archaea	Archaea	603	7.629999999999998e-168	NTclustered	gi\|71842090\|gb\|DQ133425.1\|	29281	g93518	i0	96.448	99.772602739726	366	12	100	1	1	365	570	935	Uncultured crenarchaeote clone E548AIRAC 16S ribosomal RNA gene, partial sequence	blastn	36417	603	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
19104420	19104420	PRJNA928559_P_NODE_219715_length_234_cov_2.776398_g218146_i0	PRJNA928559	219715	234	2.776398	6.49677132	Thermoproteati	1783275	Archaea	Archaea	433	6.41e-117	NTclustered	gi\|82618470\|gb\|DQ278118.1\|	29281	g218146	i0	100	97.542735042735	234	0	100	0	1	234	1140	1373	Uncultured crenarchaeote clone OdenA-100ii 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer, complete sequence	blastn	22825	433	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
26644778	26644778	PRJNA928559_P_NODE_99201_length_358_cov_2.066667_g97632_i0	PRJNA928559	99201	358	2.066667	7.39866786	Saccharolobus caldissimus	1702097	Archaea	Archaea	43.9	0.05	NR	WP_229572040.1	1702097	g97632	i0	32.1	0.67877094972067	81	50	63.7	2	333	106	120	200	WP_229572040.1 hypothetical protein [Saccharolobus caldissimus]	diamond	243	43.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Saccharolobus	Saccharolobus caldissimus
27119416	27119416	PRJNA928559_P_NODE_95142_length_365_cov_2.794521_g93573_i0	PRJNA928559	95142	365	2.794521	10.20000165	Vulcanisaeta sp.	2020871	Archaea	Archaea	77.4	9.7e-14	NR	MFP3236626.1	2020871	g93573	i0	42.2	5.50684931506849	109	62	88.8	1	347	24	65	173	MFP3236626.1 aspartate aminotransferase family protein [Vulcanisaeta sp.]	diamond	2010	77.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta sp.
31446923	31446923	PRJNA928559_P_NODE_210876_length_243_cov_2.294118_g209307_i0	PRJNA928559	210876	243	2.294118	5.57470674	Thermoprotei archaeon	2250277	Archaea	Archaea	99.8	1.3e-23	NR	RLE57769.1	2250277	g209307	i0	58.4	0.950617283950617	77	32	95.1	0	233	3	8	84	RLE57769.1 MAG: proteasome endopeptidase complex, archaeal, alpha subunit [Thermoprotei archaeon]	diamond	231	99.8	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei 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);;