RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 32 ✖

bioproject 1

  • PRJNA1218816 · 32 ✖

analysis 1

  • blastn · 32 ✖

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
333219 333219 PRJNA1218816_P_NODE_28681_length_380_cov_1.368078_g28248_i0 PRJNA1218816 28681 380 1.368078 5.1986964 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 403 8.68e-108   NTclustered gi|166047767|emb|CU362882.1| 100861 g28248 i0 86.133 97.8473684210526 375 50 98 2 1 374 471 98 Aphanomyces euteiches cDNA blastn 37182 403 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
333429 333429 PRJNA1218816_P_NODE_51501_length_258_cov_2.291892_g51068_i0 PRJNA1218816 51501 258 2.291892 5.91308136 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 473 4.2299999999999996e-129   NTclustered gi|323690576|gb|GU935635.1| 88167 g51068 i0 100 100.596899224806 256 0 99 0 3 258 2551 2296 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 25954 473 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
333449 333449 PRJNA1218816_P_NODE_54101_length_251_cov_0.865169_g53668_i0 PRJNA1218816 54101 251 0.865169 2.17157419 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 167 7.789999999999999e-37   NTclustered gi|673017857|ref|XM_008864668.1| 157072 g53668 i0 79.487 3.92430278884462 234 48 93 0 8 241 229 462 Aphanomyces invadans 60S ribosomal protein mRNA blastn 985 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
1046205 1046205 PRJNA1218816_P_NODE_13521_length_652_cov_7.386874_g13101_i0 PRJNA1218816 13521 652 7.386874 48.16241848 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 1171 0   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g13101 i0 99.08 100.19018404908 652 6 100 0 1 652 3522 4173 Thalassiosira bioculata isolate AGSB0307 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 65324 1171 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
1607958 1607958 PRJNA1218816_P_NODE_23402_length_439_cov_2.043716_g22969_i0 PRJNA1218816 23402 439 2.043716 8.97191324 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 4.97e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g22969 i0 80.533 76.9635535307517 375 65 84 4 3 370 68 441 Aphanomyces astaci polyubiquitin mRNA blastn 33787 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
1608037 1608037 PRJNA1218816_P_NODE_34062_length_338_cov_2.305660_g33629_i0 PRJNA1218816 34062 338 2.30566 7.7931308 Plasmodium falciparum 5833 SAR_Eukaryotes SAR_Eukaryotes 625 1.4999999999999999e-174   NTclustered gi|665764067|pdb|1VX6|A 36329 g33629 i0 100 52.6745562130178 338 0 100 0 1 338 3730 3393 Chain A, 28S ribosomal RNA blastn 17804 625 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
1608044 1608044 PRJNA1218816_P_NODE_35522_length_329_cov_2.074219_g35089_i0 PRJNA1218816 35522 329 2.074219 6.82418051 Poteriospumella lacustris 1117027 SAR_Eukaryotes SAR_Eukaryotes 603 6.819999999999999e-168   NTclustered gi|2295553597|gb|OP378946.1| 1117027 g35089 i0 99.696 97.3313069908815 329 1 100 0 1 329 1254 1582 Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence blastn 32022 603 1 Eukaryota Sar     Chrysophyceae Chromulinales Dinobryaceae Poteriospumella Poteriospumella lacustris
2884132 2884132 PRJNA1218816_P_NODE_18543_length_520_cov_3.407159_g18113_i0 PRJNA1218816 18543 520 3.407159 17.7172268 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 922 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g18113 i0 98.654 94.9826923076923 520 7 100 0 1 520 1546 1027 Vorticella sp. 4 JG-2011 clone 2 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 49391 922 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
2884187 2884187 PRJNA1218816_P_NODE_29003_length_377_cov_1.003289_g28570_i0 PRJNA1218816 29003 377 1.003289 3.78239953 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 211 5.6e-50   NTclustered gi|676379988|ref|XM_009035025.1| 44056 g28570 i0 77.473 64.8514588859416 364 74 95 7 16 375 1747 1388 Aureococcus anophagefferens heat shock protein 70 mRNA blastn 24449 211 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
4874379 4874379 PRJNA1218816_P_NODE_38004_length_315_cov_2.586777_g37571_i0 PRJNA1218816 38004 315 2.586777 8.14834755 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 575 1.4199999999999995e-159   NTclustered gi|1409949881|gb|MH542675.1| 88167 g37571 i0 99.682 98.3047619047619 314 1 99 0 2 315 12 325 Poterioochromonas malhamensis strain SAG933-9 small subunit ribosomal RNA gene, partial sequence blastn 30966 575 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
4874386 4874386 PRJNA1218816_P_NODE_45824_length_280_cov_1.487923_g45391_i0 PRJNA1218816 45824 280 1.487923 4.1661844 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 433 7.89e-117   NTclustered gi|74325165|ref|NC_007405.1| 35128 g45391 i0 95.255 99.4571428571429 274 12 98 1 7 280 12492 12220 Thalassiosira pseudonana mitochondrion, complete genome blastn 27848 435 0.995402298850575 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
5436636 5436636 PRJNA1218816_P_NODE_4465_length_1382_cov_8.264324_g4229_i0 PRJNA1218816 4465 1382 8.264324 114.21295768 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 2241 0   NTclustered gi|53829555|gb|AY582830.1| 289359 g4229 i0 99.433 94.1382054992764 1234 7 89 0 68 1301 5 1238 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 130099 2241 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
6711229 6711229 PRJNA1218816_P_NODE_48266_length_270_cov_1.538071_g47833_i0 PRJNA1218816 48266 270 1.538071 4.1527917 Giraudyopsis stellifer 45653 SAR_Eukaryotes SAR_Eukaryotes 128 4e-25   NTclustered gi|1181989|emb|Z46920.1| 45653 g47833 i0 84.733 1.4037037037037 131 17 49 1 118 248 11 138 G.stellifer CAC GENE blastn 379 128 1 Eukaryota Sar     Chrysomerophyceae Chrysomeridales Chrysomeridaceae Giraudyopsis Giraudyopsis stellifer
6711308 6711308 PRJNA1218816_P_NODE_57246_length_247_cov_0.885057_g56813_i0 PRJNA1218816 57246 247 0.885057 2.18609079 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 191 4.53e-44   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g56813 i0 81.673 17.7773279352227 251 26 100 11 1 247 3746 3980 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 4391 191 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
6711384 6711384 PRJNA1218816_P_NODE_64326_length_210_cov_5.211679_g63893_i0 PRJNA1218816 64326 210 5.211679 10.9445259 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 292 9.97e-75   NTclustered gi|1169296927|gb|KY364697.1| 29204 g63893 i0 91.905 93.6857142857143 210 15 100 2 1 210 5607 5814 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 19674 292 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
7424208 7424208 PRJNA1218816_P_NODE_64286_length_216_cov_5.230769_g63853_i0 PRJNA1218816 64286 216 5.230769 11.29846104 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 399 5.909999999999999e-107   NTclustered gi|1409222725|gb|MH536659.1| 88167 g63853 i0 100 100 216 0 100 0 1 216 1412 1627 Poterioochromonas malhamensis strain SAG933-1d small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 21600 399 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
8699265 8699265 PRJNA1218816_P_NODE_32867_length_346_cov_2.853480_g32434_i0 PRJNA1218816 32867 346 2.85348 9.8730408 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 634 2.5599999999999996e-177   NTclustered gi|675821511|dbj|AB827536.1| 137771 g32434 i0 99.711 100.014450867052 346 1 100 0 1 346 452 107 Uncultured diatom gene for 18S rRNA, partial sequence, clone: HP18D-93 blastn 34605 640 0.990625 Eukaryota Sar   Bacillariophyta         uncultured diatom
10537371 10537371 PRJNA1218816_P_NODE_55389_length_249_cov_1.312500_g54956_i0 PRJNA1218816 55389 249 1.3125 3.268125 Cercomonadida sp. C15_1A03 595691 SAR_Eukaryotes SAR_Eukaryotes 427 3.2e-115   NTclustered gi|223047882|gb|FJ032646.1| 595691 g54956 i0 97.59 99.9236947791165 249 6 100 0 1 249 1684 1932 Cercomonadida sp. C15_1A03 28S ribosomal RNA gene, partial sequence blastn 24881 427 1 Eukaryota Sar   Cercozoa   Cercomonadida     Cercomonadida sp. C15_1A03
11249586 11249586 PRJNA1218816_P_NODE_21729_length_463_cov_4.541026_g21296_i0 PRJNA1218816 21729 463 4.541026 21.02495038 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 856 0   NTclustered gi|323690576|gb|GU935635.1| 88167 g21296 i0 100 82.0907127429806 463 0 100 0 1 463 54 516 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 38008 856 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
12524946 12524946 PRJNA1218816_P_NODE_52450_length_255_cov_1.648352_g52017_i0 PRJNA1218816 52450 255 1.648352 4.2032976 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 472 1.5e-128   NTclustered gi|160642|gb|M19172.1|PFARGEA 5833 g52017 i0 100 101.227450980392 255 0 100 0 1 255 1931 1677 P.falciparum 18S ribosomal RNA in asexual parasites blastn 25813 472 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
14362406 14362406 PRJNA1218816_P_NODE_42372_length_294_cov_1.918552_g41939_i0 PRJNA1218816 42372 294 1.918552 5.64054288 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 313 1.13e-80   NTclustered gi|53829589|gb|AY582847.1| 289359 g41939 i0 98.857 56.6258503401361 175 2 60 0 1 175 729 903 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds blastn 16648 313 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
15073869 15073869 PRJNA1218816_P_NODE_58292_length_246_cov_0.890173_g57859_i0 PRJNA1218816 58292 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 433 6.79e-117   NTclustered gi|1837628855|gb|MN158348.1| 5909 g57859 i0 98.374 84.9227642276423 246 4 100 0 1 246 2949 2704 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 20891 433 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
18897794 18897794 PRJNA1218816_P_NODE_53355_length_252_cov_1.396648_g52922_i0 PRJNA1218816 53355 252 1.396648 3.51955296 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 466 6.89e-127   NTclustered gi|323690576|gb|GU935635.1| 88167 g52922 i0 100 99.5396825396825 252 0 100 0 1 252 877 1128 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 25084 466 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
19459552 19459552 PRJNA1218816_P_NODE_58816_length_245_cov_1.790698_g58383_i0 PRJNA1218816 58816 245 1.790698 4.3872101 Kryptoperidinium foliaceum 160619 SAR_Eukaryotes SAR_Eukaryotes 202 2.08e-47   NTclustered gi|54300507|gb|AY713393.1| 160619 g58383 i0 85.354 75.0448979591837 198 25 80 4 19 214 320 125 Kryptoperidinium foliaceum isolate KfolHSP90_6 heat shock protein 90 gene, partial cds blastn 18386 202 1 Eukaryota Sar     Dinophyceae Peridiniales Kryptoperidiniaceae Kryptoperidinium Kryptoperidinium foliaceum
20734662 20734662 PRJNA1218816_P_NODE_15397_length_595_cov_2.632184_g14972_i0 PRJNA1218816 15397 595 2.632184 15.6614948 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 313 2.45e-80   NTclustered gi|657012367|gb|KF302531.1| 2850 g14972 i0 83.832 25.236974789916 334 48 56 6 1 331 346 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 15016 313 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20734761 20734761 PRJNA1218816_P_NODE_31037_length_360_cov_1.355401_g30604_i0 PRJNA1218816 31037 360 1.355401 4.8794436 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 638 2.06e-178   NTclustered gi|53829571|gb|AY582838.1| 289359 g30604 i0 98.611 92.7888888888889 360 5 100 0 1 360 759 400 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 HSP70 gene, partial cds blastn 33404 638 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
22723168 22723168 PRJNA1218816_P_NODE_42298_length_295_cov_0.936937_g41865_i0 PRJNA1218816 42298 295 0.936937 2.76396415 root 1 Root_unresolved Root_unresolved 102 2.68e-17   NTclustered gi|219903754|emb|FM955257.1| 2996 g41865 i0 90.909 26.2135593220339 77 6 26 1 156 231 1850 1774 Hydrurus foetidus partial 28S rRNA gene blastn 7733 102 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
23285702 23285702 PRJNA1218816_P_NODE_50579_length_261_cov_4.292553_g50146_i0 PRJNA1218816 50579 261 4.292553 11.20356333 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|29242784|gb|AY124991.1| 5940 g50146 i0 92.308 0.149425287356322 39 3 15 0 27 65 1979 1941 Euplotes aediculatus beta-/gamma-platein precursor, gene, complete cds blastn 39 56.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
23285772 23285772 PRJNA1218816_P_NODE_57759_length_247_cov_0.885057_g57326_i0 PRJNA1218816 57759 247 0.885057 2.18609079 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 457 4.05e-124   NTclustered gi|2088238071|ref|NC_056910.1| 88167 g57326 i0 100 104.919028340081 247 0 100 0 1 247 15348 15594 Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome blastn 25915 457 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
23285816 23285816 PRJNA1218816_P_NODE_62459_length_241_cov_1.375000_g62026_i0 PRJNA1218816 62459 241 1.375 3.31375 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 165 2.67e-36   NTclustered gi|224002558|ref|XM_002290915.1| 296543 g62026 i0 80.444 73.3983402489627 225 36 92 5 1 221 166 386 Thalassiosira pseudonana CCMP1335 hypothetical protein (AHC3), mRNA blastn 17689 165 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23998396 23998396 PRJNA1218816_P_NODE_59179_length_245_cov_0.895349_g58746_i0 PRJNA1218816 59179 245 0.895349 2.19360505 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 453 5.1900000000000006e-123   NTclustered gi|98990570|gb|DQ514795.1| 160265 g58746 i0 100 99.6979591836735 245 0 100 0 1 245 26 270 Thalassiosira antarctica strain CCMP982 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 24426 453 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira antarctica
25272438 25272438 PRJNA1218816_P_NODE_37460_length_318_cov_1.885714_g37027_i0 PRJNA1218816 37460 318 1.885714 5.99657052 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 241 5.930000000000001e-59   NTclustered gi|59894163|gb|AY729864.1| 74557 g37027 i0 81.882 100.672955974843 287 50 90 2 3 288 941 1226 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 32014 241 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata

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