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

5 rows where bioproject = "PRJNA222400" 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
20768781	20768781	PRJNA222400_P_NODE_9337_length_162_cov_0.920354_g9304_i0	PRJNA222400	9337	162	0.920354	1.49097348	Deinococcus geothermalis	68909	Bacteria	Bacteria	292	7.3e-75	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g9304	i0	99.379	288.716049382716	161	1	99	0	2	162	328583	328423	Deinococcus geothermalis DSM 11300, complete genome	blastn	46772	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
27565509	27565509	PRJNA222400_P_NODE_3044_length_270_cov_1.411765_g3011_i0	PRJNA222400	3044	270	1.411765	3.8117655	Bacteria	2	Bacteria	Bacteria	130	9.52e-37	NR	WP_412028130.1	367282	g3011	i0	72.3	10.3111111111111	83	23	92.2	0	254	6	61	143	WP_412028130.1 NADAR family protein [Deinococcus yunweiensis]	diamond	2784	131	0.99236641221374	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
27769200	27769200	PRJNA222400_P_NODE_9064_length_163_cov_0.912281_g9031_i0	PRJNA222400	9064	163	0.912281	1.48701803	Deinococcus aquaticus	328692	Bacteria	Bacteria	94	9.57e-21	NR	WP_273991361.1	328692	g9031	i0	91.8	0.901840490797546	49	4	90.2	0	148	2	1	49	WP_273991361.1 hypothetical protein [Deinococcus aquaticus]	diamond	147	94	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
28765394	28765394	PRJNA222400_P_NODE_6307_length_179_cov_1.007692_g6274_i0	PRJNA222400	6307	179	1.007692	1.80376868	Bacteria	2	Bacteria	Bacteria	99.8	7.249999999999999e-24	NR	WP_119356974.1	863370	g6274	i0	81	22.5083798882682	58	11	97.2	0	2	175	184	241	WP_119356974.1 glucose 1-dehydrogenase [Meiothermus granaticius]	diamond	4029	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus granaticius
30895617	30895617	PRJNA222400_P_NODE_3734_length_232_cov_2.715847_g3701_i0	PRJNA222400	3734	232	2.715847	6.30076504	Synergistaceae bacterium	2053624	Bacteria	Bacteria	48.1	2.18e-4	NR	MDR2137471.1	2053624	g3701	i0	37.3	3.27155172413793	83	39	98.3	4	2	229	26	102	MDR2137471.1 TerD family protein [Synergistaceae bacterium]	diamond	759	48.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);;