metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJEB50332" and tax

20 rows where analysis = "blastn", bioproject = "PRJEB50332" 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
1393758	1393758	PRJEB50332_P_NODE_11022_length_218_cov_2.980892_g10940_i0	PRJEB50332	11022	218	2.980892	6.49834456	Meiothermus ruber	277	Bacteria	Bacteria	370	4.68e-98	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g10940	i0	97.248	3.51376146788991	218	6	100	0	1	218	587987	588204	Meiothermus ruber DSM 1279, complete genome	blastn	766	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
2266506	2266506	PRJEB50332_P_NODE_15302_length_206_cov_1.241379_g15220_i0	PRJEB50332	15302	206	1.241379	2.55724074	Deinococcus	1298	Bacteria	Bacteria	324	3.46e-84	NTclustered	gi\|444303919\|ref\|NR_074342.1\|	68909	g15220	i0	95.146	102.305825242718	206	9	100	1	1	206	451	247	Deinococcus geothermalis strain DSM 11300 plasmid pDGEO01 16S ribosomal RNA, partial sequence	blastn	21075	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
2266526	2266526	PRJEB50332_P_NODE_18222_length_196_cov_2.437037_g18140_i0	PRJEB50332	18222	196	2.437037	4.77659252	Thermus	270	Bacteria	Bacteria	363	6.899999999999998e-96	NTclustered	gi\|2199613261\|dbj\|AP025596.1\|	274	g18140	i0	100	39.4795918367347	196	0	100	0	1	196	1208018	1207823	Thermus thermophilus SNM1-1 DNA, complete genome	blastn	7738	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
2266567	2266567	PRJEB50332_P_NODE_6722_length_243_cov_2.120879_g6640_i0	PRJEB50332	6722	243	2.120879	5.15373597	Thermus	270	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2199621281\|dbj\|AP025611.1\|	274	g6640	i0	100	14.9876543209877	243	0	100	0	1	243	46881	46639	Thermus thermophilus SNM3-3 plasmid pTthSNM3-3c DNA, complete sequence	blastn	3642	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
2669451	2669451	PRJEB50332_P_NODE_12283_length_212_cov_1.291391_g12201_i0	PRJEB50332	12283	212	1.291391	2.73774892	Thermus thermophilus	274	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2199623773\|dbj\|AP025615.1\|	274	g12201	i0	100	80.8820754716981	212	0	100	0	1	212	5249	5460	Thermus thermophilus SNM6-6 plasmid pTthSNM6-6c DNA, complete sequence	blastn	17147	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3945489	3945489	PRJEB50332_P_NODE_15204_length_206_cov_1.786207_g15122_i0	PRJEB50332	15204	206	1.786207	3.67958642	Meiothermus taiwanensis	172827	Bacteria	Bacteria	375	9.41e-100	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g15122	i0	99.517	1.00485436893204	207	0	100	1	1	206	593983	593777	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	207	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
5221937	5221937	PRJEB50332_P_NODE_8745_length_232_cov_0.871345_g8663_i0	PRJEB50332	8745	232	0.871345	2.0215204	Meiothermus taiwanensis	172827	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g8663	i0	99.569	2.98275862068966	232	1	100	0	1	232	2674137	2674368	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	692	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
7771805	7771805	PRJEB50332_P_NODE_14707_length_207_cov_0.890411_g14625_i0	PRJEB50332	14707	207	0.890411	1.84315077	Meiothermus taiwanensis	172827	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g14625	i0	99.517	2.99033816425121	207	1	100	0	1	207	1801615	1801821	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	619	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
8644386	8644386	PRJEB50332_P_NODE_17667_length_202_cov_0.921986_g17585_i0	PRJEB50332	17667	202	0.921986	1.86241172	Thermus	270	Bacteria	Bacteria	346	7.2e-91	NTclustered	gi\|2090196584\|gb\|CP082323.1\|	274	g17585	i0	97.525	38.1881188118812	202	5	100	0	1	202	980371	980572	Thermus thermophilus strain N-1 chromosome, complete genome	blastn	7714	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9046678	9046678	PRJEB50332_P_NODE_18248_length_195_cov_3.044776_g18166_i0	PRJEB50332	18248	195	3.044776	5.9373132	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g18166	i0	100	8.6051282051282	195	0	100	0	1	195	1244371	1244177	Thermus sp. NEB1569 chromosome, complete genome	blastn	1678	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
11194535	11194535	PRJEB50332_P_NODE_10349_length_222_cov_2.267081_g10267_i0	PRJEB50332	10349	222	2.267081	5.03291982	Thermus	270	Bacteria	Bacteria	300	6.37e-77	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g10267	i0	90.991	42.4234234234234	222	20	100	0	1	222	915185	915406	Thermus scotoductus SA-01, complete genome	blastn	9418	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
12872994	12872994	PRJEB50332_P_NODE_6371_length_248_cov_1.566845_g6289_i0	PRJEB50332	6371	248	1.566845	3.8857756	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	387	5.409999999999998e-103	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g6289	i0	94.758	320.600806451613	248	13	100	0	1	248	2417464	2417711	Deinococcus sp. NW-56 chromosome, complete genome	blastn	79509	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14147709	14147709	PRJEB50332_P_NODE_11692_length_215_cov_1.688312_g11610_i0	PRJEB50332	11692	215	1.688312	3.6298708	Meiothermus taiwanensis	172827	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g11610	i0	100	2.98604651162791	215	0	100	0	1	215	2412695	2412909	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	642	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
14147857	14147857	PRJEB50332_P_NODE_8272_length_234_cov_1.502890_g8190_i0	PRJEB50332	8272	234	1.50289	3.5167626	Meiothermus taiwanensis	172827	Bacteria	Bacteria	399	6.499999999999999e-107	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g8190	i0	97.436	3.52991452991453	234	6	100	0	1	234	612999	613232	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	826	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
15019081	15019081	PRJEB50332_P_NODE_15772_length_205_cov_1.805556_g15690_i0	PRJEB50332	15772	205	1.805556	3.7013898	Thermus	270	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2074859917\|dbj\|AP024927.1\|	274	g15690	i0	100	13.3073170731707	205	0	100	0	1	205	123206	123002	Thermus thermophilus AA1-1 plasmid pAA1-1b DNA, complete sequence	blastn	2728	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
16293935	16293935	PRJEB50332_P_NODE_11173_length_218_cov_1.305732_g11091_i0	PRJEB50332	11173	218	1.305732	2.84649576	Deinococcus	1298	Bacteria	Bacteria	281	2.26e-71	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11091	i0	89.908	4.43577981651376	218	22	100	0	1	218	944036	944253	Deinococcus swuensis strain DY59, complete genome	blastn	967	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
16696072	16696072	PRJEB50332_P_NODE_16354_length_204_cov_1.818182_g16272_i0	PRJEB50332	16354	204	1.818182	3.70909128	Meiothermus taiwanensis	172827	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g16272	i0	99.02	21.0588235294118	204	2	100	0	1	204	1625609	1625406	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	4296	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
18842820	18842820	PRJEB50332_P_NODE_12795_length_211_cov_0.866667_g12713_i0	PRJEB50332	12795	211	0.866667	1.82866737	Thermus	270	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g12713	i0	93.365	44.9431279620853	211	14	100	0	1	211	511750	511540	Thermus thermophilus AA2-29 DNA, complete genome	blastn	9483	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
21796085	21796085	PRJEB50332_P_NODE_11898_length_214_cov_1.529412_g11816_i0	PRJEB50332	11898	214	1.529412	3.27294168	Meiothermus taiwanensis	172827	Bacteria	Bacteria	390	3.519999999999999e-104	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g11816	i0	99.533	3.73364485981308	214	1	100	0	1	214	894050	893837	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	799	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
23071427	23071427	PRJEB50332_P_NODE_15179_length_206_cov_1.793103_g15097_i0	PRJEB50332	15179	206	1.793103	3.69379218	Meiothermus taiwanensis	172827	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g15097	i0	100	3.27184466019417	206	0	100	0	1	206	2363797	2363592	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	674	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis

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