RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB7799", 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 · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJEB7799 · 15 ✖

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
25527183 25527183 PRJEB7799h_S_NODE_1441_length_190_cov_4.412903_g1438_i0 PRJEB7799 1441 190 4.412903 8.3845157 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 2.66e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g1438 i0 85.714 1.10526315789474 105 15 55 0 56 160 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25528582 25528582 PRJEB7799o_S_NODE_2137_length_186_cov_6.271523_g2129_i0 PRJEB7799 2137 186 6.271523 11.66503278 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 63.9 7.35e-6   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g2129 i0 95.122 3.28494623655914 41 1 22 1 3 42 24636 24596 Coscinodiscus granii mitochondrion, complete sequence blastn 611 63.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
25801420 25801420 PRJEB7799p_S_NODE_6955_length_211_cov_2.619318_g6932_i0 PRJEB7799 6955 211 2.619318 5.52676098 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 3.01e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g6932 i0 85.714 0.995260663507109 105 15 50 0 62 166 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26070798 26070798 PRJEB7799c_S_NODE_1421_length_292_cov_3.070039_g1398_i0 PRJEB7799 1421 292 3.070039 8.96451388 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 141 5.61e-29   NTclustered gi|2074156200|gb|MW413905.1| 216802 g1398 i0 83.439 46.1849315068493 157 21 52 4 4 155 24609 24453 Guinardia delicatula mitochondrion, complete genome blastn 13486 141 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26071274 26071274 PRJEB7799f_S_NODE_1109_length_242_cov_1.700483_g1093_i0 PRJEB7799 1109 242 1.700483 4.11516886 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 110 1.28e-19   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g1093 i0 81.379 8.38842975206612 145 17 57 8 104 242 25374 25514 Coscinodiscus granii mitochondrion, complete sequence blastn 2030 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
26073440 26073440 PRJEB7799p_S_NODE_2973_length_280_cov_7.420408_g2950_i0 PRJEB7799 2973 280 7.420408 20.7771424 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 147 1.15e-30   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g2950 i0 76.897 84.9892857142857 290 48 100 15 1 280 29911 30191 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 23797 147 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
26161446 26161446 PRJEB7799l_S_NODE_12885_length_157_cov_3.221311_g12856_i0 PRJEB7799 12885 157 3.221311 5.05745827 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 87.9 3.55e-13   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g12856 i0 83.333 8.20382165605096 102 10 62 6 15 112 25472 25374 Coscinodiscus granii mitochondrion, complete sequence blastn 1288 87.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
26343470 26343470 PRJEB7799g_S_NODE_1071_length_252_cov_5.133641_g855_i0 PRJEB7799 1071 252 5.133641 12.93677532 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.74e-13   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g855 i0 80.469 4.38095238095238 128 16 48 7 127 248 25374 25498 Coscinodiscus granii mitochondrion, complete sequence blastn 1104 89.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
26479887 26479887 PRJEB7799h_S_NODE_40_length_440_cov_7.859259_g38_i0 PRJEB7799 40 440 7.859259 34.5807396 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 209 2.39e-49   NTclustered gi|2074156200|gb|MW413905.1| 216802 g38 i0 77.6 89.5 375 64 83 16 1 363 24595 24229 Guinardia delicatula mitochondrion, complete genome blastn 39380 209 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26480174 26480174 PRJEB7799i_S_NODE_8088_length_173_cov_2.318841_g8058_i0 PRJEB7799 8088 173 2.318841 4.01159493 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 63.9 6.71e-6   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g8058 i0 95.122 3.53179190751445 41 1 23 1 2 41 24636 24596 Coscinodiscus granii mitochondrion, complete sequence blastn 611 63.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
32930551 32930551 PRJEB7799m_S_NODE_1857_length_165_cov_3.761538_g1852_i0 PRJEB7799 1857 165 3.761538 6.2065377 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00219   NR EJK58442.1 159749 g1852 i0 87 0.418181818181818 23 3 41.8 0 72 140 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32982226 32982226 PRJEB7799o_S_NODE_2659_length_177_cov_2.507042_g2651_i0 PRJEB7799 2659 177 2.507042 4.43746434 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 58.2 2.18e-9   NR EJK58442.1 159749 g2651 i0 75 0.677966101694915 40 10 67.8 0 27 146 24 63 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 120 58.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33076933 33076933 PRJEB7799p_S_NODE_22229_length_159_cov_1.612903_g22206_i0 PRJEB7799 22229 159 1.612903 2.56451577 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00383   NR XP_002290023.1 296543 g22206 i0 52.8 2 53 25 100 0 159 1 148 200 XP_002290023.1 RL13A, ribosomal protein 13A 60S large ribosomal subunit [Thalassiosira pseudonana CCMP1335] diamond 318 43.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
33110968 33110968 PRJEB7799h_S_NODE_462_length_246_cov_3.853081_g459_i0 PRJEB7799 462 246 3.853081 9.47857926 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.86e-20   NR KAL3823683.1 382380 g459 i0 73.2 2.73170731707317 56 15 68.3 0 243 76 109 164 KAL3823683.1 hypothetical protein ACHAXA_007254 [Cyclostephanos tholiformis] diamond 672 89.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
33135558 33135558 PRJEB7799n_S_NODE_6511_length_189_cov_4.675325_g6474_i0 PRJEB7799 6511 189 4.675325 8.83636425 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00311   NR EJK58442.1 159749 g6474 i0 87 0.365079365079365 23 3 36.5 0 90 22 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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