metadata: contig_metadata: 11 rows where bioproject = "PRJNA867519", tax_clade = "Stenosarchaea group" and tax

11 rows where bioproject = "PRJNA867519", tax_clade = "Stenosarchaea group" 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
8501025	8501025	PRJNA867519_P_NODE_28067_length_248_cov_0.880000_g27913_i0	PRJNA867519	28067	248	0.88	2.1824	Halococcus dombrowskii	179637	Archaea	Archaea	381	2.519999999999999e-101	NTclustered	gi\|2221489803\|gb\|CP095005.1\|	179637	g27913	i0	94.355	10.6693548387097	248	14	100	0	1	248	2199354	2199107	Halococcus dombrowskii strain H4 chromosome, complete genome	blastn	2646	381	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
11051725	11051725	PRJNA867519_P_NODE_10829_length_348_cov_0.756364_g10675_i0	PRJNA867519	10829	348	0.756364	2.63214672	Natrinema caseinilyticum	2961570	Archaea	Archaea	54.7	0.009	NTclustered	gi\|2270264148\|gb\|CP100445.1\|	2961570	g10675	i0	88.889	0.129310344827586	45	3	13	1	279	323	1452581	1452539	Natrinema caseinilyticum strain ZJ2 chromosome, complete genome	blastn	45	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema caseinilyticum
13601861	13601861	PRJNA867519_P_NODE_33691_length_241_cov_0.916667_g33537_i0	PRJNA867519	33691	241	0.916667	2.20916747	Halorubrum ruber	2982524	Archaea	Archaea	58.4	4.66e-4	NTclustered	gi\|2031421124\|gb\|CP073695.1\|	2982524	g33537	i0	94.737	0.684647302904564	38	1	15	1	123	159	2731878	2731915	Halorubrum ruber strain MBLA0099 chromosome, complete genome	blastn	165	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum ruber
27624029	27624029	PRJNA867519_P_NODE_324_length_1408_cov_2.946067_g247_i0	PRJNA867519	324	1408	2.946067	41.48062336	Methanosarcinales archaeon	2250255	Archaea	Archaea	203	9.84e-53	NR	MCD4768356.1	2250255	g247	i0	39	2.26704545454545	362	199	75.4	10	2	1063	4	351	MCD4768356.1 tandem-95 repeat protein [Methanosarcinales archaeon]	diamond	3192	203	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28950139	28950139	PRJNA867519_P_NODE_20548_length_273_cov_1.875000_g20394_i0	PRJNA867519	20548	273	1.875	5.11875	Salinigranum sp.	1966351	Archaea	Archaea	46.6	8.6e-4	NR	WP_372909564.1	1966351	g20394	i0	41.2	2.23076923076923	68	34	72.5	2	22	219	26	89	WP_372909564.1 ester cyclase [Salinigranum sp.]	diamond	609	46.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Salinigranum	Salinigranum sp.
30031746	30031746	PRJNA867519_P_NODE_26211_length_250_cov_0.870056_g26057_i0	PRJNA867519	26211	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	42.7	0.0372	NR	NYT17884.1	2184052	g26057	i0	41.5	1.476	53	31	63.6	0	240	82	65	117	NYT17884.1 DNA double-strand break repair nuclease NurA [Methanomicrobiales archaeon]	diamond	369	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
30221123	30221123	PRJNA867519_P_NODE_22572_length_264_cov_1.581152_g22418_i0	PRJNA867519	22572	264	1.581152	4.17424128	Methanobacteriota	28890	Archaea	Archaea	48.5	8.77e-5	NR	MDG6244987.1	1874737	g22418	i0	45.5	2.78409090909091	44	24	50	0	209	78	1	44	MDG6244987.1 DUF4870 domain-containing protein [Methanolobus sp.]	diamond	735	48.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus sp.
30655384	30655384	PRJNA867519_P_NODE_6833_length_419_cov_2.017341_g6679_i0	PRJNA867519	6833	419	2.017341	8.45265879	Methanoregulaceae archaeon	2485498	Archaea	Archaea	69.7	9.59e-11	NR	HNJ81026.1	2485498	g6679	i0	53.3	0.429594272076372	60	26	43	1	203	382	603	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	180	69.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
31477404	31477404	PRJNA867519_P_NODE_27576_length_249_cov_0.875000_g27422_i0	PRJNA867519	27576	249	0.875	2.17875	Methanosarcinales archaeon	2250255	Archaea	Archaea	50.8	5.57e-5	NR	HID27252.1	2250255	g27422	i0	40.4	0.686746987951807	57	34	68.7	0	77	247	551	607	HID27252.1 amino acid permease [Methanosarcinales archaeon]	diamond	171	50.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32173422	32173422	PRJNA867519_P_NODE_26318_length_250_cov_0.870056_g26164_i0	PRJNA867519	26318	250	0.870056	2.17514	Methanoregula sp.	2052170	Archaea	Archaea	56.6	5.35e-7	NR	MDD1700180.1	2052170	g26164	i0	40.3	0.924	77	46	92.4	0	20	250	333	409	MDD1700180.1 PKD domain-containing protein [Methanoregula sp.]	diamond	231	56.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
32592615	32592615	PRJNA867519_P_NODE_14319_length_310_cov_2.278481_g14165_i0	PRJNA867519	14319	310	2.278481	7.0632911	root	1	Root_unresolved	Root_unresolved	84.7	1.39e-16	NR	WP_232700914.1	2902623	g14165	i0	48.8	3.14516129032258	86	42	81.3	2	39	290	5	90	WP_232700914.1 hydroxysqualene dehydroxylase [Halobacterium wangiae]	diamond	975	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium wangiae

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);;