RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA641707 · 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
616007 616007 PRJNA641707_P_NODE_328481_length_155_cov_2.603774_g325818_i0 PRJNA641707 328481 155 2.603774 4.0358497 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 98.2 3.2800000000000002e-22   NR XP_002178118.1 556484 g325818 i0 98 1.93548387096774 50 1 96.8 0 150 1 262 311 XP_002178118.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 300 98.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8264305 8264305 PRJNA641707_P_NODE_108587_length_246_cov_3.081218_g105924_i0 PRJNA641707 108587 246 3.081218 7.57979628 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 70.1 8.76e-12   NR GAX28276.1 1519565 g105924 i0 100 0.780487804878049 32 0 39 0 6 101 434 465 GAX28276.1 dihydroxy-acid dehydratase [Fistulifera solaris] diamond 192 70.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
26732578 26732578 PRJNA641707_P_NODE_252301_length_181_cov_5.984848_g249638_i0 PRJNA641707 252301 181 5.984848 10.83257488 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.2 9.15e-17   NR GKY91186.1 2872254 g249638 i0 92.7 0.679558011049724 41 3 68 0 123 1 151 191 GKY91186.1 hypothetical protein MPSEU_000091300 [Mayamaea pseudoterrestris] diamond 123 83.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26796292 26796292 PRJNA641707_P_NODE_182981_length_199_cov_19.933333_g180318_i0 PRJNA641707 182981 199 19.933333 39.66733267 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0329   NR GAX16345.1 1519565 g180318 i0 42.6 0.708542713567839 47 22 70.9 1 146 6 28 69 GAX16345.1 RNA-binding protein 8A [Fistulifera solaris] diamond 141 41.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
26891546 26891546 PRJNA641707_P_NODE_261421_length_177_cov_9.882812_g258758_i0 PRJNA641707 261421 177 9.882812 17.49257724 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 65.1 2e-10   NR GKY94446.1 2872254 g258758 i0 80.6 0.610169491525424 36 7 61 0 63 170 9120 9155 GKY94446.1 hypothetical protein MPSEU_000410500 [Mayamaea pseudoterrestris] diamond 108 65.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27143986 27143986 PRJNA641707_P_NODE_48462_length_310_cov_13.739464_g45807_i0 PRJNA641707 48462 310 13.739464 42.5923384 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.31e-5   NR KAL3773736.1 382360 g45807 i0 75 0.619354838709677 32 8 31 0 212 307 102 133 KAL3773736.1 hypothetical protein ACHAWO_001705 [Cyclotella atomus] diamond 192 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27586728 27586728 PRJNA641707_P_NODE_249644_length_182_cov_6.992481_g246981_i0 PRJNA641707 249644 182 6.992481 12.72631542 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 106 7.03e-25   NR GKY95163.1 2872254 g246981 i0 94.8 0.956043956043956 58 3 95.6 0 7 180 514 571 GKY95163.1 hypothetical protein MPSEU_000479800 [Mayamaea pseudoterrestris] diamond 174 106 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27618347 27618347 PRJNA641707_P_NODE_229784_length_190_cov_6.148936_g227121_i0 PRJNA641707 229784 190 6.148936 11.6829784 Haslea avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.32e-10   NR YP_010471955.1 2018708 g227121 i0 61.5 0.821052631578947 52 18 78.9 1 40 189 1 52 YP_010471955.1 cell division protein FTSH [Haslea avium] diamond 156 64.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
27694071 27694071 PRJNA641707_P_NODE_78324_length_246_cov_9.314721_g75661_i0 PRJNA641707 78324 246 9.314721 22.91421366 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.16e-9   NR KAI2489057.1 210448 g75661 i0 84.4 4.29268292682927 32 5 39 0 100 5 287 318 KAI2489057.1 hypothetical protein MHU86_25537 [Fragilaria crotonensis] diamond 1056 62 0.993548387096774 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28060145 28060145 PRJNA641707_P_NODE_163905_length_205_cov_17.032051_g161242_i0 PRJNA641707 163905 205 17.032051 34.91570455 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 61.6 4.93e-9   NR KAL3768346.1 382360 g161242 i0 51 2.95609756097561 49 24 71.7 0 58 204 2 50 KAL3768346.1 hypothetical protein ACHAWO_006749 [Cyclotella atomus] diamond 606 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
28754970 28754970 PRJNA641707_P_NODE_65807_length_260_cov_6.341232_g63144_i0 PRJNA641707 65807 260 6.341232 16.4872032 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 48.5 4.01e-4   NR KAG7358714.1 303405 g63144 i0 53.5 1.98461538461538 43 17 46.2 1 224 105 185 227 KAG7358714.1 HSP20-like chaperone [Nitzschia inconspicua] diamond 516 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28767180 28767180 PRJNA641707_P_NODE_109167_length_246_cov_3.000000_g106504_i0 PRJNA641707 109167 246 3 7.38 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.26e-5   NR OEU22509.1 635003 g106504 i0 82.8 1.0609756097561 29 5 35.4 0 15 101 161 189 OEU22509.1 patatin-domain-containing protein, partial [Fragilariopsis cylindrus CCMP1102] diamond 261 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28786357 28786357 PRJNA641707_P_NODE_73787_length_246_cov_21.949239_g71124_i0 PRJNA641707 73787 246 21.949239 53.99512794 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.34e-6   NR KAL3925849.1 3061772 g71124 i0 81.3 3.5 32 6 39 0 99 4 1027 1058 KAL3925849.1 MAG: hypothetical protein SGILL_000131 [Bacillariaceae sp.] diamond 861 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28817624 28817624 PRJNA641707_P_NODE_121468_length_245_cov_6.515306_g118805_i0 PRJNA641707 121468 245 6.515306 15.9624997 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.41e-10   NR GKY97480.1 2872254 g118805 i0 100 0.391836734693878 32 0 39.2 0 5 100 57 88 GKY97480.1 hypothetical protein MPSEU_000706400 [Mayamaea pseudoterrestris] diamond 96 66.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29386470 29386470 PRJNA641707_P_NODE_214589_length_194_cov_10.110345_g211926_i0 PRJNA641707 214589 194 10.110345 19.6140693 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.95e-13   NR GKY91786.1 2872254 g211926 i0 52.5 0.912371134020619 59 28 91.2 0 178 2 662 720 GKY91786.1 hypothetical protein MPSEU_000150300 [Mayamaea pseudoterrestris] diamond 177 73.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29638580 29638580 PRJNA641707_P_NODE_196470_length_198_cov_4.369128_g193807_i0 PRJNA641707 196470 198 4.369128 8.65087344 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 59.3 3e-8   NR KAL3908169.1 3061772 g193807 i0 51.9 1.57575757575758 52 21 72.7 1 55 198 207 258 KAL3908169.1 MAG: hypothetical protein SGILL_008586 [Bacillariaceae sp.] diamond 312 59.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29733494 29733494 PRJNA641707_P_NODE_39770_length_345_cov_8.432432_g37130_i0 PRJNA641707 39770 345 8.432432 29.0918904 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42 0.0313   NR EJK58442.1 159749 g37130 i0 56.1 0.356521739130435 41 16 35.7 1 217 339 34 72 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 123 42 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30207197 30207197 PRJNA641707_P_NODE_183872_length_199_cov_12.173333_g181209_i0 PRJNA641707 183872 199 12.173333 24.22493267 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.82e-4   NR KAL3913026.1 3061772 g181209 i0 56.3 0.482412060301508 32 14 48.2 0 99 194 262 293 KAL3913026.1 MAG: hypothetical protein SGILL_006654 [Bacillariaceae sp.] diamond 96 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30365972 30365972 PRJNA641707_P_NODE_59132_length_277_cov_5.127193_g56471_i0 PRJNA641707 59132 277 5.127193 14.20232461 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0279   NR KAG7337879.1 303405 g56471 i0 54.5 0.357400722021661 33 15 35.7 0 32 130 108 140 KAG7337879.1 Myb-like DNA-binding protein [Nitzschia inconspicua] diamond 99 43.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30441173 30441173 PRJNA641707_P_NODE_102033_length_246_cov_3.949239_g99370_i0 PRJNA641707 102033 246 3.949239 9.71512794 root 1 Root_unresolved Root_unresolved 73.6 3.94e-13   NR BAA86607.1 2856 g99370 i0 90.6 521.158536585366 32 3 39 0 241 146 201 232 BAA86607.1 cytochrome oxidase subunit I, partial [Cylindrotheca closterium] diamond 128205 73.9 0.995940460081191 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30820281 30820281 PRJNA641707_P_NODE_52094_length_298_cov_4.325301_g49436_i0 PRJNA641707 52094 298 4.325301 12.88939698 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 57.4 5.27e-7   NR KAK1741776.1 267567 g49436 i0 59 1.17785234899329 39 16 39.3 0 139 23 230 268 KAK1741776.1 UDP-sugar pyrophosphorylase [Skeletonema marinoi] diamond 351 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31060809 31060809 PRJNA641707_P_NODE_16035_length_541_cov_12.079268_g13659_i0 PRJNA641707 16035 541 12.079268 65.34883988 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.18e-9   NR CAJ1940462.1 2856 g13659 i0 80.5 1.82994454713494 41 8 22.7 0 1 123 196 236 CAJ1940462.1 unnamed protein product [Cylindrotheca closterium] diamond 990 67 0.994029850746269 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32009395 32009395 PRJNA641707_P_NODE_206538_length_196_cov_6.557823_g203875_i0 PRJNA641707 206538 196 6.557823 12.85333308 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 66.6 7.71e-11   NR GAX10596.1 1519565 g203875 i0 52.5 2.52551020408163 61 24 93.4 1 13 195 520 575 GAX10596.1 hypothetical protein FisN_14Lu101 [Fistulifera solaris] diamond 495 66.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32167842 32167842 PRJNA641707_P_NODE_327858_length_155_cov_3.518868_g325195_i0 PRJNA641707 327858 155 3.518868 5.4542454 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 79 1.85e-15   NR CAB9529197.1 568900 g325195 i0 81.3 1.85806451612903 48 9 92.9 0 8 151 372 419 CAB9529197.1 Sulfite exporter TauE/SafE family protein [Seminavis robusta] diamond 288 79 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32199246 32199246 PRJNA641707_P_NODE_181338_length_200_cov_3.768212_g178675_i0 PRJNA641707 181338 200 3.768212 7.536424 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 67 2.47e-11   NR KAG7349701.1 303405 g178675 i0 97 0.99 33 1 49.5 0 100 198 1 33 KAG7349701.1 ribosomal protein S6 [Nitzschia inconspicua] diamond 198 67 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32830841 32830841 PRJNA641707_P_NODE_326700_length_155_cov_5.990566_g324037_i0 PRJNA641707 326700 155 5.990566 9.2853773 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00235   NR KAG7357962.1 303405 g324037 i0 38.8 1.83870967741935 49 30 94.8 0 149 3 424 472 KAG7357962.1 SWAP domain splicing regulatory protein [Nitzschia inconspicua] diamond 285 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32893564 32893564 PRJNA641707_P_NODE_227500_length_191_cov_4.225352_g224837_i0 PRJNA641707 227500 191 4.225352 8.07042232 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00148   NR KAG7365232.1 303405 g224837 i0 43.2 1.27225130890052 37 21 58.1 0 113 3 14 50 KAG7365232.1 U-box domain containing protein [Nitzschia inconspicua] diamond 243 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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