metadata: contig_metadata: 15 rows where bioproject = "PRJNA977246" and tax

15 rows where bioproject = "PRJNA977246" 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
3820825	3820825	PRJNA977246_S_NODE_24463_length_266_cov_8045.362869_g23471_i0	PRJNA977246	24463	266	8045.362869	21400.66523154	Thermoproteota archaeon	2056631	Archaea	Archaea	107	8.85e-25	NR	MEM3368600.1	2056631	g23471	i0	96.4	0.620300751879699	55	2	62	0	215	51	279	333	MEM3368600.1 toprim domain-containing protein [Thermoproteota archaeon]	diamond	165	107	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
7646740	7646740	PRJNA977246_S_NODE_13126_length_411_cov_4986.201571_g12147_i0	PRJNA977246	13126	411	4986.201571	20493.28845681	Thermoproteota archaeon	2056631	Archaea	Archaea	201	2.94e-62	NR	MEM3368592.1	2056631	g12147	i0	80.5	0.861313868613139	118	23	86.1	0	56	409	13	130	MEM3368592.1 hypothetical protein [Thermoproteota archaeon]	diamond	354	201	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
13704826	13704826	PRJNA977246_S_NODE_26771_length_248_cov_4.511416_g25779_i0	PRJNA977246	26771	248	4.511416	11.18831168	uncultured crenarchaeote	29281	Archaea	Archaea	335	1.9899999999999996e-87	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g25779	i0	93.013	2.7258064516129	229	16	92	0	20	248	6098	6326	Uncultured crenarchaeote 34 kb genomic fragment	blastn	676	335	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
15296743	15296743	PRJNA977246_S_NODE_22672_length_282_cov_7536.019763_g21680_i0	PRJNA977246	22672	282	7536.019763	21251.57573166	Thermoproteota archaeon	2056631	Archaea	Archaea	113	1.2399999999999998e-29	NR	MDT7864916.1	2056631	g21680	i0	90.3	0.659574468085106	62	6	66	0	237	52	1	62	MDT7864916.1 dUTP diphosphatase [Thermoproteota archaeon]	diamond	186	113	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
15297033	15297033	PRJNA977246_S_NODE_7552_length_571_cov_3828.418819_g6738_i0	PRJNA977246	7552	571	3828.418819	21860.27145649	Thermoproteota archaeon	2056631	Archaea	Archaea	136	3.9899999999999996e-38	NR	MEM3368791.1	2056631	g6738	i0	84.8	0.415061295971979	79	12	41.5	0	205	441	1	79	MEM3368791.1 hypothetical protein [Thermoproteota archaeon]	diamond	237	136	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
16571255	16571255	PRJNA977246_S_NODE_17893_length_334_cov_9.488525_g16901_i0	PRJNA977246	17893	334	9.488525	31.6916735	Thermoproteota archaeon	2056631	Archaea	Archaea	117	2.7899999999999996e-31	NR	MDT7864681.1	2056631	g16901	i0	89.1	0.574850299401198	64	7	57.5	0	13	204	1	64	MDT7864681.1 hypothetical protein [Thermoproteota archaeon]	diamond	192	117	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
25495408	25495408	PRJNA977246_S_NODE_33400_length_208_cov_10575.944134_g32408_i0	PRJNA977246	33400	208	10575.944134	21997.96379872	Pyrobaculum arsenaticum	121277	Archaea	Archaea	90.1	1.05e-21	NR	WP_345803932.1	121277	g32408	i0	91.4	0.836538461538462	58	5	83.7	0	206	33	8	65	WP_345803932.1 pH regulation protein F [Pyrobaculum arsenaticum]	diamond	174	90.1	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum arsenaticum
27910315	27910315	PRJNA977246_S_NODE_44265_length_168_cov_2.719424_g43273_i0	PRJNA977246	44265	168	2.719424	4.56863232	Pyrobaculum arsenaticum	121277	Archaea	Archaea	100	6.27e-23	NR	WP_345803937.1	121277	g43273	i0	100	5.35714285714286	50	0	89.3	0	2	151	92	141	WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum]	diamond	900	100	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum arsenaticum
27916575	27916575	PRJNA977246_S_NODE_25065_length_261_cov_7.745690_g24073_i0	PRJNA977246	25065	261	7.74569	20.2162509	root	1	Root_unresolved	Root_unresolved	94.7	2.29e-20	NR	RLF07872.1	2250277	g24073	i0	68.9	3.37931034482759	74	20	83.9	2	23	241	453	524	RLF07872.1 MAG: hypothetical protein DRJ64_02130 [Thermoprotei archaeon]	diamond	882	94.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei archaeon
28920801	28920801	PRJNA977246_S_NODE_39428_length_183_cov_7.175325_g38436_i0	PRJNA977246	39428	183	7.175325	13.13084475	Thermoproteota archaeon	2056631	Archaea	Archaea	106	3.4e-26	NR	MDT7864917.1	2056631	g38436	i0	94.4	0.885245901639344	54	3	88.5	0	20	181	217	270	MDT7864917.1 DNA polymerase ligase N-terminal domain-containing protein [Thermoproteota archaeon]	diamond	162	106	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
29741604	29741604	PRJNA977246_S_NODE_26410_length_251_cov_2.995495_g25418_i0	PRJNA977246	26410	251	2.995495	7.51869245	Pyrobaculum arsenaticum	121277	Archaea	Archaea	102	1.31e-25	NR	WP_345803931.1	121277	g25418	i0	94.5	0.657370517928287	55	3	65.7	0	5	169	76	130	WP_345803931.1 Na+/H+ antiporter subunit E [Pyrobaculum arsenaticum]	diamond	165	102	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum arsenaticum
30184090	30184090	PRJNA977246_S_NODE_48392_length_157_cov_7.281250_g47400_i0	PRJNA977246	48392	157	7.28125	11.4315625	Thermoproteota archaeon	2056631	Archaea	Archaea	107	1.28e-27	NR	MDT7864673.1	2056631	g47400	i0	96.2	0.993630573248408	52	2	99.4	0	2	157	58	109	MDT7864673.1 hypothetical protein [Thermoproteota archaeon]	diamond	156	107	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
31353373	31353373	PRJNA977246_S_NODE_26936_length_247_cov_3.174312_g25944_i0	PRJNA977246	26936	247	3.174312	7.84055064	Acidilobus sp.	1872109	Archaea	Archaea	127	6.259999999999999e-32	NR	NAZ38545.1	1872109	g25944	i0	79	12.3643724696356	81	17	98.4	0	246	4	309	389	NAZ38545.1 CDC48 family AAA ATPase [Acidilobus sp.]	diamond	3054	127	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Acidilobales	Acidilobaceae	Acidilobus	Acidilobus sp.
31770590	31770590	PRJNA977246_S_NODE_22957_length_280_cov_4.298805_g21965_i0	PRJNA977246	22957	280	4.298805	12.036654	root	1	Root_unresolved	Root_unresolved	155	1.04e-43	NR	WP_345803936.1	121277	g21965	i0	97.8	1.90714285714286	89	2	95.4	0	12	278	38	126	WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum]	diamond	534	155	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum arsenaticum
32624500	32624500	PRJNA977246_S_NODE_33480_length_208_cov_3.949721_g32488_i0	PRJNA977246	33480	208	3.949721	8.21541968	Archaea	2157	Archaea	Archaea	88.6	1.24e-18	NR	MDT7864683.1	2056631	g32488	i0	90	1.41346153846154	50	5	72.1	0	157	8	312	361	MDT7864683.1 hypothetical protein [Thermoproteota archaeon]	diamond	294	88.6	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);;