metadata: contig_metadata: 6 rows where bioproject = "PRJNA683669" and tax

6 rows where bioproject = "PRJNA683669" 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
4492799	4492799	PRJNA683669_P_NODE_10004_length_405_cov_2.500000_g9773_i0	PRJNA683669	10004	405	2.5	10.125	Bacteria	2	Bacteria	Bacteria	177	1.67e-48	NR	WP_038066611.1	2337	g9773	i0	69.8	11.2074074074074	126	38	93.3	0	378	1	4	129	WP_038066611.1 pyruvate, phosphate dikinase [Thermotoga neapolitana]	diamond	4539	177	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga neapolitana
5768609	5768609	PRJNA683669_P_NODE_28685_length_248_cov_0.880000_g28453_i0	PRJNA683669	28685	248	0.88	2.1824	Deinococcota bacterium DY0809b	3396280	Bacteria	Bacteria	165	2.76e-36	NTclustered	gi\|2904223141\|gb\|CP179936.1\|	3396280	g28453	i0	81.308	76.1612903225806	214	31	85	7	20	230	418789	418582	Deinococcota bacterium DY0809b chromosome, complete genome	blastn	18888	165	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium DY0809b
12144356	12144356	PRJNA683669_P_NODE_24690_length_259_cov_1.268817_g24458_i0	PRJNA683669	24690	259	1.268817	3.28623603	Deinococcus ficus	317577	Bacteria	Bacteria	89.8	1.8e-13	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g24458	i0	83.673	1.36679536679537	98	12	37	3	144	239	1829819	1829724	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	354	89.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
28061221	28061221	PRJNA683669_P_NODE_725_length_1400_cov_3.250942_g637_i0	PRJNA683669	725	1400	3.250942	45.513188	Deinococcus hopiensis	309885	Bacteria	Bacteria	687	3.4100000000000002e-245	NR	WP_170928889.1	309885	g637	i0	72.4	0.938571428571429	438	121	93.9	0	1315	2	43	480	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	1314	687	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
28408643	28408643	PRJNA683669_P_NODE_26746_length_250_cov_0.870056_g26514_i0	PRJNA683669	26746	250	0.870056	2.17514	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	52.4	1.53e-5	NR	MFN3328904.1	93466	g26514	i0	53	0.792	66	23	74.4	3	215	30	101	162	MFN3328904.1 LIM domain-containing protein [Fervidobacterium pennivorans]	diamond	198	52.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
32485205	32485205	PRJNA683669_P_NODE_30759_length_245_cov_0.895349_g30527_i0	PRJNA683669	30759	245	0.895349	2.19360505	Synergistaceae bacterium	2053624	Bacteria	Bacteria	46.2	0.00228	NR	MBR0168130.1	2053624	g30527	i0	52.4	1.54285714285714	63	22	77.1	3	245	57	569	623	MBR0168130.1 ankyrin repeat domain-containing protein [Synergistaceae bacterium]	diamond	378	46.2	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);;