RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA608894" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA608894 · 23 ✖

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
3136152 3136152 PRJNA608894_P_NODE_27483_length_357_cov_1.084507_g26984_i0 PRJNA608894 27483 357 1.084507 3.87168999 Pinnularia borealis complex sp. 2725370 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.54e-15   NTclustered gi|1829658902|gb|MN940843.1| 2725370 g26984 i0 86.813 23.5882352941176 91 6 25 6 195 284 265 350 Pinnularia borealis complex sp. voucher SL16_23 28S ribosomal RNA gene, partial sequence blastn 8421 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia borealis complex sp.
4975260 4975260 PRJNA608894_P_NODE_49424_length_252_cov_1.486034_g48925_i0 PRJNA608894 49424 252 1.486034 3.74480568 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 84.2 8.1e-12   NTclustered gi|1419234869|dbj|AP018512.1| 303400 g48925 i0 89.394 8.02777777777778 66 7 26 0 187 252 2684 2749 Nitzschia palea NIES-2729 mitochondrial DNA, nearly complete genome blastn 2023 84.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
14614103 14614103 PRJNA608894_P_NODE_20892_length_441_cov_1.896739_g20396_i0 PRJNA608894 20892 441 1.896739 8.36461899 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 318 3.81e-82   NTclustered gi|657012367|gb|KF302531.1| 2850 g20396 i0 85.574 4.29705215419501 305 42 69 2 1 304 90 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 1895 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14614903 14614903 PRJNA608894_P_NODE_62452_length_198_cov_4.192000_g61953_i0 PRJNA608894 62452 198 4.192 8.30016 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.78e-10   NR XP_002290921.1 296543 g61953 i0 47.5 0.924242424242424 61 30 92.4 1 189 7 166 224 XP_002290921.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 183 64.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
25373436 25373436 PRJNA608894_P_NODE_45180_length_265_cov_1.604167_g44681_i0 PRJNA608894 45180 265 1.604167 4.25104255 root 1 Root_unresolved Root_unresolved 89.7 1.13e-18   NR XP_002186384.1 556484 g44681 i0 57.1 5.51320754716981 77 33 87.2 0 34 264 236 312 XP_002186384.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1461 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26998182 26998182 PRJNA608894_P_NODE_44522_length_267_cov_2.273196_g44023_i0 PRJNA608894 44522 267 2.273196 6.06943332 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 113 9.42e-29   NR CAJ1925964.1 2856 g44023 i0 60.9 7.85393258426966 87 34 97.8 0 261 1 129 215 CAJ1925964.1 unnamed protein product [Cylindrotheca closterium] diamond 2097 114 0.991228070175439 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27346313 27346313 PRJNA608894_P_NODE_34603_length_308_cov_0.812766_g34104_i0 PRJNA608894 34603 308 0.812766 2.50331928 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.81e-9   NR KAL3758522.1 259834 g34104 i0 55.8 1.28571428571429 43 19 41.9 0 168 40 46 88 KAL3758522.1 hypothetical protein ACHAWU_008276 [Discostella pseudostelligera] diamond 396 60.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27364899 27364899 PRJNA608894_P_NODE_43383_length_271_cov_1.555556_g42884_i0 PRJNA608894 43383 271 1.555556 4.21555676 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 77.8 3.73e-16   NR AID23596.1 2850 g42884 i0 43.3 0.996309963099631 90 51 99.6 0 270 1 7 96 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 270 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27427985 27427985 PRJNA608894_P_NODE_21863_length_425_cov_1.678977_g21367_i0 PRJNA608894 21863 425 1.678977 7.13565225 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 179 6.879999999999999e-55   NR GAX15142.1 1519565 g21367 i0 68.3 5.27294117647059 126 40 88.9 0 47 424 26 151 GAX15142.1 nitrogen fixation protein NifU and related proteins [Fistulifera solaris] diamond 2241 179 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27427990 27427990 PRJNA608894_P_NODE_38763_length_287_cov_7.028037_g38264_i0 PRJNA608894 38763 287 7.028037 20.17046619 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 115 3.5699999999999996e-31   NR AID23594.1 2850 g38264 i0 74 1.65156794425087 77 20 80.5 0 6 236 19 95 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 474 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27775273 27775273 PRJNA608894_P_NODE_50984_length_250_cov_0.870056_g50485_i0 PRJNA608894 50984 250 0.870056 2.17514 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0117   NR GKY91144.1 2872254 g50485 i0 35.7 0.672 56 36 67.2 0 178 11 84 139 GKY91144.1 hypothetical protein MPSEU_000087200 [Mayamaea pseudoterrestris] diamond 168 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28753851 28753851 PRJNA608894_P_NODE_55467_length_245_cov_1.906977_g54968_i0 PRJNA608894 55467 245 1.906977 4.67209365 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 57.8 1.21e-7   NR GKY90586.1 2872254 g54968 i0 47.1 6.37959183673469 70 34 85.7 1 2 211 136 202 GKY90586.1 hypothetical protein MPSEU_000032300 [Mayamaea pseudoterrestris] diamond 1563 57.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28848376 28848376 PRJNA608894_P_NODE_28288_length_350_cov_1.111913_g27789_i0 PRJNA608894 28288 350 1.111913 3.8916955 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 98.2 4.920000000000001e-21   NR KAK1745858.1 267567 g27789 i0 45 4.68857142857143 109 60 93.4 0 350 24 1812 1920 KAK1745858.1 eIF-2-alpha kinase activator Gcn1, partial [Skeletonema marinoi] diamond 1641 98.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29069779 29069779 PRJNA608894_P_NODE_29168_length_342_cov_2.572491_g28669_i0 PRJNA608894 29168 342 2.572491 8.79791922 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 105 5.099999999999998e-25   NR KAG7346222.1 303405 g28669 i0 66.7 1.21052631578947 69 23 60.5 0 340 134 197 265 KAG7346222.1 30S ribosomal protein S4 [Nitzschia inconspicua] diamond 414 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30030174 30030174 PRJNA608894_P_NODE_48611_length_254_cov_1.983425_g48112_i0 PRJNA608894 48611 254 1.983425 5.0378995 root 1 Root_unresolved Root_unresolved 125 3.39e-31   NR KAG7346319.1 303405 g48112 i0 69 10.8897637795276 84 26 99.2 0 254 3 474 557 KAG7346319.1 ribonucleoside-diphosphate reductase [Nitzschia inconspicua] diamond 2766 125 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30522411 30522411 PRJNA608894_P_NODE_49793_length_251_cov_1.505618_g49294_i0 PRJNA608894 49793 251 1.505618 3.77910118 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 77 2.3e-15   NR KAG7346278.1 303405 g49294 i0 66 3.29880478087649 53 18 63.3 0 250 92 66 118 KAG7346278.1 ribosomal protein L6e [Nitzschia inconspicua] diamond 828 77 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31009498 31009498 PRJNA608894_P_NODE_45834_length_263_cov_1.421053_g45335_i0 PRJNA608894 45834 263 1.421053 3.73736939 root 1 Root_unresolved Root_unresolved 60.1 3.8e-8   NR KAL3758479.1 259834 g45335 i0 44.6 4.11787072243346 56 30 62.7 1 176 12 76 131 KAL3758479.1 hypothetical protein ACHAWU_004322 [Discostella pseudostelligera] diamond 1083 60.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31122402 31122402 PRJNA608894_P_NODE_62395_length_201_cov_4.546875_g61896_i0 PRJNA608894 62395 201 4.546875 9.13921875 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 79.3 3e-17   NR GKY97253.1 2872254 g61896 i0 65.5 0.865671641791045 58 20 86.6 0 24 197 40 97 GKY97253.1 60S ribosomal protein L38 [Mayamaea pseudoterrestris] diamond 174 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31312404 31312404 PRJNA608894_P_NODE_52515_length_248_cov_2.640000_g52016_i0 PRJNA608894 52515 248 2.64 6.5472 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.47e-14   NR XP_002289768.1 296543 g52016 i0 50 3.0241935483871 82 36 99.2 2 3 248 26 102 XP_002289768.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 750 76.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31534054 31534054 PRJNA608894_P_NODE_51236_length_250_cov_0.870056_g50737_i0 PRJNA608894 51236 250 0.870056 2.17514 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.23e-5   NR EJK74586.1 159749 g50737 i0 36.8 1.536 68 41 81.6 1 238 35 300 365 EJK74586.1 hypothetical protein THAOC_03725 [Thalassiosira oceanica] diamond 384 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31768370 31768370 PRJNA608894_P_NODE_32977_length_315_cov_1.239669_g32478_i0 PRJNA608894 32977 315 1.239669 3.90495735 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.3 2.47e-9   NR CAJ1930338.1 2856 g32478 i0 54.7 2.04761904761905 53 24 50.5 0 100 258 1956 2008 CAJ1930338.1 unnamed protein product [Cylindrotheca closterium] diamond 645 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31913430 31913430 PRJNA608894_P_NODE_35537_length_303_cov_1.300000_g35038_i0 PRJNA608894 35537 303 1.3 3.939 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.47e-13   NR KAI2489795.1 210448 g35038 i0 37 3.87128712871287 100 61 97 1 6 299 9 108 KAI2489795.1 RNA polymerase subunit 8 [Fragilaria crotonensis] diamond 1173 72.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32166759 32166759 PRJNA608894_P_NODE_55958_length_245_cov_0.895349_g55459_i0 PRJNA608894 55958 245 0.895349 2.19360505 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 109 7.51e-27   NR VEU42642.1 183589 g55459 i0 65.4 2.97551020408163 81 28 99.2 0 243 1 156 236 VEU42642.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 729 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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