metadata: contig_metadata: 13 rows where bioproject = "PRJNA1199330" and tax

13 rows where bioproject = "PRJNA1199330" and tax_clade = "Stenosarchaea group"

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
2875904	2875904	PRJNA1199330_P_NODE_118103_length_238_cov_2.527273_g117404_i0	PRJNA1199330	118103	238	2.527273	6.01490974	Natronococcus occultus	29288	Archaea	Archaea	185	2.0199999999999998e-42	NTclustered	gi\|433671692\|gb\|CP003929.1\|	694430	g117404	i0	91.791	2.73109243697479	134	10	56	1	105	238	2574142	2574010	Natronococcus occultus SP4, complete genome	blastn	650	185	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus occultus
6702871	6702871	PRJNA1199330_P_NODE_117186_length_240_cov_2.634731_g116487_i0	PRJNA1199330	117186	240	2.634731	6.3233544	Halorubrum ezzemoulense	337243	Archaea	Archaea	272	1.52e-68	NTclustered	gi\|1565814486\|gb\|CP034940.1\|	337243	g116487	i0	87.66	58.0458333333333	235	27	98	2	4	237	2365065	2364832	Halorubrum ezzemoulense strain Fb21 chromosome, complete genome	blastn	13931	272	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum ezzemoulense
9254163	9254163	PRJNA1199330_P_NODE_86128_length_267_cov_1.360825_g85429_i0	PRJNA1199330	86128	267	1.360825	3.63340275	Haloparvum sedimenti	1678448	Archaea	Archaea	176	1.2899999999999997e-54	NR	WP_058366244.1	1678448	g85429	i0	100	0.98876404494382	88	0	98.9	0	2	265	55	142	WP_058366244.1 DUF7112 family protein [Haloparvum sedimenti]	diamond	264	176	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloparvum	Haloparvum sedimenti
10529461	10529461	PRJNA1199330_P_NODE_44309_length_312_cov_3.644351_g43610_i0	PRJNA1199330	44309	312	3.644351	11.37037512	Natrinema versiforme	88724	Archaea	Archaea	233	9.71e-57	NTclustered	gi\|1657691899\|gb\|CP040330.1\|	88724	g43610	i0	94.667	12.1570512820513	150	8	95	0	2	151	1356950	1356801	Natrinema versiforme strain BOL5-4 chromosome, complete genome	blastn	3793	233	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema versiforme
18176472	18176472	PRJNA1199330_P_NODE_100655_length_253_cov_0.866667_g99956_i0	PRJNA1199330	100655	253	0.866667	2.19266751	Haloprofundus sp. MHR1	2572921	Archaea	Archaea	429	9.079999999999999e-116	NTclustered	gi\|2162408205\|gb\|MN918441.1\|	2572921	g99956	i0	97.233	86.7667984189723	253	7	100	0	1	253	88712	88460	Haloprofundus sp. MHR1 plasmid pMHR1-1, complete sequence	blastn	21952	429	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus sp. MHR1
20727621	20727621	PRJNA1199330_P_NODE_84557_length_268_cov_2.266667_g83858_i0	PRJNA1199330	84557	268	2.266667	6.07466756	Natrinema sp. DC36	2878680	Archaea	Archaea	52.8	0.025	NTclustered	gi\|2110956531\|gb\|CP084472.1\|	2878680	g83858	i0	100	0.208955223880597	28	0	10	0	27	54	620025	620052	Natrinema sp. DC36 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. DC36
24551250	24551250	PRJNA1199330_P_NODE_122680_length_227_cov_2.831169_g121981_i0	PRJNA1199330	122680	227	2.831169	6.42675363	Haloparvum sedimenti	1678448	Archaea	Archaea	155	9.15e-45	NR	WP_058367199.1	1678448	g121981	i0	97.3	0.991189427312775	75	2	99.1	0	1	225	168	242	WP_058367199.1 alpha/beta fold hydrolase [Haloparvum sedimenti]	diamond	225	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloparvum	Haloparvum sedimenti
27641433	27641433	PRJNA1199330_P_NODE_82744_length_270_cov_1.583756_g82045_i0	PRJNA1199330	82744	270	1.583756	4.2761412	Methanosarcinales archaeon	2250255	Archaea	Archaea	81.6	9.43e-16	NR	RYE83256.1	2250255	g82045	i0	44.8	0.966666666666667	87	47	96.7	1	270	10	214	299	RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon]	diamond	261	81.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28588609	28588609	PRJNA1199330_P_NODE_29667_length_379_cov_2.895425_g28971_i0	PRJNA1199330	29667	379	2.895425	10.97366075	Methanosarcinales archaeon	2250255	Archaea	Archaea	112	2.31e-26	NR	RYE83256.1	2250255	g28971	i0	44.3	0.965699208443272	122	67	95.8	1	376	14	171	292	RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon]	diamond	366	112	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28702154	28702154	PRJNA1199330_P_NODE_15707_length_516_cov_3.162528_g15018_i0	PRJNA1199330	15707	516	3.162528	16.31864448	root	1	Root_unresolved	Root_unresolved	45.8	0.0385	NR	MDD4162744.1	90426	g15018	i0	53.8	0.540697674418605	39	17	22.1	1	245	132	273	311	MDD4162744.1 PAN domain-containing protein [Methanothrix sp.]	diamond	279	46.2	0.991341991341991	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
29049497	29049497	PRJNA1199330_P_NODE_81508_length_271_cov_2.075758_g80809_i0	PRJNA1199330	81508	271	2.075758	5.62530418	root	1	Root_unresolved	Root_unresolved	44.7	0.0108	NR	MDD4162744.1	90426	g80809	i0	51.2	1.30627306273063	41	19	44.3	1	129	10	437	477	MDD4162744.1 PAN domain-containing protein [Methanothrix sp.]	diamond	354	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30420467	30420467	PRJNA1199330_P_NODE_89993_length_263_cov_2.010526_g89294_i0	PRJNA1199330	89993	263	2.010526	5.28768338	Natronomonas gomsonensis	1046043	Archaea	Archaea	42.7	0.0465	NR	WP_178915815.1	1046043	g89294	i0	45.2	0.479087452471483	42	23	47.9	0	168	43	438	479	WP_178915815.1 MATE family efflux transporter [Natronomonas gomsonensis]	diamond	126	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas gomsonensis
30609522	30609522	PRJNA1199330_P_NODE_77373_length_275_cov_1.584158_g76674_i0	PRJNA1199330	77373	275	1.584158	4.3564345	Halomontanus rarus	3034020	Archaea	Archaea	69.7	4.91e-12	NR	WP_276255520.1	3034020	g76674	i0	75	0.436363636363636	40	10	43.6	0	120	1	1	40	WP_276255520.1 DUF502 domain-containing protein [Halomontanus rarus]	diamond	120	69.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halomontanus	Halomontanus rarus

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