metadata: contig_metadata: 5 rows where bioproject = "PRJNA235310" and tax

5 rows where bioproject = "PRJNA235310" and tax_kingdom = "Methanobacteriati"

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
19493337	19493337	PRJNA235310_P_NODE_4516_length_175_cov_1.650794_g4490_i0	PRJNA235310	4516	175	1.650794	2.8888895	uncultured Methanocorpusculum sp.	176309	Archaea	Archaea	54.7	0.004	NTclustered	gi\|2621784620\|emb\|OY781078.1\|	176309	g4490	i0	88.889	0.8	45	3	25	2	74	117	1118629	1118672	MAG: uncultured Methanocorpusculum sp. isolate da2e5db0-0b8c-42b4-9ad7-c040378b94a4 genome assembly, chromosome: 1	blastn	140	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	uncultured Methanocorpusculum sp.
20768877	20768877	PRJNA235310_P_NODE_2877_length_225_cov_1.045455_g2851_i0	PRJNA235310	2877	225	1.045455	2.35227375	Methanolobus psychrophilus	420950	Archaea	Archaea	73.1	1.54e-8	NTclustered	gi\|409168338\|gb\|CP003083.1\|	1094980	g2851	i0	97.674	2.90222222222222	43	0	20	1	53	95	2837736	2837777	Methanolobus psychrophilus R15 chromosome, complete genome	blastn	653	73.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus psychrophilus
20768895	20768895	PRJNA235310_P_NODE_3797_length_194_cov_1.075862_g3771_i0	PRJNA235310	3797	194	1.075862	2.08717228	uncultured Poseidoniia archaeon	1697135	Archaea	Archaea	56.5	0.001	NTclustered	gi\|730903838\|gb\|KP211909.1\|	1697135	g3771	i0	90.476	0.216494845360825	42	4	22	0	57	98	13332	13373	Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-OCT2007-C1337 genomic sequence	blastn	42	56.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia				uncultured Poseidoniia archaeon
27326901	27326901	PRJNA235310_P_NODE_3363_length_207_cov_0.987342_g3337_i0	PRJNA235310	3363	207	0.987342	2.04379794	Methanocorpusculum sp.	2058474	Archaea	Archaea	55.1	9.97e-7	NR	MDO5845745.1	2058474	g3337	i0	52.5	0.579710144927536	40	19	58	0	33	152	348	387	MDO5845745.1 ABC transporter substrate-binding protein [Methanocorpusculum sp.]	diamond	120	55.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
31798300	31798300	PRJNA235310_P_NODE_2017_length_277_cov_1.820175_g1991_i0	PRJNA235310	2017	277	1.820175	5.04188475	Archaea	2157	Archaea	Archaea	62.4	8.64e-11	NR	MBC7128437.1	2268204	g1991	i0	64.9	2.76173285198556	37	13	40.1	0	276	166	12	48	MBC7128437.1 30S ribosomal protein S27ae [Thermoplasmatales archaeon]	diamond	765	62.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales 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);;