RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA670521", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 32 ✖

tax_clade 1

  • Sar · 32 ✖

bioproject 1

  • PRJNA670521 · 32 ✖

analysis 1

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
7016619 7016619 PRJNA670521_P_NODE_19126_length_429_cov_2.851124_g18384_i0 PRJNA670521 19126 429 2.851124 12.23132196 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 268 5.2899999999999986e-89   NR CAJ1953473.1 2856 g18384 i0 86.5 6.9020979020979 141 19 98.6 0 4 426 70 210 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 2961 269 0.996282527881041 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
7016785 7016785 PRJNA670521_P_NODE_58906_length_275_cov_1.524752_g58161_i0 PRJNA670521 58906 275 1.524752 4.193068 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 109 1.09e-25   NR CAJ1935402.1 2856 g58161 i0 76.6 5.65090909090909 77 17 82.9 1 275 48 107 183 CAJ1935402.1 unnamed protein product [Cylindrotheca closterium] diamond 1554 110 0.990909090909091 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
9567031 9567031 PRJNA670521_P_NODE_93868_length_233_cov_2.431250_g93123_i0 PRJNA670521 93868 233 2.43125 5.6648125 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 131 9.66e-36   NR KAI2505670.1 210448 g93123 i0 79.2 9.88841201716738 77 16 99.1 0 3 233 45 121 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 2304 132 0.992424242424242 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
18490838 18490838 PRJNA670521_P_NODE_86355_length_244_cov_0.900585_g85610_i0 PRJNA670521 86355 244 0.900585 2.1974274 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 142 3.36e-38   NR VEU36148.1 183589 g85610 i0 86.3 11.8032786885246 80 11 98.4 0 3 242 303 382 VEU36148.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 2880 143 0.993006993006993 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
23591084 23591084 PRJNA670521_P_NODE_59739_length_273_cov_1.540000_g58994_i0 PRJNA670521 59739 273 1.54 4.2042 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 135 1.39e-34   NR CAB9516456.1 568900 g58994 i0 65.5 0.956043956043956 87 29 94.5 1 10 267 440 526 CAB9516456.1 expressed unknown protein [Seminavis robusta] diamond 261 135 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
24864231 24864231 PRJNA670521_P_NODE_25460_length_383_cov_1.674194_g24716_i0 PRJNA670521 25460 383 1.674194 6.41216302 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 199 8.2e-60   NR XP_002179157.1 556484 g24716 i0 72.2 20.6553524804178 126 35 98.7 0 381 4 159 284 XP_002179157.1 nad-dependent epimerase/dehydratase [Phaeodactylum tricornutum CCAP 1055/1] diamond 7911 199 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26638444 26638444 PRJNA670521_P_NODE_6521_length_691_cov_6.493528_g5814_i0 PRJNA670521 6521 691 6.493528 44.87027848 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 109 1.69e-25   NR GFH49507.1 426638 g5814 i0 36.9 0.811866859623734 187 113 79.5 3 622 74 13 198 GFH49507.1 hypothetical protein CTEN210_05983 [Chaetoceros tenuissimus] diamond 561 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27366452 27366452 PRJNA670521_P_NODE_52923_length_289_cov_1.069444_g52178_i0 PRJNA670521 52923 289 1.069444 3.09069316 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 56.2 1.07e-6   NR GAX18056.1 1519565 g52178 i0 36.1 0.747404844290657 72 41 69.6 1 266 66 154 225 GAX18056.1 hypothetical protein FisN_25Hh030 [Fistulifera solaris] diamond 216 56.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27504660 27504660 PRJNA670521_P_NODE_46843_length_304_cov_1.181818_g46098_i0 PRJNA670521 46843 304 1.181818 3.59272672 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.25e-7   NR XP_002293792.1 296543 g46098 i0 50 2.25 76 36 75 1 2 229 146 219 XP_002293792.1 RS6, ribosomal protein 6 [Thalassiosira pseudonana CCMP1335] diamond 684 58.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28155703 28155703 PRJNA670521_P_NODE_29605_length_362_cov_1.325260_g28860_i0 PRJNA670521 29605 362 1.32526 4.7974412 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 57.8 7.65e-7   NR GAX21573.1 1519565 g28860 i0 29.3 2.77624309392265 116 74 96.1 1 361 14 478 585 GAX21573.1 hypothetical protein FisN_29Hh004 [Fistulifera solaris] diamond 1005 57.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28534617 28534617 PRJNA670521_P_NODE_18187_length_438_cov_2.161644_g17445_i0 PRJNA670521 18187 438 2.161644 9.46800072 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 92.4 6.1e-20   NR GFH49507.1 426638 g17445 i0 40.3 0.849315068493151 124 73 84.2 1 372 4 15 138 GFH49507.1 hypothetical protein CTEN210_05983 [Chaetoceros tenuissimus] diamond 372 92.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28735871 28735871 PRJNA670521_P_NODE_28187_length_369_cov_1.280405_g27442_i0 PRJNA670521 28187 369 1.280405 4.72469445 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 117 1.46e-27   NR KAG7344023.1 303405 g27442 i0 52.4 4.23577235772358 103 49 83.7 0 51 359 774 876 KAG7344023.1 ATP-dependent metalloprotease FtsH [Nitzschia inconspicua] diamond 1563 118 0.991525423728814 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28893563 28893563 PRJNA670521_P_NODE_57408_length_279_cov_1.000000_g56663_i0 PRJNA670521 57408 279 1 2.79 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 135 2.1e-34   NR CAJ1961015.1 2856 g56663 i0 64.5 2 93 33 100 0 1 279 790 882 CAJ1961015.1 unnamed protein product [Cylindrotheca closterium] diamond 558 135 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29304119 29304119 PRJNA670521_P_NODE_82229_length_246_cov_0.890173_g81484_i0 PRJNA670521 82229 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.4 9.11e-4   NR CAB9511898.1 568900 g81484 i0 39.5 2.97560975609756 81 43 92.7 4 231 4 223 302 CAB9511898.1 IBR domain [Seminavis robusta] diamond 732 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29367404 29367404 PRJNA670521_P_NODE_26249_length_379_cov_1.133987_g25505_i0 PRJNA670521 26249 379 1.133987 4.29781073 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 106 1.0399999999999997e-23   NR KAI2512639.1 210448 g25505 i0 45.5 4.83641160949868 123 67 97.4 0 378 10 1349 1471 KAI2512639.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 1833 106 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29430247 29430247 PRJNA670521_P_NODE_8769_length_602_cov_1.986767_g8039_i0 PRJNA670521 8769 602 1.986767 11.96033734 root 1 Root_unresolved Root_unresolved 104 6e-24   NR GFH49507.1 426638 g8039 i0 36.1 1.75913621262458 183 113 89.7 3 58 597 15 196 GFH49507.1 hypothetical protein CTEN210_05983 [Chaetoceros tenuissimus] diamond 1059 104 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30251811 30251811 PRJNA670521_P_NODE_24232_length_391_cov_0.896226_g23488_i0 PRJNA670521 24232 391 0.896226 3.50424366 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 150 1.02e-39   NR GFH57998.1 426638 g23488 i0 55 2.9846547314578 131 57 99.7 2 1 390 218 347 GFH57998.1 hypothetical protein CTEN210_14474 [Chaetoceros tenuissimus] diamond 1167 151 0.993377483443709 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30271552 30271552 PRJNA670521_P_NODE_59592_length_274_cov_0.930348_g58847_i0 PRJNA670521 59592 274 0.930348 2.54915352 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 48.5 4.77e-4   NR GFH49664.1 426638 g58847 i0 35.7 0.91970802919708 84 35 89.8 4 256 11 225 291 GFH49664.1 hypothetical protein CTEN210_06140 [Chaetoceros tenuissimus] diamond 252 48.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30303350 30303350 PRJNA670521_P_NODE_68772_length_254_cov_0.845304_g68027_i0 PRJNA670521 68772 254 0.84530400000000006 2.14707216 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.08e-9   NR GFH55521.1 426638 g68027 i0 72.5 0.47244094488189 40 11 47.2 0 2 121 334 373 GFH55521.1 TPR-like protein [Chaetoceros tenuissimus] diamond 120 62.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30650174 30650174 PRJNA670521_P_NODE_19913_length_422_cov_1.558739_g19170_i0 PRJNA670521 19913 422 1.558739 6.57787858 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 149 7.679999999999999e-40   NR GFH55967.1 426638 g19170 i0 47.5 1.99052132701422 139 72 98.1 1 416 3 69 207 GFH55967.1 hypothetical protein CTEN210_12443 [Chaetoceros tenuissimus] diamond 840 149 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30851914 30851914 PRJNA670521_P_NODE_67754_length_256_cov_1.262295_g67009_i0 PRJNA670521 67754 256 1.262295 3.2314752 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 120 7.789999999999999e-31   NR CAJ1937478.1 2856 g67009 i0 68.6 2.00390625 86 26 99.6 1 256 2 92 177 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 513 121 0.991735537190083 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31009901 31009901 PRJNA670521_P_NODE_50754_length_294_cov_1.190045_g50009_i0 PRJNA670521 50754 294 1.190045 3.4987323 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 114 1.0500000000000001e-30   NR KAL3807272.1 382380 g50009 i0 65 1.63265306122449 80 28 81.6 0 42 281 1 80 KAL3807272.1 hypothetical protein ACHAXA_004088 [Cyclostephanos tholiformis] diamond 480 115 0.991304347826087 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31313978 31313978 PRJNA670521_P_NODE_23175_length_397_cov_2.018519_g22432_i0 PRJNA670521 23175 397 2.018519 8.01352043 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 71.6 8.14e-12   NR KAL3765032.1 2934178 g22432 i0 47 0.6272040302267 83 33 54.4 4 6 221 43 125 KAL3765032.1 hypothetical protein ACHAW5_004291 [Stephanodiscus triporus] diamond 249 71.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
31314020 31314020 PRJNA670521_P_NODE_80955_length_246_cov_0.890173_g80210_i0 PRJNA670521 80955 246 0.890173 2.18982558 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 94.4 1.2e-20   NR KAI2503151.1 210448 g80210 i0 57.1 1.02439024390244 84 32 97.6 2 2 241 222 305 KAI2503151.1 Glucokinase [Fragilaria crotonensis] diamond 252 94.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31452682 31452682 PRJNA670521_P_NODE_57976_length_277_cov_1.754902_g57231_i0 PRJNA670521 57976 277 1.754902 4.86107854 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 120 1.91e-29   NR KAI2498295.1 210448 g57231 i0 65.9 4.92779783393502 91 31 98.6 0 3 275 759 849 KAI2498295.1 Cation transporter/ATPase [Fragilaria crotonensis] diamond 1365 120 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31725098 31725098 PRJNA670521_P_NODE_11997_length_521_cov_1.343750_g11262_i0 PRJNA670521 11997 521 1.34375 7.0009375 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 168 1.86e-48   NR CAB9514415.1 568900 g11262 i0 51.4 1.00767754318618 175 69 91.6 3 479 3 31 205 CAB9514415.1 P4Hc [Seminavis robusta] diamond 525 168 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31819954 31819954 PRJNA670521_P_NODE_12117_length_519_cov_1.340807_g11382_i0 PRJNA670521 12117 519 1.340807 6.95878833 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 95.1 2.71e-20   NR KAL3773369.1 2934178 g11382 i0 32.9 0.982658959537572 170 100 95.4 5 515 21 41 201 KAL3773369.1 hypothetical protein ACHAW5_006459 [Stephanodiscus triporus] diamond 510 95.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
32041624 32041624 PRJNA670521_P_NODE_65358_length_261_cov_1.250000_g64613_i0 PRJNA670521 65358 261 1.25 3.2625 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 47.4 5.75e-4   NR KAG7346879.1 303405 g64613 i0 87.5 0.551724137931034 24 3 27.6 0 1 72 139 162 KAG7346879.1 50S ribosomal protein L15 [Nitzschia inconspicua] diamond 144 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32085136 32085136 PRJNA670521_P_NODE_85558_length_244_cov_0.900585_g84813_i0 PRJNA670521 85558 244 0.900585 2.1974274 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.9 2.65e-10   NR KAL3822105.1 382380 g84813 i0 42.9 4.6844262295082 77 44 94.7 0 233 3 212 288 KAL3822105.1 hypothetical protein ACHAXA_011883 [Cyclostephanos tholiformis] diamond 1143 65.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32358247 32358247 PRJNA670521_P_NODE_16699_length_454_cov_4.787402_g15957_i0 PRJNA670521 16699 454 4.787402 21.73480508 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 189 7.870000000000001e-59   NR KAK1745333.1 267567 g15957 i0 65.7 1.77092511013216 134 46 88.5 0 435 34 1 134 KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi] diamond 804 189 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32389613 32389613 PRJNA670521_P_NODE_43919_length_312_cov_1.092050_g43174_i0 PRJNA670521 43919 312 1.09205 3.407196 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 126 5.289999999999999e-32   NR GFH51271.1 426638 g43174 i0 58.8 0.980769230769231 102 42 98.1 0 308 3 140 241 GFH51271.1 hypothetical protein CTEN210_07747 [Chaetoceros tenuissimus] diamond 306 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32453198 32453198 PRJNA670521_P_NODE_57499_length_278_cov_2.009756_g56754_i0 PRJNA670521 57499 278 2.009756 5.58712168 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.42e-9   NR GFH55193.1 426638 g56754 i0 55.8 1.73741007194245 52 22 55 1 181 29 51 102 GFH55193.1 TPR-like protein [Chaetoceros tenuissimus] diamond 483 64.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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