RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA752572" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 28 ✖

tax_clade 1

bioproject 1

  • PRJNA752572 · 28 ✖

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
2004669 2004669 PRJNA752572_P_NODE_33122_length_475_cov_2.065909_g32627_i0 PRJNA752572 33122 475 2.065909 9.81306775 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 146 7.83e-39   NR GAX10444.1 1519565 g32627 i0 48.4 12.3410526315789 159 76 99.8 2 474 1 3 156 GAX10444.1 ATP-dependent RNA helicase UAP56/SUB2 [Fistulifera solaris] diamond 5862 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
6305405 6305405 PRJNA752572_P_NODE_188545_length_194_cov_1.660377_g188038_i0 PRJNA752572 188545 194 1.660377 3.22113138 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 87 1.74e-19   NR GFH59293.1 426638 g188038 i0 59.4 2.01030927835052 64 26 99 0 2 193 77 140 GFH59293.1 RL9, ribosomal protein 9 [Chaetoceros tenuissimus] diamond 390 87 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
25428017 25428017 PRJNA752572_P_NODE_193340_length_191_cov_3.679487_g192833_i0 PRJNA752572 193340 191 3.679487 7.02782017 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 102 1.61e-17   NTclustered gi|1169296928|gb|KY364698.1| 2843 g192833 i0 98.276 30.2146596858639 58 1 30 0 1 58 4364 4421 Skeletonema costatum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 5771 102 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
26841462 26841462 PRJNA752572_P_NODE_191941_length_192_cov_2.038217_g191434_i0 PRJNA752572 191941 192 2.038217 3.91337664 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.3 4.09e-17   NR KAL3801990.1 29204 g191434 i0 65.6 3.828125 61 21 95.3 0 185 3 327 387 KAL3801990.1 hypothetical protein HJC23_010334, partial [Cyclotella cryptica] diamond 735 84.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26957774 26957774 PRJNA752572_P_NODE_216982_length_180_cov_1.600000_g216475_i0 PRJNA752572 216982 180 1.6 2.88 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 65.9 7.3e-11   NR KAL3772010.1 382360 g216475 i0 55.2 0.966666666666667 58 26 96.7 0 6 179 78 135 KAL3772010.1 hypothetical protein ACHAWO_008182 [Cyclotella atomus] diamond 174 65.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27274142 27274142 PRJNA752572_P_NODE_111723_length_255_cov_1.636364_g111216_i0 PRJNA752572 111723 255 1.636364 4.1727282 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.62e-5   NR CAB9509688.1 568900 g111216 i0 36.7 0.929411764705882 79 42 92.9 2 245 9 260 330 CAB9509688.1 MAP kinase-activated protein kinase 2 (Fragment) [Seminavis robusta] diamond 237 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28126822 28126822 PRJNA752572_P_NODE_62585_length_345_cov_1.851613_g62078_i0 PRJNA752572 62585 345 1.851613 6.38806485 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00997   NR VEU33642.1 183589 g62078 i0 31 0.869565217391304 100 66 85.2 2 24 317 1005 1103 VEU33642.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 300 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28136747 28136747 PRJNA752572_P_NODE_257465_length_167_cov_1.000000_g256958_i0 PRJNA752572 257465 167 1 1.67 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 49.3 6.56e-5   NR CAJ1946312.1 2856 g256958 i0 48.1 6.62874251497006 52 27 93.4 0 11 166 3952 4003 CAJ1946312.1 unnamed protein product [Cylindrotheca closterium] diamond 1107 49.7 0.991951710261569 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28547314 28547314 PRJNA752572_P_NODE_68807_length_328_cov_2.535836_g68300_i0 PRJNA752572 68807 328 2.535836 8.31754208 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 2.01e-24   NR CAJ1951400.1 2856 g68300 i0 59.5 4.28963414634146 79 32 72.3 0 81 317 380 458 CAJ1951400.1 unnamed protein product [Cylindrotheca closterium] diamond 1407 108 0.990740740740741 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29074140 29074140 PRJNA752572_P_NODE_175888_length_201_cov_1.927711_g175381_i0 PRJNA752572 175888 201 1.927711 3.87469911 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.62e-8   NR KAL3765415.1 259834 g175381 i0 51.5 1.97014925373134 66 31 98.5 1 2 199 565 629 KAL3765415.1 hypothetical protein ACHAWU_002333 [Discostella pseudostelligera] diamond 396 60.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29547400 29547400 PRJNA752572_P_NODE_97290_length_274_cov_1.949791_g96783_i0 PRJNA752572 97290 274 1.949791 5.34242734 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.18e-5   NR CAB9520156.1 568900 g96783 i0 41.3 0.68978102189781 63 37 69 0 190 2 296 358 CAB9520156.1 expressed unknown protein [Seminavis robusta] diamond 189 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29620121 29620121 PRJNA752572_P_NODE_134390_length_231_cov_1.964286_g133883_i0 PRJNA752572 134390 231 1.964286 4.53750066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 4.25e-5   NR GAX15668.1 1519565 g133883 i0 34.3 4.84415584415584 67 44 87 0 201 1 243 309 GAX15668.1 alpha-soluble NSF attachment protein [Fistulifera solaris] diamond 1119 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29863283 29863283 PRJNA752572_P_NODE_59611_length_354_cov_1.250784_g59104_i0 PRJNA752572 59611 354 1.250784 4.42777536 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.0108   NR KAL3929676.1 3061772 g59104 i0 41.4 1.30508474576271 70 34 59.3 2 133 342 14 76 KAL3929676.1 MAG: hypothetical protein SGBAC_012106 [Bacillariaceae sp.] diamond 462 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29904927 29904927 PRJNA752572_P_NODE_239231_length_172_cov_0.963504_g238724_i0 PRJNA752572 239231 172 0.963504 1.65722688 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.1 6.17e-7   NR KAG7366980.1 303405 g238724 i0 51 3.52325581395349 51 25 89 0 3 155 869 919 KAG7366980.1 CRM1 C terminal-domain containing protein [Nitzschia inconspicua] diamond 606 55.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30179122 30179122 PRJNA752572_P_NODE_252432_length_168_cov_1.255639_g251925_i0 PRJNA752572 252432 168 1.255639 2.10947352 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 47 1.92e-4   NR KAL3924569.1 3061772 g251925 i0 40.8 0.875 49 27 83.9 1 143 3 67 115 KAL3924569.1 MAG: hypothetical protein SGILL_000966 [Bacillariaceae sp.] diamond 147 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30621462 30621462 PRJNA752572_P_NODE_223353_length_177_cov_1.957746_g222846_i0 PRJNA752572 223353 177 1.957746 3.46521042 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.15e-13   NR VEU39364.1 183589 g222846 i0 69.4 0.830508474576271 49 15 83.1 0 31 177 735 783 VEU39364.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 147 74.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30653016 30653016 PRJNA752572_P_NODE_90413_length_285_cov_1.516000_g89906_i0 PRJNA752572 90413 285 1.516 4.3206 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 87 1.66e-17   NR GFH59097.1 426638 g89906 i0 47.8 3.87368421052632 92 48 96.8 0 5 280 334 425 GFH59097.1 hypothetical protein CTEN210_15573 [Chaetoceros tenuissimus] diamond 1104 87 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30663047 30663047 PRJNA752572_P_NODE_252553_length_168_cov_1.203008_g252046_i0 PRJNA752572 252553 168 1.203008 2.02105344 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 103 7.11e-24   NR KAL3777740.1 29204 g252046 i0 82.1 15.8035714285714 56 10 100 0 168 1 306 361 KAL3777740.1 hypothetical protein HJC23_005373 [Cyclotella cryptica] diamond 2655 103 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30716239 30716239 PRJNA752572_P_NODE_101314_length_268_cov_2.386266_g100807_i0 PRJNA752572 101314 268 2.386266 6.39519288 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0268   NR KAG7360612.1 303405 g100807 i0 30.3 0.996268656716418 89 42 77.2 4 213 7 248 336 KAG7360612.1 PA domain containing protein [Nitzschia inconspicua] diamond 267 43.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30757923 30757923 PRJNA752572_P_NODE_211334_length_183_cov_1.081081_g210827_i0 PRJNA752572 211334 183 1.081081 1.97837823 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.9e-7   NR KAK1741860.1 267567 g210827 i0 49.1 5.40983606557377 55 28 90.2 0 181 17 550 604 KAK1741860.1 U3 small nucleolar RNA-associated protein 15 family protein [Skeletonema marinoi] diamond 990 55.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30757925 30757925 PRJNA752572_P_NODE_47414_length_397_cov_2.569061_g46909_i0 PRJNA752572 47414 397 2.569061 10.19917217 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 208 1.22e-62   NR GFH47772.1 426638 g46909 i0 74.8 15.7632241813602 131 33 99 0 396 4 245 375 GFH47772.1 hypothetical protein CTEN210_04247 [Chaetoceros tenuissimus] diamond 6258 209 0.995215311004785 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30811148 30811148 PRJNA752572_P_NODE_174134_length_202_cov_2.155689_g173627_i0 PRJNA752572 174134 202 2.155689 4.35449178 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.1e-5   NR XP_002177068.1 556484 g173627 i0 49.2 0.935643564356436 63 32 93.6 0 201 13 72 134 XP_002177068.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 189 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31316811 31316811 PRJNA752572_P_NODE_66175_length_335_cov_1.730000_g65668_i0 PRJNA752572 66175 335 1.73 5.7955 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.17e-14   NR OEU18003.1 635003 g65668 i0 40.4 0.93134328358209 104 60 91.3 2 3 308 191 294 OEU18003.1 Zinc/iron permease [Fragilariopsis cylindrus CCMP1102] diamond 312 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
31791071 31791071 PRJNA752572_P_NODE_50397_length_385_cov_2.760000_g49891_i0 PRJNA752572 50397 385 2.76 10.626 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 94 1.64e-19   NR KAG7355237.1 303405 g49891 i0 53 1.29350649350649 83 37 63.1 1 13 255 343 425 KAG7355237.1 UDP-N-acetylglucosamine pyrophosphorylase [Nitzschia inconspicua] diamond 498 94 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31854456 31854456 PRJNA752572_P_NODE_87937_length_289_cov_1.925197_g87430_i0 PRJNA752572 87937 289 1.925197 5.56381933 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.77e-5   NR KAG7356956.1 303405 g87430 i0 46.9 0.508650519031142 49 26 50.9 0 73 219 1609 1657 KAG7356956.1 MORN repeat-containing protein [Nitzschia inconspicua] diamond 147 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32149259 32149259 PRJNA752572_P_NODE_56178_length_365_cov_1.818182_g55671_i0 PRJNA752572 56178 365 1.818182 6.6363643 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 88.6 2.34e-18   NR XP_002181181.1 556484 g55671 i0 66.1 3.65753424657534 62 21 51 0 180 365 40 101 XP_002181181.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 1335 88.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32487511 32487511 PRJNA752572_P_NODE_28319_length_513_cov_2.144351_g27842_i0 PRJNA752572 28319 513 2.144351 11.00052063 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 112 2.9700000000000004e-27   NR KAL3756586.1 259834 g27842 i0 38.6 1.75438596491228 145 82 84.8 3 437 3 91 228 KAL3756586.1 hypothetical protein ACHAWU_001789 [Discostella pseudostelligera] diamond 900 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32676455 32676455 PRJNA752572_P_NODE_94180_length_279_cov_1.471311_g93673_i0 PRJNA752572 94180 279 1.471311 4.10495769 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 87.4 9.51e-18   NR GKY99390.1 2872254 g93673 i0 46.8 1.01075268817204 94 48 98.9 1 3 278 84 177 GKY99390.1 hypothetical protein MPSEU_000893700 [Mayamaea pseudoterrestris] diamond 282 87.4 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);;