RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1047551 · 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
12488741 12488741 PRJNA1047551_S_NODE_10390_length_165_cov_4.761538_g10263_i0 PRJNA1047551 10390 165 4.761538 7.8565377 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 71.2 8.64e-13   NR VEU45061.1 183589 g10263 i0 97.1 2.47272727272727 34 1 61.8 0 163 62 310 343 VEU45061.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 408 71.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
26623651 26623651 PRJNA1047551_S_NODE_1741_length_338_cov_2.438944_g1614_i0 PRJNA1047551 1741 338 2.438944 8.24363072 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.21e-12   NR GAX11566.1 1519565 g1614 i0 57.1 1.99704142011834 56 19 45.3 1 6 158 44 99 GAX11566.1 chaperonin GroES [Fistulifera solaris] diamond 675 69.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27161428 27161428 PRJNA1047551_S_NODE_3302_length_256_cov_2.796380_g3175_i0 PRJNA1047551 3302 256 2.79638 7.1587328 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.44e-19   NR KAL3810479.1 382380 g3175 i0 90 0.5859375 50 5 58.6 0 254 105 252 301 KAL3810479.1 hypothetical protein ACHAXA_010173 [Cyclostephanos tholiformis] diamond 150 90.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
27256502 27256502 PRJNA1047551_S_NODE_9623_length_170_cov_1.925926_g9496_i0 PRJNA1047551 9623 170 1.925926 3.2740742 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.05e-8   NR KAG7340592.1 303405 g9496 i0 81.8 1.16470588235294 33 6 58.2 0 155 57 831 863 KAG7340592.1 elongation factor EF-2 [Nitzschia inconspicua] diamond 198 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27446362 27446362 PRJNA1047551_S_NODE_13423_length_151_cov_1.689655_g13296_i0 PRJNA1047551 13423 151 1.689655 2.55137905 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.26e-10   NR KAI2502065.1 210448 g13296 i0 93.1 0.576158940397351 29 2 57.6 0 146 60 197 225 KAI2502065.1 hypothetical protein MHU86_12384 [Fragilaria crotonensis] diamond 87 62.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28045970 28045970 PRJNA1047551_S_NODE_6205_length_200_cov_1.181818_g6078_i0 PRJNA1047551 6205 200 1.181818 2.363636 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 50.1 5.39e-5   NR CAB9503380.1 568900 g6078 i0 95.7 0.345 23 1 34.5 0 199 131 375 397 CAB9503380.1 Acetyl-CoA acetyltransferase [Seminavis robusta] diamond 69 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28298517 28298517 PRJNA1047551_S_NODE_12086_length_157_cov_1.172131_g11959_i0 PRJNA1047551 12086 157 1.172131 1.84024567 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 58.2 4.05e-8   NR CAB9521096.1 568900 g11959 i0 61.4 0.840764331210191 44 17 84.1 0 12 143 806 849 CAB9521096.1 expressed unknown protein [Seminavis robusta] diamond 132 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28488141 28488141 PRJNA1047551_S_NODE_6867_length_192_cov_1.656051_g6740_i0 PRJNA1047551 6867 192 1.656051 3.17961792 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.34e-10   NR GKY97133.1 2872254 g6740 i0 56.7 2.84375 60 21 85.9 1 190 26 499 558 GKY97133.1 hypothetical protein MPSEU_000671700 [Mayamaea pseudoterrestris] diamond 546 64.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28803557 28803557 PRJNA1047551_S_NODE_10288_length_166_cov_1.687023_g10161_i0 PRJNA1047551 10288 166 1.687023 2.80045818 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.55e-9   NR KAL3785207.1 382360 g10161 i0 88.2 0.614457831325301 34 4 61.4 0 19 120 295 328 KAL3785207.1 hypothetical protein ACHAWO_011952 [Cyclotella atomus] diamond 102 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
28803568 28803568 PRJNA1047551_S_NODE_7288_length_188_cov_1.490196_g7161_i0 PRJNA1047551 7288 188 1.490196 2.80156848 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 75.9 2.42e-14   NR KAG7356048.1 303405 g7161 i0 81.3 1.02127659574468 64 7 94.1 1 182 6 269 332 KAG7356048.1 RRM domain containing RNA-binding protein [Nitzschia inconspicua] diamond 192 75.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28930121 28930121 PRJNA1047551_S_NODE_4048_length_235_cov_1.520000_g3921_i0 PRJNA1047551 4048 235 1.52 3.572 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 102 4.63e-25   NR KAL3791235.1 29204 g3921 i0 87 0.68936170212766 54 7 68.9 0 220 59 152 205 KAL3791235.1 hypothetical protein HJC23_000852 [Cyclotella cryptica] diamond 162 102 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29079951 29079951 PRJNA1047551_S_NODE_9428_length_171_cov_6.007353_g9301_i0 PRJNA1047551 9428 171 6.007353 10.27257363 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 55.1 2.5e-7   NR 8J7Z_A 29205 g9301 i0 100 1.26315789473684 24 0 42.1 0 1 72 158 181 8J7Z_A Chain A, FCP [Stephanocyclus meneghinianus] diamond 216 55.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
29277227 29277227 PRJNA1047551_S_NODE_3689_length_244_cov_5.263158_g3562_i0 PRJNA1047551 3689 244 5.263158 12.84210552 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.75e-16   NR KAL3770082.1 2934178 g3562 i0 76 1.26639344262295 50 12 61.5 0 225 76 9 58 KAL3770082.1 hypothetical protein ACHAW5_003458 [Stephanodiscus triporus] diamond 309 76.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
29498372 29498372 PRJNA1047551_S_NODE_8710_length_176_cov_2.489362_g8583_i0 PRJNA1047551 8710 176 2.489362 4.38127712 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 58.2 2.17e-8   NR XP_002183291.1 556484 g8583 i0 59.3 1.89204545454545 59 17 92 2 163 2 139 195 XP_002183291.1 protein fucoxanthin chlorophyll a/c protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 333 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29592731 29592731 PRJNA1047551_S_NODE_7570_length_185_cov_2.166667_g7443_i0 PRJNA1047551 7570 185 2.166667 4.00833395 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 115 1.17e-30   NR CAB9512099.1 568900 g7443 i0 86.9 0.989189189189189 61 8 98.9 0 2 184 130 190 CAB9512099.1 chloroplastic [Seminavis robusta] diamond 183 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29845740 29845740 PRJNA1047551_S_NODE_5411_length_210_cov_2.040000_g5284_i0 PRJNA1047551 5411 210 2.04 4.284 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0123   NR KAL3810479.1 382380 g5284 i0 95.5 0.314285714285714 22 1 31.4 0 18 83 280 301 KAL3810479.1 hypothetical protein ACHAXA_010173 [Cyclostephanos tholiformis] diamond 66 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29972074 29972074 PRJNA1047551_S_NODE_8411_length_179_cov_1.361111_g8284_i0 PRJNA1047551 8411 179 1.361111 2.43638869 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 84.3 3.45e-17   NR KAL3795052.1 29204 g8284 i0 78.8 0.871508379888268 52 11 87.2 0 179 24 844 895 KAL3795052.1 hypothetical protein HJC23_006373 [Cyclotella cryptica] diamond 156 84.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30129733 30129733 PRJNA1047551_S_NODE_6412_length_197_cov_1.870370_g6285_i0 PRJNA1047551 6412 197 1.87037 3.6846289 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.27e-8   NR KAL3810479.1 382380 g6285 i0 86.1 0.548223350253807 36 5 54.8 0 195 88 266 301 KAL3810479.1 hypothetical protein ACHAXA_010173 [Cyclostephanos tholiformis] diamond 108 60.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30572183 30572183 PRJNA1047551_S_NODE_10513_length_165_cov_1.307692_g10386_i0 PRJNA1047551 10513 165 1.307692 2.1576918 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 99 5.14e-25   NR GKY91065.1 2872254 g10386 i0 84.9 0.963636363636364 53 8 96.4 0 161 3 71 123 GKY91065.1 hypothetical protein MPSEU_000079300 [Mayamaea pseudoterrestris] diamond 159 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30603891 30603891 PRJNA1047551_S_NODE_5953_length_202_cov_7.401198_g5826_i0 PRJNA1047551 5953 202 7.401198 14.95041996 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 67.4 4.4e-11   NR CAB9521483.1 568900 g5826 i0 64.4 0.668316831683168 45 16 66.8 0 13 147 543 587 CAB9521483.1 expressed unknown protein [Seminavis robusta] diamond 135 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31299182 31299182 PRJNA1047551_S_NODE_8695_length_176_cov_3.439716_g8568_i0 PRJNA1047551 8695 176 3.439716 6.05390016 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 72.8 3.35e-13   NR CAB9513735.1 568900 g8568 i0 86.7 0.767045454545455 45 6 76.7 0 176 42 344 388 CAB9513735.1 Phosphoribulokinase, chloroplastic [Seminavis robusta] diamond 135 72.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31615494 31615494 PRJNA1047551_S_NODE_7436_length_186_cov_4.039735_g7309_i0 PRJNA1047551 7436 186 4.039735 7.5139071 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.51e-14   NR YP_009329932.1 1115533 g7309 i0 52.6 0.919354838709677 57 27 91.9 0 173 3 25 81 YP_009329932.1 ribosomal protein S19 [Didymosphenia geminata] diamond 171 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
31646953 31646953 PRJNA1047551_S_NODE_12677_length_154_cov_1.773109_g12550_i0 PRJNA1047551 12677 154 1.773109 2.73058786 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 56.2 1.84e-7   NR KAG7349058.1 303405 g12550 i0 100 0.545454545454545 28 0 54.5 0 3 86 428 455 KAG7349058.1 translation elongation factor EF-1 subunit alpha [Nitzschia inconspicua] diamond 84 56.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32153352 32153352 PRJNA1047551_S_NODE_8638_length_177_cov_1.542254_g8511_i0 PRJNA1047551 8638 177 1.542254 2.72978958 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 103 3.55e-27   NR KAI2491939.1 210448 g8511 i0 98.2 0.932203389830508 55 1 93.2 0 175 11 52 106 KAI2491939.1 ribosomal eL36-like protein [Fragilaria crotonensis] diamond 165 103 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32879451 32879451 PRJNA1047551_S_NODE_3640_length_246_cov_1.521327_g3513_i0 PRJNA1047551 3640 246 1.521327 3.74246442 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 67 1.1e-10   NR KAL3797856.1 29204 g3513 i0 63.8 0.707317073170732 58 21 70.7 0 230 57 985 1042 KAL3797856.1 hypothetical protein HJC23_006894 [Cyclotella cryptica] diamond 174 67 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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