metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1022392" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1022392" 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
162168	162168	PRJNA1022392_P_NODE_46121_length_194_cov_2.877551_g45452_i0	PRJNA1022392	46121	194	2.877551	5.58244894	Deinococcus radiopugnans	57497	Bacteria	Bacteria	97.1	7.63e-16	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g45452	i0	84.536	1.43814432989691	97	15	50	0	98	194	325116	325020	Deinococcus swuensis strain DY59, complete genome	blastn	279	97.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2279200	2279200	PRJNA1022392_P_NODE_70262_length_165_cov_0.864407_g69593_i0	PRJNA1022392	70262	165	0.864407	1.42627155	Fervidobacterium	2422	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g69593	i0	99.394	4.93939393939394	165	1	100	0	1	165	1805554	1805390	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	815	300	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
2712813	2712813	PRJNA1022392_P_NODE_59283_length_178_cov_1.954198_g58614_i0	PRJNA1022392	59283	178	1.954198	3.47847244	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	322	1.04e-83	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g58614	i0	99.435	5.5	177	1	99	0	2	178	751792	751616	Thermus sp. NEB1569 chromosome, complete genome	blastn	979	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3988635	3988635	PRJNA1022392_P_NODE_33504_length_206_cov_2.723270_g32835_i0	PRJNA1022392	33504	206	2.72327	5.6099362	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	159	1.03e-34	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g32835	i0	95.918	16.9757281553398	98	4	48	0	109	206	360011	360108	Deinococcus sp. NW-56 chromosome, complete genome	blastn	3497	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
4831946	4831946	PRJNA1022392_P_NODE_55324_length_183_cov_2.617647_g54655_i0	PRJNA1022392	55324	183	2.617647	4.79029401	Fervidobacterium	2422	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g54655	i0	100	4.01092896174863	124	0	68	0	60	183	1737696	1737819	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	734	230	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
11640787	11640787	PRJNA1022392_P_NODE_43830_length_195_cov_2.790541_g43161_i0	PRJNA1022392	43830	195	2.790541	5.44155495	Aminithiophilus ramosus	3029084	Bacteria	Bacteria	69.4	1.67e-7	NTclustered	gi\|2027188528\|gb\|CP072943.1\|	3029084	g43161	i0	95.349	3.00512820512821	43	2	22	0	153	195	1413766	1413724	Aminithiophilus ramosus strain J.5.4.2-T.3.5.2 chromosome, complete genome	blastn	586	69.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminithiophilaceae	Aminithiophilus	Aminithiophilus ramosus
11641198	11641198	PRJNA1022392_P_NODE_80150_length_157_cov_2.045455_g79481_i0	PRJNA1022392	80150	157	2.045455	3.21136435	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	230	5.58e-56	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g79481	i0	92.994	33.9108280254777	157	11	100	0	1	157	2507806	2507650	Deinococcus sp. NW-56 chromosome, complete genome	blastn	5324	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12916274	12916274	PRJNA1022392_P_NODE_74911_length_161_cov_1.728070_g74242_i0	PRJNA1022392	74911	161	1.72807	2.7821927	Allomeiothermus silvanus	52022	Bacteria	Bacteria	189	9.77e-44	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g74242	i0	88.889	0.950310559006211	153	17	95	0	9	161	2545650	2545802	Meiothermus silvanus DSM 9946, complete genome	blastn	153	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12916373	12916373	PRJNA1022392_P_NODE_84951_length_150_cov_2.475728_g84282_i0	PRJNA1022392	84951	150	2.475728	3.713592	Deinococcus geothermalis	68909	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g84282	i0	99.333	1	150	1	100	0	1	150	2117984	2118133	Deinococcus geothermalis DSM 11300, complete genome	blastn	150	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14191223	14191223	PRJNA1022392_P_NODE_79972_length_157_cov_2.509091_g79303_i0	PRJNA1022392	79972	157	2.509091	3.93927287	Deinococcus metallilatus	1211322	Bacteria	Bacteria	215	1.56e-51	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g79303	i0	91.667	5.61783439490446	156	11	99	2	3	157	2625682	2625528	Deinococcus metallilatus strain MA1002 chromosome	blastn	882	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
18014333	18014333	PRJNA1022392_P_NODE_68875_length_166_cov_1.949580_g68206_i0	PRJNA1022392	68875	166	1.94958	3.2363028	Allomeiothermus silvanus	52022	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g68206	i0	98.193	1	166	3	100	0	1	166	2974263	2974428	Meiothermus silvanus DSM 9946, complete genome	blastn	166	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
18855371	18855371	PRJNA1022392_P_NODE_24115_length_214_cov_2.838323_g23446_i0	PRJNA1022392	24115	214	2.838323	6.07401122	root	1	Root_unresolved	Root_unresolved	387	4.55e-103	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g23446	i0	99.528	56.1869158878505	212	1	99	0	1	212	1974	2185	Thermus aquaticus DNA polymerase (PolI) gene	blastn	12024	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18855692	18855692	PRJNA1022392_P_NODE_79215_length_158_cov_0.918919_g78546_i0	PRJNA1022392	79215	158	0.918919	1.45189202	Deinococcus	1298	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g78546	i0	100	3.20253164556962	158	0	100	0	1	158	949245	949402	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	506	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
19288307	19288307	PRJNA1022392_P_NODE_79216_length_158_cov_0.918919_g78547_i0	PRJNA1022392	79216	158	0.918919	1.45189202	Thermus thermophilus	274	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g78547	i0	100	42.7658227848101	158	0	100	0	1	158	1672302	1672459	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	6757	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25230167	25230167	PRJNA1022392_P_NODE_58680_length_179_cov_1.409091_g58011_i0	PRJNA1022392	58680	179	1.409091	2.52227289	Thermus	270	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g58011	i0	100	35.6312849162011	179	0	100	0	1	179	1505948	1505770	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	6378	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus

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