RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA438111", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA438111 · 14 ✖

analysis 1

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
25316587 25316587 PRJNA438111_P_NODE_1560_length_757_cov_12.833791_g1204_i1 PRJNA438111 1560 757 12.833791 97.15179787 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 369 8.32e-124   NR KAL3778461.1 29204 g1204 i1 66.4 29.9128137384412 262 76 99.1 2 3 752 183 444 KAL3778461.1 hypothetical protein HJC23_004401 [Cyclotella cryptica] diamond 22644 372 0.991935483870968 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26632787 26632787 PRJNA438111_P_NODE_79801_length_158_cov_2.403101_g79176_i0 PRJNA438111 79801 158 2.403101 3.79689958 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 66.6 2.51e-11   NR EJK74909.1 159749 g79176 i0 55.8 0.987341772151899 52 23 98.7 0 156 1 99 150 EJK74909.1 hypothetical protein THAOC_03385, partial [Thalassiosira oceanica] diamond 156 66.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
26759284 26759284 PRJNA438111_P_NODE_13041_length_287_cov_4.077519_g12416_i0 PRJNA438111 13041 287 4.077519 11.70247953 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 63.9 2.27e-9   NR GFH43692.1 426638 g12416 i0 36.1 2.02787456445993 97 58 97.2 1 279 1 488 584 GFH43692.1 ran binding protein 7 [Chaetoceros tenuissimus] diamond 582 63.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27518356 27518356 PRJNA438111_P_NODE_57603_length_173_cov_7.361111_g56978_i0 PRJNA438111 57603 173 7.361111 12.73472203 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.06e-8   NR CAJ1902643.1 2856 g56978 i0 53.8 2.70520231213873 52 24 90.2 0 157 2 43 94 CAJ1902643.1 unnamed protein product [Cylindrotheca closterium] diamond 468 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28450508 28450508 PRJNA438111_P_NODE_8626_length_344_cov_3.196825_g8007_i0 PRJNA438111 8626 344 3.196825 10.997078 root 1 Root_unresolved Root_unresolved 151 6.7e-41   NR KAK1748636.1 267567 g8007 i0 61.3 4.85755813953488 111 43 96.8 0 340 8 234 344 KAK1748636.1 acetylornithine deacetylase [Skeletonema marinoi] diamond 1671 151 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28671423 28671423 PRJNA438111_P_NODE_4867_length_447_cov_9.043062_g4309_i0 PRJNA438111 4867 447 9.043062 40.42248714 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 199 1.15e-62   NR KAI2491056.1 210448 g4309 i0 73.2 9.12080536912752 138 34 91.3 3 431 24 32 168 KAI2491056.1 Ribosomal S17 N terminal [Fragilaria crotonensis] diamond 4077 201 0.990049751243781 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29097154 29097154 PRJNA438111_P_NODE_83948_length_155_cov_2.166667_g83323_i0 PRJNA438111 83948 155 2.166667 3.35833385 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.45e-10   NR XP_002185147.1 556484 g83323 i0 58.8 2.96129032258065 51 21 98.7 0 2 154 434 484 XP_002185147.1 isomerase glucose-6-phosphate isomerase [Phaeodactylum tricornutum CCAP 1055/1] diamond 459 65.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29145240 29145240 PRJNA438111_P_NODE_2529_length_608_cov_7.839378_g2081_i0 PRJNA438111 2529 608 7.839378 47.66341824 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 134 7.27e-35   NR KAL3804891.1 29204 g2081 i0 52.1 2.93092105263158 121 58 59.7 0 565 203 85 205 KAL3804891.1 hypothetical protein HJC23_006663 [Cyclotella cryptica] diamond 1782 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29475592 29475592 PRJNA438111_P_NODE_30310_length_210_cov_4.243094_g29685_i0 PRJNA438111 30310 210 4.243094 8.9104974 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 53.9 2.74e-6   NR VEU42792.1 183589 g29685 i0 74.2 4.42857142857143 31 8 44.3 0 116 208 281 311 VEU42792.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 930 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30155199 30155199 PRJNA438111_P_NODE_86952_length_152_cov_7.560976_g86327_i0 PRJNA438111 86952 152 7.560976 11.49268352 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.34e-19   NR XP_002176635.1 556484 g86327 i0 82 15.7894736842105 50 9 98.7 0 152 3 98 147 XP_002176635.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 2400 87.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30329231 30329231 PRJNA438111_P_NODE_34392_length_207_cov_1.595506_g33767_i0 PRJNA438111 34392 207 1.595506 3.30269742 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 75.1 3e-14   NR XP_002287855.1 296543 g33767 i0 45.3 0.927536231884058 64 34 91.3 1 16 204 173 236 XP_002287855.1 hypothetical protein THAPSDRAFT_261394, partial [Thalassiosira pseudonana CCMP1335] diamond 192 75.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31735637 31735637 PRJNA438111_P_NODE_40737_length_193_cov_3.286585_g40112_i0 PRJNA438111 40737 193 3.286585 6.34310905 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 67 5.09e-11   NR EJK45560.1 159749 g40112 i0 49.2 6.60621761658031 61 30 94.8 1 191 9 223 282 EJK45560.1 hypothetical protein THAOC_35820, partial [Thalassiosira oceanica] diamond 1275 67 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32320951 32320951 PRJNA438111_P_NODE_69339_length_165_cov_1.536765_g68714_i0 PRJNA438111 69339 165 1.536765 2.53566225 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.29e-5   NR GFH58817.1 426638 g68714 i0 64.7 0.618181818181818 34 12 61.8 0 164 63 345 378 GFH58817.1 hypothetical protein CTEN210_15293 [Chaetoceros tenuissimus] diamond 102 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32573946 32573946 PRJNA438111_P_NODE_43979_length_189_cov_1.681250_g43354_i0 PRJNA438111 43979 189 1.68125 3.1775625 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 106 2.58e-25   NR GKY91244.1 2872254 g43354 i0 87.1 1.96825396825397 62 8 98.4 0 3 188 302 363 GKY91244.1 hypothetical protein MPSEU_000097000 [Mayamaea pseudoterrestris] diamond 372 106 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);;