metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA807685" 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
806592	806592	PRJNA807685_P_NODE_37441_length_202_cov_1.648485_g36368_i0	PRJNA807685	37441	202	1.648485	3.3299397	Deinococcus radiomollis	468916	Bacteria	Bacteria	237	4.52e-58	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g36368	i0	94.231	15.8118811881188	156	7	77	1	3	158	2818582	2818735	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	3194	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
2082109	2082109	PRJNA807685_P_NODE_10282_length_521_cov_2.243802_g9244_i0	PRJNA807685	10282	521	2.243802	11.69020842	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	747	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g9244	i0	92.351	38.1132437619962	536	23	99	5	2	521	155222	154689	Deinococcus sp. NW-56 chromosome, complete genome	blastn	19857	747	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
5909881	5909881	PRJNA807685_P_NODE_25885_length_260_cov_1.210762_g24812_i0	PRJNA807685	25885	260	1.210762	3.1479812	Deinococcus sonorensis	309891	Bacteria	Bacteria	340	4.52e-89	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g24812	i0	90.698	59.8230769230769	258	20	98	4	1	256	2200816	2201071	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	15554	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
7184656	7184656	PRJNA807685_P_NODE_13346_length_426_cov_3.724936_g12284_i0	PRJNA807685	13346	426	3.724936	15.86822736	Trueperaceae bacterium	2026798	Bacteria	Bacteria	492	2.0399999999999996e-134	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g12284	i0	88.278	394.697183098592	418	40	96	5	16	426	8066	7651	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	168141	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7184798	7184798	PRJNA807685_P_NODE_30326_length_232_cov_2.902564_g29253_i0	PRJNA807685	30326	232	2.902564	6.73394848	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	303	5.19e-78	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g29253	i0	92.093	28.5646551724138	215	17	93	0	1	215	429936	429722	Deinococcus sp. NW-56 chromosome, complete genome	blastn	6627	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
8459393	8459393	PRJNA807685_P_NODE_13707_length_418_cov_1.850394_g12645_i0	PRJNA807685	13707	418	1.850394	7.73464692	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	446	1.5799999999999998e-120	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g12645	i0	85.919	20.9569377990431	419	57	100	2	1	418	236734	237151	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	8760	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
9734738	9734738	PRJNA807685_P_NODE_56228_length_163_cov_1.515873_g55155_i0	PRJNA807685	56228	163	1.515873	2.47087299	Deinococcus radiomollis	468916	Bacteria	Bacteria	158	2.8e-34	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g55155	i0	87.591	0.840490797546012	137	15	83	2	20	155	1128957	1129092	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	137	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
11010217	11010217	PRJNA807685_P_NODE_10049_length_530_cov_3.158215_g9017_i0	PRJNA807685	10049	530	3.158215	16.7385395	Trueperaceae bacterium	2026798	Bacteria	Bacteria	361	7.609999999999999e-95	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g9017	i0	89	401.918867924528	300	22	55	7	240	530	3601102	3600805	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	213017	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
11010493	11010493	PRJNA807685_P_NODE_43689_length_185_cov_1.824324_g42616_i0	PRJNA807685	43689	185	1.824324	3.3749994	Deinococcus maricopensis	309887	Bacteria	Bacteria	193	8.919999999999999e-45	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g42616	i0	85.405	1	185	27	100	0	1	185	2484172	2484356	Deinococcus maricopensis DSM 21211, complete genome	blastn	185	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
11426578	11426578	PRJNA807685_P_NODE_29409_length_237_cov_5.105000_g28336_i0	PRJNA807685	29409	237	5.105	12.09885	Truepera	332248	Bacteria	Bacteria	326	1.14e-84	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g28336	i0	93.578	622.194092827004	218	14	92	0	2	219	762032	762249	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	147460	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12285915	12285915	PRJNA807685_P_NODE_2950_length_1831_cov_561.383501_g1637_i1	PRJNA807685	2950	1831	561.383501	10278.93190331	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	2806	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1637	i1	95.707	268.196067722556	1747	70	95	5	63	1807	544733	542990	Deinococcus sp. NW-56 chromosome, complete genome	blastn	491067	2806	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12702301	12702301	PRJNA807685_P_NODE_30390_length_232_cov_1.748718_g29317_i0	PRJNA807685	30390	232	1.748718	4.05702576	Deinococcus	1298	Bacteria	Bacteria	329	8.56e-86	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g29317	i0	92.241	52.375	232	18	100	0	1	232	921719	921950	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	12151	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
22900397	22900397	PRJNA807685_P_NODE_45698_length_181_cov_1.076389_g44625_i0	PRJNA807685	45698	181	1.076389	1.94826409	Deinococcus	1298	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g44625	i0	100	4.98895027624309	181	0	100	0	1	181	464138	464318	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	903	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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