metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
1467084	1467084	PRJNA1078753_P_NODE_19382_length_281_cov_1.302885_g19186_i0	PRJNA1078753	19382	281	1.302885	3.66110685	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	359	1.36e-94	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g19186	i0	90.545	291.576512455516	275	21	98	5	2	275	543126	543396	Deinococcus sp. NW-56 chromosome, complete genome	blastn	81933	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
2743244	2743244	PRJNA1078753_P_NODE_25283_length_257_cov_1.635870_g25087_i0	PRJNA1078753	25283	257	1.63587	4.2041859	Deinococcus metallilatus	1211322	Bacteria	Bacteria	176	1.33e-39	NTclustered	gi\|1609450184\|gb\|CP038510.1\|	1211322	g25087	i0	82.353	1.49027237354086	204	34	79	2	55	257	20682	20884	Deinococcus metallilatus strain MA1002 plasmid unnamed1, complete sequence	blastn	383	176	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
5295376	5295376	PRJNA1078753_P_NODE_31925_length_248_cov_0.880000_g31729_i0	PRJNA1078753	31925	248	0.88	2.1824	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	361	3.2799999999999995e-95	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g31729	i0	93.089	5.56451612903226	246	17	99	0	1	246	2285612	2285367	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1380	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5295442	5295442	PRJNA1078753_P_NODE_40645_length_243_cov_0.894118_g40449_i0	PRJNA1078753	40645	243	0.894118	2.17270674	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	180	9.63e-41	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g40449	i0	89.437	0.584362139917695	142	15	58	0	102	243	383172	383031	Deinococcus sp. NW-56 chromosome, complete genome	blastn	142	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6570417	6570417	PRJNA1078753_P_NODE_17746_length_288_cov_1.274419_g17550_i0	PRJNA1078753	17746	288	1.274419	3.67032672	Deinococcus geothermalis	68909	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g17550	i0	100	1	288	0	100	0	1	288	1178407	1178120	Deinococcus geothermalis DSM 11300, complete genome	blastn	288	532	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7394683	7394683	PRJNA1078753_P_NODE_31946_length_248_cov_0.880000_g31750_i0	PRJNA1078753	31946	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	250	7.41e-62	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g31750	i0	87.793	6.07661290322581	213	26	86	0	1	213	2588456	2588668	Deinococcus swuensis strain DY59, complete genome	blastn	1507	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
7394687	7394687	PRJNA1078753_P_NODE_32726_length_248_cov_0.880000_g32530_i0	PRJNA1078753	32726	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	457	4.07e-124	NTclustered	gi\|369724608\|gb\|JN792321.1\|	158789	g32530	i0	100	105.266129032258	247	0	99	0	2	248	406	160	Uncultured Deinococcus sp. clone PLYFP55 16S ribosomal RNA gene, partial sequence	blastn	26106	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
9120127	9120127	PRJNA1078753_P_NODE_20828_length_275_cov_1.287129_g20632_i0	PRJNA1078753	20828	275	1.287129	3.53960475	Deinococcus geothermalis	68909	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g20632	i0	100	1	275	0	100	0	1	275	207838	208112	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	275	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
10395915	10395915	PRJNA1078753_P_NODE_34469_length_247_cov_0.862069_g34273_i0	PRJNA1078753	34469	247	0.862069	2.12931043	Deinococcus maricopensis	309887	Bacteria	Bacteria	158	4.6e-34	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g34273	i0	79.06	30.0688259109312	234	45	94	4	11	242	2064506	2064275	Deinococcus maricopensis DSM 21211, complete genome	blastn	7427	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
11220388	11220388	PRJNA1078753_P_NODE_33769_length_247_cov_0.885057_g33573_i0	PRJNA1078753	33769	247	0.885057	2.18609079	Thermus	270	Bacteria	Bacteria	143	1.29e-29	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g33573	i0	83.544	59.2834008097166	158	20	63	4	60	214	736592	736438	Thermus thermophilus AA2-29 DNA, complete genome	blastn	14643	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11671183	11671183	PRJNA1078753_P_NODE_21490_length_272_cov_1.547739_g21294_i0	PRJNA1078753	21490	272	1.547739	4.20985008	Deinococcus metallilatus	1211322	Bacteria	Bacteria	383	7.79e-102	NTclustered	gi\|1609450927\|gb\|CP038511.1\|	1211322	g21294	i0	92.222	5.48529411764706	270	21	99	0	3	272	199216	199485	Deinococcus metallilatus strain MA1002 plasmid unnamed2	blastn	1492	383	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
14221301	14221301	PRJNA1078753_P_NODE_29912_length_249_cov_1.551136_g29716_i0	PRJNA1078753	29912	249	1.551136	3.86232864	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g29716	i0	99.598	19.8112449799197	249	1	100	0	1	249	460115	460363	Thermus sp. NEB1569 chromosome, complete genome	blastn	4933	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
14221395	14221395	PRJNA1078753_P_NODE_41492_length_242_cov_0.911243_g41296_i0	PRJNA1078753	41492	242	0.911243	2.20520806	Deinococcus radiopugnans	57497	Bacteria	Bacteria	180	9.58e-41	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g41296	i0	81.448	2.61570247933884	221	39	91	2	5	224	296067	295848	Deinococcus swuensis strain DY59, complete genome	blastn	633	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
15495201	15495201	PRJNA1078753_P_NODE_28913_length_250_cov_0.870056_g28717_i0	PRJNA1078753	28913	250	0.870056	2.17514	Deinococcus yunweiensis	367282	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g28717	i0	85.657	1.748	251	34	100	2	1	250	1329031	1329280	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	437	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
16769481	16769481	PRJNA1078753_P_NODE_21714_length_271_cov_1.878788_g21518_i0	PRJNA1078753	21714	271	1.878788	5.09151548	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	429	9.83e-116	NTclustered	gi\|1868564649\|gb\|CP058536.1\|	2755035	g21518	i0	95.203	1	271	13	100	0	1	271	175851	176121	Deinococcus sp. D7000 plasmid p_2, complete sequence	blastn	271	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
18044358	18044358	PRJNA1078753_P_NODE_34295_length_247_cov_0.885057_g34099_i0	PRJNA1078753	34295	247	0.885057	2.18609079	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g34099	i0	97.872	16.4210526315789	235	5	95	0	1	235	2480912	2481146	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	4056	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18868545	18868545	PRJNA1078753_P_NODE_30775_length_249_cov_0.875000_g30579_i0	PRJNA1078753	30775	249	0.875	2.17875	Truepera	332248	Bacteria	Bacteria	137	6.0499999999999996e-28	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g30579	i0	78.673	2.26907630522088	211	41	84	4	22	230	2797991	2797783	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	565	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
20593533	20593533	PRJNA1078753_P_NODE_17417_length_289_cov_2.000000_g17221_i0	PRJNA1078753	17417	289	2	5.78	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	178	4.23e-40	NTclustered	gi\|429128598\|gb\|CP003382.1\|	937777	g17221	i0	85.714	2.37716262975779	168	24	58	0	107	274	2520087	2520254	Deinococcus peraridilitoris DSM 19664, complete genome	blastn	687	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
20593666	20593666	PRJNA1078753_P_NODE_35117_length_246_cov_0.890173_g34921_i0	PRJNA1078753	35117	246	0.890173	2.18982558	Deinococcus metallilatus	1211322	Bacteria	Bacteria	257	4.39e-64	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g34921	i0	92.697	3.38211382113821	178	13	72	0	1	178	3056100	3055923	Deinococcus metallilatus strain MA1002 chromosome	blastn	832	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
20593712	20593712	PRJNA1078753_P_NODE_4217_length_502_cov_2.153846_g4021_i0	PRJNA1078753	4217	502	2.153846	10.81230692	Deinococcus aetherius	200252	Bacteria	Bacteria	640	8.229999999999999e-179	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g4021	i0	89.723	374.221115537849	506	44	100	7	1	502	299714	299213	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	187859	640	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21419045	21419045	PRJNA1078753_P_NODE_577_length_1191_cov_2.006261_g460_i0	PRJNA1078753	577	1191	2.006261	23.89456851	Deinococcus	1298	Bacteria	Bacteria	1687	0	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g460	i0	92.327	214.851385390428	1199	72	100	14	1	1191	83363	82177	Deinococcus aetherius ST0316 DNA, complete genome	blastn	255888	1687	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius

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