RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA414036" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA414036 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
1082849 1082849 PRJNA414036_P_NODE_28901_length_279_cov_25.975410_g27166_i0 PRJNA414036 28901 279 25.97541 72.4713939 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 248 3.0499999999999997e-61   NTclustered gi|1002343681|gb|KU738559.1| 175275 g27166 i0 90.86 27.6774193548387 186 15 66 2 83 266 168 353 Uncultured Cercozoa clone elephant_dung23 18S ribosomal RNA gene, partial sequence blastn 7722 248 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
1693527 1693527 PRJNA414036_P_NODE_28722_length_280_cov_21.077551_g26987_i0 PRJNA414036 28722 280 21.077551 59.0171428 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 274 5.059999999999998e-69   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g26987 i0 86.486 32.6464285714286 259 24 91 10 10 264 2213 2464 Rosculus vulgaris isolate CCA sequence blastn 9141 274 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
2358367 2358367 PRJNA414036_P_NODE_442_length_856_cov_17.490865_g32_i2 PRJNA414036 442 856 17.490865 149.7218044 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 274 1.69e-68   NTclustered gi|160688658|gb|EU138880.1| 352461 g32 i2 82.848 39.8434579439252 309 39 36 10 247 550 2525 2226 Thaumatomonas coloniensis strain HFCC93 28S ribosomal RNA gene, partial sequence blastn 34106 276 0.992753623188406 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas coloniensis
2969375 2969375 PRJNA414036_P_NODE_123_length_1196_cov_17.425495_g114_i0 PRJNA414036 123 1196 17.425495 208.4089202 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 390 2.28e-103   NTclustered gi|1402550481|gb|MH488767.1| 2231163 g114 i0 85.751 12.8311036789298 386 35 58 15 9 383 22 398 Rosculus philanguis isolate RSA small subunit ribosomal RNA gene, partial sequence blastn 15346 390 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
3633697 3633697 PRJNA414036_P_NODE_1423_length_680_cov_10.972093_g1136_i0 PRJNA414036 1423 680 10.972093 74.6102324 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 274 1.33e-68   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g1136 i0 83.333 9.20147058823529 318 31 45 13 9 314 315 8 Rosculus vulgaris isolate CCA sequence blastn 6257 274 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
3633735 3633735 PRJNA414036_P_NODE_2563_length_603_cov_13.079225_g2038_i0 PRJNA414036 2563 603 13.079225 78.86772675 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 272 4.209999999999999e-68   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g2038 i0 83.281 16.7446102819237 317 31 72 13 110 414 8 314 Rosculus vulgaris isolate CCA sequence blastn 10097 272 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
4245850 4245850 PRJNA414036_P_NODE_484_length_844_cov_16.279357_g392_i0 PRJNA414036 484 844 16.279357 137.39777308 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 315 9.81e-81   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g392 i0 88.519 28.9810426540284 270 18 59 7 567 835 1659 1916 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 24460 315 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
9346868 9346868 PRJNA414036_P_NODE_288_length_938_cov_14.365449_g248_i0 PRJNA414036 288 938 14.365449 134.74791162 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 396 3.8e-105   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g248 i0 89.297 31.5394456289979 327 20 64 10 520 844 1659 1972 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 29584 396 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
10010914 10010914 PRJNA414036_P_NODE_12188_length_409_cov_22.526738_g10586_i0 PRJNA414036 12188 409 22.526738 92.13435842 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 374 7.38e-99   NTclustered gi|1002343678|gb|KU738556.1| 175275 g10586 i0 89.761 40.3814180929095 293 28 71 2 72 363 166 457 Uncultured Cercozoa clone agricultural_soil20 18S ribosomal RNA gene, partial sequence blastn 16516 375 0.997333333333333 Eukaryota Sar   Cercozoa         uncultured Cercozoa
14447542 14447542 PRJNA414036_P_NODE_14132_length_389_cov_31.562147_g114_i3 PRJNA414036 14132 389 31.562147 122.77675183 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 333 1.19e-86   NTclustered gi|1402550481|gb|MH488767.1| 2231163 g114 i3 83.117 9.84575835475578 385 45 96 14 10 383 23 398 Rosculus philanguis isolate RSA small subunit ribosomal RNA gene, partial sequence blastn 3830 333 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
15110657 15110657 PRJNA414036_P_NODE_34912_length_251_cov_6.129630_g33176_i0 PRJNA414036 34912 251 6.12963 15.3853713 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 137 6.100000000000001e-28   NTclustered gi|290760481|gb|GQ144684.1| 361426 g33176 i0 94.382 36.9123505976096 89 5 35 0 74 162 2861 2773 Ebria tripartita large subunit ribosomal RNA gene, partial sequence blastn 9265 137 1 Eukaryota Sar   Cercozoa Thecofilosea   Ebriacea Ebria Ebria tripartita
15721362 15721362 PRJNA414036_P_NODE_24953_length_303_cov_4.466418_g23219_i0 PRJNA414036 24953 303 4.466418 13.53324654 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 169 2.69e-37   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g23219 i0 89.781 45.1353135313531 137 7 43 2 10 139 3713 3849 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 13676 169 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
16385311 16385311 PRJNA414036_P_NODE_33_length_1610_cov_14.420952_g32_i0 PRJNA414036 33 1610 14.420952 232.1773272 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 274 3.25e-68   NTclustered gi|160688658|gb|EU138880.1| 352461 g32 i0 82.848 29.6515527950311 309 39 33 10 307 610 2226 2525 Thaumatomonas coloniensis strain HFCC93 28S ribosomal RNA gene, partial sequence blastn 47739 276 0.992753623188406 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas coloniensis
16385325 16385325 PRJNA414036_P_NODE_40033_length_232_cov_7.634518_g38294_i0 PRJNA414036 40033 232 7.634518 17.71208176 Verrucomonas 2545269 SAR_Eukaryotes SAR_Eukaryotes 80.5 9.52e-11   NTclustered gi|290760488|gb|GQ144691.1| 629763 g38294 i0 90.164 25.0172413793103 61 6 26 0 161 221 1308 1248 Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence blastn 5804 80.5 1 Eukaryota Sar   Cercozoa Thecofilosea Ventricleftida   Verrucomonas Verrucomonas bifida
16996157 16996157 PRJNA414036_P_NODE_3174_length_576_cov_16.103512_g2554_i0 PRJNA414036 3174 576 16.103512 92.75622912 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 263 2.41e-65   NTclustered gi|2666517884|gb|PP258995.1| 2231160 g2554 i0 90.594 25.5885416666667 202 13 50 6 183 379 367 167 Rosculus sp. strain SARCA10 small subunit ribosomal RNA gene, partial sequence blastn 14739 263 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
18270286 18270286 PRJNA414036_P_NODE_195_length_1032_cov_20.122367_g114_i1 PRJNA414036 195 1032 20.122367 207.66282744 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 597 1.0699999999999996e-165   NTclustered gi|1402550481|gb|MH488767.1| 2231163 g114 i1 85.593 17.9156976744186 590 62 64 17 9 585 22 601 Rosculus philanguis isolate RSA small subunit ribosomal RNA gene, partial sequence blastn 18489 597 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
18934437 18934437 PRJNA414036_P_NODE_75_length_1311_cov_13.825235_g32_i1 PRJNA414036 75 1311 13.825235 181.24883085 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 274 2.63e-68   NTclustered gi|160688658|gb|EU138880.1| 352461 g32 i1 82.848 36.4141876430206 309 39 41 10 702 1005 2525 2226 Thaumatomonas coloniensis strain HFCC93 28S ribosomal RNA gene, partial sequence blastn 47739 276 0.992753623188406 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas coloniensis
20820316 20820316 PRJNA414036_P_NODE_10957_length_423_cov_17.987113_g9399_i0 PRJNA414036 10957 423 17.987113 76.08548799 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 327 6.05e-85   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g9399 i0 84.615 24.4562647754137 325 39 76 8 10 331 2224 2540 Rosculus vulgaris isolate CCA sequence blastn 10345 327 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
20820325 20820325 PRJNA414036_P_NODE_13717_length_393_cov_29.893855_g114_i2 PRJNA414036 13717 393 29.893855 117.48285015 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 339 2.58e-88   NTclustered gi|1402550481|gb|MH488767.1| 2231163 g114 i2 82.995 9.94910941475827 394 47 97 15 5 387 14 398 Rosculus philanguis isolate RSA small subunit ribosomal RNA gene, partial sequence blastn 3910 339 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
20820326 20820326 PRJNA414036_P_NODE_137_length_1154_cov_14.189455_g124_i0 PRJNA414036 137 1154 14.189455 163.7463107 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 444 1.6599999999999994e-119   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g124 i0 86.396 22.9332755632582 419 41 58 14 116 522 746 1160 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 26465 444 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a

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