RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 15 ✖

bioproject 1

  • PRJNA683902 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
665250 665250 PRJNA683902_S_NODE_20681_length_232_cov_2.702564_g20237_i0 PRJNA683902 20681 232 2.702564 6.26994848 Jenufa minuta 993092 Plants Plants 429 8.2e-116   NTclustered gi|959124355|ref|NC_028582.1| 993092 g20237 i0 100 85.4396551724138 232 0 100 0 1 232 104901 104670 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 19822 429 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
665349 665349 PRJNA683902_S_NODE_32281_length_170_cov_3.225564_g31837_i0 PRJNA683902 32281 170 3.225564 5.4834588 Jenufa minuta 993092 Plants Plants 315 1.64e-81   NTclustered gi|959124355|ref|NC_028582.1| 993092 g31837 i0 100 165.952941176471 170 0 100 0 1 170 104132 103963 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 28212 315 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
2450817 2450817 PRJNA683902_S_NODE_28762_length_183_cov_4.554795_g28318_i0 PRJNA683902 28762 183 4.554795 8.33527485 root 1 Root_unresolved Root_unresolved 339 1.07e-88   NTclustered gi|1714003650|gb|MN243923.1| 3079 g28318 i0 100 100.153005464481 183 0 100 0 1 183 683 865 Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence blastn 18328 339 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sp.
4493143 4493143 PRJNA683902_S_NODE_16204_length_285_cov_3.923387_g15760_i0 PRJNA683902 16204 285 3.923387 11.18165295 Jenufa minuta 993092 Plants Plants 527 3.59e-145   NTclustered gi|959124355|ref|NC_028582.1| 993092 g15760 i0 100 145.185964912281 285 0 100 0 1 285 103412 103128 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 41378 527 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
7043980 7043980 PRJNA683902_S_NODE_29166_length_181_cov_10.847222_g28722_i0 PRJNA683902 29166 181 10.847222 19.63347182 Aphanochaete magnum 104531 Plants Plants 268 1.3999999999999999e-67   NTclustered gi|6119989|gb|AF183449.1| 104531 g28722 i0 93.37 100.038674033149 181 12 100 0 1 181 1789 1609 Aphanochaete magnum strain UTEX B 1909 28S ribosomal RNA gene, partial sequence blastn 18107 268 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chaetophorales Aphanochaetaceae Aphanochaete Aphanochaete magnum
7044020 7044020 PRJNA683902_S_NODE_33766_length_165_cov_4.265625_g33322_i0 PRJNA683902 33766 165 4.265625 7.03828125 Jenufa minuta 993092 Plants Plants 305 9.59e-79   NTclustered gi|959124355|ref|NC_028582.1| 993092 g33322 i0 100 129.212121212121 165 0 100 0 1 165 103821 103985 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 21320 305 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
9593829 9593829 PRJNA683902_S_NODE_17068_length_272_cov_6.097872_g16624_i0 PRJNA683902 17068 272 6.097872 16.58621184 Micractinium reisseri 532145 Plants Plants 147 1.11e-30   NTclustered gi|297501471|dbj|AB506071.1| 532145 g16624 i0 90.265 34.8308823529412 113 10 41 1 9 120 6453 6341 Micractinium reisseri genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 2 blastn 9474 147 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium reisseri
12144713 12144713 PRJNA683902_S_NODE_31490_length_173_cov_2.000000_g31046_i0 PRJNA683902 31490 173 2 3.46 uncultured Chloroidium 1267198 Plants Plants 270 3.69e-68   NTclustered gi|2515376813|gb|OR101670.1| 1267198 g31046 i0 95.294 94.9248554913295 170 8 98 0 1 170 1147 1316 Uncultured Chloroidium clone gcl123_AM09 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 16422 270 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales     uncultured Chloroidium
13419250 13419250 PRJNA683902_S_NODE_25571_length_199_cov_5.098765_g25127_i0 PRJNA683902 25571 199 5.098765 10.14654235 Jenufa minuta 993092 Plants Plants 368 1.51e-97   NTclustered gi|325484952|gb|HM563744.1| 993092 g25127 i0 100 96.9748743718593 199 0 100 0 1 199 660 858 Jenufa minuta culture-collection CAUP<CZH>:H 8102 18S ribosomal RNA gene, partial sequence blastn 19298 368 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
14694277 14694277 PRJNA683902_S_NODE_28572_length_184_cov_2.993197_g28128_i0 PRJNA683902 28572 184 2.993197 5.50748248 Coccomyxa subellipsoidea 248742 Plants Plants 200 5.3e-47   NTclustered gi|1360638125|gb|AC277041.1| 574566 g28128 i0 87.719 13.3478260869565 171 21 93 0 14 184 39766 39596 Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence blastn 2456 200 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
18517577 18517577 PRJNA683902_S_NODE_8775_length_532_cov_4.688889_g8352_i0 PRJNA683902 8775 532 4.688889 24.94488948 Jenufa minuta 993092 Plants Plants 773 0   NTclustered gi|959124355|ref|NC_028582.1| 993092 g8352 i0 92.804 135.906015037594 542 26 100 9 1 532 103376 103914 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 72302 773 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
19027231 19027231 PRJNA683902_S_NODE_29515_length_180_cov_2.314685_g29071_i0 PRJNA683902 29515 180 2.314685 4.166433 Coccomyxa 41891 Plants Plants 220 3.96e-53   NTclustered gi|1360638129|gb|AC277064.1| 574566 g29071 i0 88.889 100.205555555556 180 19 100 1 1 180 1704 1526 Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence blastn 18037 220 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
24127600 24127600 PRJNA683902_S_NODE_35079_length_162_cov_1.216000_g34635_i0 PRJNA683902 35079 162 1.216 1.96992 Ulotrichales 31306 Plants Plants 272 9.51e-69   NTclustered gi|557844178|gb|KF144222.1| 160070 g34635 i0 97.484 98.1481481481482 159 4 98 0 3 161 658 816 Tupiella akineta isolate WB20 18S ribosomal RNA gene, partial sequence blastn 15900 272 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Tupiellaceae Tupiella Tupiella akineta
24891382 24891382 PRJNA683902_S_NODE_23080_length_214_cov_4.118644_g22636_i0 PRJNA683902 23080 214 4.118644 8.81389816 Jenufa minuta 993092 Plants Plants 390 3.519999999999999e-104   NTclustered gi|959124355|ref|NC_028582.1| 993092 g22636 i0 99.533 110.060747663551 214 1 100 0 1 214 102917 103130 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 23553 390 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta
24891434 24891434 PRJNA683902_S_NODE_29800_length_179_cov_1.922535_g29356_i0 PRJNA683902 29800 179 1.922535 3.44133765 Jenufa minuta 993092 Plants Plants 307 2.9300000000000005e-79   NTclustered gi|959124355|ref|NC_028582.1| 993092 g29356 i0 97.753 100.68156424581 178 4 99 0 2 179 93582 93405 Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome blastn 18022 307 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Jenufa Jenufa minuta

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