metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
414630	414630	PRJNA404067_P_NODE_32141_length_208_cov_0.870748_g31754_i0	PRJNA404067	32141	208	0.870748	1.81115584	Deinococcus grandis	57498	Bacteria	Bacteria	267	5.98e-67	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g31754	i0	93.785	2.55288461538462	177	11	85	0	32	208	2709766	2709942	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	531	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
1689463	1689463	PRJNA404067_P_NODE_28642_length_214_cov_1.359477_g28255_i0	PRJNA404067	28642	214	1.359477	2.90928078	Allomeiothermus silvanus	52022	Bacteria	Bacteria	374	3.539999999999999e-99	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g28255	i0	98.131	1	214	4	100	0	1	214	3243594	3243381	Meiothermus silvanus DSM 9946, complete genome	blastn	214	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2965386	2965386	PRJNA404067_P_NODE_3023_length_1123_cov_390.920904_g2755_i0	PRJNA404067	3023	1123	390.920904	4390.04175192	Deinococcus aquaticus	328692	Bacteria	Bacteria	1784	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g2755	i0	96.59	213.66874443455	1085	21	96	13	26	1102	715727	714651	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	239950	1784	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4241480	4241480	PRJNA404067_P_NODE_12084_length_303_cov_2.450413_g11698_i0	PRJNA404067	12084	303	2.450413	7.42475139	Trueperaceae bacterium	2026798	Bacteria	Bacteria	451	2.38e-122	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g11698	i0	93.688	404.726072607261	301	19	99	0	3	303	7487	7187	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	122632	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4241881	4241881	PRJNA404067_P_NODE_37384_length_202_cov_1.304965_g36997_i0	PRJNA404067	37384	202	1.304965	2.6360293	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g36997	i0	99.505	7.08415841584158	202	1	100	0	1	202	629027	628826	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	1431	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5518625	5518625	PRJNA404067_P_NODE_41045_length_192_cov_3.664122_g40658_i0	PRJNA404067	41045	192	3.664122	7.03511424	Thermus aquaticus	271	Bacteria	Bacteria	220	4.279999999999999e-53	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g40658	i0	95.62	56.78125	137	6	71	0	56	192	121	257	Thermus aquaticus DNA polymerase (PolI) gene	blastn	10902	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
6792466	6792466	PRJNA404067_P_NODE_34766_length_205_cov_0.888889_g34379_i0	PRJNA404067	34766	205	0.888889	1.82222245	Allomeiothermus silvanus	52022	Bacteria	Bacteria	374	3.3599999999999997e-99	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g34379	i0	99.512	1	205	1	100	0	1	205	727526	727730	Meiothermus silvanus DSM 9946, complete genome	blastn	205	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
8067840	8067840	PRJNA404067_P_NODE_23367_length_227_cov_1.421687_g22980_i0	PRJNA404067	23367	227	1.421687	3.22722949	Allomeiothermus silvanus	52022	Bacteria	Bacteria	398	2.25e-106	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g22980	i0	98.238	1	227	4	100	0	1	227	1351753	1351527	Meiothermus silvanus DSM 9946, complete genome	blastn	227	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10009341	10009341	PRJNA404067_P_NODE_21468_length_232_cov_1.719298_g21081_i0	PRJNA404067	21468	232	1.719298	3.98877136	Truepera	332248	Bacteria	Bacteria	351	1.8299999999999998e-92	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g21081	i0	93.966	1087.93103448276	232	14	100	0	1	232	2939	2708	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	252400	351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10009355	10009355	PRJNA404067_P_NODE_22508_length_229_cov_2.005952_g22121_i0	PRJNA404067	22508	229	2.005952	4.59363008	Deinococcus	1298	Bacteria	Bacteria	412	8.13e-111	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g22121	i0	99.127	132.052401746725	229	2	100	0	1	229	1393	1621	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	30240	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11893507	11893507	PRJNA404067_P_NODE_32770_length_207_cov_1.260274_g32383_i0	PRJNA404067	32770	207	1.260274	2.60876718	Allomeiothermus silvanus	52022	Bacteria	Bacteria	355	1.23e-93	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g32383	i0	97.585	1	207	5	100	0	1	207	2233187	2232981	Meiothermus silvanus DSM 9946, complete genome	blastn	207	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
11893511	11893511	PRJNA404067_P_NODE_32990_length_207_cov_0.876712_g32603_i0	PRJNA404067	32990	207	0.876712	1.81479384	Allomeiothermus silvanus	52022	Bacteria	Bacteria	224	3.6299999999999996e-54	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g32603	i0	88.325	12.5458937198068	197	9	95	6	11	207	2432579	2432397	Meiothermus silvanus DSM 9946, complete genome	blastn	2597	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
13168343	13168343	PRJNA404067_P_NODE_25931_length_220_cov_2.163522_g25544_i0	PRJNA404067	25931	220	2.163522	4.7597484	Trueperaceae bacterium	2026798	Bacteria	Bacteria	250	6.44e-62	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g25544	i0	87.5	869.572727272727	216	27	98	0	5	220	6814	6599	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	191306	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
20816230	20816230	PRJNA404067_P_NODE_25417_length_222_cov_1.136646_g25030_i0	PRJNA404067	25417	222	1.136646	2.52335412	Allomeiothermus silvanus	52022	Bacteria	Bacteria	383	6.1499999999999996e-102	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g25030	i0	97.758	1.97297297297297	223	4	100	1	1	222	2775424	2775202	Meiothermus silvanus DSM 9946, complete genome	blastn	438	383	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
23366759	23366759	PRJNA404067_P_NODE_32499_length_207_cov_2.205479_g32112_i0	PRJNA404067	32499	207	2.205479	4.56534153	Allomeiothermus silvanus	52022	Bacteria	Bacteria	370	4.4e-98	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g32112	i0	99.507	2.98067632850242	203	1	98	0	5	207	959909	959707	Meiothermus silvanus DSM 9946, complete genome	blastn	617	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
25307457	25307457	PRJNA404067_P_NODE_26060_length_220_cov_1.308176_g25673_i0	PRJNA404067	26060	220	1.308176	2.8779872	Thermus	270	Bacteria	Bacteria	401	1.6799999999999993e-107	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g25673	i0	99.545	12.9227272727273	220	1	100	0	1	220	2153521	2153302	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	2843	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii

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