metadata: contig_metadata: 19 rows where bioproject = "PRJNA835051" and tax

19 rows where bioproject = "PRJNA835051" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4654697	4654697	PRJNA835051_S_NODE_60884_length_203_cov_2.387500_g60588_i0	PRJNA835051	60884	203	2.3875	4.846625	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	52.8	0.018	NTclustered	gi\|2258811197\|gb\|CP060218.1\|	2026803	g60588	i0	100	0.413793103448276	28	0	14	0	130	157	118899	118926	MAG: Candidatus Woesearchaeota archaeon isolate HK-STAS-Nano-1 chromosome, complete genome	blastn	84	52.8	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
13580045	13580045	PRJNA835051_S_NODE_75011_length_189_cov_1.630137_g74715_i0	PRJNA835051	75011	189	1.630137	3.08095893	Methanobrevibacter sp.	66852	Archaea	Archaea	99	2.7900000000000003e-22	NR	MBS7257934.1	66852	g74715	i0	71.2	2.9047619047619	59	17	93.7	0	11	187	532	590	MBS7257934.1 hypothetical protein [Methanobrevibacter sp.]	diamond	549	99	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
13983383	13983383	PRJNA835051_S_NODE_51751_length_214_cov_2.701754_g51455_i0	PRJNA835051	51751	214	2.701754	5.78175356	Methanosarcina	2207	Archaea	Archaea	52.8	0.019	NTclustered	gi\|2515741548\|gb\|CP117271.1\|	2209	g51455	i0	88.636	2.67289719626168	44	3	21	1	48	91	465414	465373	Mutant Methanosarcina mazei strain Mm Mut 208, complete genome	blastn	572	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
19952085	19952085	PRJNA835051_S_NODE_133956_length_150_cov_0.887850_g133660_i0	PRJNA835051	133956	150	0.88785	1.331775	Natrialba magadii	13769	Archaea	Archaea	63.9	5.64e-6	NTclustered	gi\|289529249\|gb\|CP001932.1\|	547559	g133660	i0	100	51.5533333333333	34	0	23	0	45	78	3095408	3095375	Natrialba magadii ATCC 43099, complete sequence	blastn	7733	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba magadii
23778385	23778385	PRJNA835051_S_NODE_38679_length_233_cov_47.389474_g38383_i0	PRJNA835051	38679	233	47.389474	110.41747442	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.021	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g38383	i0	100	0.120171673819742	28	0	12	0	76	103	336127	336100	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
23779095	23779095	PRJNA835051_S_NODE_9819_length_327_cov_1.637324_g9523_i0	PRJNA835051	9819	327	1.637324	5.35404948	Candidatus Nanopusillus acidilobi	1577684	Archaea	Archaea	52.8	0.031	NTclustered	gi\|985630447\|gb\|CP010514.1\|	1577684	g9523	i0	100	0.0856269113149847	28	0	9	0	140	167	237711	237684	Candidatus Nanopusillus acidilobi strain 7A chromosome, complete genome	blastn	28	52.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Nanoarchaeales	Nanopusillaceae	Candidatus Nanopusillus	Candidatus Nanopusillus acidilobi
26619955	26619955	PRJNA835051_S_NODE_83261_length_182_cov_1.359712_g82965_i0	PRJNA835051	83261	182	1.359712	2.47467584	root	1	Root_unresolved	Root_unresolved	52	1.59e-6	NR	MBR0370293.1	66852	g82965	i0	41.5	1.82967032967033	53	31	87.4	0	176	18	36	88	MBR0370293.1 single-stranded DNA-binding protein [Methanobrevibacter sp.]	diamond	333	52	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
26833179	26833179	PRJNA835051_S_NODE_106541_length_165_cov_1.163934_g106245_i0	PRJNA835051	106541	165	1.163934	1.9204911	Methanobrevibacter sp.	66852	Archaea	Archaea	110	3.65e-28	NR	WP_329977078.1	66852	g106245	i0	96.3	0.981818181818182	54	2	98.2	0	2	163	106	159	WP_329977078.1 hypothetical protein, partial [Methanobrevibacter sp.]	diamond	162	110	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27086320	27086320	PRJNA835051_S_NODE_50482_length_216_cov_1.907514_g50186_i0	PRJNA835051	50482	216	1.907514	4.12023024	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	45.8	4.25e-4	NR	HYP43214.1	2109671	g50186	i0	90.5	0.291666666666667	21	2	29.2	0	147	209	1	21	HYP43214.1 hypothetical protein [Candidatus Nitrosocosmicus sp.]	diamond	63	45.8	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
28191399	28191399	PRJNA835051_S_NODE_117346_length_158_cov_1.634783_g117050_i0	PRJNA835051	117346	158	1.634783	2.58295714	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	57	3.17e-9	NR	RLI47031.1	2026714	g117050	i0	54	0.949367088607595	50	23	94.9	0	152	3	4	53	RLI47031.1 MAG: hypothetical protein DRO61_08490 [Candidatus Bathyarchaeota archaeon]	diamond	150	57	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
28254659	28254659	PRJNA835051_S_NODE_122486_length_155_cov_1.482143_g122190_i0	PRJNA835051	122486	155	1.482143	2.29732165	Thermococcus sp. Bubb.Bath	1638242	Archaea	Archaea	46.2	6.87e-5	NR	WP_206205915.1	1638242	g122190	i0	46.8	0.909677419354839	47	25	91	0	142	2	23	69	WP_206205915.1 hypothetical protein, partial [Thermococcus sp. Bubb.Bath]	diamond	141	46.2	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. Bubb.Bath
28958149	28958149	PRJNA835051_S_NODE_13908_length_301_cov_2.178295_g13612_i0	PRJNA835051	13908	301	2.178295	6.55666795	root	1	Root_unresolved	Root_unresolved	96.3	3.47e-21	NR	MCK9442685.1	90426	g13612	i0	48	2.90033222591362	98	51	97.7	0	298	5	114	211	MCK9442685.1 hypothetical protein [Methanothrix sp.]	diamond	873	96.7	0.995863495346432	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
29139137	29139137	PRJNA835051_S_NODE_12509_length_308_cov_46.935849_g12213_i0	PRJNA835051	12509	308	46.935849	144.56241492	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	55.8	3.66e-8	NR	AIF11850.1	1456186	g12213	i0	75	0.350649350649351	36	9	35.1	0	193	300	1	36	AIF11850.1 hypothetical protein, partial [uncultured marine thaumarchaeote KM3_53_F08]	diamond	108	55.8	1	Archaea		Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08
30063014	30063014	PRJNA835051_S_NODE_12771_length_307_cov_2.344697_g12475_i0	PRJNA835051	12771	307	2.344697	7.19821979	root	1	Root_unresolved	Root_unresolved	114	5.649999999999999e-31	NR	MBQ2636984.1	66852	g12475	i0	78.1	2.48208469055375	64	14	62.5	0	305	114	7	70	MBQ2636984.1 hypothetical protein [Methanobrevibacter sp.]	diamond	762	115	0.991304347826087	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30876095	30876095	PRJNA835051_S_NODE_121974_length_155_cov_2.098214_g121678_i0	PRJNA835051	121974	155	2.098214	3.2522317	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	43.1	0.00825	NR	HYP42844.1	2109671	g121678	i0	86.4	0.425806451612903	22	3	42.6	0	71	6	432	453	HYP42844.1 RNase H family protein [Candidatus Nitrosocosmicus sp.]	diamond	66	43.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
30876099	30876099	PRJNA835051_S_NODE_1754_length_546_cov_2.216700_g1478_i0	PRJNA835051	1754	546	2.2167	12.103182	Candidatus Marsarchaeota archaeon	2823144	Archaea	Archaea	53.1	1.52e-4	NR	MCL5423474.1	2823144	g1478	i0	24.6	2.14835164835165	126	93	68.1	2	443	72	2	127	MCL5423474.1 hypothetical protein [Candidatus Marsarchaeota archaeon]	diamond	1173	53.1	1	Archaea		Thermoproteati	Candidatus Marsarchaeota					Candidatus Marsarchaeota archaeon
31002569	31002569	PRJNA835051_S_NODE_27614_length_255_cov_2.839623_g27318_i0	PRJNA835051	27614	255	2.839623	7.24103865	Methanosphaera sp.	2666342	Archaea	Archaea	79.3	1.71e-16	NR	MBR3214339.1	2666342	g27318	i0	54.4	0.929411764705882	79	33	91.8	2	236	3	1	77	MBR3214339.1 hypothetical protein [Methanosphaera sp.]	diamond	237	79.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
32109405	32109405	PRJNA835051_S_NODE_18878_length_280_cov_2.405063_g18582_i0	PRJNA835051	18878	280	2.405063	6.7341764	Nitrososphaerota archaeon	2026795	Archaea	Archaea	43.9	0.0202	NR	MER3602033.1	2026795	g18582	i0	39.7	0.835714285714286	78	44	80.4	1	33	257	119	196	MER3602033.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	234	43.9	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
32898633	32898633	PRJNA835051_S_NODE_104260_length_166_cov_2.308943_g103964_i0	PRJNA835051	104260	166	2.308943	3.83284538	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	42.4	0.00742	NR	MDD4354267.1	2910166	g103964	i0	39.5	0.77710843373494	43	25	75.9	1	37	162	74	116	MDD4354267.1 DUF362 domain-containing protein [Candidatus Nanoarchaeia archaeon]	diamond	129	42.4	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia				Candidatus Nanoarchaeia 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);;