RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA983838" 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

bioproject 1

  • PRJNA983838 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
12444157 12444157 PRJNA983838_P_NODE_18650_length_986_cov_14.371303_g16725_i0 PRJNA983838 18650 986 14.371303 141.70104758 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 2.1599999999999998e-118   NR XP_002181180.1 556484 g16725 i0 79.2 6.11257606490872 212 44 64.5 0 954 319 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6027 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13718725 13718725 PRJNA983838_P_NODE_33931_length_599_cov_3.686312_g31587_i0 PRJNA983838 33931 599 3.686312 22.08100888 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 113 6.57e-26   NR XP_002291609.1 296543 g31587 i0 74.4 1.40233722871452 117 29 58.1 1 559 212 260 376 XP_002291609.1 calreticulin-like protein, partial [Thalassiosira pseudonana CCMP1335] diamond 840 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
16267730 16267730 PRJNA983838_P_NODE_117533_length_243_cov_0.917647_g115166_i0 PRJNA983838 117533 243 0.917647 2.22988221 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 162 2.840000000000001e-44   NR KAL3788256.1 29204 g115166 i0 93.8 27 81 5 100 0 1 243 89 169 KAL3788256.1 hypothetical protein HJC23_011888 [Cyclotella cryptica] diamond 6561 163 0.993865030674847 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
17543806 17543806 PRJNA983838_P_NODE_89334_length_279_cov_1.577670_g86967_i0 PRJNA983838 89334 279 1.57767 4.4016993 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 163 2.07e-44   NR KAI2501209.1 210448 g86967 i0 81.7 14 93 17 100 0 279 1 609 701 KAI2501209.1 Threonyl and Alanyl tRNA synthetase second additional domain [Fragilaria crotonensis] diamond 3906 163 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26614609 26614609 PRJNA983838_P_NODE_106061_length_252_cov_0.871508_g103694_i0 PRJNA983838 106061 252 0.871508 2.19620016 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00363   NR KAL3789563.1 382360 g103694 i0 33.3 0.821428571428571 69 45 82.1 1 252 46 1758 1825 KAL3789563.1 hypothetical protein ACHAWO_009126 [Cyclotella atomus] diamond 207 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27000489 27000489 PRJNA983838_P_NODE_90422_length_277_cov_1.529412_g88055_i0 PRJNA983838 90422 277 1.529412 4.23647124 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 78.6 9.65e-15   NR KAL3770485.1 259834 g88055 i0 42.9 4.93862815884477 91 49 96.4 2 268 2 266 355 KAL3770485.1 hypothetical protein ACHAWU_009324 [Discostella pseudostelligera] diamond 1368 79 0.994936708860759 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27026305 27026305 PRJNA983838_P_NODE_26902_length_731_cov_3.870821_g24635_i0 PRJNA983838 26902 731 3.870821 28.29570151 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 159 1.05e-44   NR KAI2494838.1 210448 g24635 i0 48 0.820793433652531 200 102 81.7 2 680 84 10 208 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 600 159 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27032225 27032225 PRJNA983838_P_NODE_116042_length_244_cov_0.912281_g113675_i0 PRJNA983838 116042 244 0.912281 2.22596564 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 92.8 5.5e-20   NR CAJ1966835.1 2856 g113675 i0 53.8 2.91393442622951 80 32 98.4 1 5 244 89 163 CAJ1966835.1 unnamed protein product [Cylindrotheca closterium] diamond 711 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27063918 27063918 PRJNA983838_P_NODE_111722_length_247_cov_1.494253_g109355_i0 PRJNA983838 111722 247 1.494253 3.69080491 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.76e-6   NR GFH46767.1 426638 g109355 i0 38 3.40080971659919 79 40 89.9 3 245 24 1500 1574 GFH46767.1 E1A/CREB-binding protein [Chaetoceros tenuissimus] diamond 840 55.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27215775 27215775 PRJNA983838_P_NODE_118762_length_242_cov_0.923077_g116395_i0 PRJNA983838 118762 242 0.923077 2.23384634 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 94 8.75e-22   NR OEU21790.1 635003 g116395 i0 53.5 3.02479338842975 86 34 99.2 1 3 242 25 110 OEU21790.1 NAD(P)-binding protein [Fragilariopsis cylindrus CCMP1102] diamond 732 94 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27279286 27279286 PRJNA983838_P_NODE_113743_length_246_cov_0.901734_g111376_i0 PRJNA983838 113743 246 0.901734 2.21826564 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 132 6.36e-35   NR KAI2492552.1 210448 g111376 i0 76.5 1.96341463414634 81 18 97.6 1 5 244 323 403 KAI2492552.1 C1 peptidase-like protein [Fragilaria crotonensis] diamond 483 132 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27721800 27721800 PRJNA983838_P_NODE_108564_length_250_cov_0.881356_g106197_i0 PRJNA983838 108564 250 0.881356 2.20339 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.67e-21   NR OEU20080.1 635003 g106197 i0 67.7 1.488 62 20 74.4 0 63 248 352 413 OEU20080.1 hypothetical protein FRACYDRAFT_274669 [Fragilariopsis cylindrus CCMP1102] diamond 372 97.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27727686 27727686 PRJNA983838_P_NODE_121724_length_232_cov_2.943396_g119357_i0 PRJNA983838 121724 232 2.943396 6.82867872 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.21e-7   NR CAJ1940262.1 2856 g119357 i0 78.1 0.827586206896552 32 7 41.4 0 229 134 464 495 CAJ1940262.1 unnamed protein product [Cylindrotheca closterium] diamond 192 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28100090 28100090 PRJNA983838_P_NODE_96245_length_266_cov_1.761658_g93878_i0 PRJNA983838 96245 266 1.761658 4.68601028 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.51e-8   NR GKY94273.1 2872254 g93878 i0 40 1.34210526315789 55 33 62 0 257 93 634 688 GKY94273.1 hypothetical protein MPSEU_000393100 [Mayamaea pseudoterrestris] diamond 357 61.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28416097 28416097 PRJNA983838_P_NODE_105246_length_252_cov_1.743017_g102879_i0 PRJNA983838 105246 252 1.743017 4.39240284 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.1 2.9e-8   NR GKY95999.1 2872254 g102879 i0 38.8 0.797619047619048 67 40 78.6 1 200 3 87 153 GKY95999.1 Non-histone chromosomal protein 6 [Mayamaea pseudoterrestris] diamond 201 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28479143 28479143 PRJNA983838_P_NODE_106926_length_251_cov_0.876404_g104559_i0 PRJNA983838 106926 251 0.876404 2.19977404 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 52 1.85e-5   NR KAI2490089.1 210448 g104559 i0 60 1.25498007968127 35 14 41.8 0 113 9 188 222 KAI2490089.1 hypothetical protein MHU86_24485 [Fragilaria crotonensis] diamond 315 52 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28668695 28668695 PRJNA983838_P_NODE_104627_length_253_cov_0.866667_g102260_i0 PRJNA983838 104627 253 0.866667 2.19266751 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0165   NR VEU37688.1 183589 g102260 i0 43.1 0.604743083003953 51 29 60.5 0 250 98 510 560 VEU37688.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 153 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29116752 29116752 PRJNA983838_P_NODE_119008_length_242_cov_0.923077_g116641_i0 PRJNA983838 119008 242 0.923077 2.23384634 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 110 1.24e-26   NR KAL3762875.1 259834 g116641 i0 68.1 5.18181818181818 69 22 85.5 0 241 35 286 354 KAL3762875.1 hypothetical protein ACHAWU_001022 [Discostella pseudostelligera] diamond 1254 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29242938 29242938 PRJNA983838_P_NODE_85009_length_288_cov_1.376744_g82642_i0 PRJNA983838 85009 288 1.376744 3.96502272 root 1 Root_unresolved Root_unresolved 94 4.7400000000000006e-21   NR CAJ1954332.1 2856 g82642 i0 54.2 5.04166666666667 96 42 99 2 287 3 56 150 CAJ1954332.1 unnamed protein product [Cylindrotheca closterium] diamond 1452 94.7 0.992608236536431 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29805165 29805165 PRJNA983838_P_NODE_62951_length_358_cov_2.652632_g60584_i0 PRJNA983838 62951 358 2.652632 9.49642256 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.58e-9   NR KAL3794117.1 2934178 g60584 i0 38.8 0.863128491620112 103 60 86.3 2 1 309 1349 1448 KAL3794117.1 hypothetical protein ACHAW5_008753 [Stephanodiscus triporus] diamond 309 65.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
29836737 29836737 PRJNA983838_P_NODE_98431_length_262_cov_2.232804_g96064_i0 PRJNA983838 98431 262 2.232804 5.84994648 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 99 2.7899999999999998e-24   NR GAX27651.1 1519565 g96064 i0 73.7 1.27099236641221 57 15 65.3 0 91 261 2 58 GAX27651.1 hypothetical protein FisN_13Hh257 [Fistulifera solaris] diamond 333 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29969127 29969127 PRJNA983838_P_NODE_86891_length_284_cov_1.478673_g84524_i0 PRJNA983838 86891 284 1.478673 4.19943132 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 117 3.55e-28   NR GFH48303.1 426638 g84524 i0 70.9 5.15492957746479 86 25 90.8 0 2 259 814 899 GFH48303.1 P2B, P type ATPase [Chaetoceros tenuissimus] diamond 1464 118 0.991525423728814 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30158460 30158460 PRJNA983838_P_NODE_81972_length_295_cov_1.405405_g79605_i0 PRJNA983838 81972 295 1.405405 4.14594475 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 118 1.36e-28   NR KAI2513004.1 210448 g79605 i0 54.5 5.03389830508475 99 44 99.7 1 294 1 336 434 KAI2513004.1 exonuclease [Fragilaria crotonensis] diamond 1485 119 0.991596638655462 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30759124 30759124 PRJNA983838_P_NODE_29694_length_673_cov_1.636667_g27381_i0 PRJNA983838 29694 673 1.636667 11.01476891 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 237 1.71e-72   NR VEU40543.1 183589 g27381 i0 59.9 4.19910846953938 192 69 85.6 1 656 81 262 445 VEU40543.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 2826 237 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31416780 31416780 PRJNA983838_P_NODE_108076_length_250_cov_0.881356_g105709_i0 PRJNA983838 108076 250 0.881356 2.20339 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.85e-6   NR CAB9507293.1 568900 g105709 i0 52.7 0.66 55 26 66 0 7 171 340 394 CAB9507293.1 70 kDa protein [Seminavis robusta] diamond 165 55.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31802131 31802131 PRJNA983838_P_NODE_77537_length_307_cov_1.333333_g75170_i0 PRJNA983838 77537 307 1.333333 4.09333231 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 150 1.17e-41   NR KAL3760801.1 259834 g75170 i0 66.7 6.77198697068404 99 33 96.7 0 2 298 176 274 KAL3760801.1 hypothetical protein ACHAWU_007867 [Discostella pseudostelligera] diamond 2079 150 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31928812 31928812 PRJNA983838_P_NODE_61297_length_365_cov_3.541096_g58930_i0 PRJNA983838 61297 365 3.541096 12.9250004 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 160 2.48e-45   NR KAL3767548.1 259834 g58930 i0 64.2 2.93424657534247 120 43 98.6 0 3 362 233 352 KAL3767548.1 hypothetical protein ACHAWU_000211 [Discostella pseudostelligera] diamond 1071 160 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32176207 32176207 PRJNA983838_P_NODE_84078_length_290_cov_1.437788_g81711_i0 PRJNA983838 84078 290 1.437788 4.1695852 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 49.3 3.06e-4   NR KAG7365466.1 303405 g81711 i0 64.5 0.641379310344828 31 11 32.1 0 289 197 170 200 KAG7365466.1 DUF1336 domain containing protein [Nitzschia inconspicua] diamond 186 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32555983 32555983 PRJNA983838_P_NODE_110399_length_248_cov_1.554286_g108032_i0 PRJNA983838 110399 248 1.554286 3.85462928 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 147 4.479999999999999e-40   NR KAK1744640.1 267567 g108032 i0 81.5 8.79435483870968 81 15 98 0 246 4 340 420 KAK1744640.1 methionine aminopeptidase 2 [Skeletonema marinoi] diamond 2181 147 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32555984 32555984 PRJNA983838_P_NODE_113119_length_246_cov_1.294798_g110752_i0 PRJNA983838 113119 246 1.294798 3.18520308 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.54e-7   NR CAB9520060.1 568900 g110752 i0 59.5 0.451219512195122 37 15 45.1 0 155 45 3 39 CAB9520060.1 domain protein [Seminavis robusta] diamond 111 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32555991 32555991 PRJNA983838_P_NODE_84599_length_289_cov_1.194444_g82232_i0 PRJNA983838 84599 289 1.194444 3.45194316 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 56.6 8.82e-7   NR KAL3939102.1 3061772 g82232 i0 50 0.581314878892734 56 28 58.1 0 183 16 1025 1080 KAL3939102.1 MAG: hypothetical protein SGBAC_006105 [Bacillariaceae sp.] diamond 168 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32649855 32649855 PRJNA983838_P_NODE_105520_length_252_cov_0.871508_g103153_i0 PRJNA983838 105520 252 0.871508 2.19620016 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 105 3.53e-24   NR KAL3922278.1 3061772 g103153 i0 59 1.97619047619048 83 34 98.8 0 3 251 795 877 KAL3922278.1 MAG: hypothetical protein SGILL_002291 [Bacillariaceae sp.] diamond 498 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.

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