RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA688736 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
667630 667630 PRJNA688736_P_NODE_2641_length_844_cov_9.534371_g2430_i0 PRJNA688736 2641 844 9.534371 80.47009124 Ochromonas sp. SAG 933.10 984272 SAR_Eukaryotes SAR_Eukaryotes 1327 0   NTclustered gi|323690578|gb|GU935637.1| 984272 g2430 i0 95.053 87.3258293838863 849 33 100 7 1 844 2007 1163 Ochromonas sp. SAG 933.10 28S ribosomal RNA gene, partial sequence blastn 73703 1327 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas sp. SAG 933.10
668241 668241 PRJNA688736_P_NODE_51341_length_234_cov_2.422360_g51056_i0 PRJNA688736 51341 234 2.42236 5.6683224 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 422 1.39e-113   NTclustered gi|759083562|gb|KM222179.1| 1607889 g51056 i0 99.145 99.5470085470085 234 2 100 0 1 234 1677 1444 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 23294 422 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
668267 668267 PRJNA688736_P_NODE_5881_length_600_cov_2.574953_g5603_i0 PRJNA688736 5881 600 2.574953 15.449718 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1037 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g5603 i0 97.99 198.581666666667 597 12 100 0 4 600 121358 120762 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 119149 1037 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
1177168 1177168 PRJNA688736_P_NODE_16101_length_383_cov_1.006452_g15816_i0 PRJNA688736 16101 383 1.006452 3.85471116 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 78.7 6.03e-10   NTclustered gi|319412263|gb|HQ840955.1| 227086 g15816 i0 95.833 1.57702349869452 48 2 13 0 331 378 14562 14515 Bigelowiella natans culture-collection CCMP:621 mitochondrion, partial genome blastn 604 78.7 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
2452470 2452470 PRJNA688736_P_NODE_17942_length_365_cov_1.691781_g17657_i0 PRJNA688736 17942 365 1.691781 6.17500065 root 1 Root_unresolved Root_unresolved 665 0   NTclustered gi|363412127|gb|JN120201.1| 6026 g17657 i0 99.455 100.550684931507 367 0 100 1 1 365 447 813 Opisthonecta henneguyi isolate 43Opisthonectau1S1S2 18S ribosomal RNA gene, partial sequence blastn 36701 665 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
4496296 4496296 PRJNA688736_P_NODE_5704_length_608_cov_1.747664_g5426_i0 PRJNA688736 5704 608 1.747664 10.62579712 Synura synuroidea 47573 SAR_Eukaryotes SAR_Eukaryotes 313 2.5000000000000004e-80   NTclustered gi|11466457|ref|NC_002174.1| 47573 g5426 i0 77.408 47.8125 571 100 92 27 1 560 1001 449 Chrysodidymus synuroideus mitochondrion, complete genome blastn 29070 313 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura synuroidea
5771543 5771543 PRJNA688736_P_NODE_38265_length_258_cov_1.648649_g37980_i0 PRJNA688736 38265 258 1.648649 4.25351442 Humidophila perpusilla 1574070 SAR_Eukaryotes SAR_Eukaryotes 364 2.6599999999999992e-96   NTclustered gi|725539090|gb|KM407563.1| 1574070 g37980 i0 92.248 98.7441860465116 258 19 100 1 1 258 37 293 Diadesmis perpusilla isolate Ant013-D09 28S ribosomal RNA gene, partial sequence blastn 25476 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales   Humidophila Humidophila perpusilla
6281425 6281425 PRJNA688736_P_NODE_29285_length_295_cov_1.783784_g29000_i0 PRJNA688736 29285 295 1.783784 5.2621628 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 540 4.79e-149   NTclustered gi|2651357791|gb|PP174306.1| 41631 g29000 i0 99.661 100.237288135593 295 1 100 0 1 295 2984 2690 Colpoda sp. isolate JGP15 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 29570 540 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
6281538 6281538 PRJNA688736_P_NODE_33425_length_277_cov_3.352941_g33140_i0 PRJNA688736 33425 277 3.352941 9.28764657 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 512 9.73e-141   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g33140 i0 100 99.6028880866426 277 0 100 0 1 277 23 299 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 27590 512 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
7046269 7046269 PRJNA688736_P_NODE_27026_length_306_cov_2.390558_g26741_i0 PRJNA688736 27026 306 2.390558 7.31510748 Ochromonas danica 2986 SAR_Eukaryotes SAR_Eukaryotes 250 9.43e-62   NTclustered gi|11465862|ref|NC_002571.1| 2986 g26741 i0 85.833 79.062091503268 240 28 77 4 2 238 33250 33014 Ochromonas danica mitochondrion, complete genome blastn 24193 250 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
8830162 8830162 PRJNA688736_P_NODE_19347_length_353_cov_11.435714_g19062_i0 PRJNA688736 19347 353 11.435714 40.36807042 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 652 0   NTclustered gi|1202134875|gb|KY454454.1| 63136 g19062 i0 100 98.9886685552408 353 0 100 0 1 353 8 360 Colpoda steinii 18S ribosomal RNA gene, partial sequence blastn 34943 652 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
12147493 12147493 PRJNA688736_P_NODE_47730_length_245_cov_0.906977_g47445_i0 PRJNA688736 47730 245 0.906977 2.22209365 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 254 5.65e-63   NTclustered gi|829100487|ref|XM_001007447.3| 312017 g47445 i0 85.306 4.57959183673469 245 36 100 0 1 245 725 481 Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA blastn 1122 254 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
13422031 13422031 PRJNA688736_P_NODE_45531_length_247_cov_0.896552_g45246_i0 PRJNA688736 45531 247 0.896552 2.21448344 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 183 7.59e-42   NTclustered gi|300676719|gb|GQ377693.1| 151077 g45246 i0 82.464 10.1457489878543 211 35 85 2 37 246 420 211 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 2506 183 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
15969970 15969970 PRJNA688736_P_NODE_10213_length_468_cov_1.326582_g9928_i0 PRJNA688736 10213 468 1.326582 6.20840376 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 791 0   NTclustered gi|759083562|gb|KM222179.1| 1607889 g9928 i0 97.222 96.6282051282051 468 12 100 1 1 468 819 353 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 45222 791 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
15970314 15970314 PRJNA688736_P_NODE_26433_length_309_cov_2.737288_g26148_i0 PRJNA688736 26433 309 2.737288 8.45821992 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 333 9.2e-87   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g26148 i0 86.645 54.0388349514563 307 34 99 6 1 305 3706 4007 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 16698 333 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
19794587 19794587 PRJNA688736_P_NODE_26816_length_307_cov_3.324786_g26531_i0 PRJNA688736 26816 307 3.324786 10.20709302 Vorticella sp. 2219883 SAR_Eukaryotes SAR_Eukaryotes 568 2.3e-157   NTclustered gi|2217167749|gb|ON157274.1| 2219883 g26531 i0 100 98.1693811074919 307 0 100 0 1 307 1676 1370 Vorticella sp. isolate BP174 small subunit ribosomal RNA gene, partial sequence blastn 30138 568 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp.
20303994 20303994 PRJNA688736_P_NODE_36616_length_264_cov_2.041885_g36331_i0 PRJNA688736 36616 264 2.041885 5.3905764 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 206 1.75e-48   NTclustered gi|2088246177|ref|NC_057078.1| 671091 g36331 i0 82.906 87.6590909090909 234 35 88 5 34 264 27645 27876 Coscinodiscus wailesii mitochondrion, complete genome blastn 23142 206 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
20304302 20304302 PRJNA688736_P_NODE_51696_length_209_cov_5.058824_g51411_i0 PRJNA688736 51696 209 5.058824 10.57294216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 385 1.59e-102   NTclustered gi|1802599794|gb|MT001203.1| 41631 g51411 i0 100 99.6028708133971 208 0 99 0 1 208 1356 1563 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 20817 385 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
21579282 21579282 PRJNA688736_P_NODE_13917_length_408_cov_1.641791_g13632_i0 PRJNA688736 13917 408 1.641791 6.69850728 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 532 1.15e-146   NTclustered gi|146762526|gb|EF553458.1| 2850 g13632 i0 92.105 96.796568627451 380 26 92 4 32 408 4591 4213 Phaeodactylum tricornutum strain CCAP 1055/1 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 39493 532 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21579291 21579291 PRJNA688736_P_NODE_14297_length_403_cov_14.336364_g14012_i0 PRJNA688736 14297 403 14.336364 57.77554692 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 743 0   NTclustered gi|1802599797|gb|MT001206.1| 41631 g14012 i0 100 98.9205955334988 402 0 99 0 1 402 508 909 Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence blastn 39865 743 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
21579762 21579762 PRJNA688736_P_NODE_33117_length_279_cov_1.135922_g32832_i0 PRJNA688736 33117 279 1.135922 3.16922238 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 459 1.3000000000000002e-124   NTclustered gi|2166921685|gb|OL894853.1| 63136 g32832 i0 96.416 11.2293906810036 279 8 100 2 1 279 789 513 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 3133 459 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini

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