RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA556842" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA556842 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
1124146 1124146 PRJNA556842_P_NODE_10881_length_226_cov_1.354497_g10376_i0 PRJNA556842 10881 226 1.354497 3.06116322 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 368 1.76e-97   NTclustered gi|2127884593|ref|NC_058877.1| 83372 g10376 i0 96.018 199.044247787611 226 9 100 0 1 226 14939 14714 Thalassiosira nordenskioeldii isolate CNS00052 chloroplast, complete genome blastn 44984 368 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira nordenskioeldii
3072718 3072718 PRJNA556842_P_NODE_13623_length_186_cov_1.697987_g13118_i0 PRJNA556842 13623 186 1.697987 3.15825582 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 294 2.39e-75   NTclustered gi|2091535207|ref|NC_057645.1| 444606 g13118 i0 96.61 186.516129032258 177 6 95 0 1 177 17811 17635 Eucampia zodiacus strain CNS00061 chloroplast, complete genome blastn 34692 294 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
3675478 3675478 PRJNA556842_P_NODE_13783_length_184_cov_2.326531_g13278_i0 PRJNA556842 13783 184 2.326531 4.28081704 Hymenostomatida 31277 SAR_Eukaryotes SAR_Eukaryotes 307 3.0300000000000004e-79   NTclustered gi|2624665746|gb|OR878271.1| 210825 g13278 i0 96.739 83.9891304347826 184 6 100 0 1 184 986 803 Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence blastn 15454 307 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Glaucomidae Glaucoma Glaucoma scintillans
4348923 4348923 PRJNA556842_P_NODE_16984_length_157_cov_0.966667_g16479_i0 PRJNA556842 16984 157 0.966667 1.51766719 Phytopythium vexans 907947 SAR_Eukaryotes SAR_Eukaryotes 176 7.37e-40   NTclustered gi|829497382|dbj|AB856793.1| 907947 g16479 i0 87.662 28.6369426751592 154 15 97 3 5 156 60 211 Phytopythium vexans HSP90 gene for heat shock protein 90, partial cds, isolate: 2D111 blastn 4496 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium vexans
4348924 4348924 PRJNA556842_P_NODE_17224_length_155_cov_1.313559_g16719_i0 PRJNA556842 17224 155 1.313559 2.03601645 Hibberdia magna 3000 SAR_Eukaryotes SAR_Eukaryotes 220 3.2999999999999996e-53   NTclustered gi|282936951|gb|GU325202.1| 3000 g16719 i0 92.258 100.464516129032 155 12 100 0 1 155 291 137 Hibberdia magna strain CCMP1160 photosystem II P680 protein D1 (psbA) gene, partial cds; plastid blastn 15572 220 1 Eukaryota Sar     Chrysophyceae Hibberdiales Hibberdiaceae Hibberdia Hibberdia magna
4348927 4348927 PRJNA556842_P_NODE_4184_length_461_cov_79.228774_g3691_i0 PRJNA556842 4184 461 79.228774 365.24464814 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 399 1.3899999999999998e-106   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g3691 i0 85.788 50.4642082429501 387 44 83 11 1 382 3659 4039 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 23264 399 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
9450202 9450202 PRJNA556842_P_NODE_2388_length_650_cov_3.634584_g1967_i0 PRJNA556842 2388 650 3.634584 23.624796 Paramecium gigas 2709424 SAR_Eukaryotes SAR_Eukaryotes 95.3 1.06e-14   NTclustered gi|2120474459|ref|NC_058286.1| 2709424 g1967 i0 88.608 27.4246153846154 79 8 12 1 382 459 1843 1921 Paramecium gigas mitochondrion, complete genome blastn 17826 95.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium gigas
10052587 10052587 PRJNA556842_P_NODE_9428_length_254_cov_3.161290_g8923_i0 PRJNA556842 9428 254 3.16129 8.0296766 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 436 5.45e-118   NTclustered gi|2862228899|gb|PQ645533.1| 265540 g8923 i0 97.638 100.03937007874 254 6 100 0 1 254 3532 3785 Minidiscus trioculatus isolate AGSB0407 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 25410 436 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus trioculatus
10725952 10725952 PRJNA556842_P_NODE_10709_length_229_cov_2.208333_g10204_i0 PRJNA556842 10709 229 2.208333 5.05708257 Licmophora juergensii 210598 SAR_Eukaryotes SAR_Eukaryotes 396 8.1899999999999985e-106   NTclustered gi|2862228907|gb|PQ645541.1| 210598 g10204 i0 97.817 100.427947598253 229 5 100 0 1 229 2993 3221 Licmophora juergensii isolate AGSB0420 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 22998 396 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Licmophoraceae Licmophora Licmophora juergensii
12000735 12000735 PRJNA556842_P_NODE_11790_length_210_cov_2.647399_g11285_i0 PRJNA556842 11790 210 2.647399 5.5595379 Hydrurus foetidus 2996 SAR_Eukaryotes SAR_Eukaryotes 261 2.81e-65   NTclustered gi|2550427459|gb|OR336050.1| 2996 g11285 i0 89.1 102.509523809524 211 22 100 1 1 210 2406 2196 Hydrurus foetidus strain Fenhe 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 21527 261 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
12603110 12603110 PRJNA556842_P_NODE_10510_length_232_cov_17.307692_g10005_i0 PRJNA556842 10510 232 17.307692 40.15384544 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 418 1.7799999999999995e-112   NTclustered gi|219903753|emb|FM955256.1| 2996 g10005 i0 99.142 100.431034482759 233 1 100 1 1 232 1398 1630 Hydrurus foetidus partial 18S rRNA gene blastn 23300 418 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
15152217 15152217 PRJNA556842_P_NODE_10412_length_234_cov_7.350254_g9907_i0 PRJNA556842 10412 234 7.350254 17.19959436 Synura 2991 SAR_Eukaryotes SAR_Eukaryotes 392 1.0899999999999999e-104   NTclustered gi|859809579|gb|KM590718.1| 52553 g9907 i0 96.996 101.568376068376 233 7 99 0 2 234 1268 1500 Synura glabra strain Yeondong060207B 23S ribosomal RNA gene, partial sequence; plastid blastn 23767 392 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura glabra
15152229 15152229 PRJNA556842_P_NODE_9852_length_245_cov_5.625000_g9347_i0 PRJNA556842 9852 245 5.625 13.78125 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 403 5.299999999999998e-108   NTclustered gi|2757671030|gb|PQ008817.1| 2989 g9347 i0 96.327 97.1387755102041 245 9 100 0 1 245 983 1227 Mallomonas papillosa strain CZ03F large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 23799 407 0.99017199017199 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Mallomonas Mallomonas papillosa
17099341 17099341 PRJNA556842_P_NODE_3294_length_535_cov_11.664659_g2822_i0 PRJNA556842 3294 535 11.664659 62.40592565 Hydrurus foetidus 2996 SAR_Eukaryotes SAR_Eukaryotes 843 0   NTclustered gi|2550427459|gb|OR336050.1| 2996 g2822 i0 95.149 100.43738317757 536 22 99 4 1 534 1866 2399 Hydrurus foetidus strain Fenhe 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 53734 843 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
18975526 18975526 PRJNA556842_P_NODE_7075_length_320_cov_14.406360_g6572_i0 PRJNA556842 7075 320 14.40636 46.100352 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 512 1.1499999999999998e-140   NTclustered gi|219903753|emb|FM955256.1| 2996 g6572 i0 96.178 97.9875 314 11 98 1 2 315 73 385 Hydrurus foetidus partial 18S rRNA gene blastn 31356 512 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
22198671 22198671 PRJNA556842_P_NODE_10258_length_238_cov_1.174129_g9753_i0 PRJNA556842 10258 238 1.174129 2.79442702 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 303 5.35e-78   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g9753 i0 89.958 93.7436974789916 239 18 100 4 1 238 4042 3809 Haslea avium 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 22311 303 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
22198675 22198675 PRJNA556842_P_NODE_13238_length_190_cov_12.183007_g12733_i0 PRJNA556842 13238 190 12.183007 23.1477133 Hydrurus foetidus 2996 SAR_Eukaryotes SAR_Eukaryotes 324 3.13e-84   NTclustered gi|219903754|emb|FM955257.1| 2996 g12733 i0 97.368 100.410526315789 190 5 100 0 1 190 954 1143 Hydrurus foetidus partial 28S rRNA gene blastn 19078 324 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
24076120 24076120 PRJNA556842_P_NODE_16939_length_157_cov_1.508333_g16434_i0 PRJNA556842 16939 157 1.508333 2.36808281 Turaniellidae 291295 SAR_Eukaryotes SAR_Eukaryotes 287 3.26e-73   NTclustered gi|10931|emb|X56532.1| 5927 g16434 i0 100 98.5668789808917 155 0 99 0 3 157 555 401 C.campylum small subunit ribosomal RNA gene blastn 15475 287 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Turaniellidae Dexiostoma Dexiostoma campyla

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