RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB75230 · 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
2687056 2687056 PRJEB75230_P_NODE_27823_length_355_cov_2.393617_g27641_i0 PRJEB75230 27823 355 2.393617 8.49734035 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 186 2.2e-52   NR CAB9522148.1 568900 g27641 i0 73.7 3.9887323943662 118 31 99.7 0 355 2 541 658 CAB9522148.1 Spermatogenesis-associated protein 5-like protein 1 [Seminavis robusta] diamond 1416 186 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
4824001 4824001 PRJEB75230_P_NODE_178224_length_241_cov_2.750000_g178042_i0 PRJEB75230 178224 241 2.75 6.6275 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 123 1.52e-33   NR KAG7359130.1 303405 g178042 i0 70.1 0.95850622406639 77 23 95.9 0 233 3 1 77 KAG7359130.1 cyclophilin type peptidyl-prolyl cis-trans isomerase [Nitzschia inconspicua] diamond 231 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
6515291 6515291 PRJEB75230_P_NODE_36266_length_335_cov_1.175573_g36084_i0 PRJEB75230 36266 335 1.175573 3.93816955 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 160 5.73e-48   NR GFH58715.1 426638 g36084 i0 69.4 18.0716417910448 108 33 96.7 0 12 335 8 115 GFH58715.1 small subunit ribosomal protein S13e [Chaetoceros tenuissimus] diamond 6054 161 0.993788819875776 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
7788162 7788162 PRJEB75230_P_NODE_10667_length_460_cov_11.627907_g10485_i0 PRJEB75230 10667 460 11.627907 53.4883722 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 134 2.52e-37   NR EJK75259.1 159749 g10485 i0 64.1 0.671739130434783 103 36 66.5 1 364 59 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
19262294 19262294 PRJEB75230_P_NODE_179516_length_241_cov_1.202381_g179334_i0 PRJEB75230 179516 241 1.202381 2.89773821 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 149 7.89e-41   NR EJK69095.1 159749 g179334 i0 86.1 18.6846473029046 79 11 98.3 0 3 239 193 271 EJK69095.1 hypothetical protein THAOC_09683, partial [Thalassiosira oceanica] diamond 4503 149 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
20122490 20122490 PRJEB75230_P_NODE_19556_length_386_cov_1.948882_g19374_i0 PRJEB75230 19556 386 1.948882 7.52268452 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 168 3.75e-51   NR CAJ1934332.1 2856 g19374 i0 63.9 0.948186528497409 122 44 94.8 0 377 12 1 122 CAJ1934332.1 unnamed protein product [Cylindrotheca closterium] diamond 366 168 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26748898 26748898 PRJEB75230_P_NODE_15501_length_410_cov_7.240356_g15319_i0 PRJEB75230 15501 410 7.240356 29.6854596 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 86.3 8.35e-17   NR GFH49118.1 426638 g15319 i0 50.6 0.607317073170732 83 39 60 2 161 406 13 94 GFH49118.1 cyclin-domain-containing protein [Chaetoceros tenuissimus] diamond 249 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
26970786 26970786 PRJEB75230_P_NODE_137102_length_248_cov_0.880000_g136920_i0 PRJEB75230 137102 248 0.88 2.1824 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 111 3.18e-26   NR KAL3772705.1 2934178 g136920 i0 45.9 4.94758064516129 111 29 96.8 1 246 7 1422 1532 KAL3772705.1 hypothetical protein ACHAW5_002680 [Stephanodiscus triporus] diamond 1227 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
27121453 27121453 PRJEB75230_P_NODE_29462_length_351_cov_1.003597_g29280_i0 PRJEB75230 29462 351 1.003597 3.52262547 Fragilariopsis 186035 SAR_Eukaryotes SAR_Eukaryotes 135 7.31e-35   NR OEU15732.1 635003 g29280 i0 54.8 2.95726495726496 115 51 98.3 1 3 347 261 374 OEU15732.1 translation initiation factor eIF-2, gamma subunit [Fragilariopsis cylindrus CCMP1102] diamond 1038 135 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27255380 27255380 PRJEB75230_P_NODE_108563_length_257_cov_1.358696_g108381_i0 PRJEB75230 108563 257 1.358696 3.49184872 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 89.7 2.22e-19   NR CAB9508596.1 568900 g108381 i0 56.7 0.782101167315175 67 29 78.2 0 253 53 215 281 CAB9508596.1 Eukaryotic protein of unknown function (DUF829) [Seminavis robusta] diamond 201 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27848082 27848082 PRJEB75230_P_NODE_36824_length_334_cov_1.176245_g36642_i0 PRJEB75230 36824 334 1.176245 3.9286583 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72 5.66e-12   NR KAL3826522.1 382380 g36642 i0 41 10.2215568862275 83 47 72.8 1 90 332 563 645 KAL3826522.1 hypothetical protein ACHAXA_004359 [Cyclostephanos tholiformis] diamond 3414 72 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28321811 28321811 PRJEB75230_P_NODE_133286_length_249_cov_0.875000_g133104_i0 PRJEB75230 133286 249 0.875 2.17875 Fragilariopsis 186035 SAR_Eukaryotes SAR_Eukaryotes 47 0.00129   NR OEU19763.1 635003 g133104 i0 29.5 1.87951807228916 78 55 94 0 242 9 701 778 OEU19763.1 hypothetical protein FRACYDRAFT_235821 [Fragilariopsis cylindrus CCMP1102] diamond 468 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28550334 28550334 PRJEB75230_P_NODE_3327_length_743_cov_2.064179_g3160_i0 PRJEB75230 3327 743 2.064179 15.33684997 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 168 4.129999999999999e-48   NR KAI2494838.1 210448 g3160 i0 46.9 0.791386271870794 196 103 79.1 1 43 630 13 207 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 588 168 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29024153 29024153 PRJEB75230_P_NODE_82728_length_277_cov_1.509804_g82546_i0 PRJEB75230 82728 277 1.509804 4.18215708 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 140 3.53e-39   NR KAL3917061.1 3061772 g82546 i0 87.3 0.768953068592058 71 9 76.9 0 275 63 32 102 KAL3917061.1 MAG: hypothetical protein SGARI_007808, partial [Bacillariaceae sp.] diamond 213 140 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29584529 29584529 PRJEB75230_P_NODE_110850_length_255_cov_2.021978_g110668_i0 PRJEB75230 110850 255 2.021978 5.1560439 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 70.5 7.19e-12   NR KAL3826953.1 382380 g110668 i0 42.2 2.05882352941176 83 46 96.5 2 9 254 75 156 KAL3826953.1 hypothetical protein ACHAXA_000017 [Cyclostephanos tholiformis] diamond 525 71.2 0.990168539325843 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30097297 30097297 PRJEB75230_P_NODE_23272_length_371_cov_1.033557_g23090_i0 PRJEB75230 23272 371 1.033557 3.83449647 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 107 1.05e-26   NR KAI2508236.1 210448 g23090 i0 42.9 1.0188679245283 126 64 95.4 1 12 365 1 126 KAI2508236.1 dienelactone hydrolase [Fragilaria crotonensis] diamond 378 107 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30319133 30319133 PRJEB75230_P_NODE_21132_length_379_cov_2.986928_g20950_i0 PRJEB75230 21132 379 2.986928 11.32045712 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 89.4 3.98e-20   NR AID23596.1 2850 g20950 i0 82 0.395778364116095 50 9 39.6 0 5 154 68 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 150 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31266572 31266572 PRJEB75230_P_NODE_8575_length_497_cov_1.551887_g8393_i0 PRJEB75230 8575 497 1.551887 7.71287839 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 49.3 0.0023   NR KAL3762943.1 259834 g8393 i0 59.1 0.464788732394366 44 17 26 1 497 369 423 466 KAL3762943.1 hypothetical protein ACHAWU_001090 [Discostella pseudostelligera] diamond 231 49.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31298080 31298080 PRJEB75230_P_NODE_177435_length_242_cov_0.911243_g177253_i0 PRJEB75230 177435 242 0.911243 2.20520806 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 104 5.65e-24   NR GKY96096.1 2872254 g177253 i0 62.7 0.929752066115702 75 28 93 0 5 229 181 255 GKY96096.1 hypothetical protein MPSEU_000569800 [Mayamaea pseudoterrestris] diamond 225 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31298083 31298083 PRJEB75230_P_NODE_29355_length_351_cov_1.107914_g29173_i0 PRJEB75230 29355 351 1.107914 3.88877814 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 181 2.15e-53   NR CAJ1943401.1 2856 g29173 i0 80 6.76923076923077 115 22 98.3 1 350 6 108 221 CAJ1943401.1 unnamed protein product [Cylindrotheca closterium] diamond 2376 181 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31354193 31354193 PRJEB75230_P_NODE_49796_length_312_cov_2.192469_g49614_i0 PRJEB75230 49796 312 2.192469 6.84050328 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 147 2.29e-39   NR CAB9518138.1 568900 g49614 i0 63.1 2.95192307692308 103 38 99 0 311 3 362 464 CAB9518138.1 Protein of unknown function (DUF2009) [Seminavis robusta] diamond 921 148 0.993243243243243 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31361539 31361539 PRJEB75230_P_NODE_175456_length_242_cov_0.911243_g175274_i0 PRJEB75230 175456 242 0.911243 2.20520806 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 89.7 3.25e-20   NR EJK74743.1 159749 g175274 i0 54.5 0.954545454545455 77 35 95.5 0 241 11 63 139 EJK74743.1 hypothetical protein THAOC_03563 [Thalassiosira oceanica] diamond 231 89.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31393193 31393193 PRJEB75230_P_NODE_25636_length_363_cov_0.931034_g25454_i0 PRJEB75230 25636 363 0.931034 3.37965342 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.96e-5   NR CAJ1942770.1 2856 g25454 i0 44.3 0.504132231404959 61 34 50.4 0 361 179 113 173 CAJ1942770.1 unnamed protein product [Cylindrotheca closterium] diamond 183 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31772526 31772526 PRJEB75230_P_NODE_81697_length_278_cov_1.502439_g81515_i0 PRJEB75230 81697 278 1.502439 4.17678042 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 117 1.6599999999999998e-31   NR XP_002180336.1 556484 g81515 i0 56.5 0.992805755395683 92 40 99.3 0 1 276 28 119 XP_002180336.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 276 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32398219 32398219 PRJEB75230_P_NODE_170399_length_243_cov_0.905882_g170217_i0 PRJEB75230 170399 243 0.905882 2.20129326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.3 9.1e-10   NR CAB9499682.1 568900 g170217 i0 49.2 3.33333333333333 65 33 80.2 0 197 3 536 600 CAB9499682.1 Sensor protein FixL [Seminavis robusta] diamond 810 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32657706 32657706 PRJEB75230_P_NODE_33360_length_341_cov_1.149254_g33178_i0 PRJEB75230 33360 341 1.149254 3.91895614 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00571   NR CAB9506402.1 568900 g33178 i0 35.6 0.519061583577713 59 38 51.9 0 28 204 64 122 CAB9506402.1 expressed unknown protein [Seminavis robusta] diamond 177 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32682062 32682062 PRJEB75230_P_NODE_96880_length_266_cov_1.196891_g96698_i0 PRJEB75230 96880 266 1.196891 3.18373006 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72 1.42e-12   NR KAL3795522.1 29204 g96698 i0 47 2.90977443609023 83 42 93.6 2 1 249 142 222 KAL3795522.1 hypothetical protein HJC23_009235 [Cyclotella cryptica] diamond 774 72 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);;