metadata: contig_metadata: 18 rows where bioproject = "PRJNA1041773" and tax

18 rows where bioproject = "PRJNA1041773" and tax_kingdom = "Thermoproteati"

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
1008402	1008402	PRJNA1041773_P_NODE_38981_length_338_cov_4.018868_g38648_i0	PRJNA1041773	38981	338	4.018868	13.58377384	Metallosphaera	41980	Archaea	Archaea	73.1	2.45e-8	NTclustered	gi\|676314532\|gb\|CP008822.1\|	43687	g38648	i0	85.915	4.22781065088757	71	6	29	3	40	107	1708064	1708133	Metallosphaera sedula strain CuR1 genome	blastn	1429	73.1	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Metallosphaera	Metallosphaera sedula
1445028	1445028	PRJNA1041773_P_NODE_47122_length_311_cov_0.840336_g46789_i0	PRJNA1041773	47122	311	0.840336	2.61344496	Candidatus Nitrosopelagicus brevis	1410606	Archaea	Archaea	442	1.4799999999999995e-119	NTclustered	gi\|742120812\|gb\|CP007026.1\|	1410606	g46789	i0	92.628	2.0064308681672	312	15	100	4	1	311	1043496	1043192	Candidatus Nitrosopelagicus brevis strain CN25, complete genome	blastn	624	442	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosopelagicus	Candidatus Nitrosopelagicus brevis
2720642	2720642	PRJNA1041773_P_NODE_36263_length_350_cov_0.967509_g35930_i0	PRJNA1041773	36263	350	0.967509	3.3862815	Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016)	1867261	Archaea	Archaea	311	4.94e-80	NTclustered	gi\|2551788334\|gb\|CP130488.1\|	1867261	g35930	i0	94.118	0.925714285714286	204	12	93	0	147	350	411003	411206	MAG: Candidatus Methanosuratincola petrocarbonis isolate LWZ-6 chromosome, complete genome	blastn	324	311	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae	Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016)	Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016)
4836497	4836497	PRJNA1041773_P_NODE_43704_length_321_cov_3.959677_g43371_i0	PRJNA1041773	43704	321	3.959677	12.71056317	Candidatus Nitrosomarinus	1993653	Archaea	Archaea	593	3.9899999999999986e-165	NTclustered	gi\|663499833\|gb\|KF900318.1\|	1455885	g43371	i0	100	50.4236760124611	321	0	100	0	1	321	14999	15319	Uncultured marine thaumarchaeote AD1000_06_F06 genomic sequence	blastn	16186	593	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote AD1000_06_F06
4836685	4836685	PRJNA1041773_P_NODE_71624_length_259_cov_2.376344_g71291_i0	PRJNA1041773	71624	259	2.376344	6.15473096	Candidatus Nitrosomarinus	1993653	Archaea	Archaea	435	2e-117	NTclustered	gi\|663499833\|gb\|KF900318.1\|	1455885	g71291	i0	96.911	27.984555984556	259	8	100	0	1	259	15285	15027	Uncultured marine thaumarchaeote AD1000_06_F06 genomic sequence	blastn	7248	435	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote AD1000_06_F06
5272687	5272687	PRJNA1041773_P_NODE_10445_length_637_cov_75.845745_g10121_i0	PRJNA1041773	10445	637	75.845745	483.13739565	Infirmifilum sp. NZ	2926850	Archaea	Archaea	169	6.02e-37	NTclustered	gi\|2211485873\|gb\|CP094288.1\|	2926850	g10121	i0	87.671	33.9058084772371	146	17	30	1	89	233	909863	909718	Infirmifilum sp. NZ chromosome	blastn	21598	169	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Infirmifilum	Infirmifilum sp. NZ
10373939	10373939	PRJNA1041773_P_NODE_70909_length_260_cov_3.197861_g70576_i0	PRJNA1041773	70909	260	3.197861	8.3144386	Candidatus Nitrosopelagicus brevis	1410606	Archaea	Archaea	407	4.39e-109	NTclustered	gi\|742120812\|gb\|CP007026.1\|	1410606	g70576	i0	100	63.2769230769231	220	0	100	0	41	260	482324	482105	Candidatus Nitrosopelagicus brevis strain CN25, complete genome	blastn	16452	407	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosopelagicus	Candidatus Nitrosopelagicus brevis
18022644	18022644	PRJNA1041773_P_NODE_75595_length_253_cov_1.711111_g75262_i0	PRJNA1041773	75595	253	1.711111	4.32911083	uncultured marine thaumarchaeote SAT1000_10_G09	1456375	Archaea	Archaea	390	4.28e-104	NTclustered	gi\|663532869\|gb\|KF901217.1\|	1456375	g75262	i0	94.8	24.6126482213439	250	13	99	0	1	250	25289	25538	Uncultured marine thaumarchaeote SAT1000_10_G09 genomic sequence	blastn	6227	390	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote SAT1000_10_G09
23960633	23960633	PRJNA1041773_P_NODE_23399_length_429_cov_6.005618_g23068_i0	PRJNA1041773	23399	429	6.005618	25.76410122	Candidatus Nitrosomarinus	1993653	Archaea	Archaea	793	0	NTclustered	gi\|1196088602\|gb\|CP021324.1\|	1898749	g23068	i0	100	56.4009324009324	429	0	100	0	1	429	509592	510020	Candidatus Nitrosomarinus catalina strain SPOT01 chromosome, complete genome	blastn	24196	793	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Candidatus Nitrosomarinus	Candidatus Nitrosomarinus catalinensis
26591756	26591756	PRJNA1041773_P_NODE_58501_length_283_cov_0.957143_g58168_i0	PRJNA1041773	58501	283	0.957143	2.70871469	Thermoprotei archaeon	2250277	Archaea	Archaea	93.2	3.43e-22	NR	RLE90483.1	2250277	g58168	i0	77.2	0.604240282685512	57	13	60.4	0	242	72	1	57	RLE90483.1 MAG: hypothetical protein DRJ55_06930 [Thermoprotei archaeon]	diamond	171	93.2	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei archaeon
26813731	26813731	PRJNA1041773_P_NODE_8461_length_706_cov_1.545024_g8141_i0	PRJNA1041773	8461	706	1.545024	10.90786944	Nitrososphaeria archaeon	2268198	Archaea	Archaea	221	4.4e-66	NR	MBC7091228.1	2268198	g8141	i0	100	0.446175637393768	105	0	44.6	0	702	388	83	187	MBC7091228.1 DNA cytosine methyltransferase [Nitrososphaeria archaeon]	diamond	315	221	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
27256437	27256437	PRJNA1041773_P_NODE_91763_length_245_cov_0.895349_g91430_i0	PRJNA1041773	91763	245	0.895349	2.19360505	Nitrosopumilus sp.	2024843	Archaea	Archaea	57.4	2.69e-7	NR	MDC3254044.1	2024843	g91430	i0	43.8	1.08979591836735	89	31	95.5	3	7	240	117	197	MDC3254044.1 hypothetical protein [Nitrosopumilus sp.]	diamond	267	57.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
28361578	28361578	PRJNA1041773_P_NODE_52066_length_297_cov_1.294643_g51733_i0	PRJNA1041773	52066	297	1.294643	3.84508971	Ignisphaera sp.	2268142	Archaea	Archaea	61.6	1.65e-8	NR	MCI4437815.1	2268142	g51733	i0	32	0.97979797979798	97	65	97	1	296	9	577	673	MCI4437815.1 hypothetical protein [Ignisphaera sp.]	diamond	291	61.6	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera sp.
29813980	29813980	PRJNA1041773_P_NODE_40411_length_333_cov_1.776923_g40078_i0	PRJNA1041773	40411	333	1.776923	5.91715359	Ignisphaera sp.	2268142	Archaea	Archaea	61.6	3.22e-9	NR	MCI4437302.1	2268142	g40078	i0	40.2	0.738738738738739	82	47	73	2	83	325	15	95	MCI4437302.1 hypothetical protein [Ignisphaera sp.]	diamond	246	61.6	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera sp.
30540718	30540718	PRJNA1041773_P_NODE_61233_length_277_cov_2.264706_g60900_i0	PRJNA1041773	61233	277	2.264706	6.27323562	Ignisphaera sp.	2268142	Archaea	Archaea	89.7	1.64e-18	NR	MCI4436154.1	2268142	g60900	i0	48.9	0.974729241877256	90	46	97.5	0	3	272	244	333	MCI4436154.1 adenosylcobalamin-dependent ribonucleoside-diphosphate reductase [Ignisphaera sp.]	diamond	270	89.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera sp.
31995057	31995057	PRJNA1041773_P_NODE_65398_length_270_cov_1.218274_g65065_i0	PRJNA1041773	65398	270	1.218274	3.2893398	Nitrososphaerota archaeon	2026795	Archaea	Archaea	63.9	1.76e-9	NR	MEM2987122.1	2026795	g65065	i0	43	0.877777777777778	79	39	87.8	1	243	7	74	146	MEM2987122.1 DEAD/DEAH box helicase family protein [Nitrososphaerota archaeon]	diamond	237	63.9	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
32184975	32184975	PRJNA1041773_P_NODE_74258_length_255_cov_1.692308_g73925_i0	PRJNA1041773	74258	255	1.692308	4.3153854	Thermoproteota archaeon	2056631	Archaea	Archaea	164	4.399999999999998e-47	NR	MDP8887685.1	2056631	g73925	i0	98.8	0.988235294117647	84	1	98.8	0	254	3	297	380	MDP8887685.1 cysteine desulfurase [Thermoproteota archaeon]	diamond	252	164	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
32847907	32847907	PRJNA1041773_P_NODE_15500_length_526_cov_2.947020_g15171_i0	PRJNA1041773	15500	526	2.94702	15.5013252	Candidatus Methanomethylicaceae archaeon	2282146	Archaea	Archaea	329	1.87e-108	NR	MEM3434087.1	2282146	g15171	i0	88.6	0.998098859315589	175	20	99.8	0	1	525	148	322	MEM3434087.1 peptide ABC transporter substrate-binding protein [Candidatus Methanomethyliaceae archaeon]	diamond	525	329	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae		Candidatus Methanomethylicaceae 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);;