contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Tubulinea"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25576911 | 25576911 | PRJNA737474f_S_NODE_125897_length_277_cov_1.887255_g125219_i0 | PRJNA737474 | 125897 | 277 | 1.887255 | 5.22769635 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 507 | 4.53e-139 | NTclustered | gi|399764168|gb|JQ271679.1| | 1215977 | g125219 | i0 | 99.639 | 71.4223826714802 | 277 | 1 | 100 | 0 | 1 | 277 | 373 | 97 | Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence | blastn | 19784 | 507 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 25579785 | 25579785 | PRJNA737474f_S_NODE_32497_length_385_cov_3.362179_g31819_i0 | PRJNA737474 | 32497 | 385 | 3.362179 | 12.94438915 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 704 | 0 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g31819 | i0 | 99.74 | 71.0285714285714 | 384 | 1 | 99 | 0 | 2 | 385 | 988 | 605 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 27346 | 704 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 25581980 | 25581980 | PRJNA737474g_S_NODE_10129_length_1225_cov_11.802083_g9223_i0 | PRJNA737474 | 10129 | 1225 | 11.802083 | 144.57551675 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1197 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g9223 | i0 | 86.523 | 15.6424489795918 | 1113 | 120 | 89 | 21 | 1 | 1089 | 283 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 19162 | 1197 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 25723666 | 25723666 | PRJNA737474g_S_NODE_401466_length_244_cov_0.888889_g400172_i0 | PRJNA737474 | 401466 | 244 | 0.888889 | 2.16888916 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 285 | 1.99e-72 | NTclustered | gi|1042160949|dbj|LC102281.1| | 931554 | g400172 | i0 | 87.755 | 8.68852459016393 | 245 | 28 | 100 | 2 | 1 | 244 | 719 | 476 | Copromyxa protea gene for elongation factor 2 alpha, partial cds, strain: LUM | blastn | 2120 | 285 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 25726457 | 25726457 | PRJNA737474g_S_NODE_95906_length_331_cov_4.643411_g94612_i0 | PRJNA737474 | 95906 | 331 | 4.643411 | 15.36969041 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 383 | 9.73e-102 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g94612 | i0 | 89.667 | 18.7945619335347 | 300 | 31 | 91 | 0 | 32 | 331 | 1 | 300 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 6221 | 383 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 25859702 | 25859702 | PRJNA737474g_S_NODE_406379_length_243_cov_1.641176_g405085_i0 | PRJNA737474 | 406379 | 243 | 1.641176 | 3.98805768 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 398 | 2.4399999999999997e-106 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g405085 | i0 | 100 | 68.8847736625514 | 215 | 0 | 88 | 0 | 29 | 243 | 321 | 107 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 16739 | 398 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 25985414 | 25985414 | PRJNA737474f_S_NODE_13508_length_548_cov_9.816842_g12843_i0 | PRJNA737474 | 13508 | 548 | 9.816842 | 53.79629416 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 662 | 0 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g12843 | i0 | 95.012 | 72.8485401459854 | 421 | 21 | 77 | 0 | 128 | 548 | 1148 | 728 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 39921 | 662 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 26128137 | 26128137 | PRJNA737474g_S_NODE_172837_length_287_cov_1.518692_g171543_i0 | PRJNA737474 | 172837 | 287 | 1.518692 | 4.35864604 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 171 | 7.02e-38 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g171543 | i0 | 94.545 | 25.418118466899 | 110 | 6 | 38 | 0 | 178 | 287 | 1876 | 1767 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 7295 | 171 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 26128355 | 26128355 | PRJNA737474g_S_NODE_183205_length_283_cov_3.066667_g181911_i0 | PRJNA737474 | 183205 | 283 | 3.066667 | 8.67866761 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 202 | 2.4499999999999998e-47 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g181911 | i0 | 91.724 | 51.886925795053 | 145 | 12 | 51 | 0 | 139 | 283 | 1148 | 1004 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 14684 | 202 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 26128357 | 26128357 | PRJNA737474g_S_NODE_183277_length_283_cov_2.319048_g181983_i0 | PRJNA737474 | 183277 | 283 | 2.319048 | 6.56290584 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 193 | 1.47e-44 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g181983 | i0 | 82.805 | 77.3180212014134 | 221 | 32 | 76 | 5 | 10 | 225 | 28119 | 27900 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 21881 | 193 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26132700 | 26132700 | PRJNA737474g_S_NODE_465565_length_235_cov_3.925926_g464271_i0 | PRJNA737474 | 465565 | 235 | 3.925926 | 9.2259261 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 206 | 1.53e-48 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g464271 | i0 | 96.032 | 49.7574468085106 | 126 | 5 | 54 | 0 | 110 | 235 | 1151 | 1026 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 11693 | 206 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 26133604 | 26133604 | PRJNA737474g_S_NODE_59525_length_385_cov_2.185897_g58232_i0 | PRJNA737474 | 59525 | 385 | 2.185897 | 8.41570345 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 614 | 3.7399999999999996e-171 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g58232 | i0 | 95.561 | 94.2051948051948 | 383 | 17 | 99 | 0 | 1 | 383 | 722 | 1104 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 36269 | 614 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 26259850 | 26259850 | PRJNA737474f_S_NODE_2742_length_1479_cov_38.813656_g2386_i0 | PRJNA737474 | 2742 | 1479 | 38.813656 | 574.05397224 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1574 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g2386 | i0 | 87.365 | 25.3015551048005 | 1393 | 150 | 93 | 16 | 40 | 1410 | 1 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 37421 | 1574 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26530763 | 26530763 | PRJNA737474f_S_NODE_190384_length_253_cov_1.511111_g189706_i0 | PRJNA737474 | 190384 | 253 | 1.511111 | 3.82311083 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 344 | 3.3799999999999993e-90 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g189706 | i0 | 100 | 21.3359683794466 | 186 | 0 | 74 | 0 | 1 | 186 | 1460 | 1645 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 5398 | 344 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 |
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);;