RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 27 ✖

tax_clade 1

bioproject 1

  • PRJNA641991 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
18470002 18470002 PRJNA641991_P_NODE_3835_length_164_cov_0.886957_g3794_i0 PRJNA641991 3835 164 0.886957 1.45460948 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 84.7 2.13e-19   NR YP_005090341.1 2850 g3794 i0 82.4 1.88414634146341 51 9 93.3 0 11 163 12 62 YP_005090341.1 ribosomal protein S12 [Phaeodactylum tricornutum] diamond 309 84.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26669462 26669462 PRJNA641991_S_NODE_9601_length_183_cov_1.194030_g9482_i0 PRJNA641991 9601 183 1.19403 2.1850749 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.37e-9   NR GKY92502.1 2872254 g9482 i0 77.8 0.590163934426229 36 8 59 0 1 108 326 361 GKY92502.1 hypothetical protein MPSEU_000220600 [Mayamaea pseudoterrestris] diamond 108 62.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26701243 26701243 PRJNA641991_S_NODE_7341_length_204_cov_1.619355_g7222_i0 PRJNA641991 7341 204 1.619355 3.3034842 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 63.9 2.63e-11   NR GAX19143.1 1519565 g7222 i0 73.3 1.32352941176471 45 12 66.2 0 182 48 53 97 GAX19143.1 hypothetical protein FisN_3Lh085 [Fistulifera solaris] diamond 270 63.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
26923087 26923087 PRJNA641991_P_NODE_3662_length_165_cov_0.879310_g3621_i0 PRJNA641991 3662 165 0.87931 1.4508615 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 55.8 7e-8   NR CAB9514777.1 568900 g3621 i0 50 2.94545454545455 54 22 98.2 1 165 4 86 134 CAB9514777.1 expressed unknown protein [Seminavis robusta] diamond 486 55.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
26935299 26935299 PRJNA641991_P_NODE_4022_length_162_cov_0.902655_g3981_i0 PRJNA641991 4022 162 0.902655 1.4623011 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.33e-19   NR KAG7345624.1 303405 g3981 i0 76.9 5.75925925925926 52 11 96.3 1 5 160 380 430 KAG7345624.1 OTU-like cysteine protease [Nitzschia inconspicua] diamond 933 91.3 0.995618838992333 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27535990 27535990 PRJNA641991_S_NODE_12043_length_167_cov_0.864407_g11924_i0 PRJNA641991 12043 167 0.864407 1.44355969 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0183   NR XP_002183391.1 556484 g11924 i0 52.5 1.65269461077844 40 11 71.9 1 47 166 322 353 XP_002183391.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 276 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27713454 27713454 PRJNA641991_S_NODE_13484_length_164_cov_0.886957_g13365_i0 PRJNA641991 13484 164 0.886957 1.45460948 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 102 4.2999999999999996e-24   NR CAB9497990.1 568900 g13365 i0 92.6 2.96341463414634 54 4 98.8 0 162 1 331 384 CAB9497990.1 expressed unknown protein [Seminavis robusta] diamond 486 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27934102 27934102 PRJNA641991_S_NODE_10425_length_177_cov_0.898438_g10306_i0 PRJNA641991 10425 177 0.898438 1.59023526 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.1e-5   NR GKZ00532.1 2872254 g10306 i0 40.7 0.915254237288136 54 32 91.5 0 3 164 157 210 GKZ00532.1 hypothetical protein MPSEU_001005600 [Mayamaea pseudoterrestris] diamond 162 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28028914 28028914 PRJNA641991_S_NODE_13745_length_163_cov_0.894737_g13626_i0 PRJNA641991 13745 163 0.894737 1.45842131 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 94 9.65e-22   NR XP_002183472.1 556484 g13626 i0 88.5 0.957055214723926 52 6 95.7 0 1 156 205 256 XP_002183472.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 156 94 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28692047 28692047 PRJNA641991_S_NODE_13067_length_165_cov_0.879310_g12948_i0 PRJNA641991 13067 165 0.87931 1.4508615 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 68.9 5.75e-13   NR CAB9514777.1 568900 g12948 i0 56.4 3 55 24 100 0 165 1 57 111 CAB9514777.1 expressed unknown protein [Seminavis robusta] diamond 495 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28912611 28912611 PRJNA641991_S_NODE_6548_length_215_cov_0.921687_g6429_i0 PRJNA641991 6548 215 0.921687 1.98162705 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.3e-4   NR GAX27686.1 1519565 g6429 i0 80 0.697674418604651 25 5 34.9 0 213 139 376 400 GAX27686.1 hypothetical protein FisN_13Hh219 [Fistulifera solaris] diamond 150 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29134063 29134063 PRJNA641991_S_NODE_13929_length_163_cov_0.894737_g13810_i0 PRJNA641991 13929 163 0.894737 1.45842131 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.94e-14   NR XP_002185197.1 556484 g13810 i0 48.3 1.60122699386503 87 12 99.4 1 1 162 599 685 XP_002185197.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 261 76.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29240954 29240954 PRJNA641991_S_NODE_12969_length_165_cov_0.879310_g12850_i0 PRJNA641991 12969 165 0.87931 1.4508615 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 42 0.0246   NR VEU35931.1 183589 g12850 i0 48.6 3.89090909090909 37 17 63.6 1 161 57 1304 1340 VEU35931.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 642 42 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29304008 29304008 PRJNA641991_S_NODE_12449_length_166_cov_0.871795_g12330_i0 PRJNA641991 12449 166 0.871795 1.4471797 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 77.4 7.6e-15   NR KAL3757376.1 259834 g12330 i0 67.9 3.86746987951807 53 17 95.8 0 3 161 601 653 KAL3757376.1 hypothetical protein ACHAWU_008537 [Discostella pseudostelligera] diamond 642 77.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29544210 29544210 PRJNA641991_S_NODE_14910_length_161_cov_0.875000_g14791_i0 PRJNA641991 14910 161 0.875 1.40875 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0123   NR GKY93588.1 2872254 g14791 i0 47.2 0.670807453416149 36 19 67.1 0 160 53 448 483 GKY93588.1 hypothetical protein MPSEU_000326200 [Mayamaea pseudoterrestris] diamond 108 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29891866 29891866 PRJNA641991_S_NODE_12911_length_165_cov_0.879310_g12792_i0 PRJNA641991 12911 165 0.87931 1.4508615 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 104 1.16e-24   NR KAG7339443.1 303405 g12792 i0 85.5 2 55 8 100 0 165 1 177 231 KAG7339443.1 cobalamin synthesis protein P47K [Nitzschia inconspicua] diamond 330 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29998910 29998910 PRJNA641991_S_NODE_14391_length_162_cov_0.902655_g14272_i0 PRJNA641991 14391 162 0.902655 1.4623011 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 73.6 1.95e-14   NR XP_002180222.1 556484 g14272 i0 54.7 2.90740740740741 53 24 98.1 0 161 3 40 92 XP_002180222.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 471 74.3 0.990578734858681 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30188235 30188235 PRJNA641991_S_NODE_14312_length_162_cov_0.902655_g14193_i0 PRJNA641991 14312 162 0.902655 1.4623011 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.12e-15   NR CAB9512941.1 568900 g14193 i0 71.2 7.83333333333333 52 15 96.3 0 2 157 1861 1912 CAB9512941.1 Paraquat-inducible protein A [Seminavis robusta] diamond 1269 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30219849 30219849 PRJNA641991_S_NODE_12092_length_167_cov_0.864407_g11973_i0 PRJNA641991 12092 167 0.864407 1.44355969 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.03e-6   NR XP_002183579.1 556484 g11973 i0 52 2.44311377245509 50 23 88 1 6 152 207 256 XP_002183579.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 408 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30460810 30460810 PRJNA641991_S_NODE_11753_length_168_cov_1.285714_g11634_i0 PRJNA641991 11753 168 1.285714 2.15999952 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.49e-11   NR GKY99009.1 2872254 g11634 i0 53.6 2 56 26 100 0 168 1 194 249 GKY99009.1 hypothetical protein MPSEU_000856600 [Mayamaea pseudoterrestris] diamond 336 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31345301 31345301 PRJNA641991_S_NODE_8876_length_189_cov_1.092857_g8757_i0 PRJNA641991 8876 189 1.092857 2.06549973 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 67.8 2.73e-11   NR XP_002185452.1 556484 g8757 i0 56.9 0.920634920634921 58 21 85.7 1 183 22 567 624 XP_002185452.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 174 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31408552 31408552 PRJNA641991_S_NODE_12516_length_166_cov_0.871795_g12397_i0 PRJNA641991 12516 166 0.871795 1.4471797 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.68e-17   NR XP_002295045.1 296543 g12397 i0 66.7 0.975903614457831 54 18 97.6 0 4 165 7 60 XP_002295045.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 162 77.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31503513 31503513 PRJNA641991_S_NODE_12256_length_167_cov_0.864407_g12137_i0 PRJNA641991 12256 167 0.864407 1.44355969 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 98.2 3.81e-22   NR KAI2493332.1 210448 g12137 i0 79.6 1.94011976047904 54 11 97 0 2 163 504 557 KAI2493332.1 Phosphoenolpyruvate carboxykinase [Fragilaria crotonensis] diamond 324 98.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31756398 31756398 PRJNA641991_S_NODE_7477_length_203_cov_0.993506_g7358_i0 PRJNA641991 7477 203 0.993506 2.01681718 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 67.8 3.07e-11   NR GKY93630.1 2872254 g7358 i0 39.7 0.931034482758621 63 38 93.1 0 3 191 344 406 GKY93630.1 hypothetical protein MPSEU_000330400 [Mayamaea pseudoterrestris] diamond 189 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31787832 31787832 PRJNA641991_S_NODE_10117_length_179_cov_1.561538_g9998_i0 PRJNA641991 10117 179 1.561538 2.79515302 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.1599999999999998e-24   NR CAJ1936351.1 2856 g9998 i0 67.8 3.95530726256983 59 19 98.9 0 3 179 20 78 CAJ1936351.1 unnamed protein product [Cylindrotheca closterium] diamond 708 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32104382 32104382 PRJNA641991_S_NODE_14178_length_162_cov_0.911504_g14059_i0 PRJNA641991 14178 162 0.911504 1.47663648 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 95.1 4.52e-21   NR GAX25191.1 1519565 g14059 i0 79.6 1 54 11 100 0 162 1 1805 1858 GAX25191.1 hypothetical protein FisN_16Hu030 [Fistulifera solaris] diamond 162 95.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32136151 32136151 PRJNA641991_S_NODE_13938_length_163_cov_0.894737_g13819_i0 PRJNA641991 13938 163 0.894737 1.45842131 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.08e-9   NR GKY92835.1 2872254 g13819 i0 68.9 2.66871165644172 45 14 82.8 0 135 1 370 414 GKY92835.1 hypothetical protein MPSEU_000253100 [Mayamaea pseudoterrestris] diamond 435 62.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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