metadata: contig_metadata: 10 rows where bioproject = "PRJNA911178", tax_phylum = "Thermoproteota" and tax

10 rows where bioproject = "PRJNA911178", tax_phylum = "Thermoproteota" 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_order	tax_family	tax_genus	tax_species
2168289	2168289	PRJNA911178_P_NODE_294442_length_241_cov_0.916667_g291968_i0	PRJNA911178	294442	241	0.916667	2.20916747	uncultured crenarchaeote	29281	Archaea	Archaea	117	7.58e-22	NTclustered	gi\|82697915\|gb\|DQ284448.1\|	29281	g291968	i0	85	2.05394190871369	120	13	48	5	15	130	740	858	Uncultured crenarchaeote clone MDArch077 putative OB-fold nucleic acid binding protein, putative SpoU-like RNA methylase, and putative conserved protein genes, complete cds	blastn	495	117	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
3443379	3443379	PRJNA911178_P_NODE_249603_length_249_cov_1.585227_g247129_i0	PRJNA911178	249603	249	1.585227	3.94721523	uncultured crenarchaeote 29d5	684057	Archaea	Archaea	248	2.68e-61	NTclustered	gi\|262089226\|gb\|GU059106.1\|	684057	g247129	i0	85.477	0.967871485943775	241	31	96	4	10	249	13998	14235	Uncultured crenarchaeote 29d5 genomic sequence	blastn	241	248	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote 29d5
13645533	13645533	PRJNA911178_P_NODE_178431_length_284_cov_1.322275_g175958_i0	PRJNA911178	178431	284	1.322275	3.755261	uncultured crenarchaeote	29281	Archaea	Archaea	516	7.74e-142	NTclustered	gi\|18087452\|gb\|AF458646.1\|	29281	g175958	i0	100	98.2535211267606	279	0	98	0	6	284	149	427	Uncultured crenarchaeote 12_02a 16S ribosomal RNA gene, partial sequence	blastn	27904	516	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
16194630	16194630	PRJNA911178_P_NODE_167693_length_290_cov_1.746544_g165220_i0	PRJNA911178	167693	290	1.746544	5.0649776	uncultured crenarchaeote 29d5	684057	Archaea	Archaea	313	1.12e-80	NTclustered	gi\|262089226\|gb\|GU059106.1\|	684057	g165220	i0	86.572	1.9586206896551701	283	38	98	0	6	288	13106	12824	Uncultured crenarchaeote 29d5 genomic sequence	blastn	568	313	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote 29d5
25118160	25118160	PRJNA911178_P_NODE_196920_length_273_cov_2.195000_g194447_i0	PRJNA911178	196920	273	2.195	5.99235	Acidianus sulfidivorans	312539	Archaea	Archaea	54.7	0.007	NTclustered	gi\|1820310478\|gb\|CP029288.2\|	619593	g194447	i0	100	0.106227106227106	29	0	11	0	218	246	2073007	2072979	Acidianus sulfidivorans JP7 chromosome, complete genome	blastn	29	54.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Acidianus	Acidianus sulfidivorans
27213901	27213901	PRJNA911178_P_NODE_124202_length_330_cov_1.486381_g121730_i0	PRJNA911178	124202	330	1.486381	4.9050573	Pyrodictium abyssi	54256	Archaea	Archaea	42	0.048	NR	WP_338249940.1	54256	g121730	i0	34.8	0.6	66	37	60	2	78	275	45	104	WP_338249940.1 hypothetical protein [Pyrodictium abyssi]	diamond	198	42	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Pyrodictiaceae	Pyrodictium	Pyrodictium abyssi
27593365	27593365	PRJNA911178_P_NODE_233204_length_254_cov_1.756906_g230730_i0	PRJNA911178	233204	254	1.756906	4.46254124	Thermoproteota archaeon	2056631	Archaea	Archaea	94.4	1.47e-23	NR	MEM3368604.1	2056631	g230730	i0	94	0.590551181102362	50	3	59.1	0	72	221	1	50	MEM3368604.1 hypothetical protein [Thermoproteota archaeon]	diamond	150	94.4	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
27593370	27593370	PRJNA911178_P_NODE_248084_length_250_cov_0.870056_g245610_i0	PRJNA911178	248084	250	0.870056	2.17514	Thermoproteota archaeon	2056631	Archaea	Archaea	115	1.9099999999999998e-31	NR	MDP9211234.1	2056631	g245610	i0	100	0.708	59	0	70.8	0	178	2	1	59	MDP9211234.1 U6 snRNA-associated Sm-like protein LSm6 [Thermoproteota archaeon]	diamond	177	115	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
31098599	31098599	PRJNA911178_P_NODE_293095_length_241_cov_0.916667_g290621_i0	PRJNA911178	293095	241	0.916667	2.20916747	Thermoproteota archaeon	2056631	Archaea	Archaea	146	1.0999999999999999e-38	NR	MEM3368526.1	2056631	g290621	i0	90	0.995850622406639	80	8	99.6	0	2	241	26	105	MEM3368526.1 baseplate J/gp47 family protein [Thermoproteota archaeon]	diamond	240	146	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
31541573	31541573	PRJNA911178_P_NODE_73196_length_413_cov_1.320588_g70733_i0	PRJNA911178	73196	413	1.320588	5.45402844	Thermoproteota archaeon	2056631	Archaea	Archaea	269	5.25e-86	NR	MEM3368575.1	2056631	g70733	i0	94.9	0.987893462469734	136	7	98.8	0	4	411	208	343	MEM3368575.1 hypothetical protein [Thermoproteota archaeon]	diamond	408	269	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota 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);;