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

5 rows where bioproject = "PRJNA1108009" and tax_kingdom = "Thermotogati"

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
1488016	1488016	PRJNA1108009_P_NODE_8402_length_473_cov_1.555000_g8085_i0	PRJNA1108009	8402	473	1.555	7.35515	Mesotoga sp.	2053577	Bacteria	Bacteria	243	5.2e-75	NR	MCB1222954.1	2053577	g8085	i0	73.9	3.9830866807611	157	41	99.6	0	472	2	119	275	MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.]	diamond	1884	243	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
14241899	14241899	PRJNA1108009_P_NODE_26792_length_248_cov_0.880000_g26474_i0	PRJNA1108009	26792	248	0.88	2.1824	Deinococcus rubellus	1889240	Bacteria	Bacteria	207	4.52e-49	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g26474	i0	82.072	178.721774193548	251	37	100	8	1	248	321257	321012	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	44323	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
23972775	23972775	PRJNA1108009_P_NODE_13799_length_356_cov_1.625442_g13481_i0	PRJNA1108009	13799	356	1.625442	5.78657352	Mesotoga sp.	2053577	Bacteria	Bacteria	183	1.8099999999999993e-52	NR	MCB1222954.1	2053577	g13481	i0	71.8	0.985955056179775	117	33	98.6	0	351	1	129	245	MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.]	diamond	351	183	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
27952172	27952172	PRJNA1108009_P_NODE_30445_length_243_cov_0.905882_g30127_i0	PRJNA1108009	30445	243	0.905882	2.20129326	Aminivibrio sp.	1872489	Bacteria	Bacteria	96.7	1.6400000000000002e-21	NR	WP_367339685.1	1872489	g30127	i0	54.8	1.03703703703704	84	35	100	2	243	1	280	363	WP_367339685.1 M24 family metallopeptidase [Aminivibrio sp.]	diamond	252	96.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.
31110165	31110165	PRJNA1108009_P_NODE_18815_length_298_cov_1.506667_g18497_i0	PRJNA1108009	18815	298	1.506667	4.48986766	Synergistaceae bacterium	2053624	Bacteria	Bacteria	60.1	1.45e-8	NR	MDR2137471.1	2053624	g18497	i0	38.5	0.966442953020134	96	46	89.6	4	280	14	23	112	MDR2137471.1 TerD family protein [Synergistaceae bacterium]	diamond	288	60.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium

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