metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA795663" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA795663" 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
2055274	2055274	PRJNA795663_S_NODE_162_length_1127_cov_18.140367_g85_i3	PRJNA795663	162	1127	18.140367	204.44193609	Deinococcus aquaticus	328692	Bacteria	Bacteria	1712	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g85	i3	94.454	300.222715173026	1118	53	99	9	15	1127	714790	715903	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	338351	1712	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
2055356	2055356	PRJNA795663_S_NODE_3682_length_301_cov_2.090909_g3577_i0	PRJNA795663	3682	301	2.090909	6.29363609	Deinococcus aquaticus	328692	Bacteria	Bacteria	448	3.0599999999999997e-121	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g3577	i0	95.07	38.7242524916944	284	14	94	0	1	284	2475228	2475511	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	11656	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
3330437	3330437	PRJNA795663_S_NODE_13923_length_169_cov_1.439394_g13818_i0	PRJNA795663	13923	169	1.439394	2.43257586	Deinococcus aquaticus	328692	Bacteria	Bacteria	220	3.66e-53	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g13818	i0	90.476	12.1360946745562	168	14	99	2	3	169	1327817	1327651	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	2051	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4607744	4607744	PRJNA795663_S_NODE_16984_length_156_cov_2.058824_g16879_i0	PRJNA795663	16984	156	2.058824	3.21176544	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	206	9.32e-49	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g16879	i0	90.506	78.9423076923077	158	11	100	2	1	156	2020207	2020052	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	12315	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4607809	4607809	PRJNA795663_S_NODE_3064_length_327_cov_1.858621_g2959_i0	PRJNA795663	3064	327	1.858621	6.07769067	Deinococcus aquaticus	328692	Bacteria	Bacteria	497	3.29e-136	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g2959	i0	94.172	9.68807339449541	326	19	99	0	2	327	2922809	2922484	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	3168	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
6320406	6320406	PRJNA795663_S_NODE_5045_length_259_cov_13.716216_g4940_i0	PRJNA795663	5045	259	13.716216	35.52499944	Truepera	332248	Bacteria	Bacteria	340	4.5e-89	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g4940	i0	90.347	347.366795366795	259	25	100	0	1	259	490	748	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	89968	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7157818	7157818	PRJNA795663_S_NODE_3786_length_297_cov_1.492308_g3681_i0	PRJNA795663	3786	297	1.492308	4.43215476	Deinococcus grandis	57498	Bacteria	Bacteria	470	6.43e-128	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g3681	i0	95.563	3.31986531986532	293	13	99	0	1	293	1373112	1373404	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	986	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
9707517	9707517	PRJNA795663_S_NODE_12968_length_174_cov_1.416058_g12863_i0	PRJNA795663	12968	174	1.416058	2.46394092	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	289	1.02e-73	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g12863	i0	96.552	12.3505747126437	174	6	100	0	1	174	3169010	3169183	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2149	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
10144786	10144786	PRJNA795663_S_NODE_11068_length_185_cov_2.087838_g10963_i0	PRJNA795663	11068	185	2.087838	3.8625003	Deinococcus	1298	Bacteria	Bacteria	248	1.88e-61	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g10963	i0	90.811	8	185	17	100	0	1	185	2385429	2385613	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	1480	248	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
10983191	10983191	PRJNA795663_S_NODE_1089_length_518_cov_3.149688_g990_i0	PRJNA795663	1089	518	3.149688	16.31538384	Deinococcus ficus	317577	Bacteria	Bacteria	636	1.0999999999999996e-177	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g990	i0	89.841	185.76833976834	502	42	96	7	1	498	2342525	2343021	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	96228	636	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
12258916	12258916	PRJNA795663_S_NODE_18730_length_151_cov_1.201754_g18625_i0	PRJNA795663	18730	151	1.201754	1.81464854	Deinococcus aquaticus	328692	Bacteria	Bacteria	219	1.15e-52	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g18625	i0	92.715	2.96688741721854	151	11	100	0	1	151	3040475	3040325	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	448	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
12695950	12695950	PRJNA795663_S_NODE_130_length_1234_cov_19.591479_g85_i0	PRJNA795663	130	1234	19.591479	241.75885086	Deinococcus	1298	Bacteria	Bacteria	1766	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g85	i0	94.435	267.044570502431	1150	61	96	3	71	1219	563	1710	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	329533	1766	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
12695974	12695974	PRJNA795663_S_NODE_1530_length_449_cov_25.206311_g1425_i0	PRJNA795663	1530	449	25.206311	113.17633639	Deinococcus	1298	Bacteria	Bacteria	780	0	NTclustered	gi\|1073549716\|gb\|KX946495.1\|	47478	g1425	i0	97.996	106.293986636971	449	9	100	0	1	449	468	916	Deinococcus sp. strain FX4 16S ribosomal RNA gene, partial sequence	blastn	47726	780	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
13970303	13970303	PRJNA795663_S_NODE_271_length_912_cov_17.640000_g85_i4	PRJNA795663	271	912	17.64	160.8768	Deinococcus	1298	Bacteria	Bacteria	1400	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g85	i4	94.414	383.116228070175	913	48	100	3	1	912	1389	479	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	349402	1400	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
14807870	14807870	PRJNA795663_S_NODE_12772_length_175_cov_1.666667_g12667_i0	PRJNA795663	12772	175	1.666667	2.91666725	Deinococcus grandis	57498	Bacteria	Bacteria	191	2.99e-44	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g12667	i0	92.481	10.0514285714286	133	10	76	0	43	175	1869953	1869821	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1759	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18630899	18630899	PRJNA795663_S_NODE_17035_length_156_cov_1.630252_g16930_i0	PRJNA795663	17035	156	1.630252	2.54319312	Deinococcus radiopugnans	57497	Bacteria	Bacteria	117	4.49e-22	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g16930	i0	84.426	3.69230769230769	122	15	77	2	37	156	2169280	2169399	Deinococcus swuensis strain DY59, complete genome	blastn	576	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18631055	18631055	PRJNA795663_S_NODE_795_length_593_cov_3.717626_g706_i0	PRJNA795663	795	593	3.717626	22.04552218	Trueperaceae bacterium	2026798	Bacteria	Bacteria	804	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g706	i0	91.246	484.286677908938	594	46	100	6	1	593	3600511	3601099	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	287182	804	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
18631065	18631065	PRJNA795663_S_NODE_8375_length_208_cov_1.573099_g8270_i0	PRJNA795663	8375	208	1.573099	3.27204592	Deinococcus metallilatus	1211322	Bacteria	Bacteria	219	1.7e-52	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g8270	i0	85.854	14.6971153846154	205	29	99	0	2	206	473823	474027	Deinococcus metallilatus strain MA1002 chromosome	blastn	3057	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
19068115	19068115	PRJNA795663_S_NODE_7815_length_214_cov_2.259887_g7710_i0	PRJNA795663	7815	214	2.259887	4.83615818	Truepera	332248	Bacteria	Bacteria	274	3.6999999999999997e-69	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g7710	i0	89.72	154.191588785047	214	22	100	0	1	214	281	494	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	32997	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19906102	19906102	PRJNA795663_S_NODE_156_length_1147_cov_17.456757_g85_i2	PRJNA795663	156	1147	17.456757	200.22900279	Deinococcus aquaticus	328692	Bacteria	Bacteria	1655	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g85	i2	94.683	271.972101133391	1072	47	97	10	15	1080	714790	715857	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	311952	1655	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
20342736	20342736	PRJNA795663_S_NODE_136_length_1214_cov_20.260833_g85_i1	PRJNA795663	136	1214	20.260833	245.96651262	Deinococcus	1298	Bacteria	Bacteria	1825	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g85	i1	94.167	293.521416803954	1200	67	99	3	16	1214	1710	513	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	356335	1825	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
23732098	23732098	PRJNA795663_S_NODE_12039_length_179_cov_1.859155_g11934_i0	PRJNA795663	12039	179	1.859155	3.32788745	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	148	1.8799999999999999e-31	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g11934	i0	97.674	172.586592178771	86	2	49	0	1	86	674282	674197	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	30893	148	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23732140	23732140	PRJNA795663_S_NODE_13879_length_169_cov_1.651515_g13774_i0	PRJNA795663	13879	169	1.651515	2.79106035	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	145	2.26e-30	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g13774	i0	84.211	102.89349112426	152	20	89	3	1	150	73626	73477	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	17389	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
25005644	25005644	PRJNA795663_S_NODE_11500_length_182_cov_2.455172_g11395_i0	PRJNA795663	11500	182	2.455172	4.46841304	Deinococcus aquaticus	328692	Bacteria	Bacteria	281	1.81e-71	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g11395	i0	94.505	10.489010989011	182	10	100	0	1	182	1264366	1264547	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	1909	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus

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