RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1073183", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 19 ✖

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA1073183 · 19 ✖

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
1461647 1461647 PRJNA1073183_P_NODE_15622_length_330_cov_1.249027_g15527_i0 PRJNA1073183 15622 330 1.249027 4.1217891 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 241 6.18e-59   NTclustered gi|657012511|gb|KF302595.1| 2850 g15527 i0 89.119 3.66969696969697 193 21 58 0 1 193 101 293 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 1211 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5289967 5289967 PRJNA1073183_P_NODE_20785_length_287_cov_1.182243_g20690_i0 PRJNA1073183 20785 287 1.182243 3.39303741 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 149 1.9799999999999994e-42   NR KAG7366514.1 303405 g20690 i0 82.1 5.9581881533101 95 16 99.3 1 286 2 112 205 KAG7366514.1 V-ATPase subunit C [Nitzschia inconspicua] diamond 1710 150 0.993333333333333 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
5290134 5290134 PRJNA1073183_P_NODE_2985_length_723_cov_3.244615_g2901_i0 PRJNA1073183 2985 723 3.244615 23.45856645 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 510 9.929999999999999e-140   NTclustered gi|657012367|gb|KF302531.1| 2850 g2901 i0 90.838 68.7869986168741 382 33 53 2 138 518 390 10 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 49733 510 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5290275 5290275 PRJNA1073183_P_NODE_6045_length_515_cov_14.676471_g5952_i0 PRJNA1073183 6045 515 14.676471 75.58382565 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 466 1.52e-126   NTclustered gi|657012562|gb|KF302618.1| 2850 g5952 i0 87.775 3.71067961165049 409 37 78 7 1 401 426 23 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 1911 466 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10390637 10390637 PRJNA1073183_P_NODE_3149_length_705_cov_4.330696_g3065_i0 PRJNA1073183 3149 705 4.330696 30.5314068 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 420 1.6799999999999998e-112   NTclustered gi|657012465|gb|KF302574.1| 2850 g3065 i0 88.663 37.9872340425532 344 39 49 0 331 674 1 344 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 26781 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19312923 19312923 PRJNA1073183_P_NODE_24136_length_265_cov_1.604167_g24041_i0 PRJNA1073183 24136 265 1.604167 4.25104255 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 149 2.18e-44   NR AID23573.1 2850 g24041 i0 78.6 2.85283018867925 84 18 95.1 0 263 12 28 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 756 149 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23139602 23139602 PRJNA1073183_P_NODE_27519_length_250_cov_0.870056_g27424_i0 PRJNA1073183 27519 250 0.870056 2.17514 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 217 7.59e-52   NTclustered gi|223997043|ref|XM_002288159.1| 296543 g27424 i0 87.435 76.612 191 20 76 4 51 239 365 177 Thalassiosira pseudonana CCMP1335 histone H2B mRNA blastn 19153 217 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26940738 26940738 PRJNA1073183_P_NODE_14782_length_338_cov_1.705660_g14687_i0 PRJNA1073183 14782 338 1.70566 5.7651308 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 124 2.63e-34   NR AID23596.1 2850 g14687 i0 73.5 0.736686390532544 83 22 73.7 0 338 90 35 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 249 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27225246 27225246 PRJNA1073183_P_NODE_26483_length_251_cov_0.865169_g26388_i0 PRJNA1073183 26483 251 0.865169 2.17157419 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.43e-4   NR XP_002178012.1 556484 g26388 i0 54.5 0.657370517928287 55 22 65.7 1 243 79 34 85 XP_002178012.1 RAD23 [Phaeodactylum tricornutum CCAP 1055/1] diamond 165 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27225249 27225249 PRJNA1073183_P_NODE_31823_length_244_cov_0.900585_g31728_i0 PRJNA1073183 31823 244 0.900585 2.1974274 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.88e-15   NR KAL3801383.1 29204 g31728 i0 50.6 0.971311475409836 79 39 97.1 0 242 6 799 877 KAL3801383.1 hypothetical protein HJC23_006993 [Cyclotella cryptica] diamond 237 80.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27572915 27572915 PRJNA1073183_P_NODE_20884_length_286_cov_1.446009_g20789_i0 PRJNA1073183 20884 286 1.446009 4.13558574 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 86.3 4.35e-18   NR GKY90802.1 2872254 g20789 i0 61.5 1.36363636363636 65 25 68.2 0 200 6 44 108 GKY90802.1 hypothetical protein MPSEU_000053000 [Mayamaea pseudoterrestris] diamond 390 86.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28606332 28606332 PRJNA1073183_P_NODE_29407_length_247_cov_1.327586_g29312_i0 PRJNA1073183 29407 247 1.327586 3.27913742 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.5 6.78e-8   NR KAL3780735.1 29204 g29312 i0 38 1.90688259109312 79 48 94.7 1 246 13 35 113 KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica] diamond 471 58.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28994042 28994042 PRJNA1073183_P_NODE_30368_length_246_cov_0.890173_g30273_i0 PRJNA1073183 30368 246 0.890173 2.18982558 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0389   NR KAL3925584.1 3061772 g30273 i0 40.4 0.634146341463415 52 31 63.4 0 195 40 396 447 KAL3925584.1 MAG: hypothetical protein SGILL_000307 [Bacillariaceae sp.] diamond 156 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29057001 29057001 PRJNA1073183_P_NODE_28068_length_249_cov_0.875000_g27973_i0 PRJNA1073183 28068 249 0.875 2.17875 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 64.3 4.34e-10   NR GKY95870.1 2872254 g27973 i0 45.5 2.81927710843373 77 41 91.6 1 4 231 57 133 GKY95870.1 hypothetical protein MPSEU_000547600 [Mayamaea pseudoterrestris] diamond 702 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29120272 29120272 PRJNA1073183_P_NODE_34189_length_241_cov_0.916667_g34094_i0 PRJNA1073183 34189 241 0.916667 2.20916747 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00396   NR XP_002289427.1 296543 g34094 i0 78.3 0.286307053941909 23 5 28.6 0 69 1 310 332 XP_002289427.1 hypothetical protein THAPSDRAFT_22368 [Thalassiosira pseudonana CCMP1335] diamond 69 45.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
30627459 30627459 PRJNA1073183_P_NODE_13693_length_351_cov_1.082734_g13598_i0 PRJNA1073183 13693 351 1.082734 3.80039634 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 207 3.57e-63   NR CAJ1952935.1 2856 g13598 i0 82.1 40 117 21 100 0 1 351 153 269 CAJ1952935.1 unnamed protein product [Cylindrotheca closterium] diamond 14040 209 0.990430622009569 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31521238 31521238 PRJNA1073183_P_NODE_28916_length_248_cov_0.880000_g28821_i0 PRJNA1073183 28916 248 0.88 2.1824 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 118 1.14e-28   NR VEU35041.1 183589 g28821 i0 63.4 3.96774193548387 82 30 99.2 0 2 247 606 687 VEU35041.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 984 118 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31774062 31774062 PRJNA1073183_P_NODE_25017_length_260_cov_1.058824_g24922_i0 PRJNA1073183 25017 260 1.058824 2.7529424 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 56.6 6.13e-7   NR GAX15524.1 1519565 g24922 i0 41.4 2.00769230769231 87 47 98.1 3 258 4 813 897 GAX15524.1 hypothetical protein FisN_6Hu141 [Fistulifera solaris] diamond 522 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32438838 32438838 PRJNA1073183_P_NODE_25139_length_259_cov_1.241935_g25044_i0 PRJNA1073183 25139 259 1.241935 3.21661165 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 136 3.43e-35   NR KAI2512608.1 210448 g25044 i0 79.8 19.9111969111969 84 16 96.1 1 259 11 450 533 KAI2512608.1 Amino-transferase class IV [Fragilaria crotonensis] diamond 5157 136 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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