metadata: contig_metadata: 5 rows where bioproject = "PRJNA615175", tax_kingdom = "Methanobacteriati" and tax

5 rows where bioproject = "PRJNA615175", tax_kingdom = "Methanobacteriati" and tax_phylum = "Methanobacteriota"

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
13349064	13349064	PRJNA615175_P_NODE_21471_length_298_cov_1.368889_g21303_i0	PRJNA615175	21471	298	1.368889	4.07928922	Halalkalicoccus jeotgali	413810	Archaea	Archaea	398	3.0899999999999995e-106	NTclustered	gi\|299126090\|gb\|CP002063.1\|	795797	g21303	i0	91.379	0.973154362416107	290	25	97	0	1	290	66675	66386	Halalkalicoccus jeotgali B3 plasmid 1, complete sequence	blastn	290	398	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
19001188	19001188	PRJNA615175_P_NODE_10595_length_449_cov_2.109043_g10427_i0	PRJNA615175	10595	449	2.109043	9.46960307	Halobellus	1073986	Archaea	Archaea	135	4.2e-34	NR	WP_049986121.1	1448860	g10427	i0	50.7	2.96659242761693	148	69	98.9	3	6	449	361	504	WP_049986121.1 GMC family oxidoreductase [Halobellus rufus]	diamond	1332	135	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus rufus
24101620	24101620	PRJNA615175_P_NODE_20779_length_304_cov_1.264069_g20611_i0	PRJNA615175	20779	304	1.264069	3.84276976	Methanobrevibacter	2172	Archaea	Archaea	551	2.289999999999999e-152	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g20611	i0	99.342	136.411184210526	304	2	100	0	1	304	542581	542278	Methanobrevibacter millerae strain SM9, complete genome	blastn	41469	551	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
28122594	28122594	PRJNA615175_P_NODE_25125_length_270_cov_2.324873_g24957_i0	PRJNA615175	25125	270	2.324873	6.2771571	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	94.4	3.69e-20	NR	WP_296886270.1	253161	g24957	i0	63.5	2.8	85	24	86.7	1	236	3	1	85	WP_296886270.1 C1 family peptidase, partial [uncultured Methanobrevibacter sp.]	diamond	756	94.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32053142	32053142	PRJNA615175_P_NODE_6498_length_597_cov_3.007634_g6333_i0	PRJNA615175	6498	597	3.007634	17.95557498	root	1	Root_unresolved	Root_unresolved	53.1	2.57e-4	NR	WP_292729902.1	90427	g6333	i0	39.7	3.49748743718593	78	38	38.2	3	351	124	312	382	WP_292729902.1 NosD domain-containing protein, partial [Methanoculleus sp.]	diamond	2088	53.5	0.992523364485981	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus 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);;