metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA407368" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA407368" 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
1689907	1689907	PRJNA407368_S_NODE_3482_length_314_cov_20.810526_g3380_i0	PRJNA407368	3482	314	20.810526	65.34505164	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	398	3.279999999999999e-106	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g3380	i0	89.935	734.315286624204	308	31	100	0	7	314	544516	544209	Deinococcus sp. NW-56 chromosome, complete genome	blastn	230575	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3632606	3632606	PRJNA407368_S_NODE_9283_length_164_cov_6.022222_g9181_i0	PRJNA407368	9283	164	6.022222	9.87644408	Deinococcus	1298	Bacteria	Bacteria	265	1.6199999999999998e-66	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9181	i0	100	260	143	0	87	0	22	164	3061135	3060993	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	42640	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4909660	4909660	PRJNA407368_S_NODE_1704_length_479_cov_26.215556_g1608_i0	PRJNA407368	1704	479	26.215556	125.57251324	Deinococcus	1298	Bacteria	Bacteria	355	3.17e-93	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g1608	i0	81.116	236.091858037578	466	69	95	15	20	473	20	478	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	113088	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
5518920	5518920	PRJNA407368_S_NODE_6745_length_203_cov_6.172414_g6643_i0	PRJNA407368	6745	203	6.172414	12.53000042	Jonquetella anthropi	428712	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g6643	i0	99.015	73.3103448275862	203	2	100	0	1	203	215	417	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	14882	364	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
6184799	6184799	PRJNA407368_S_NODE_8345_length_176_cov_3.156463_g8243_i0	PRJNA407368	8345	176	3.156463	5.55537488	root	1	Root_unresolved	Root_unresolved	326	7.92e-85	NTclustered	gi\|45385854\|gb\|AY554280.1\|	274	g8243	i0	100	108	176	0	100	0	1	176	1259	1084	Thermus thermophilus 16S ribosomal RNA gene, partial sequence	blastn	19008	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
10009778	10009778	PRJNA407368_S_NODE_3748_length_301_cov_234.014706_g3646_i0	PRJNA407368	3748	301	234.014706	704.38426506	Deinococcus	1298	Bacteria	Bacteria	255	1.99e-63	NTclustered	gi\|1752957117\|gb\|MN519553.1\|	47478	g3646	i0	92.737	98.7574750830565	179	10	97	3	120	296	107	284	Deinococcus sp. strain J16OP19 16S ribosomal RNA gene, partial sequence	blastn	29726	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
10618938	10618938	PRJNA407368_S_NODE_1149_length_589_cov_1530.469643_g1070_i0	PRJNA407368	1149	589	1530.469643	9014.46619727	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	922	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1070	i0	95.353	303.393887945671	581	26	99	1	9	589	2417457	2418036	Deinococcus sp. NW-56 chromosome, complete genome	blastn	178699	922	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
11893845	11893845	PRJNA407368_S_NODE_1150_length_589_cov_1449.985714_g1071_i0	PRJNA407368	1150	589	1449.985714	8540.41585546	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	944	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1071	i0	96.041	294.811544991511	581	22	99	1	1	581	2418036	2417457	Deinococcus sp. NW-56 chromosome, complete genome	blastn	173644	944	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
11893932	11893932	PRJNA407368_S_NODE_4770_length_257_cov_10.241228_g4668_i0	PRJNA407368	4770	257	10.241228	26.31995596	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	296	9.78e-76	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g4668	i0	87.692	162.630350194553	260	25	100	7	1	257	73432	73687	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	41796	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
12560377	12560377	PRJNA407368_S_NODE_3390_length_320_cov_22.608247_g3288_i0	PRJNA407368	3390	320	22.608247	72.3463904	Deinococcus	1298	Bacteria	Bacteria	405	1.9999999999999997e-108	NTclustered	gi\|2461130460\|gb\|OQ647331.1\|	47478	g3288	i0	96.356	106.2625	247	8	77	1	74	320	175	420	Deinococcus sp. strain BFS2HB25 16S ribosomal RNA gene, partial sequence	blastn	34004	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
12560427	12560427	PRJNA407368_S_NODE_9690_length_159_cov_32.892308_g9588_i0	PRJNA407368	9690	159	32.892308	52.29876972	Deinococcus	1298	Bacteria	Bacteria	254	3.36e-63	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g9588	i0	97.945	200.716981132075	146	3	92	0	14	159	2358	2213	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	31914	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
13835207	13835207	PRJNA407368_S_NODE_4431_length_270_cov_28.585062_g4329_i0	PRJNA407368	4431	270	28.585062	77.1796674	Bacteria	2	Bacteria	Bacteria	460	3.4699999999999996e-125	NTclustered	gi\|281313228\|gb\|GU214129.1\|	158789	g4329	i0	97.407	138.033333333333	270	7	100	0	1	270	1030	1299	Uncultured Deinococcus sp. clone IAFpp7118 16S ribosomal RNA gene, partial sequence	blastn	37269	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
13835229	13835229	PRJNA407368_S_NODE_7151_length_195_cov_297.018072_g7049_i0	PRJNA407368	7151	195	297.018072	579.1852404	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g7049	i0	100	104	195	0	100	0	1	195	612	418	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	20280	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16992611	16992611	PRJNA407368_S_NODE_3854_length_296_cov_29.041199_g3752_i0	PRJNA407368	3854	296	29.041199	85.96194904	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	394	3.96e-105	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g3752	i0	91.579	204.368243243243	285	24	96	0	11	295	397231	397515	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	60493	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
18933176	18933176	PRJNA407368_S_NODE_3855_length_296_cov_13.865169_g3753_i0	PRJNA407368	3855	296	13.865169	41.04090024	Deinococcus	1298	Bacteria	Bacteria	516	8.11e-142	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g3753	i0	99.298	202.195945945946	285	2	96	0	11	295	1637039	1636755	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	59850	516	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
20207899	20207899	PRJNA407368_S_NODE_3836_length_297_cov_15.541045_g3734_i0	PRJNA407368	3836	297	15.541045	46.15690365	Deinococcus	1298	Bacteria	Bacteria	508	1.36e-139	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g3734	i0	98.606	203.771043771044	287	4	97	0	11	297	1955	2241	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	60520	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
20207934	20207934	PRJNA407368_S_NODE_7276_length_193_cov_38.140244_g7174_i0	PRJNA407368	7276	193	38.140244	73.61067092	Deinococcus	1298	Bacteria	Bacteria	268	1.5199999999999998e-67	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g7174	i0	91.753	208.549222797927	194	14	100	2	1	193	823	1015	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	40250	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
20816823	20816823	PRJNA407368_S_NODE_857_length_701_cov_31.352679_g788_i0	PRJNA407368	857	701	31.352679	219.78227979	Deinococcus maricopensis	309887	Bacteria	Bacteria	628	2.5399999999999995e-175	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g788	i0	83.218	840.843081312411	721	85	99	31	1	699	639983	640689	Deinococcus maricopensis DSM 21211, complete genome	blastn	589431	628	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
21483409	21483409	PRJNA407368_S_NODE_2237_length_410_cov_146.070866_g2136_i0	PRJNA407368	2237	410	146.070866	598.8905506	Deinococcus	1298	Bacteria	Bacteria	641	1.84e-179	NTclustered	gi\|1073549716\|gb\|KX946495.1\|	47478	g2136	i0	94.891	107.951219512195	411	19	100	2	1	410	469	878	Deinococcus sp. strain FX4 16S ribosomal RNA gene, partial sequence	blastn	44260	647	0.990726429675425	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
22091570	22091570	PRJNA407368_S_NODE_4718_length_259_cov_9.773913_g4616_i0	PRJNA407368	4718	259	9.773913	25.31443467	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	457	4.279999999999999e-124	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g4616	i0	98.456	169.602316602317	259	4	100	0	1	259	73687	73429	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	43927	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
22758623	22758623	PRJNA407368_S_NODE_2138_length_420_cov_170.708440_g2037_i0	PRJNA407368	2138	420	170.70844	716.975448	Bacteria	2	Bacteria	Bacteria	732	0	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g2037	i0	98.095	105.752380952381	420	8	100	0	1	420	857	438	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	44416	732	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23367167	23367167	PRJNA407368_S_NODE_3959_length_291_cov_332.538168_g3857_i0	PRJNA407368	3959	291	332.538168	967.68606888	Deinococcus puniceus	1182568	Bacteria	Bacteria	302	2.42e-77	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g3857	i0	89.256	221.632302405498	242	25	83	1	50	291	71108	70868	Deinococcus puniceus strain DY1, complete genome	blastn	64495	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
24033399	24033399	PRJNA407368_S_NODE_2319_length_402_cov_16.337802_g2218_i0	PRJNA407368	2319	402	16.337802	65.67796404	Thermus	270	Bacteria	Bacteria	743	0	NTclustered	gi\|1701967042\|dbj\|AP019801.1\|	274	g2218	i0	100	135.410447761194	402	0	100	0	1	402	12985	12584	Thermus thermophilus HC11 DNA, complete genome	blastn	54435	743	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
24033410	24033410	PRJNA407368_S_NODE_3319_length_323_cov_31.544218_g3217_i0	PRJNA407368	3319	323	31.544218	101.88782414	Bacteria	2	Bacteria	Bacteria	357	5.74e-94	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g3217	i0	99.49	143.173374613003	196	1	100	0	1	196	1149	954	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	46245	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25307817	25307817	PRJNA407368_S_NODE_1640_length_490_cov_200.479393_g1545_i0	PRJNA407368	1640	490	200.479393	982.3490257	Deinococcus	1298	Bacteria	Bacteria	706	0	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g1545	i0	94.737	197.326530612245	456	21	93	3	3	456	1799	1345	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	96690	712	0.991573033707865	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus

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