metadata: contig_metadata: 44 rows where analysis = "blastn", bioproject = "PRJEB48218" and tax

44 rows where analysis = "blastn", bioproject = "PRJEB48218" and tax_phylum = "Deinococcota"

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
62660	62660	PRJEB48218_S_NODE_28481_length_158_cov_2.248062_g27519_i0	PRJEB48218	28481	158	2.248062	3.55193796	Thermus thermophilus	274	Bacteria	Bacteria	281	1.53e-71	NTclustered	gi\|1519240935\|emb\|LR027518.1\|	274	g27519	i0	99.359	3.9493670886076	156	0	98	1	1	155	7296	7451	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 2	blastn	624	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
62864	62864	PRJEB48218_S_NODE_7961_length_336_cov_947.000000_g6999_i0	PRJEB48218	7961	336	947	3181.92	Thermus thermophilus	274	Bacteria	Bacteria	401	2.729999999999999e-107	NTclustered	gi\|2074862859\|dbj\|AP024933.1\|	274	g6999	i0	97.447	252.839285714286	235	6	70	0	7	241	1671178	1671412	Thermus thermophilus AA3-7 DNA, complete genome	blastn	84954	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
62904	62904	PRJEB48218_S_NODE_9201_length_303_cov_13785.208029_g8239_i0	PRJEB48218	9201	303	13785.208029	41769.18032787	Deinococcus gobiensis	502394	Bacteria	Bacteria	337	6.959999999999998e-88	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g8239	i0	99.459	264.521452145215	185	1	61	0	1	185	2773678	2773862	Deinococcus gobiensis I-0, complete genome	blastn	80150	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3541049	3541049	PRJEB48218_S_NODE_9883_length_289_cov_14529.346154_g8921_i0	PRJEB48218	9883	289	14529.346154	41989.81038506	Thermus	270	Bacteria	Bacteria	300	8.650000000000001e-77	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g8921	i0	98.246	284.792387543253	171	3	59	0	119	289	1376368	1376198	Thermus thermophilus HB5008 DNA, complete genome	blastn	82305	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3888448	3888448	PRJEB48218_S_NODE_11884_length_259_cov_15671.026087_g10922_i0	PRJEB48218	11884	259	15671.026087	40587.95756533	Thermus thermophilus	274	Bacteria	Bacteria	257	4.66e-64	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g10922	i0	99.296	312.023166023166	142	1	55	0	118	259	628999	628858	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	80814	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3888833	3888833	PRJEB48218_S_NODE_5864_length_424_cov_9285.463291_g4907_i0	PRJEB48218	5864	424	9285.463291	39370.36435384	Thermus thermophilus	274	Bacteria	Bacteria	514	4.34e-141	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g4907	i0	98.955	188.108490566038	287	3	68	0	23	309	353530	353244	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	79758	514	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
5164708	5164708	PRJEB48218_S_NODE_11765_length_261_cov_194.879310_g10803_i0	PRJEB48218	11765	261	194.87931	508.6349991	Deinococcus geothermalis	68909	Bacteria	Bacteria	477	3.3099999999999986e-130	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g10803	i0	99.617	298.061302681992	261	1	100	0	1	261	2375586	2375326	Deinococcus geothermalis DSM 11300, complete genome	blastn	77794	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
6093633	6093633	PRJEB48218_S_NODE_7705_length_344_cov_12124.225397_g6743_i0	PRJEB48218	7705	344	12124.225397	41707.33536568	Truepera	332248	Bacteria	Bacteria	322	2.25e-83	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g6743	i0	92.444	434.433139534884	225	17	65	0	117	341	762249	762025	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	149445	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6440510	6440510	PRJEB48218_S_NODE_12146_length_256_cov_5.281938_g11184_i0	PRJEB48218	12146	256	5.281938	13.52176128	Thermus thermophilus	274	Bacteria	Bacteria	407	4.31e-109	NTclustered	gi\|2091883088\|dbj\|AP025158.1\|	274	g11184	i0	95.331	36.15234375	257	11	100	1	1	256	2026160	2026416	Thermus thermophilus TMY DNA, complete genome	blastn	9255	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
6440601	6440601	PRJEB48218_S_NODE_20106_length_208_cov_2.631285_g19144_i0	PRJEB48218	20106	208	2.631285	5.4730728	Deinococcus gobiensis	502394	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g19144	i0	99.519	1	208	1	100	0	1	208	511472	511265	Deinococcus gobiensis I-0, complete genome	blastn	208	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
6440994	6440994	PRJEB48218_S_NODE_9786_length_291_cov_1488.587786_g8824_i0	PRJEB48218	9786	291	1488.587786	4331.79045726	Thermus thermophilus	274	Bacteria	Bacteria	300	8.72e-77	NTclustered	gi\|383508497\|gb\|CP003252.1\|	798128	g8824	i0	97.175	261.580756013746	177	5	61	0	1	177	1523725	1523549	Thermus thermophilus JL-18, complete genome	blastn	76120	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7367955	7367955	PRJEB48218_S_NODE_28886_length_156_cov_4.275591_g27924_i0	PRJEB48218	28886	156	4.275591	6.66992196	Deinococcus	1298	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g27924	i0	98.726	319.134615384615	157	1	100	1	1	156	2238	2394	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	49785	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7367971	7367971	PRJEB48218_S_NODE_29966_length_152_cov_527.097561_g29004_i0	PRJEB48218	29966	152	527.097561	801.18829272	Deinococcus	1298	Bacteria	Bacteria	274	2.44e-69	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g29004	i0	99.338	285.052631578947	151	1	99	0	2	152	521	371	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	43328	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8643402	8643402	PRJEB48218_S_NODE_17247_length_226_cov_75.766497_g16285_i0	PRJEB48218	17247	226	75.766497	171.23228322	Deinococcus	1298	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g16285	i0	100	194.597345132743	226	0	100	0	1	226	1793242	1793467	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	43979	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8643424	8643424	PRJEB48218_S_NODE_20047_length_208_cov_13.229050_g19085_i0	PRJEB48218	20047	208	13.22905	27.516424	Deinococcus	1298	Bacteria	Bacteria	318	1.63e-82	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g19085	i0	94.286	179.317307692308	210	8	100	4	1	208	193	400	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	37298	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
8643430	8643430	PRJEB48218_S_NODE_20307_length_206_cov_109.418079_g19345_i0	PRJEB48218	20307	206	109.418079	225.40124274	Deinococcus	1298	Bacteria	Bacteria	255	1.28e-63	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g19345	i0	99.291	188.95145631068	141	1	68	0	1	141	1793656	1793516	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	38924	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8643557	8643557	PRJEB48218_S_NODE_3327_length_697_cov_45.751497_g2522_i0	PRJEB48218	3327	697	45.751497	318.88793409	Deinococcus	1298	Bacteria	Bacteria	1158	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2522	i0	96.705	298.591104734577	698	20	100	3	1	697	1745	1050	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	208118	1158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8989556	8989556	PRJEB48218_S_NODE_17248_length_226_cov_43.385787_g16286_i0	PRJEB48218	17248	226	43.385787	98.05187862	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	385	1.75e-102	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g16286	i0	97.345	198.672566371681	226	6	100	0	1	226	1638813	1638588	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	44900	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
8989596	8989596	PRJEB48218_S_NODE_20308_length_206_cov_81.480226_g19346_i0	PRJEB48218	20308	206	81.480226	167.84926556	Deinococcus puniceus	1182568	Bacteria	Bacteria	331	2.0700000000000002e-86	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g19346	i0	95.631	179.742718446602	206	9	100	0	1	206	72268	72473	Deinococcus puniceus strain DY1, complete genome	blastn	37027	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
9918639	9918639	PRJEB48218_S_NODE_3328_length_697_cov_41.250000_g2523_i0	PRJEB48218	3328	697	41.25	287.5125	Deinococcus	1298	Bacteria	Bacteria	1042	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2523	i0	93.723	296.736011477762	701	35	100	9	1	697	1050	1745	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	206825	1042	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9918648	9918648	PRJEB48218_S_NODE_3628_length_646_cov_4424.764992_g2579_i1	PRJEB48218	3628	646	4424.764992	28583.98184832	Deinococcus	1298	Bacteria	Bacteria	881	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2579	i1	96.617	201.825077399381	532	17	82	1	116	646	990	459	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	130379	881	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
10265252	10265252	PRJEB48218_S_NODE_17249_length_226_cov_40.284264_g16287_i0	PRJEB48218	17249	226	40.284264	91.04243664	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	246	8.599999999999998e-61	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g16287	i0	86.58	196.597345132743	231	21	100	9	1	226	97775	97550	Deinococcus sp. AJ005 chromosome, complete genome	blastn	44431	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
10265678	10265678	PRJEB48218_S_NODE_9149_length_304_cov_13256.185455_g8187_i0	PRJEB48218	9149	304	13256.185455	40298.8037832	Deinococcus gobiensis	502394	Bacteria	Bacteria	335	2.5099999999999993e-87	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g8187	i0	98.93	262.427631578947	187	2	62	0	118	304	274610	274796	Deinococcus gobiensis I-0, complete genome	blastn	79778	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11193740	11193740	PRJEB48218_S_NODE_26749_length_165_cov_3.044118_g25787_i0	PRJEB48218	26749	165	3.044118	5.0227947	Thermus	270	Bacteria	Bacteria	274	2.7e-69	NTclustered	gi\|2199613261\|dbj\|AP025596.1\|	274	g25787	i0	96.951	4.94545454545455	164	4	99	1	3	165	1263275	1263112	Thermus thermophilus SNM1-1 DNA, complete genome	blastn	816	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11540770	11540770	PRJEB48218_S_NODE_23770_length_181_cov_3.842105_g22808_i0	PRJEB48218	23770	181	3.842105	6.95421005	Thermus thermophilus	274	Bacteria	Bacteria	311	2.3e-80	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g22808	i0	97.79	37.9171270718232	181	3	99	1	1	180	1738244	1738424	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	6863	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12469339	12469339	PRJEB48218_S_NODE_17250_length_226_cov_36.472081_g16288_i0	PRJEB48218	17250	226	36.472081	82.42690306	Deinococcus	1298	Bacteria	Bacteria	219	1.8699999999999998e-52	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g16288	i0	84.071	193.566371681416	226	36	100	0	1	226	418	193	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	43746	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
12469366	12469366	PRJEB48218_S_NODE_21510_length_197_cov_162.023810_g20548_i0	PRJEB48218	21510	197	162.02381	319.1869057	Deinococcus	1298	Bacteria	Bacteria	337	4.21e-88	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g20548	i0	97.475	186.005076142132	198	3	100	2	1	197	1	197	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	36643	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
13743659	13743659	PRJEB48218_S_NODE_10491_length_279_cov_50.988000_g9529_i0	PRJEB48218	10491	279	50.988	142.25652	Deinococcus	1298	Bacteria	Bacteria	394	3.709999999999999e-105	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9529	i0	94.186	199.215053763441	258	15	92	0	22	279	1793499	1793242	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	55581	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
14091235	14091235	PRJEB48218_S_NODE_9412_length_298_cov_13576.739777_g8450_i0	PRJEB48218	9412	298	13576.739777	40458.68453546	Thermus thermophilus	274	Bacteria	Bacteria	327	4.11e-85	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g8450	i0	98.907	276.429530201342	183	2	61	0	116	298	628702	628884	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	82376	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15364589	15364589	PRJEB48218_S_NODE_12873_length_248_cov_29.515982_g11911_i0	PRJEB48218	12873	248	29.515982	73.19963536	Deinococcus ficus	317577	Bacteria	Bacteria	279	9.45e-71	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g11911	i0	89.64	460.75	222	20	89	3	6	225	2342801	2343021	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	114266	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15364710	15364710	PRJEB48218_S_NODE_21953_length_194_cov_47.866667_g20991_i0	PRJEB48218	21953	194	47.866667	92.86133398	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	292	9.06e-75	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g20991	i0	93.814	210	194	12	100	0	1	194	543530	543337	Deinococcus sp. NW-56 chromosome, complete genome	blastn	40740	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15364990	15364990	PRJEB48218_S_NODE_5993_length_418_cov_134.740360_g5034_i0	PRJEB48218	5993	418	134.74036	563.2147048	Deinococcus gobiensis	502394	Bacteria	Bacteria	773	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g5034	i0	100	207.485645933014	418	0	100	0	1	418	109591	110008	Deinococcus gobiensis I-0, complete genome	blastn	86729	773	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
16639415	16639415	PRJEB48218_S_NODE_27494_length_162_cov_2.383459_g26532_i0	PRJEB48218	27494	162	2.383459	3.86120358	Thermus thermophilus	274	Bacteria	Bacteria	270	3.4199999999999993e-68	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g26532	i0	98.684	21.5802469135802	152	2	94	0	1	152	966745	966594	Thermus thermophilus TF27 DNA, complete genome	blastn	3496	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
16639556	16639556	PRJEB48218_S_NODE_5994_length_418_cov_111.748072_g5035_i0	PRJEB48218	5994	418	111.748072	467.10694096	Deinococcus gobiensis	502394	Bacteria	Bacteria	623	6.799999999999999e-174	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g5035	i0	93.556	206.629186602871	419	25	100	2	1	418	110008	109591	Deinococcus gobiensis I-0, complete genome	blastn	86371	623	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
17568233	17568233	PRJEB48218_S_NODE_3394_length_685_cov_762.669207_g2579_i0	PRJEB48218	3394	685	762.669207	5224.28406795	Deinococcus	1298	Bacteria	Bacteria	1142	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2579	i0	96.793	256.12700729927	686	19	100	3	1	685	459	1142	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	175447	1142	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
20116979	20116979	PRJEB48218_S_NODE_3636_length_645_cov_5885.188312_g2579_i2	PRJEB48218	3636	645	5885.188312	37959.4646124	Deinococcus	1298	Bacteria	Bacteria	881	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2579	i2	96.617	202.137984496124	532	17	82	1	115	645	990	459	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	130379	881	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
20463219	20463219	PRJEB48218_S_NODE_11537_length_264_cov_41.331915_g10575_i0	PRJEB48218	11537	264	41.331915	109.1162556	Deinococcus ficus	317577	Bacteria	Bacteria	320	5.99e-83	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g10575	i0	88.679	161.988636363636	265	27	99	2	1	263	2342603	2342866	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	42765	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
21392376	21392376	PRJEB48218_S_NODE_20557_length_204_cov_130.697143_g19595_i0	PRJEB48218	20557	204	130.697143	266.62217172	Deinococcus	1298	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g19595	i0	99.51	200.323529411765	204	1	100	0	1	204	1793656	1793453	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	40866	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21739045	21739045	PRJEB48218_S_NODE_11538_length_264_cov_32.880851_g10576_i0	PRJEB48218	11538	264	32.880851	86.80544664	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	411	3.4499999999999996e-110	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g10576	i0	94.697	149.359848484848	264	14	100	0	1	264	1361329	1361066	Deinococcus sp. QL22 chromosome, complete genome	blastn	39431	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
21739076	21739076	PRJEB48218_S_NODE_12778_length_249_cov_59.963636_g11816_i0	PRJEB48218	12778	249	59.963636	149.30945364	Deinococcus rubellus	1889240	Bacteria	Bacteria	375	1.18e-99	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g11816	i0	94.024	209.839357429719	251	9	100	6	1	249	321026	321272	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	52250	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
21739417	21739417	PRJEB48218_S_NODE_4818_length_509_cov_13550.120833_g3881_i0	PRJEB48218	4818	509	13550.120833	68970.11503997	Deinococcus gobiensis	502394	Bacteria	Bacteria	503	1.14e-137	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g3881	i0	99.281	293.984282907662	278	2	55	0	119	396	2294832	2294555	Deinococcus gobiensis I-0, complete genome	blastn	149638	503	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
22667411	22667411	PRJEB48218_S_NODE_8618_length_317_cov_13181.385417_g7656_i0	PRJEB48218	8618	317	13181.385417	41784.99177189	Thermus	270	Bacteria	Bacteria	351	2.61e-92	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g7656	i0	96.296	248.561514195584	216	5	68	3	1	215	1560132	1560345	Thermus parvatiensis strain RL, complete genome	blastn	78794	351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
23942592	23942592	PRJEB48218_S_NODE_17099_length_227_cov_50.742424_g16137_i0	PRJEB48218	17099	227	50.742424	115.18530248	Deinococcus	1298	Bacteria	Bacteria	274	3.96e-69	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g16137	i0	88.546	203.810572687225	227	25	100	1	1	227	1793467	1793242	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	46265	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25216458	25216458	PRJEB48218_S_NODE_22280_length_192_cov_2.361963_g21318_i0	PRJEB48218	22280	192	2.361963	4.53496896	Thermus	270	Bacteria	Bacteria	305	1.15e-78	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g21318	i0	96.721	23.75	183	6	95	0	10	192	383648	383830	Thermus parvatiensis strain RL, complete genome	blastn	4560	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis

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