contig_metadata
21 rows where bioproject = "PRJNA414036", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418666 | 418666 | PRJNA414036_P_NODE_14941_length_381_cov_80.179191_g13261_i0 | PRJNA414036 | 14941 | 381 | 80.179191 | 305.48271771 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 326 | 1.94e-84 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g13261 | i0 | 86.23 | 14.9186351706037 | 305 | 36 | 80 | 5 | 69 | 371 | 107 | 407 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 5684 | 326 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 1082819 | 1082819 | PRJNA414036_P_NODE_14421_length_386_cov_30.726496_g12748_i0 | PRJNA414036 | 14421 | 386 | 30.726496 | 118.60427456 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 270 | 9.35e-68 | NTclustered | gi|399764274|gb|JQ271785.1| | 1215994 | g12748 | i0 | 86.1 | 35.3367875647668 | 259 | 26 | 66 | 8 | 9 | 263 | 375 | 627 | Tubulinea group 04 sp. BCHM5 18S ribosomal RNA gene, partial sequence | blastn | 13640 | 270 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. BCHM5 | ||||||
| 1082903 | 1082903 | PRJNA414036_P_NODE_4201_length_543_cov_21.314961_g3411_i0 | PRJNA414036 | 4201 | 543 | 21.314961 | 115.74023823 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 270 | 1.3499999999999999e-67 | NTclustered | gi|399764274|gb|JQ271785.1| | 1215994 | g3411 | i0 | 86.1 | 26.572744014733 | 259 | 26 | 47 | 9 | 124 | 378 | 627 | 375 | Tubulinea group 04 sp. BCHM5 18S ribosomal RNA gene, partial sequence | blastn | 14429 | 270 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. BCHM5 | ||||||
| 2969449 | 2969449 | PRJNA414036_P_NODE_34863_length_251_cov_34.555556_g33127_i0 | PRJNA414036 | 34863 | 251 | 34.555556 | 86.73444556 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 219 | 2.1199999999999998e-52 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g33127 | i0 | 84.519 | 37.6932270916335 | 239 | 17 | 93 | 8 | 9 | 242 | 1568 | 1791 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 9461 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 4910923 | 4910923 | PRJNA414036_P_NODE_3364_length_569_cov_107.897004_g103_i2 | PRJNA414036 | 3364 | 569 | 107.897004 | 613.93395276 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 178 | 8.869999999999999e-40 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g103 | i2 | 91.473 | 20.8242530755712 | 129 | 11 | 23 | 0 | 204 | 332 | 2897 | 3025 | Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11849 | 178 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 5522463 | 5522463 | PRJNA414036_P_NODE_21885_length_323_cov_320.895833_g20157_i0 | PRJNA414036 | 21885 | 323 | 320.895833 | 1036.49354059 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 370 | 7.37e-98 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g20157 | i0 | 98.113 | 27.2755417956656 | 212 | 4 | 66 | 0 | 9 | 220 | 1598 | 1387 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 8810 | 370 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 6796483 | 6796483 | PRJNA414036_P_NODE_35846_length_247_cov_37.070755_g34110_i0 | PRJNA414036 | 35846 | 247 | 37.070755 | 91.56476485 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 204 | 5.819999999999998e-48 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g34110 | i0 | 84.052 | 39.7246963562753 | 232 | 16 | 93 | 6 | 10 | 238 | 1784 | 1571 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 9812 | 204 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 7460903 | 7460903 | PRJNA414036_P_NODE_60286_length_215_cov_4.066667_g58547_i0 | PRJNA414036 | 60286 | 215 | 4.066667 | 8.74333405 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 219 | 1.77e-52 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g58547 | i0 | 86.432 | 38.1581395348837 | 199 | 27 | 93 | 0 | 8 | 206 | 597 | 399 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 8204 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 8071995 | 8071995 | PRJNA414036_P_NODE_2887_length_587_cov_113.817029_g2305_i0 | PRJNA414036 | 2887 | 587 | 113.817029 | 668.10596023 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 503 | 1.33e-137 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g2305 | i0 | 89.104 | 27.8177172061329 | 413 | 33 | 69 | 11 | 171 | 577 | 1 | 407 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16329 | 503 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 8072029 | 8072029 | PRJNA414036_P_NODE_40307_length_231_cov_74.025510_g38568_i0 | PRJNA414036 | 40307 | 231 | 74.02551 | 170.9989281 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 209 | 1.16e-49 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g38568 | i0 | 93.056 | 5.97402597402597 | 144 | 8 | 87 | 2 | 1 | 143 | 265 | 407 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 1380 | 209 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 9346805 | 9346805 | PRJNA414036_P_NODE_15348_length_377_cov_86.514620_g13663_i0 | PRJNA414036 | 15348 | 377 | 86.51462 | 326.1601174 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 641 | 1.68e-179 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g13663 | i0 | 98.889 | 66.6604774535809 | 360 | 3 | 95 | 1 | 10 | 368 | 1549 | 1908 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 25131 | 641 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 9346865 | 9346865 | PRJNA414036_P_NODE_2768_length_593_cov_90.259857_g46_i9 | PRJNA414036 | 2768 | 593 | 90.259857 | 535.24095201 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 1053 | 0 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g46 | i9 | 99.313 | 44.8971332209106 | 582 | 4 | 98 | 0 | 10 | 591 | 602 | 21 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 26624 | 1053 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 14447697 | 14447697 | PRJNA414036_P_NODE_58232_length_223_cov_10.111702_g56493_i0 | PRJNA414036 | 58232 | 223 | 10.111702 | 22.54909546 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 243 | 1.09e-59 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g56493 | i0 | 87.864 | 11.0313901345291 | 206 | 25 | 92 | 0 | 9 | 214 | 448 | 243 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 2460 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 18270259 | 18270259 | PRJNA414036_P_NODE_1335_length_688_cov_77.237366_g46_i5 | PRJNA414036 | 1335 | 688 | 77.237366 | 531.39307808 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 1072 | 0 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g46 | i5 | 99.491 | 38.7936046511628 | 589 | 3 | 86 | 0 | 91 | 679 | 14 | 602 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 26690 | 1072 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 19544549 | 19544549 | PRJNA414036_P_NODE_38816_length_236_cov_6.592040_g37077_i0 | PRJNA414036 | 38816 | 236 | 6.59204 | 15.5572144 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 239 | 1.5100000000000002e-58 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g37077 | i0 | 85.841 | 4.30508474576271 | 226 | 31 | 95 | 1 | 7 | 231 | 735 | 960 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 1016 | 239 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 20209013 | 20209013 | PRJNA414036_P_NODE_11056_length_422_cov_5.434109_g9496_i0 | PRJNA414036 | 11056 | 422 | 5.434109 | 22.93193998 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 3.98e-17 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g9496 | i0 | 86.17 | 1.78199052132701 | 94 | 13 | 22 | 0 | 216 | 309 | 1160 | 1253 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 752 | 102 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 20820324 | 20820324 | PRJNA414036_P_NODE_13217_length_398_cov_6.831956_g11581_i0 | PRJNA414036 | 13217 | 398 | 6.831956 | 27.19118488 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 148 | 4.73e-31 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g11581 | i0 | 84.564 | 1.86683417085427 | 149 | 23 | 37 | 0 | 41 | 189 | 812 | 960 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 743 | 148 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 21484738 | 21484738 | PRJNA414036_P_NODE_897_length_745_cov_106.049296_g103_i1 | PRJNA414036 | 897 | 745 | 106.049296 | 790.0672552 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 178 | 1.18e-39 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g103 | i1 | 91.473 | 15.9046979865772 | 129 | 11 | 17 | 0 | 238 | 366 | 3025 | 2897 | Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11849 | 178 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 23370786 | 23370786 | PRJNA414036_P_NODE_2579_length_602_cov_89.093474_g46_i7 | PRJNA414036 | 2579 | 602 | 89.093474 | 536.34271348 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 1027 | 0 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g46 | i7 | 98.456 | 28.0265780730897 | 583 | 9 | 97 | 0 | 10 | 592 | 596 | 14 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 16872 | 1027 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 24645029 | 24645029 | PRJNA414036_P_NODE_10220_length_432_cov_42.735516_g8701_i0 | PRJNA414036 | 10220 | 432 | 42.735516 | 184.61742912 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 209 | 2.34e-49 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g8701 | i0 | 93.056 | 3.05787037037037 | 144 | 8 | 33 | 2 | 290 | 432 | 407 | 265 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 1321 | 209 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 24645090 | 24645090 | PRJNA414036_P_NODE_2580_length_602_cov_88.970018_g46_i8 | PRJNA414036 | 2580 | 602 | 88.970018 | 535.59950836 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 1044 | 0 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g46 | i8 | 98.971 | 36.5797342192691 | 583 | 6 | 97 | 0 | 10 | 592 | 596 | 14 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 22021 | 1044 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 |
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);;