metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA849172" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA849172" 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
18688431	18688431	PRJNA849172_P_NODE_70955_length_268_cov_5.497436_g70595_i0	PRJNA849172	70955	268	5.497436	14.73312848	root	1	Root_unresolved	Root_unresolved	66.2	2.74e-10	NR	WP_052279112.1	2214	g70595	i0	47.7	2.95522388059702	88	44	98.5	1	268	5	239	324	WP_052279112.1 PAS domain S-box protein [Methanosarcina acetivorans]	diamond	792	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina acetivorans
19961813	19961813	PRJNA849172_P_NODE_146076_length_201_cov_4.500000_g145716_i0	PRJNA849172	146076	201	4.5	9.045	Halococcus sediminicola	1264579	Archaea	Archaea	115	5.430000000000001e-29	NR	WP_154019981.1	1264579	g145716	i0	90.2	0.91044776119403	61	6	91	0	200	18	111	171	WP_154019981.1 IS630 family transposase [Halococcus sediminicola]	diamond	183	115	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sediminicola
26905090	26905090	PRJNA849172_P_NODE_82941_length_257_cov_2.255435_g82581_i0	PRJNA849172	82941	257	2.255435	5.79646795	root	1	Root_unresolved	Root_unresolved	66.6	1.71e-10	NR	MCX8207589.1	90426	g82581	i0	36.5	5.96498054474708	85	54	99.2	0	257	3	293	377	MCX8207589.1 PAS domain S-box protein [Methanothrix sp.]	diamond	1533	66.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
27023242	27023242	PRJNA849172_P_NODE_89562_length_252_cov_1.083799_g89202_i0	PRJNA849172	89562	252	1.083799	2.73117348	Halococcus salifodinae	36738	Archaea	Archaea	51.6	3.25e-5	NR	WP_241430264.1	36738	g89202	i0	60	0.833333333333333	35	14	41.7	0	252	148	954	988	WP_241430264.1 VWA domain-containing protein [Halococcus salifodinae]	diamond	210	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus salifodinae
27781522	27781522	PRJNA849172_P_NODE_59264_length_282_cov_1.712919_g58904_i0	PRJNA849172	59264	282	1.712919	4.83043158	Halococcus thailandensis	335952	Archaea	Archaea	161	5.15e-44	NR	WP_241431201.1	335952	g58904	i0	86.5	1.8936170212766	89	12	94.7	0	269	3	34	122	WP_241431201.1 carboxypeptidase-like regulatory domain-containing protein [Halococcus thailandensis]	diamond	534	161	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus thailandensis
27947631	27947631	PRJNA849172_P_NODE_114505_length_236_cov_6.453988_g114145_i0	PRJNA849172	114505	236	6.453988	15.23141168	Halococcus	2249	Archaea	Archaea	54.7	6.69e-7	NR	PSQ64376.1	1919209	g114145	i0	73.2	4.71610169491525	41	11	52.1	0	8	130	129	169	PSQ64376.1 MAG: TspO protein [Halobacteriales archaeon SW_9_67_24]	diamond	1113	55.1	0.992740471869329	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon SW_9_67_24
29589093	29589093	PRJNA849172_P_NODE_101370_length_245_cov_3.953488_g101010_i0	PRJNA849172	101370	245	3.953488	9.6860456	root	1	Root_unresolved	Root_unresolved	56.6	5.04e-7	NR	WP_292345499.1	1811680	g101010	i0	70	3.64897959183673	50	14	61.2	1	231	82	215	263	WP_292345499.1 PKD domain-containing protein [Methanoregula sp. PtaB.Bin085]	diamond	894	56.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. PtaB.Bin085
30497302	30497302	PRJNA849172_P_NODE_55553_length_287_cov_1.448598_g55193_i0	PRJNA849172	55553	287	1.448598	4.15747626	Methanosarcina sp.	2213	Archaea	Archaea	141	1.96e-40	NR	HET8689243.1	2213	g55193	i0	71.3	0.982578397212544	94	27	98.3	0	287	6	68	161	HET8689243.1 hypothetical protein [Methanosarcina sp.]	diamond	282	141	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
31517087	31517087	PRJNA849172_P_NODE_82996_length_257_cov_2.108696_g82636_i0	PRJNA849172	82996	257	2.108696	5.41934872	Halococcus	2249	Archaea	Archaea	120	2.78e-29	NR	WP_256686162.1	224402	g82636	i0	69.4	1.98443579766537	85	26	99.2	0	256	2	653	737	WP_256686162.1 ABC transporter permease [Halococcus qingdaonensis]	diamond	510	120	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus qingdaonensis
32077888	32077888	PRJNA849172_P_NODE_101838_length_245_cov_2.575581_g101478_i0	PRJNA849172	101838	245	2.575581	6.31017345	Methanosarcina sp.	2213	Archaea	Archaea	73.6	3.28e-14	NR	HET8688272.1	2213	g101478	i0	64	0.612244897959184	50	18	61.2	0	95	244	3	52	HET8688272.1 protein-tyrosine phosphatase family protein [Methanosarcina sp.]	diamond	150	73.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
32772977	32772977	PRJNA849172_P_NODE_62540_length_278_cov_1.795122_g62180_i0	PRJNA849172	62540	278	1.795122	4.99043916	Halococcus sp. PRR34	3020830	Archaea	Archaea	141	2.17e-39	NR	WP_273838618.1	3020830	g62180	i0	94.6	0.798561151079137	74	4	79.9	0	55	276	7	80	WP_273838618.1 hypothetical protein [Halococcus sp. PRR34]	diamond	222	141	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp. PRR34

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