metadata: contig_metadata: 9 rows where bioproject = "PRJNA1041773", tax_phylum = "Thermoproteota" and tax

9 rows where bioproject = "PRJNA1041773", 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
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
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)
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
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
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.
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);;