RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1218818" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA1218818 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1608451 1608451 PRJNA1218818_P_NODE_23162_length_257_cov_1.505435_g23095_i0 PRJNA1218818 23162 257 1.505435 3.86896795 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 420 5.56e-113   NTclustered gi|300676719|gb|GQ377693.1| 151077 g23095 i0 96.109 3.70817120622568 257 10 100 0 1 257 29 285 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 953 420 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
12524991 12524991 PRJNA1218818_P_NODE_12830_length_343_cov_1.829630_g12763_i0 PRJNA1218818 12830 343 1.82963 6.2756309 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 634 2.5299999999999996e-177   NTclustered gi|343129395|gb|HM991684.1| 265564 g12763 i0 100 99.8046647230321 343 0 100 0 1 343 183 525 Thalassiosira punctigera 28S ribosomal RNA gene, partial sequence blastn 34233 634 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira punctigera
13087566 13087566 PRJNA1218818_P_NODE_7011_length_459_cov_1.606218_g6944_i0 PRJNA1218818 7011 459 1.606218 7.37254062 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 776 0   NTclustered gi|110645063|gb|DQ665311.1| 151077 g6944 i0 97.168 40.156862745098 459 13 100 0 1 459 246 704 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 18432 776 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
13799681 13799681 PRJNA1218818_P_NODE_16691_length_305_cov_1.327586_g16624_i0 PRJNA1218818 16691 305 1.327586 4.0491373 root 1 Root_unresolved Root_unresolved 564 2.95e-156   NTclustered gi|314905776|gb|HM213230.1| 46086 g16624 i0 100 102 305 0 100 0 1 305 91 395 Elphidium aculeatum isolate A53.6 small subunit ribosomal RNA (SSU) gene, partial sequence; plastid blastn 31110 564 1 Eukaryota Sar   Foraminifera   Rotaliida Elphidiidae Elphidium Elphidium aculeatum
14362789 14362789 PRJNA1218818_P_NODE_24992_length_249_cov_0.875000_g24925_i0 PRJNA1218818 24992 249 0.875 2.17875 Acavomonas peruviana 1542312 SAR_Eukaryotes SAR_Eukaryotes 169 2.1399999999999996e-37   NTclustered gi|567569548|gb|KF651071.1| 1542312 g24925 i0 84.615 74.2168674698795 169 26 68 0 69 237 835 1003 Acavomonas peruviana strain Colp-5 clone 21 alpha tubulin subunit gene, partial cds blastn 18480 169 1 Eukaryota Sar       Colponemida Acavomonidia Acavomonas Acavomonas peruviana
16910932 16910932 PRJNA1218818_P_NODE_28234_length_242_cov_0.911243_g28167_i0 PRJNA1218818 28234 242 0.911243 2.20520806 Chrysophyceae sp. I76 429461 SAR_Eukaryotes SAR_Eukaryotes 257 4.3e-64   NTclustered gi|134142272|gb|EF432474.1| 429461 g28167 i0 86.638 46.2231404958678 232 31 96 0 11 242 892 1123 Chrysophyceae sp. I76 clone E7 beta tubulin (btub) mRNA, partial cds blastn 11186 257 1 Eukaryota Sar     Chrysophyceae       Chrysophyceae sp. I76
23285973 23285973 PRJNA1218818_P_NODE_21999_length_265_cov_1.296875_g21932_i0 PRJNA1218818 21999 265 1.296875 3.43671875 Ochromonas sp. SAG 933.10 984272 SAR_Eukaryotes SAR_Eukaryotes 344 3.57e-90   NTclustered gi|323690578|gb|GU935637.1| 984272 g21932 i0 90.335 57.0037735849057 269 17 99 7 1 264 2007 1743 Ochromonas sp. SAG 933.10 28S ribosomal RNA gene, partial sequence blastn 15106 344 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas sp. SAG 933.10

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