metadata: contig_metadata: 8 rows where bioproject = "PRJEB12237" and tax

8 rows where bioproject = "PRJEB12237" 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
2570593	2570593	PRJEB12237_P_NODE_5123_length_270_cov_1.702128_g4927_i0	PRJEB12237	5123	270	1.702128	4.5957456	Bacteria	2	Bacteria	Bacteria	116	4.35e-29	NR	WP_027463593.1	317577	g4927	i0	66.7	19.0333333333333	84	27	93.3	1	4	255	237	319	WP_027463593.1 malate dehydrogenase [Deinococcus ficus]	diamond	5139	116	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3536181	3536181	PRJEB12237_P_NODE_10303_length_165_cov_1.538462_g10107_i0	PRJEB12237	10303	165	1.538462	2.5384623	Deinococcus	1298	Bacteria	Bacteria	259	7.57e-65	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g10107	i0	95.152	193.406060606061	165	6	100	2	1	165	2341229	2341391	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	31912	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
10223414	10223414	PRJEB12237_P_NODE_11809_length_153_cov_1.016949_g11613_i0	PRJEB12237	11809	153	1.016949	1.55593197	Deinococcus aetherius	200252	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11613	i0	98.693	184.960784313725	153	2	100	0	1	153	83450	83602	Deinococcus aetherius ST0316 DNA, complete genome	blastn	28299	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11498668	11498668	PRJEB12237_P_NODE_10710_length_162_cov_0.944882_g10514_i0	PRJEB12237	10710	162	0.944882	1.53070884	Trueperaceae bacterium	2026798	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g10514	i0	88.272	265.691358024691	162	19	100	0	1	162	9550	9389	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	43042	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
13739002	13739002	PRJEB12237_P_NODE_2271_length_470_cov_2.390805_g2077_i0	PRJEB12237	2271	470	2.390805	11.2367835	Truepera	332248	Bacteria	Bacteria	632	1.2799999999999998e-176	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2077	i0	90.928	157.340425531915	474	37	100	4	1	470	1515	1986	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	73950	632	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16288299	16288299	PRJEB12237_P_NODE_6713_length_220_cov_2.724324_g6517_i0	PRJEB12237	6713	220	2.724324	5.9935128	Truepera	332248	Bacteria	Bacteria	300	6.3e-77	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g6517	i0	91.324	320.254545454545	219	19	99	0	1	219	507	289	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	70456	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
20421348	20421348	PRJEB12237_P_NODE_5097_length_271_cov_1.830508_g4901_i0	PRJEB12237	5097	271	1.830508	4.96067668	Trueperaceae bacterium	2026798	Bacteria	Bacteria	318	2.2199999999999995e-82	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g4901	i0	88.192	81.3247232472325	271	26	99	6	1	270	3600994	3600729	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	22039	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
21387763	21387763	PRJEB12237_P_NODE_9557_length_173_cov_2.826087_g9361_i0	PRJEB12237	9557	173	2.826087	4.88913051	Truepera	332248	Bacteria	Bacteria	209	8.15e-50	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g9361	i0	88.439	357.28901734104	173	20	100	0	1	173	702	530	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	61811	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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