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

5 rows where bioproject = "PRJNA1122875" and tax_phylum = "Thermotogota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16331222	16331222	PRJNA1122875_P_NODE_45193_length_249_cov_0.875000_g44969_i0	PRJNA1122875	45193	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	72	1.46e-14	NR	WP_290644586.1	1955248	g44969	i0	60.4	3.68674698795181	53	21	63.9	0	248	90	13	65	WP_290644586.1 cold-shock protein [Kosmotoga sp.]	diamond	918	72	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga sp.
28480569	28480569	PRJNA1122875_P_NODE_35966_length_276_cov_2.251232_g35742_i0	PRJNA1122875	35966	276	2.251232	6.21340032	Bacteria	2	Bacteria	Bacteria	112	1.64e-26	NR	WP_274967493.1	177758	g35742	i0	57.8	5.78260869565217	90	38	97.8	0	272	3	315	404	WP_274967493.1 dipeptidase [Pseudothermotoga lettingae]	diamond	1596	113	0.991150442477876	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga lettingae
28606767	28606767	PRJNA1122875_P_NODE_12227_length_476_cov_1.605459_g12004_i0	PRJNA1122875	12227	476	1.605459	7.64198484	root	1	Root_unresolved	Root_unresolved	98.6	3.2899999999999996e-23	NR	HOJ87808.1	2033661	g12004	i0	53.7	1.52521008403361	82	36	50.4	1	174	413	42	123	HOJ87808.1 glycine cleavage system protein GcvH [Pseudothermotoga sp.]	diamond	726	98.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga sp.
28954402	28954402	PRJNA1122875_P_NODE_38528_length_267_cov_1.747423_g38304_i0	PRJNA1122875	38528	267	1.747423	4.66561941	Bacteria	2	Bacteria	Bacteria	45.4	0.00574	NR	MCD6105328.1	1968895	g38304	i0	29.3	4.37078651685393	99	59	98.9	2	4	267	519	617	MCD6105328.1 sodium-translocating pyrophosphatase [Thermosipho sp. (in: thermotogales)]	diamond	1167	45.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
29849091	29849091	PRJNA1122875_P_NODE_36091_length_276_cov_1.369458_g35867_i0	PRJNA1122875	36091	276	1.369458	3.77970408	Mesotoga sp.	2053577	Bacteria	Bacteria	42.4	0.00809	NR	HRR45445.1	2053577	g35867	i0	34	0.576086956521739	53	35	57.6	0	250	92	5	57	HRR45445.1 hypothetical protein [Mesotoga sp.]	diamond	159	42.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga 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);;