RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA857143" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 31 ✖

tax_clade 1

bioproject 1

  • PRJNA857143 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
1235339 1235339 PRJNA857143_S_NODE_6501_length_792_cov_3.147427_g5677_i0 PRJNA857143 6501 792 3.147427 24.92762184 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 106 3.51e-22   NR CAJ1953640.1 2856 g5677 i0 69.9 10.7272727272727 73 22 27.7 0 3 221 370 442 CAJ1953640.1 unnamed protein product [Cylindrotheca closterium] diamond 8496 107 0.990654205607477 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
5946389 5946389 PRJNA857143_S_NODE_132365_length_281_cov_1.500000_g131272_i0 PRJNA857143 132365 281 1.5 4.215 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.02e-16   NR CAJ1953336.1 2856 g131272 i0 55.4 4.50533807829181 83 37 88.6 0 26 274 235 317 CAJ1953336.1 unnamed protein product [Cylindrotheca closterium] diamond 1266 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
7222077 7222077 PRJNA857143_S_NODE_26806_length_482_cov_21.095355_g25714_i0 PRJNA857143 26806 482 21.095355 101.6796111 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 150 4.569999999999999e-42   NR KAL3772391.1 259834 g25714 i0 76.8 5.32157676348548 95 22 59.1 0 481 197 137 231 KAL3772391.1 hypothetical protein ACHAWU_005568 [Discostella pseudostelligera] diamond 2565 150 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
17422229 17422229 PRJNA857143_S_NODE_40234_length_424_cov_1.333333_g39142_i0 PRJNA857143 40234 424 1.333333 5.65333192 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 6.9e-26   NR XP_002185822.1 556484 g39142 i0 58.2 0.693396226415094 98 38 69.3 1 422 129 332 426 XP_002185822.1 glycosyl transferase, family 1 [Phaeodactylum tricornutum CCAP 1055/1] diamond 294 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19086803 19086803 PRJNA857143_S_NODE_122755_length_290_cov_1.078341_g121662_i0 PRJNA857143 122755 290 1.078341 3.1271889 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.13e-12   NR KAK1748276.1 267567 g121662 i0 50 0.724137931034483 70 35 72.4 0 285 76 41 110 KAK1748276.1 60S ribosomal protein L24 [Skeletonema marinoi] diamond 210 68.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26683272 26683272 PRJNA857143_S_NODE_66501_length_361_cov_1.298611_g65408_i0 PRJNA857143 66501 361 1.298611 4.68798571 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 5.04e-7   NR CAJ1945500.1 2856 g65408 i0 56.3 1.75346260387812 48 21 39.9 0 36 179 177 224 CAJ1945500.1 unnamed protein product [Cylindrotheca closterium] diamond 633 57.8 0.993079584775087 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26770218 26770218 PRJNA857143_S_NODE_113301_length_299_cov_1.331858_g112208_i0 PRJNA857143 113301 299 1.331858 3.98225542 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 86.7 2.9e-18   NR XP_002287211.1 296543 g112208 i0 45.7 1.88628762541806 94 43 94.3 2 11 292 148 233 XP_002287211.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 564 86.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27031548 27031548 PRJNA857143_S_NODE_89722_length_325_cov_4.019841_g88629_i0 PRJNA857143 89722 325 4.019841 13.06448325 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 109 1.08e-26   NR KAL3796718.1 29204 g88629 i0 75.8 16.4953846153846 62 15 57.2 0 2 187 200 261 KAL3796718.1 hypothetical protein HJC23_010018 [Cyclotella cryptica] diamond 5361 110 0.990909090909091 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27181322 27181322 PRJNA857143_S_NODE_187842_length_245_cov_0.906977_g186749_i0 PRJNA857143 187842 245 0.906977 2.22209365 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 53.9 2.63e-6   NR KAL3792195.1 2934178 g186749 i0 43.9 1.57959183673469 66 34 77.1 1 3 191 155 220 KAL3792195.1 hypothetical protein ACHAW5_004070 [Stephanodiscus triporus] diamond 387 53.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
27308118 27308118 PRJNA857143_S_NODE_52303_length_390_cov_3.435331_g51210_i0 PRJNA857143 52303 390 3.435331 13.3977909 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.48e-9   NR EJK44235.1 159749 g51210 i0 76.9 0.3 39 9 30 0 386 270 36 74 EJK44235.1 hypothetical protein THAOC_37244, partial [Thalassiosira oceanica] diamond 117 61.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27750287 27750287 PRJNA857143_S_NODE_183784_length_247_cov_0.879310_g182691_i0 PRJNA857143 183784 247 0.87931 2.1718957 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00324   NR GAX14233.1 1519565 g182691 i0 32.9 0.923076923076923 76 47 92.3 2 229 2 594 665 GAX14233.1 heat shock 70kDa protein 5 [Fistulifera solaris] diamond 228 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27781731 27781731 PRJNA857143_S_NODE_120324_length_292_cov_1.424658_g119231_i0 PRJNA857143 120324 292 1.424658 4.16000136 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.9e-14   NR KAL3756043.1 259834 g119231 i0 41.8 0.811643835616438 79 46 81.2 0 2 238 61 139 KAL3756043.1 hypothetical protein ACHAWU_002622 [Discostella pseudostelligera] diamond 237 74.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28318341 28318341 PRJNA857143_S_NODE_116206_length_296_cov_1.399103_g115113_i0 PRJNA857143 116206 296 1.399103 4.14134488 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.31e-4   NR VEU43864.1 183589 g115113 i0 53.5 0.871621621621622 43 20 43.6 0 290 162 97 139 VEU43864.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 258 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28381520 28381520 PRJNA857143_S_NODE_69566_length_355_cov_3.039007_g68473_i0 PRJNA857143 69566 355 3.039007 10.78847485 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 92.8 3.82e-19   NR EJK67362.1 159749 g68473 i0 57.7 2.00281690140845 78 33 65.9 0 355 122 602 679 EJK67362.1 hypothetical protein THAOC_11616 [Thalassiosira oceanica] diamond 711 92.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28665803 28665803 PRJNA857143_S_NODE_147107_length_269_cov_1.193878_g146014_i0 PRJNA857143 147107 269 1.193878 3.21153182 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.74e-4   NR KAI2504666.1 210448 g146014 i0 38.5 1.07063197026022 52 32 58 0 3 158 301 352 KAI2504666.1 casein kinase II subunit beta [Fragilaria crotonensis] diamond 288 49.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28791796 28791796 PRJNA857143_S_NODE_159127_length_260_cov_1.122995_g158034_i0 PRJNA857143 159127 260 1.122995 2.919787 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 50.4 8.78e-5   NR GFH49429.1 426638 g158034 i0 41.7 0.692307692307692 60 35 69.2 0 220 41 494 553 GFH49429.1 hypothetical protein CTEN210_05905 [Chaetoceros tenuissimus] diamond 180 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28823282 28823282 PRJNA857143_S_NODE_161028_length_258_cov_1.902703_g159935_i0 PRJNA857143 161028 258 1.902703 4.90897374 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.77e-7   NR CAB9517197.1 568900 g159935 i0 38.6 0.965116279069767 83 44 96.5 1 249 1 460 535 CAB9517197.1 Retinal-specific ATP-binding cassette transporter [Seminavis robusta] diamond 249 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29147850 29147850 PRJNA857143_S_NODE_150049_length_266_cov_3.212435_g148956_i0 PRJNA857143 150049 266 3.212435 8.5450771 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.82e-9   NR CAB9507749.1 568900 g148956 i0 50.9 4.43233082706767 57 28 64.3 0 3 173 455 511 CAB9507749.1 Phosphatidate cytidylyltransferase 2 [Seminavis robusta] diamond 1179 62.8 0.993630573248408 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29431408 29431408 PRJNA857143_S_NODE_41309_length_420_cov_3.815562_g40216_i0 PRJNA857143 41309 420 3.815562 16.0253604 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 63.9 9.87e-9   NR KAG7363991.1 303405 g40216 i0 43.5 1.27857142857143 62 35 44.3 0 338 153 592 653 KAG7363991.1 villin headpiece domain containing protein [Nitzschia inconspicua] diamond 537 64.3 0.993779160186625 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29897213 29897213 PRJNA857143_S_NODE_100331_length_313_cov_1.050000_g99238_i0 PRJNA857143 100331 313 1.05 3.2865 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0176   NR CAB9503140.1 568900 g99238 i0 48.4 0.297124600638978 31 16 29.7 0 9 101 120 150 CAB9503140.1 Polyubiquitin (Fragment) [Seminavis robusta] diamond 93 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30308322 30308322 PRJNA857143_S_NODE_147632_length_268_cov_2.615385_g146539_i0 PRJNA857143 147632 268 2.615385 7.0092318 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.31e-4   NR KAG7372038.1 303405 g146539 i0 32.9 1.76865671641791 79 50 85.1 2 266 39 806 884 KAG7372038.1 adaptin N terminal region-domain containing protein [Nitzschia inconspicua] diamond 474 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30403066 30403066 PRJNA857143_S_NODE_192173_length_243_cov_1.023529_g191080_i0 PRJNA857143 192173 243 1.023529 2.48717547 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.18e-8   NR KAI2490498.1 210448 g191080 i0 34.8 4.51851851851852 69 45 85.2 0 229 23 520 588 KAI2490498.1 sulfite exporter TauE/SafE [Fragilaria crotonensis] diamond 1098 58.9 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30497516 30497516 PRJNA857143_S_NODE_46053_length_406_cov_5.273273_g44960_i0 PRJNA857143 46053 406 5.273273 21.40948838 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 50.4 3.81e-4   NR KAL3938366.1 3061772 g44960 i0 45.5 0.916256157635468 66 35 48 1 396 202 257 322 KAL3938366.1 MAG: hypothetical protein SGBAC_006716 [Bacillariaceae sp.] diamond 372 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30592102 30592102 PRJNA857143_S_NODE_159113_length_260_cov_1.139037_g158020_i0 PRJNA857143 159113 260 1.139037 2.9614962 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 66.2 2.38e-10   NR VEU40910.1 183589 g158020 i0 60.4 0.553846153846154 48 19 55.4 0 252 109 473 520 VEU40910.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 144 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31128963 31128963 PRJNA857143_S_NODE_161255_length_258_cov_1.659459_g160162_i0 PRJNA857143 161255 258 1.659459 4.28140422 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.83e-5   NR CAB9522936.1 568900 g160162 i0 38.4 0.848837209302326 73 45 84.9 0 256 38 984 1056 CAB9522936.1 Transcription initiation factor TFIID subunit 1 [Seminavis robusta] diamond 219 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31295512 31295512 PRJNA857143_S_NODE_145455_length_270_cov_1.583756_g144362_i0 PRJNA857143 145455 270 1.583756 4.2761412 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 71.6 3.54e-12   NR KAG7345918.1 303405 g144362 i0 46.7 3.34444444444444 75 34 80 2 6 221 629 700 KAG7345918.1 cupin-like domain containing protein [Nitzschia inconspicua] diamond 903 72 0.994444444444444 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31761799 31761799 PRJNA857143_S_NODE_41697_length_419_cov_2.326590_g40604_i0 PRJNA857143 41697 419 2.32659 9.7484121 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 81.3 3.79e-16   NR KAG7346278.1 303405 g40604 i0 50.5 2.11933174224344 99 47 69.5 1 419 129 78 176 KAG7346278.1 ribosomal protein L6e [Nitzschia inconspicua] diamond 888 81.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31824902 31824902 PRJNA857143_S_NODE_105617_length_307_cov_1.333333_g104524_i0 PRJNA857143 105617 307 1.333333 4.09333231 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0405   NR KAL3806078.1 382380 g104524 i0 30.9 1.8957654723127 97 58 88.9 4 299 27 393 486 KAL3806078.1 hypothetical protein ACHAXA_008526 [Cyclostephanos tholiformis] diamond 582 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31983184 31983184 PRJNA857143_S_NODE_64778_length_364_cov_2.079038_g63685_i0 PRJNA857143 64778 364 2.079038 7.56769832 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.47e-12   NR EJK65292.1 159749 g63685 i0 55.9 0.486263736263736 59 26 48.6 0 2 178 77 135 EJK65292.1 hypothetical protein THAOC_13865 [Thalassiosira oceanica] diamond 177 70.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32014912 32014912 PRJNA857143_S_NODE_133498_length_280_cov_1.507246_g132405_i0 PRJNA857143 133498 280 1.507246 4.2202888 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 48.1 6.24e-4   NR EJK57610.1 159749 g132405 i0 34.2 0.782142857142857 73 46 77.1 2 276 61 189 260 EJK57610.1 hypothetical protein THAOC_22329 [Thalassiosira oceanica] diamond 219 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32553108 32553108 PRJNA857143_S_NODE_139719_length_275_cov_1.158416_g138626_i0 PRJNA857143 139719 275 1.158416 3.185644 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 89.4 4.9900000000000006e-21   NR KAK1743969.1 267567 g138626 i0 62.3 0.752727272727273 69 26 75.3 0 218 12 20 88 KAK1743969.1 60S ribosomal protein L38 [Skeletonema marinoi] diamond 207 89.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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