RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB20058", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJEB20058 · 15 ✖

analysis 1

tax_kingdom 0

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
25652682 25652682 PRJEB20058_P_NODE_192794_length_262_cov_3.457711_g189970_i0 PRJEB20058 192794 262 3.457711 9.05920282 uncultured Thaumatomonadida 404740 SAR_Eukaryotes SAR_Eukaryotes 422 1.58e-113   NTclustered gi|134022509|gb|EF023859.1| 404740 g189970 i0 98.333 92.0496183206107 240 4 92 0 1 240 431 192 Thaumatomonadida environmental sample clone Amb_18S_1311 18S ribosomal RNA gene, partial sequence blastn 24117 422 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida     uncultured Thaumatomonadida
25654748 25654748 PRJEB20058_P_NODE_248170_length_198_cov_7.000000_g245345_i0 PRJEB20058 248170 198 7 13.86 Trinema lineare 432298 SAR_Eukaryotes SAR_Eukaryotes 366 5.4e-97   NTclustered gi|133902273|gb|EF456752.1| 432298 g245345 i0 100 100 198 0 100 0 1 198 1431 1628 Trinema lineare small subunit ribosomal RNA gene, partial sequence blastn 19800 366 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Trinematidae Trinema Trinema lineare
25784989 25784989 PRJEB20058_P_NODE_103699_length_398_cov_32.326409_g100892_i0 PRJEB20058 103699 398 32.326409 128.65910782 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 326 2.03e-84   NTclustered gi|290760485|gb|GQ144688.1| 741089 g100892 i0 88.256 93.072864321608 281 22 92 10 1 280 1027 757 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 37043 326 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
25790694 25790694 PRJEB20058_P_NODE_241083_length_213_cov_4.282895_g238258_i0 PRJEB20058 241083 213 4.282895 9.12256635 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 207 3.78e-49   NTclustered gi|1402550475|gb|MH488761.1| 2231165 g238258 i0 86.458 11.0422535211268 192 23 90 3 21 211 1136 1325 Rosculus vulgaris isolate CCAC1 small subunit ribosomal RNA gene, partial sequence blastn 2352 207 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
25793883 25793883 PRJEB20058_P_NODE_79043_length_466_cov_6.893827_g76262_i0 PRJEB20058 79043 466 6.893827 32.12523382 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 292 2.4499999999999994e-74   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g76262 i0 88.189 29.137339055794 254 19 55 5 213 466 3916 3674 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 13578 292 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
25884121 25884121 PRJEB20058_P_NODE_116899_length_370_cov_11.770227_g114084_i0 PRJEB20058 116899 370 11.770227 43.5498399 Paracercomonas 372085 SAR_Eukaryotes SAR_Eukaryotes 684 0   NTclustered gi|113926792|emb|AM114800.1| 175275 g114084 i0 100 100.021621621622 370 0 100 0 1 370 33 402 Uncultured cercozoan partial 18S rRNA gene, clone WIM2 blastn 37008 684 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
25922953 25922953 PRJEB20058_P_NODE_143780_length_323_cov_2.022901_g140959_i0 PRJEB20058 143780 323 2.022901 6.53397023 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 228 4.6999999999999986e-55   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g140959 i0 90.341 32.359133126935 176 14 54 3 1 174 3664 3838 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 10452 228 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
26022974 26022974 PRJEB20058_P_NODE_51452_length_586_cov_4.674286_g48719_i0 PRJEB20058 51452 586 4.674286 27.39131596 Bigyra 2683628 SAR_Eukaryotes SAR_Eukaryotes 407 1.07e-108   NTclustered gi|27734374|gb|AY099142.1| 45110 g48719 i0 84.198 166.087030716724 424 61 72 3 152 570 424 2 Cercomonas ATCC50316 isolate pub4 polyubiquitin gene, partial cds blastn 97327 407 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50316
26063585 26063585 PRJEB20058_P_NODE_32861_length_731_cov_31.108955_g30323_i0 PRJEB20058 32861 731 31.108955 227.40646105 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 870 0   NTclustered gi|290760485|gb|GQ144688.1| 741089 g30323 i0 88.467 70.1887824897401 737 64 100 19 1 731 2373 1652 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 51308 870 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
26201763 26201763 PRJEB20058_P_NODE_66702_length_511_cov_12.613333_g63933_i0 PRJEB20058 66702 511 12.613333 64.45413163 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 516 1.48e-141   NTclustered gi|756877536|ref|NC_026310.1| 372086 g63933 i0 87.473 42.9667318982387 455 47 88 7 20 468 1379 929 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 21956 516 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
26202471 26202471 PRJEB20058_P_NODE_80334_length_462_cov_2.586035_g77552_i0 PRJEB20058 80334 462 2.586035 11.9474817 Protaspis grandis 361427 SAR_Eukaryotes SAR_Eukaryotes 619 9.8e-173   NTclustered gi|290760486|gb|GQ144689.1| 361427 g77552 i0 90.889 100.324675324675 461 41 99 1 3 462 2054 1594 Protaspis grandis large subunit ribosomal RNA gene, partial sequence blastn 46350 619 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Protaspis Protaspis grandis
26331096 26331096 PRJEB20058_P_NODE_145335_length_320_cov_57.810811_g142514_i0 PRJEB20058 145335 320 57.810811 184.9945952 Gymnophrys sp. ATCC 5 2170314 SAR_Eukaryotes SAR_Eukaryotes 590 5.1399999999999985e-164   NTclustered gi|238617604|gb|FJ973379.1| 646463 g142514 i0 100 100.334375 319 0 99 0 2 320 23 341 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 32107 590 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
26332351 26332351 PRJEB20058_P_NODE_175063_length_281_cov_14.740909_g172240_i0 PRJEB20058 175063 281 14.740909 41.42195429 Paulinella chromatophora 39717 SAR_Eukaryotes SAR_Eukaryotes 159 1.48e-34   NTclustered gi|238617607|gb|FJ973382.1| 39717 g172240 i0 95.05 34.3167259786477 101 5 36 0 10 110 1248 1348 Paulinella chromatophora strain MO88/a 28S ribosomal RNA gene, partial sequence blastn 9643 159 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
26338867 26338867 PRJEB20058_P_NODE_92519_length_426_cov_8.369863_g89720_i0 PRJEB20058 92519 426 8.369863 35.65561638 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 294 6.18e-75   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g89720 i0 89.167 43.6056338028169 240 21 56 5 1 237 3679 3916 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 18576 294 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
26466827 26466827 PRJEB20058_P_NODE_133768_length_339_cov_6.248201_g130948_i0 PRJEB20058 133768 339 6.248201 21.18140139 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 268 2.9199999999999994e-67   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g130948 i0 92.973 51.905604719764 185 12 54 1 156 339 3856 3672 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 17596 268 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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