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

5 rows where bioproject = "PRJNA690124" 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
8322919	8322919	PRJNA690124_P_NODE_5867_length_658_cov_1.793162_g5513_i0	PRJNA690124	5867	658	1.793162	11.79900596	Natronorubrum daqingense	588898	Archaea	Archaea	69.4	6.5e-7	NTclustered	gi\|1134979927\|gb\|CP019327.1\|	588898	g5513	i0	85.294	0.103343465045593	68	8	10	2	326	392	592951	592885	Natronorubrum daqingense strain JX313, complete sequence	blastn	68	69.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum daqingense
28314158	28314158	PRJNA690124_P_NODE_51146_length_246_cov_0.901734_g50780_i0	PRJNA690124	51146	246	0.901734	2.21826564	Methanobacteriota archaeon	2026739	Archaea	Archaea	110	4.05e-26	NR	TLZ83810.1	2026739	g50780	i0	74.1	0.98780487804878	81	21	98.8	0	3	245	217	297	TLZ83810.1 MAG: hypothetical protein E6K03_03900, partial [Methanobacteriota archaeon]	diamond	243	110	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29766352	29766352	PRJNA690124_P_NODE_48391_length_248_cov_1.737143_g48025_i0	PRJNA690124	48391	248	1.737143	4.30811464	Methanobacteriota archaeon	2026739	Archaea	Archaea	95.1	9.13e-22	NR	TLZ64887.1	2026739	g48025	i0	58.5	1.98387096774194	82	34	99.2	0	1	246	143	224	TLZ64887.1 MAG: glycosyltransferase family 2 protein [Methanobacteriota archaeon]	diamond	492	95.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30082217	30082217	PRJNA690124_P_NODE_37152_length_273_cov_1.380000_g36786_i0	PRJNA690124	37152	273	1.38	3.7674	Methanobacteriota archaeon	2026739	Archaea	Archaea	80.9	3.9e-16	NR	MDE1822279.1	2026739	g36786	i0	45.2	0.802197802197802	73	40	80.2	0	220	2	176	248	MDE1822279.1 ERCC4 domain-containing protein [Methanobacteriota archaeon]	diamond	219	80.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31030483	31030483	PRJNA690124_P_NODE_44795_length_252_cov_0.871508_g44429_i0	PRJNA690124	44795	252	0.871508	2.19620016	Candidatus Hadarchaeota archaeon	3097284	Archaea	Archaea	70.5	9.17e-13	NR	MEW6593193.1	3097284	g44429	i0	67.9	0.630952380952381	53	17	63.1	0	244	86	132	184	MEW6593193.1 (Fe-S)-binding protein [Candidatus Hadarchaeota archaeon]	diamond	159	70.5	1	Archaea		Methanobacteriati	Candidatus Hadarchaeota					Candidatus Hadarchaeota 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);;