metadata: contig_metadata: 10 rows where bioproject = "PRJNA550047" and tax

10 rows where bioproject = "PRJNA550047" 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
4343425	4343425	PRJNA550047_P_NODE_430964_length_253_cov_11.311111_g428992_i0	PRJNA550047	430964	253	11.311111	28.61711083	Pyrobaculum aerophilum	13773	Archaea	Archaea	222	1.65e-53	NTclustered	gi\|18308975\|gb\|AE009441.1\|	178306	g428992	i0	99.187	0.486166007905138	123	1	49	0	131	253	1197078	1197200	Pyrobaculum aerophilum str. IM2, complete genome	blastn	123	222	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum aerophilum
10721580	10721580	PRJNA550047_P_NODE_521229_length_223_cov_11.146667_g519256_i0	PRJNA550047	521229	223	11.146667	24.85706741	Pyrobaculum aerophilum	13773	Archaea	Archaea	377	2.88e-100	NTclustered	gi\|18308975\|gb\|AE009441.1\|	178306	g519256	i0	97.309	1	223	5	100	1	1	223	1645699	1645478	Pyrobaculum aerophilum str. IM2, complete genome	blastn	223	377	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum aerophilum
16423128	16423128	PRJNA550047_P_NODE_203413_length_337_cov_8.799242_g201451_i0	PRJNA550047	203413	337	8.799242	29.65344554	Archaea	2157	Archaea	Archaea	595	1.1699999999999996e-165	NTclustered	gi\|47155798\|gb\|AY601291.1\|	29281	g201451	i0	98.521	100.287833827893	338	4	100	1	1	337	21	358	Uncultured crenarchaeote clone GFS3-135i 16S ribosomal RNA gene, partial sequence	blastn	33797	595	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
21524108	21524108	PRJNA550047_P_NODE_539637_length_217_cov_7.861111_g537664_i0	PRJNA550047	539637	217	7.861111	17.05861087	root	1	Root_unresolved	Root_unresolved	401	1.6499999999999994e-107	NTclustered	gi\|373125855\|gb\|JN567036.1\|	29281	g537664	i0	100	103	217	0	100	0	1	217	576	792	Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence	blastn	22351	401	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
25348402	25348402	PRJNA550047_P_NODE_552140_length_213_cov_5.664286_g550167_i0	PRJNA550047	552140	213	5.664286	12.06492918	Thermoproteati	1783275	Archaea	Archaea	388	1.26e-103	NTclustered	gi\|153865719\|gb\|EF450813.1\|	29281	g550167	i0	99.531	99.9906103286385	213	1	100	0	1	213	315	103	Uncultured crenarchaeote clone CBS16S4-1-17 16S ribosomal RNA gene, partial sequence	blastn	21298	388	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
26888404	26888404	PRJNA550047_P_NODE_231961_length_301_cov_5.399123_g229992_i0	PRJNA550047	231961	301	5.399123	16.25136023	Thermosphaera sp.	2831947	Archaea	Archaea	59.3	1.03e-7	NR	MEM4655254.1	2831947	g229992	i0	60	0.996677740863787	50	20	49.8	0	150	299	22	71	MEM4655254.1 flippase [Thermosphaera sp.]	diamond	300	59.3	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Thermosphaera	Thermosphaera sp.
28814664	28814664	PRJNA550047_P_NODE_300348_length_297_cov_8.080357_g298379_i0	PRJNA550047	300348	297	8.080357	23.99866029	Pyrobaculum aerophilum	13773	Archaea	Archaea	186	3.74e-57	NR	WP_116420834.1	13773	g298379	i0	98.9	0.888888888888889	88	1	88.9	0	265	2	60	147	WP_116420834.1 hypothetical protein [Pyrobaculum aerophilum]	diamond	264	186	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum aerophilum
29099089	29099089	PRJNA550047_P_NODE_155328_length_345_cov_4.375000_g153368_i0	PRJNA550047	155328	345	4.375	15.09375	Thermoproteota archaeon	2056631	Archaea	Archaea	56.6	1.5e-6	NR	MCR8454875.1	2056631	g153368	i0	55.3	0.843478260869565	47	21	40.9	0	11	151	234	280	MCR8454875.1 methionine adenosyltransferase [Thermoproteota archaeon]	diamond	291	56.6	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
30661495	30661495	PRJNA550047_P_NODE_406693_length_262_cov_10.449735_g404721_i0	PRJNA550047	406693	262	10.449735	27.3783057	Thermoproteati	1783275	Archaea	Archaea	97.8	7.03e-24	NR	MDQ3974997.1	2056631	g404721	i0	82.1	2.42748091603053	56	10	64.1	0	93	260	1	56	MDQ3974997.1 glycine cleavage system protein GcvH [Thermoproteota archaeon]	diamond	636	97.8	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
30741585	30741585	PRJNA550047_P_NODE_467454_length_241_cov_12.130952_g465481_i0	PRJNA550047	467454	241	12.130952	29.23559432	Sulfolobus sp.	2288	Archaea	Archaea	44.7	0.00642	NR	MCI4456318.1	2288	g465481	i0	34.8	0.821576763485477	66	40	78.4	1	224	36	24	89	MCI4456318.1 DNA polymerase sliding clamp [Sulfolobus sp.]	diamond	198	44.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus sp.

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