metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA493827" 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
11948686	11948686	PRJNA493827_P_NODE_123870_length_307_cov_1.324786_g121672_i0	PRJNA493827	123870	307	1.324786	4.06709302	Methanosarcinales archaeon	2250255	Archaea	Archaea	139	9.31e-39	NR	RYE84306.1	2250255	g121672	i0	80.5	0.801302931596091	82	16	80.1	0	2	247	140	221	RYE84306.1 MAG: 50S ribosomal protein L3 [Methanosarcinales archaeon]	diamond	246	139	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
11950825	11950825	PRJNA493827_P_NODE_222750_length_243_cov_0.905882_g220552_i0	PRJNA493827	222750	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	118	4.34e-29	NR	WP_214046385.1	45200	g220552	i0	70.1	17.3333333333333	77	23	95.1	0	233	3	191	267	WP_214046385.1 catalase [Methanospirillum sp.]	diamond	4212	118	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum sp.
27155291	27155291	PRJNA493827_P_NODE_96442_length_349_cov_1.391304_g94244_i0	PRJNA493827	96442	349	1.391304	4.85565096	root	1	Root_unresolved	Root_unresolved	164	4.609999999999999e-48	NR	MDD4249870.1	2213	g94244	i0	72.6	3.73065902578797	106	29	91.1	0	348	31	146	251	MDD4249870.1 glycosyl amidation-associated protein WbuZ [Methanosarcina sp.]	diamond	1302	165	0.993939393939394	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28087347	28087347	PRJNA493827_P_NODE_159865_length_271_cov_1.303030_g157667_i0	PRJNA493827	159865	271	1.30303	3.5312113	Natronococcus sp. JC468	1961921	Archaea	Archaea	54.7	3.24e-6	NR	NKE35440.1	1961921	g157667	i0	47.9	4.8929889298893	48	17	53.1	1	125	268	40	79	NKE35440.1 multicopper oxidase domain-containing protein [Natronococcus sp. JC468]	diamond	1326	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus sp. JC468
30772008	30772008	PRJNA493827_P_NODE_120794_length_311_cov_1.294118_g118596_i0	PRJNA493827	120794	311	1.294118	4.02470698	Haloferax sp. S1W	3377110	Archaea	Archaea	48.1	3.51e-4	NR	WP_396612920.1	3377110	g118596	i0	30.1	0.80064308681672	83	54	76.2	1	47	283	5	87	WP_396612920.1 ester cyclase [Haloferax sp. S1W]	diamond	249	48.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. S1W
31166398	31166398	PRJNA493827_P_NODE_150555_length_279_cov_1.427184_g148357_i0	PRJNA493827	150555	279	1.427184	3.98184336	Haladaptatus	367188	Archaea	Archaea	45.8	0.00447	NR	WP_069453129.1	1897478	g148357	i0	33.8	2.09677419354839	65	42	69.9	1	197	3	289	352	WP_069453129.1 ABC transporter substrate-binding protein [Haladaptatus sp. W1]	diamond	585	46.2	0.991341991341991	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus sp. W1
31166410	31166410	PRJNA493827_P_NODE_23035_length_802_cov_3.766804_g21180_i0	PRJNA493827	23035	802	3.766804	30.20976808	Haladaptatus	367188	Archaea	Archaea	108	1.3e-23	NR	WP_244895571.1	367189	g21180	i0	35.7	2.92518703241895	196	120	71.4	4	57	629	20	214	WP_244895571.1 DUF4397 domain-containing protein [Haladaptatus paucihalophilus]	diamond	2346	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus paucihalophilus
31182298	31182298	PRJNA493827_P_NODE_156695_length_274_cov_1.034826_g154497_i0	PRJNA493827	156695	274	1.034826	2.83542324	Halobaculum sp. MBLA	1891221	Archaea	Archaea	43.1	0.0381	NR	WP_370900125.1	3079933	g154497	i0	45.8	0.525547445255474	48	23	49.3	1	151	17	66	113	WP_370900125.1 hypothetical protein [Halobaculum sp. MBLA0143]	diamond	144	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp. MBLA0143
32873455	32873455	PRJNA493827_P_NODE_220620_length_243_cov_2.023529_g218422_i0	PRJNA493827	220620	243	2.023529	4.91717547	Methanothrix	2222	Archaea	Archaea	85.5	3.28e-17	NR	MDD1738293.1	90426	g218422	i0	62.9	1.51851851851852	62	23	76.5	0	56	241	604	665	MDD1738293.1 cation-transporting P-type ATPase [Methanothrix sp.]	diamond	369	86.3	0.990730011587486	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.

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