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

24 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
589806	589806	PRJNA611476_P_NODE_65501_length_275_cov_1.227723_g64710_i0	PRJNA611476	65501	275	1.227723	3.37623825	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	481	2.72e-131	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g64710	i0	98.182	2	275	5	100	0	1	275	2666743	2667017	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	550	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
1865419	1865419	PRJNA611476_P_NODE_44302_length_324_cov_0.916335_g43511_i0	PRJNA611476	44302	324	0.916335	2.9689254	Deinococcus ficus	317577	Bacteria	Bacteria	490	5.44e-134	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g43511	i0	95.469	183.348765432099	309	10	95	3	18	324	2342398	2342704	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	59405	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
2423600	2423600	PRJNA611476_P_NODE_92622_length_248_cov_0.880000_g91831_i0	PRJNA611476	92622	248	0.88	2.1824	Thermus	270	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|374854759\|dbj\|AP011781.1\|	179882	g91831	i0	82.114	16.2983870967742	246	42	99	2	3	247	36777	36533	Uncultured Thermus/Deinococcus group bacterium DNA, fosmid clone: JFF051_G12	blastn	4042	211	0.990521327014218	Bacteria	Thermotogati	Deinococcota					uncultured Deinococcota bacterium
3699549	3699549	PRJNA611476_P_NODE_42763_length_328_cov_1.533333_g41972_i0	PRJNA611476	42763	328	1.533333	5.02933224	Deinococcus	1298	Bacteria	Bacteria	551	2.499999999999999e-152	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g41972	i0	96.96	179.740853658537	329	9	100	1	1	328	352	24	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	58955	551	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3699725	3699725	PRJNA611476_P_NODE_64043_length_278_cov_1.073171_g63252_i0	PRJNA611476	64043	278	1.073171	2.98341538	Deinococcus	1298	Bacteria	Bacteria	479	9.91e-131	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g63252	i0	98.524	1.94964028776978	271	4	97	0	1	271	630158	629888	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	542	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
4417315	4417315	PRJNA611476_P_NODE_61124_length_283_cov_1.171429_g60333_i0	PRJNA611476	61124	283	1.171429	3.31514407	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	507	4.64e-139	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g60333	i0	98.94	2.01413427561837	283	3	100	0	1	283	2024394	2024676	Deinococcus sp. NW-56 chromosome, complete genome	blastn	570	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
5692601	5692601	PRJNA611476_P_NODE_113765_length_242_cov_0.911243_g112974_i0	PRJNA611476	113765	242	0.911243	2.20520806	Thermus brockianus	56956	Bacteria	Bacteria	305	1.52e-78	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g112974	i0	90.171	1.93388429752066	234	23	97	0	9	242	26953	26720	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	468	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
6968578	6968578	PRJNA611476_P_NODE_97746_length_246_cov_0.890173_g96955_i0	PRJNA611476	97746	246	0.890173	2.18982558	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g96955	i0	100	44.3861788617886	246	0	100	0	1	246	346389	346144	Thermus sp. NEB1569 chromosome, complete genome	blastn	10919	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
7525545	7525545	PRJNA611476_P_NODE_25306_length_402_cov_1.702128_g24515_i0	PRJNA611476	25306	402	1.702128	6.84255456	Thermus	270	Bacteria	Bacteria	259	2.12e-64	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g24515	i0	78.589	82.4800995024876	397	82	98	3	2	396	717562	717957	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	33157	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
8800838	8800838	PRJNA611476_P_NODE_45887_length_319_cov_1.252033_g45096_i0	PRJNA611476	45887	319	1.252033	3.99398527	Thermus	270	Bacteria	Bacteria	113	1.35e-20	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g45096	i0	88.421	0.595611285266458	95	9	29	2	20	113	715289	715382	Thermus oshimai strain Blanco chromosome, complete genome	blastn	190	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
13343195	13343195	PRJNA611476_P_NODE_14911_length_509_cov_2.215596_g14121_i0	PRJNA611476	14911	509	2.215596	11.27738364	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g14121	i0	100	0.0589390962671906	30	0	6	0	15	44	1296680	1296709	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
13343211	13343211	PRJNA611476_P_NODE_15991_length_493_cov_2.766667_g15201_i0	PRJNA611476	15991	493	2.766667	13.63966831	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	721	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g15201	i0	93.117	201.46247464503	494	31	100	3	1	493	543600	543109	Deinococcus sp. NW-56 chromosome, complete genome	blastn	99321	721	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13344206	13344206	PRJNA611476_P_NODE_88231_length_249_cov_0.875000_g87440_i0	PRJNA611476	88231	249	0.875	2.17875	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	215	2.72e-51	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g87440	i0	100	0.465863453815261	116	0	47	0	1	116	1107459	1107344	Thermus sp. NEB1569 chromosome, complete genome	blastn	116	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
14618048	14618048	PRJNA611476_P_NODE_13912_length_526_cov_2.858720_g13122_i0	PRJNA611476	13912	526	2.85872	15.0368672	Deinococcus metallilatus	1211322	Bacteria	Bacteria	678	0	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g13122	i0	90.038	209.739543726236	532	42	100	8	1	526	328844	329370	Deinococcus metallilatus strain MA1002 chromosome	blastn	110323	678	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
14618954	14618954	PRJNA611476_P_NODE_81912_length_250_cov_1.073446_g81121_i0	PRJNA611476	81912	250	1.073446	2.683615	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g81121	i0	98	195.076	250	5	100	0	1	250	2417512	2417761	Deinococcus sp. NW-56 chromosome, complete genome	blastn	48769	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17166626	17166626	PRJNA611476_P_NODE_100674_length_245_cov_0.895349_g99883_i0	PRJNA611476	100674	245	0.895349	2.19360505	Deinococcus aetherius	200252	Bacteria	Bacteria	309	1.19e-79	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g99883	i0	89.669	75.1387755102041	242	25	99	0	3	244	542399	542640	Deinococcus aetherius ST0316 DNA, complete genome	blastn	18409	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18442002	18442002	PRJNA611476_P_NODE_77215_length_252_cov_1.815642_g76424_i0	PRJNA611476	77215	252	1.815642	4.57541784	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g76424	i0	96.774	0.123015873015873	31	1	12	0	63	93	1105498	1105528	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
20992054	20992054	PRJNA611476_P_NODE_59957_length_285_cov_1.179245_g59166_i0	PRJNA611476	59957	285	1.179245	3.36084825	Deinococcus taeanensis	2737050	Bacteria	Bacteria	388	1.77e-103	NTclustered	gi\|2105695065\|gb\|CP083457.1\|	2737050	g59166	i0	91.228	1	285	25	100	0	1	285	224733	224449	Deinococcus taeanensis strain TS293 plasmid p_TS293_3, complete sequence	blastn	285	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
20992290	20992290	PRJNA611476_P_NODE_79777_length_251_cov_0.865169_g78986_i0	PRJNA611476	79777	251	0.865169	2.17157419	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g78986	i0	98.008	2	251	5	100	0	1	251	493036	493286	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	502	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
23542307	23542307	PRJNA611476_P_NODE_69459_length_267_cov_2.484536_g68668_i0	PRJNA611476	69459	267	2.484536	6.63371112	Deinococcus gobiensis	502394	Bacteria	Bacteria	278	3.7e-70	NTclustered	gi\|380001697\|gb\|CP002192.1\|	745776	g68668	i0	85.556	1.01123595505618	270	34	100	5	1	267	132216	131949	Deinococcus gobiensis I-0 plasmid P1, complete sequence	blastn	270	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24100003	24100003	PRJNA611476_P_NODE_67119_length_272_cov_1.246231_g66328_i0	PRJNA611476	67119	272	1.246231	3.38974832	Deinococcus	1298	Bacteria	Bacteria	399	7.739999999999999e-107	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g66328	i0	97.046	3.03308823529412	237	7	87	0	36	272	1811656	1811892	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	825	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24815667	24815667	PRJNA611476_P_NODE_3500_length_1045_cov_4.438272_g2858_i0	PRJNA611476	3500	1045	4.438272	46.3799424	Trueperaceae bacterium	2026798	Bacteria	Bacteria	54.7	0.03	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g2858	i0	100	0.0277511961722488	29	0	3	0	20	48	4172291	4172319	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
24816057	24816057	PRJNA611476_P_NODE_64360_length_277_cov_1.348039_g63569_i0	PRJNA611476	64360	277	1.348039	3.73406803	Deinococcus yunweiensis	367282	Bacteria	Bacteria	492	1.27e-134	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g63569	i0	98.909	11.3501805054152	275	3	99	0	1	275	1381118	1381392	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	3144	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
24816526	24816526	PRJNA611476_P_NODE_97540_length_246_cov_0.890173_g96749_i0	PRJNA611476	97540	246	0.890173	2.18982558	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g96749	i0	98.785	2.00813008130081	247	2	100	1	1	246	2037994	2038240	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	494	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343

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