metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1126661" 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
282757	282757	PRJNA1126661_P_NODE_72981_length_246_cov_0.901734_g72451_i0	PRJNA1126661	72981	246	0.901734	2.21826564	Deinococcus aetherius	200252	Bacteria	Bacteria	141	4.61e-29	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g72451	i0	91.429	0.426829268292683	105	6	43	3	141	245	737302	737403	Deinococcus aetherius ST0316 DNA, complete genome	blastn	105	141	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
1557198	1557198	PRJNA1126661_P_NODE_53822_length_291_cov_2.412844_g53293_i0	PRJNA1126661	53822	291	2.412844	7.02137604	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	361	3.939999999999999e-95	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g53293	i0	89.384	4.01718213058419	292	23	98	6	8	291	2739247	2739538	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1169	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
2833281	2833281	PRJNA1126661_P_NODE_53303_length_291_cov_11.408257_g52774_i0	PRJNA1126661	53303	291	11.408257	33.19802787	Meiothermus taiwanensis	172827	Bacteria	Bacteria	276	1.47e-69	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g52774	i0	100	3.5807560137457	149	0	100	0	143	291	346311	346163	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	1042	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
4109316	4109316	PRJNA1126661_P_NODE_31224_length_325_cov_3.642857_g30695_i0	PRJNA1126661	31224	325	3.642857	11.83928525	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	217	1.02e-51	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g30695	i0	95.556	36.3753846153846	135	6	88	0	1	135	2451919	2452053	Deinococcus sp. NW-56 chromosome, complete genome	blastn	11822	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
4859113	4859113	PRJNA1126661_P_NODE_50684_length_295_cov_4.500000_g50155_i0	PRJNA1126661	50684	295	4.5	13.275	Deinococcus	1298	Bacteria	Bacteria	169	2.6099999999999996e-37	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g50155	i0	87.586	1.47457627118644	145	18	49	0	3	147	2502948	2503092	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	435	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
6133986	6133986	PRJNA1126661_P_NODE_63945_length_268_cov_7.620513_g63415_i0	PRJNA1126661	63945	268	7.620513	20.42297484	Meiothermus	65551	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|118025299\|emb\|AJ864718.1\|	277	g63415	i0	100	103.014925373134	268	0	100	0	1	268	853	586	Meiothermus ruber 16S rRNA gene, strain E-steel-R2A-2	blastn	27608	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
6660521	6660521	PRJNA1126661_P_NODE_64606_length_267_cov_2.556701_g64076_i0	PRJNA1126661	64606	267	2.556701	6.82639167	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	379	9.869999999999997e-101	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g64076	i0	92.481	1.8876404494382	266	19	99	1	1	265	1309168	1308903	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	504	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
7408792	7408792	PRJNA1126661_P_NODE_37026_length_301_cov_4.732456_g36497_i0	PRJNA1126661	37026	301	4.732456	14.24469256	Truepera	332248	Bacteria	Bacteria	126	1.63e-24	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g36497	i0	89.796	15.328903654485	98	10	33	0	54	151	2896169	2896266	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	4614	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7935571	7935571	PRJNA1126661_P_NODE_49467_length_296_cov_6.973094_g48938_i0	PRJNA1126661	49467	296	6.973094	20.64035824	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	279	1.16e-70	NTclustered	gi\|1339790005\|gb\|CP026518.1\|	2080419	g48938	i0	99.355	22.1418918918919	155	0	100	1	1	155	20670	20823	Deinococcus sp. NW-56 plasmid unnamed2, complete sequence	blastn	6554	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
9959298	9959298	PRJNA1126661_P_NODE_75948_length_238_cov_3.606061_g75418_i0	PRJNA1126661	75948	238	3.606061	8.58242518	Deinococcus	1298	Bacteria	Bacteria	296	8.94e-76	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g75418	i0	89.076	6.94957983193277	238	26	100	0	1	238	2401336	2401573	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	1654	298	0.993288590604027	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11761200	11761200	PRJNA1126661_P_NODE_51630_length_294_cov_4.221719_g51101_i0	PRJNA1126661	51630	294	4.221719	12.41185386	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	281	3.2000000000000007e-71	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g51101	i0	100	6.06802721088435	152	0	100	0	1	152	347209	347360	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	1784	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16859636	16859636	PRJNA1126661_P_NODE_3714_length_462_cov_9.742931_g3193_i0	PRJNA1126661	3714	462	9.742931	45.01234122	Deinococcus ficus	317577	Bacteria	Bacteria	307	8.67e-79	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g3193	i0	100	174.229437229437	166	0	99	0	151	316	2341528	2341363	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	80494	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18133889	18133889	PRJNA1126661_P_NODE_16775_length_326_cov_4.584980_g16246_i0	PRJNA1126661	16775	326	4.58498	14.9470348	Deinococcus aetherius	200252	Bacteria	Bacteria	108	6.45e-19	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g16246	i0	86.139	0.309815950920245	101	12	31	2	51	150	124514	124415	Deinococcus aetherius ST0316 DNA, complete genome	blastn	101	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18134534	18134534	PRJNA1126661_P_NODE_72995_length_245_cov_30.372093_g72465_i0	PRJNA1126661	72995	245	30.372093	74.41162785	Meiothermus ruber	277	Bacteria	Bacteria	377	3.21e-100	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g72465	i0	94.672	3.03673469387755	244	11	99	2	1	243	1226272	1226030	Meiothermus ruber DSM 1279, complete genome	blastn	744	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
20157382	20157382	PRJNA1126661_P_NODE_39336_length_301_cov_3.675439_g38807_i0	PRJNA1126661	39336	301	3.675439	11.06307139	Deinococcus	1298	Bacteria	Bacteria	95.3	4.59e-15	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g38807	i0	86.207	4.38538205980066	87	12	29	0	1	87	1766490	1766404	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	1320	95.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
21432799	21432799	PRJNA1126661_P_NODE_30717_length_325_cov_8.710317_g30188_i0	PRJNA1126661	30717	325	8.710317	28.30853025	Truepera	332248	Bacteria	Bacteria	209	1.7100000000000001e-49	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g30188	i0	92.466	7.03076923076923	146	11	46	0	1	146	24257	24402	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	2285	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22708028	22708028	PRJNA1126661_P_NODE_67178_length_260_cov_5.256684_g66648_i0	PRJNA1126661	67178	260	5.256684	13.6673784	Meiothermus	65551	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|118025299\|emb\|AJ864718.1\|	277	g66648	i0	100	99.6038461538461	260	0	100	0	1	260	1	260	Meiothermus ruber 16S rRNA gene, strain E-steel-R2A-2	blastn	25897	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
23234431	23234431	PRJNA1126661_P_NODE_10179_length_326_cov_7.162055_g9650_i0	PRJNA1126661	10179	326	7.162055	23.3482993	Meiothermus taiwanensis	172827	Bacteria	Bacteria	235	2.8299999999999996e-57	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g9650	i0	94.702	2.77300613496933	151	8	93	0	176	326	1710605	1710455	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	904	235	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
24508203	24508203	PRJNA1126661_P_NODE_22760_length_326_cov_3.490119_g22231_i0	PRJNA1126661	22760	326	3.490119	11.37778794	Deinococcus taeanensis	2737050	Bacteria	Bacteria	207	6.18e-49	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g22231	i0	98.305	40.3251533742331	118	2	52	0	1	118	2008378	2008261	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	13146	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis

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