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

5 rows where bioproject = "PRJNA376117" 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
13153729	13153729	PRJNA376117_P_NODE_34851_length_250_cov_0.870056_g34549_i0	PRJNA376117	34851	250	0.870056	2.17514	Natronomonas halophila	2747817	Archaea	Archaea	449	6.87e-122	NTclustered	gi\|1865516082\|gb\|CP058334.1\|	2747817	g34549	i0	99.197	2.284	249	2	99	0	2	250	978647	978399	Natronomonas halophila strain C90 chromosome, complete genome	blastn	571	449	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas halophila
18925292	18925292	PRJNA376117_P_NODE_5255_length_593_cov_2.019231_g4960_i0	PRJNA376117	5255	593	2.019231	11.97403983	Thermococcus	2263	Archaea	Archaea	1020	0	NTclustered	gi\|189908859\|gb\|EU571472.1\|	342948	g4960	i0	100	14.2428330522766	552	0	93	0	33	584	555	4	Thermococcus onnurineus dITPase gene, complete cds	blastn	8446	1020	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus onnurineus
27927738	27927738	PRJNA376117_P_NODE_37025_length_248_cov_0.880000_g36723_i0	PRJNA376117	37025	248	0.88	2.1824	Methanosphaera sp.	2666342	Archaea	Archaea	101	6.29e-23	NR	MEE3419334.1	2666342	g36723	i0	74.7	0.955645161290323	79	18	95.6	1	244	8	154	230	MEE3419334.1 hypothetical protein [Methanosphaera sp.]	diamond	237	101	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
28386798	28386798	PRJNA376117_P_NODE_33286_length_252_cov_1.720670_g32984_i0	PRJNA376117	33286	252	1.72067	4.3360884	root	1	Root_unresolved	Root_unresolved	49.7	9.78e-5	NR	WP_080510819.1	416585	g32984	i0	47.7	3.3452380952381	44	23	52.4	0	188	57	129	172	WP_080510819.1 protein kinase domain-containing protein [Halorubrum californiense]	diamond	843	49.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum californiense
29253583	29253583	PRJNA376117_P_NODE_27189_length_275_cov_1.524752_g26887_i0	PRJNA376117	27189	275	1.524752	4.193068	Methanosphaera sp. rholeuAM27	2666342	Archaea	Archaea	47.4	0.00127	NR	RAP51212.1	1945577	g26887	i0	52.3	1.24363636363636	44	20	46.9	1	3	131	60	103	RAP51212.1 MAG: hypothetical protein BZ138_05740 [Methanosphaera sp. rholeuAM270]	diamond	342	47.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. rholeuAM270

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