RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1215813" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 25 ✖

tax_clade 1

bioproject 1

  • PRJNA1215813 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
2882701 2882701 PRJNA1215813_P_NODE_483_length_965_cov_4.809417_g433_i0 PRJNA1215813 483 965 4.809417 46.41087405 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 1.1799999999999996e-118   NR XP_002181180.1 556484 g433 i0 79.2 6.25492227979275 212 44 65.9 0 930 295 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6036 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5435023 5435023 PRJNA1215813_P_NODE_505_length_940_cov_2.159170_g455_i0 PRJNA1215813 505 940 2.15917 20.296198 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 486 2.529999999999999e-168   NR KAI2494262.1 210448 g455 i0 77.4 29.5978723404255 310 69 98.6 1 14 940 26 335 KAI2494262.1 hypothetical protein MHU86_20280 [Fragilaria crotonensis] diamond 27822 487 0.997946611909651 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
5435067 5435067 PRJNA1215813_P_NODE_7365_length_289_cov_1.083333_g7285_i0 PRJNA1215813 7365 289 1.083333 3.13083237 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 139 9.49e-36   NR GFH50881.1 426638 g7285 i0 67 3.90311418685121 94 31 97.6 0 287 6 547 640 GFH50881.1 ATP-binding cassette, subfamily F, member 2 [Chaetoceros tenuissimus] diamond 1128 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
22008470 22008470 PRJNA1215813_P_NODE_5278_length_336_cov_2.403042_g5198_i0 PRJNA1215813 5278 336 2.403042 8.07422112 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 111 3.55e-29   NR EJK75259.1 159749 g5198 i0 65.8 0.705357142857143 79 27 70.5 0 97 333 9 87 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 237 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27135481 27135481 PRJNA1215813_P_NODE_7982_length_278_cov_1.141463_g7902_i0 PRJNA1215813 7982 278 1.141463 3.17326714 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 106 9.28e-25   NR XP_002286538.1 296543 g7902 i0 56.5 0.992805755395683 92 39 99.3 1 1 276 205 295 XP_002286538.1 hypothetical protein THAPSDRAFT_31021, partial [Thalassiosira pseudonana CCMP1335] diamond 276 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27786629 27786629 PRJNA1215813_P_NODE_7784_length_281_cov_2.086538_g7704_i0 PRJNA1215813 7784 281 2.086538 5.86317178 root 1 Root_unresolved Root_unresolved 104 5.63e-24   NR EJK76215.1 159749 g7704 i0 73.2 3.80071174377224 71 19 75.8 0 213 1 127 197 EJK76215.1 hypothetical protein THAOC_02038 [Thalassiosira oceanica] diamond 1068 105 0.990476190476191 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27830766 27830766 PRJNA1215813_P_NODE_5364_length_334_cov_1.333333_g5284_i0 PRJNA1215813 5364 334 1.333333 4.45333222 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.03e-18   NR KAL3808413.1 382380 g5284 i0 65.7 1.19461077844311 67 23 60.2 0 2 202 643 709 KAL3808413.1 hypothetical protein ACHAXA_001350 [Cyclostephanos tholiformis] diamond 399 91.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
27944378 27944378 PRJNA1215813_P_NODE_5885_length_321_cov_1.245968_g5805_i0 PRJNA1215813 5885 321 1.245968 3.99955728 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 134 5.92e-34   NR GFH61932.1 426638 g5805 i0 57.7 5.85981308411215 104 44 97.2 0 9 320 428 531 GFH61932.1 hypothetical protein CTEN210_18408 [Chaetoceros tenuissimus] diamond 1881 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28165377 28165377 PRJNA1215813_P_NODE_5285_length_336_cov_1.779468_g5205_i0 PRJNA1215813 5285 336 1.779468 5.97901248 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 129 1.2199999999999999e-32   NR EJK73605.1 159749 g5205 i0 76.3 8.58928571428571 80 19 71.4 0 333 94 443 522 EJK73605.1 hypothetical protein THAOC_04758 [Thalassiosira oceanica] diamond 2886 130 0.992307692307692 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28177874 28177874 PRJNA1215813_P_NODE_3066_length_432_cov_1.415042_g2986_i0 PRJNA1215813 3066 432 1.415042 6.11298144 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 174 7.07e-48   NR KAL3807144.1 382380 g2986 i0 62.5 11 144 52 100 2 432 1 517 658 KAL3807144.1 hypothetical protein ACHAXA_011768 [Cyclostephanos tholiformis] diamond 4752 174 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28228243 28228243 PRJNA1215813_P_NODE_9806_length_251_cov_1.752809_g9726_i0 PRJNA1215813 9806 251 1.752809 4.39955059 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 102 2.02e-25   NR KAI2491899.1 210448 g9726 i0 55.4 2.96414342629482 83 37 99.2 0 249 1 47 129 KAI2491899.1 ATP synthase [Fragilaria crotonensis] diamond 744 103 0.990291262135922 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29251429 29251429 PRJNA1215813_P_NODE_4309_length_369_cov_0.939189_g4229_i0 PRJNA1215813 4309 369 0.939189 3.46560741 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 148 4.43e-39   NR KAI2498924.1 210448 g4229 i0 67.6 1.86991869918699 111 31 90.2 1 336 4 10 115 KAI2498924.1 chaperonin-like protein [Fragilaria crotonensis] diamond 690 148 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29598674 29598674 PRJNA1215813_P_NODE_6610_length_304_cov_2.025974_g6530_i0 PRJNA1215813 6610 304 2.025974 6.15896096 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00338   NR KAL3776125.1 29204 g6530 i0 29.3 0.976973684210526 99 70 97.7 0 300 4 348 446 KAL3776125.1 hypothetical protein HJC23_011447, partial [Cyclotella cryptica] diamond 297 46.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29661654 29661654 PRJNA1215813_P_NODE_4830_length_349_cov_1.978261_g4750_i0 PRJNA1215813 4830 349 1.978261 6.90413089 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 130 2.1e-32   NR GFH55025.1 426638 g4750 i0 56.9 0.936962750716332 109 47 93.7 0 3 329 771 879 GFH55025.1 aminopeptidase with a membrane alanine aminopeptidase domain [Chaetoceros tenuissimus] diamond 327 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29712102 29712102 PRJNA1215813_P_NODE_1970_length_530_cov_1.787746_g1890_i0 PRJNA1215813 1970 530 1.787746 9.4750538 root 1 Root_unresolved Root_unresolved 136 1.06e-33   NR CAB9510700.1 568900 g1890 i0 45.4 2.94905660377359 174 89 97.9 2 523 5 466 634 CAB9510700.1 Sensor protein FixL [Seminavis robusta] diamond 1563 136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29819748 29819748 PRJNA1215813_P_NODE_6131_length_315_cov_1.719008_g6051_i0 PRJNA1215813 6131 315 1.719008 5.4148752 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 105 1.64e-25   NR CAB9514219.1 568900 g6051 i0 56.7 2.25714285714286 97 38 92.4 1 24 314 26 118 CAB9514219.1 NADH-quinone oxidoreductase subunit I [Seminavis robusta] diamond 711 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30565071 30565071 PRJNA1215813_P_NODE_10073_length_250_cov_1.638418_g9993_i0 PRJNA1215813 10073 250 1.638418 4.096045 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 105 3.33e-24   NR KAL3768840.1 259834 g9993 i0 63 2.916 81 30 97.2 0 3 245 889 969 KAL3768840.1 hypothetical protein ACHAWU_006941 [Discostella pseudostelligera] diamond 729 105 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31336516 31336516 PRJNA1215813_P_NODE_12236_length_243_cov_0.917647_g12156_i0 PRJNA1215813 12236 243 0.917647 2.22988221 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 90.9 4.16e-19   NR KAL3914154.1 3061772 g12156 i0 56.4 2.91358024691358 78 34 96.3 0 9 242 276 353 KAL3914154.1 MAG: hypothetical protein SGILL_006212 [Bacillariaceae sp.] diamond 708 90.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31684413 31684413 PRJNA1215813_P_NODE_7397_length_288_cov_1.451163_g7317_i0 PRJNA1215813 7397 288 1.451163 4.17934944 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 60.8 4.8e-9   NR KAL3925771.1 3061772 g7317 i0 48.8 2.51041666666667 82 34 77.1 3 288 67 79 160 KAL3925771.1 MAG: hypothetical protein SGILL_000189 [Bacillariaceae sp.] diamond 723 60.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31861368 31861368 PRJNA1215813_P_NODE_11657_length_245_cov_0.906977_g11577_i0 PRJNA1215813 11657 245 0.906977 2.22209365 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0287   NR KAL3808115.1 382380 g11577 i0 46.4 1.38367346938776 56 29 68.6 1 184 17 1304 1358 KAL3808115.1 hypothetical protein ACHAXA_001021 [Cyclostephanos tholiformis] diamond 339 43.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32190868 32190868 PRJNA1215813_P_NODE_11758_length_245_cov_0.906977_g11678_i0 PRJNA1215813 11758 245 0.906977 2.22209365 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0285   NR KAL3756767.1 259834 g11678 i0 51.2 0.502040816326531 41 19 49 1 124 5 883 923 KAL3756767.1 hypothetical protein ACHAWU_003517 [Discostella pseudostelligera] diamond 123 43.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32190875 32190875 PRJNA1215813_P_NODE_7278_length_290_cov_1.437788_g7198_i0 PRJNA1215813 7278 290 1.437788 4.1695852 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 50.8 9.03e-5   NR KAL3781886.1 382360 g7198 i0 31.9 0.972413793103448 94 59 93.1 2 278 9 347 439 KAL3781886.1 hypothetical protein ACHAWO_010048 [Cyclotella atomus] diamond 282 50.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32209641 32209641 PRJNA1215813_P_NODE_498_length_946_cov_1.549828_g448_i0 PRJNA1215813 498 946 1.549828 14.66137288 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 254 3.47e-77   NR KAL3790860.1 29204 g448 i0 44.1 3.66596194503171 290 142 86.9 5 5 826 224 509 KAL3790860.1 hypothetical protein HJC23_004490 [Cyclotella cryptica] diamond 3468 254 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32633163 32633163 PRJNA1215813_P_NODE_4700_length_354_cov_1.056940_g4620_i0 PRJNA1215813 4700 354 1.05694 3.7415676 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 74.7 8.22e-13   NR CAB9510324.1 568900 g4620 i0 37.7 1.8728813559322 114 68 94.1 3 3 335 688 801 CAB9510324.1 Phospholipid:diacylglycerol acyltransferase [Seminavis robusta] diamond 663 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32903933 32903933 PRJNA1215813_P_NODE_9720_length_252_cov_0.871508_g9640_i0 PRJNA1215813 9720 252 0.871508 2.19620016 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 7.03e-25   NR VEU34236.1 183589 g9640 i0 67.6 30.0119047619048 74 23 86.9 1 223 5 272 345 VEU34236.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 7563 107 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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