metadata: contig_metadata: 17 rows where bioproject = "PRJEB64798" and tax

17 rows where bioproject = "PRJEB64798" 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
3543439	3543439	PRJEB64798_P_NODE_151643_length_187_cov_12.811594_g149877_i0	PRJEB64798	151643	187	12.811594	23.95768078	Thermoprotei	183924	Archaea	Archaea	82.4	2.04e-11	NTclustered	gi\|363804978\|gb\|JN971013.1\|	1126828	g149877	i0	91.525	26.3048128342246	59	5	32	0	27	85	1794	1736	Sulfolobales sp. MK5 23S large subunit ribosomal RNA gene, partial sequence	blastn	4919	82.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales			Sulfolobales sp. MK5
7370618	7370618	PRJEB64798_P_NODE_189546_length_170_cov_7.619835_g187780_i0	PRJEB64798	189546	170	7.619835	12.9537195	root	1	Root_unresolved	Root_unresolved	298	1.65e-76	NTclustered	gi\|373125855\|gb\|JN567036.1\|	29281	g187780	i0	99.39	98.4529411764706	164	1	96	0	7	170	540	703	Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence	blastn	16737	298	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
8645861	8645861	PRJEB64798_P_NODE_124487_length_202_cov_11.882353_g122721_i0	PRJEB64798	124487	202	11.882353	24.00235306	root	1	Root_unresolved	Root_unresolved	355	1.2e-93	NTclustered	gi\|42406208\|gb\|AY522899.1\|	29281	g122721	i0	98.99	98.0445544554455	198	2	98	0	1	198	413	216	Uncultured crenarchaeote clone MAS5 16S ribosomal RNA gene, partial sequence	blastn	19805	355	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
9921012	9921012	PRJEB64798_P_NODE_13328_length_547_cov_9.120482_g11684_i0	PRJEB64798	13328	547	9.120482	49.88903654	Thermoproteati	1783275	Archaea	Archaea	800	0	NTclustered	gi\|325984322\|gb\|JF262219.1\|	29281	g11684	i0	100	84.2504570383912	433	0	84	0	4	436	2	434	Uncultured crenarchaeote clone YLA019 16S ribosomal RNA gene, partial sequence	blastn	46085	800	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
17978821	17978821	PRJEB64798_P_NODE_161375_length_183_cov_1.276119_g159609_i0	PRJEB64798	161375	183	1.276119	2.33529777	Pyrobaculum aerophilum	13773	Archaea	Archaea	339	1.07e-88	NTclustered	gi\|18308975\|gb\|AE009441.1\|	178306	g159609	i0	100	1	183	0	100	0	1	183	1795947	1796129	Pyrobaculum aerophilum str. IM2, complete genome	blastn	183	339	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum aerophilum
19253094	19253094	PRJEB64798_P_NODE_177716_length_175_cov_5.055556_g175950_i0	PRJEB64798	177716	175	5.055556	8.847223	uncultured crenarchaeote	29281	Archaea	Archaea	322	1.02e-83	NTclustered	gi\|58334024\|emb\|AJ876976.1\|	29281	g175950	i0	100	98.8742857142857	174	0	99	0	2	175	451	278	Uncultured crenarchaeote partial 16S rRNA gene, clone CSSed-21Arc	blastn	17303	322	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
21805102	21805102	PRJEB64798_P_NODE_234918_length_157_cov_2.833333_g233152_i0	PRJEB64798	234918	157	2.833333	4.44833281	Sulfolobus acidocaldarius	2285	Archaea	Archaea	58.4	2.78e-4	NTclustered	gi\|566046648\|gb\|CP006977.1\|	1435377	g233152	i0	92.683	0.261146496815287	41	1	25	2	75	114	575195	575156	Sulfolobus acidocaldarius SUSAZ, complete genome	blastn	41	58.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus acidocaldarius
24352774	24352774	PRJEB64798_P_NODE_138780_length_194_cov_3.268966_g137014_i0	PRJEB64798	138780	194	3.268966	6.34179404	uncultured crenarchaeote	29281	Archaea	Archaea	320	4.16e-83	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g137014	i0	96.859	31.2422680412371	191	6	98	0	1	191	7400	7210	Uncultured crenarchaeote 34 kb genomic fragment	blastn	6061	320	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
27729101	27729101	PRJEB64798_P_NODE_168904_length_179_cov_3.992308_g167138_i0	PRJEB64798	168904	179	3.992308	7.14623132	Thermoproteota archaeon	2056631	Archaea	Archaea	55.8	3.72e-7	NR	MEW6043311.1	2056631	g167138	i0	56.4	0.921787709497207	55	20	92.2	2	170	6	39	89	MEW6043311.1 thrombospondin type 3 repeat-containing protein [Thermoproteota archaeon]	diamond	165	55.8	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
29275694	29275694	PRJEB64798_P_NODE_154249_length_186_cov_4.686131_g152483_i0	PRJEB64798	154249	186	4.686131	8.71620366	Thermoproteota archaeon	2056631	Archaea	Archaea	40.8	0.0255	NR	MDP8905924.1	2056631	g152483	i0	42.3	0.838709677419355	52	27	79	2	7	153	17	68	MDP8905924.1 hypothetical protein [Thermoproteota archaeon]	diamond	156	40.8	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
30159801	30159801	PRJEB64798_P_NODE_107272_length_210_cov_21.950311_g105506_i0	PRJEB64798	107272	210	21.950311	46.0956531	Sulfolobaceae archaeon	2967306	Archaea	Archaea	42.7	0.00694	NR	MEM0173589.1	2967306	g105506	i0	60	0.571428571428571	40	16	57.1	0	206	87	14	53	MEM0173589.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	120	42.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae		Sulfolobaceae archaeon
30223322	30223322	PRJEB64798_P_NODE_235592_length_156_cov_18.429907_g233826_i0	PRJEB64798	235592	156	18.429907	28.75065492	Thermoproteota archaeon	2056631	Archaea	Archaea	51.6	3.05e-6	NR	MEC8530310.1	2056631	g233826	i0	56.8	0.711538461538462	37	16	71.2	0	155	45	55	91	MEC8530310.1 DNA primase [Thermoproteota archaeon]	diamond	111	51.6	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
30633904	30633904	PRJEB64798_P_NODE_203593_length_166_cov_5.820513_g201827_i0	PRJEB64798	203593	166	5.820513	9.66205158	Acidilobus sp.	1872109	Archaea	Archaea	41.6	0.0346	NR	MFP3320873.1	1872109	g201827	i0	41.4	1.04819277108434	58	28	94	2	1	156	98	155	MFP3320873.1 hypothetical protein [Acidilobus sp.]	diamond	174	41.6	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Acidilobales	Acidilobaceae	Acidilobus	Acidilobus sp.
30690303	30690303	PRJEB64798_P_NODE_90493_length_212_cov_6.539877_g88727_i0	PRJEB64798	90493	212	6.539877	13.86453924	Thermoproteati	1783275	Archaea	Archaea	49.7	7.29e-6	NR	MEM3615123.1	2268187	g88727	i0	53.1	0.905660377358491	32	15	45.3	0	6	101	2	33	MEM3615123.1 creatininase family protein [Candidatus Methanomethylicia archaeon]	diamond	192	49.7	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia				Candidatus Methanomethylicia archaeon
31803603	31803603	PRJEB64798_P_NODE_204177_length_166_cov_3.649573_g202411_i0	PRJEB64798	204177	166	3.649573	6.05829118	Thermoproteales archaeon	2268205	Archaea	Archaea	56.2	2.29e-7	NR	MCD6562492.1	2268205	g202411	i0	60	2.56626506024096	45	18	81.3	0	159	25	482	526	MCD6562492.1 ribonuclease H-like domain-containing protein [Thermoproteales archaeon]	diamond	426	56.2	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales			Thermoproteales archaeon
31961841	31961841	PRJEB64798_P_NODE_157538_length_184_cov_14.303704_g155772_i0	PRJEB64798	157538	184	14.303704	26.31881536	Ignisphaera sp.	2268142	Archaea	Archaea	60.5	9.68e-9	NR	MCI4435493.1	2268142	g155772	i0	47.5	0.96195652173913	59	29	92.9	1	177	7	1374	1432	MCI4435493.1 hypothetical protein [Ignisphaera sp.]	diamond	177	60.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera sp.
32341859	32341859	PRJEB64798_P_NODE_216339_length_163_cov_2.149123_g214573_i0	PRJEB64798	216339	163	2.149123	3.50307049	Ignisphaera sp.	2268142	Archaea	Archaea	60.5	7.11e-9	NR	MCI4435493.1	2268142	g214573	i0	58	0.920245398773006	50	20	92	1	4	153	2317	2365	MCI4435493.1 hypothetical protein [Ignisphaera sp.]	diamond	150	60.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera 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);;