RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA222400", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA222400 · 16 ✖

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
15669960 15669960 PRJNA222400_P_NODE_1093_length_493_cov_20.202703_g1060_i0 PRJNA222400 1093 493 20.202703 99.59932579 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 2.07e-36   NR EJK75259.1 159749 g1060 i0 63.1 0.626774847870183 103 37 62.1 1 135 440 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
15669976 15669976 PRJNA222400_P_NODE_1773_length_382_cov_3.186186_g1740_i0 PRJNA222400 1773 382 3.186186 12.17123052 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 194 2.58e-60   NR CAJ1966769.1 2856 g1740 i0 87.6 13.3115183246073 113 14 88.7 0 382 44 98 210 CAJ1966769.1 unnamed protein product [Cylindrotheca closterium] diamond 5085 194 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
16944464 16944464 PRJNA222400_P_NODE_2674_length_294_cov_1.644898_g2641_i0 PRJNA222400 2674 294 1.644898 4.83600012 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 164 4.35e-49   NR KAL3769429.1 259834 g2641 i0 81.3 5.87755102040816 96 18 98 0 289 2 48 143 KAL3769429.1 hypothetical protein ACHAWU_008838 [Discostella pseudostelligera] diamond 1728 165 0.993939393939394 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
19493168 19493168 PRJNA222400_P_NODE_3736_length_232_cov_1.579235_g3703_i0 PRJNA222400 3736 232 1.579235 3.6638252 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 143 7.38e-40   NR AAX09600.1 29204 g3703 i0 90.5 0.956896551724138 74 7 95.7 0 223 2 203 276 AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica] diamond 222 143 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26630857 26630857 PRJNA222400_P_NODE_9181_length_162_cov_1.840708_g9148_i0 PRJNA222400 9181 162 1.840708 2.98194696 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.93e-13   NR KAL3927455.1 3061772 g9148 i0 79.5 1.62962962962963 44 9 81.5 0 3 134 91 134 KAL3927455.1 MAG: hypothetical protein SGARI_005316 [Bacillariaceae sp.] diamond 264 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26662168 26662168 PRJNA222400_P_NODE_6821_length_172_cov_1.308943_g6788_i0 PRJNA222400 6821 172 1.308943 2.25138196 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0365   NR CAB9514358.1 568900 g6788 i0 52.5 0.697674418604651 40 18 69.8 1 143 24 647 685 CAB9514358.1 expressed unknown protein [Seminavis robusta] diamond 120 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27755397 27755397 PRJNA222400_P_NODE_4044_length_222_cov_1.086705_g4011_i0 PRJNA222400 4044 222 1.086705 2.4124851 root 1 Root_unresolved Root_unresolved 111 2.27e-28   NR KAI2510725.1 210448 g4011 i0 69.4 4.89189189189189 72 22 97.3 0 1 216 145 216 KAI2510725.1 Redoxin [Fragilaria crotonensis] diamond 1086 112 0.991071428571429 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28007896 28007896 PRJNA222400_P_NODE_8445_length_165_cov_0.896552_g8412_i0 PRJNA222400 8445 165 0.896552 1.4793108 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00664   NR GFH58926.1 426638 g8412 i0 37.7 4.78181818181818 53 33 96.4 0 2 160 12 64 GFH58926.1 Derlin-2/3 [Chaetoceros tenuissimus] diamond 789 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28084585 28084585 PRJNA222400_P_NODE_7865_length_167_cov_0.881356_g7832_i0 PRJNA222400 7865 167 0.881356 1.47186452 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.22e-9   NR XP_002291575.1 296543 g7832 i0 47.3 1.92215568862275 55 29 98.8 0 2 166 20 74 XP_002291575.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 321 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29663005 29663005 PRJNA222400_P_NODE_1270_length_459_cov_2.370732_g1237_i0 PRJNA222400 1270 459 2.370732 10.88165988 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 188 1.71e-58   NR KAK1745333.1 267567 g1237 i0 65.7 1.7516339869281 134 46 87.6 0 31 432 1 134 KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi] diamond 804 188 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29947668 29947668 PRJNA222400_P_NODE_7711_length_167_cov_0.881356_g7678_i0 PRJNA222400 7711 167 0.881356 1.47186452 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00109   NR CAB9497821.1 568900 g7678 i0 32.7 1.83233532934132 52 35 93.4 0 161 6 370 421 CAB9497821.1 expressed unknown protein [Seminavis robusta] diamond 306 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30913380 30913380 PRJNA222400_P_NODE_4434_length_211_cov_1.098765_g4401_i0 PRJNA222400 4434 211 1.098765 2.31839415 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 64.3 5.66e-10   NR CAJ1930398.1 2856 g4401 i0 49.3 10.8341232227488 71 35 99.5 1 2 211 269 339 CAJ1930398.1 unnamed protein product [Cylindrotheca closterium] diamond 2286 64.7 0.993817619783617 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30944945 30944945 PRJNA222400_P_NODE_7694_length_167_cov_1.186441_g7661_i0 PRJNA222400 7694 167 1.186441 1.98135647 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.4e-19   NR EJK52618.1 159749 g7661 i0 69.1 6.91616766467066 55 17 98.8 0 166 2 128 182 EJK52618.1 hypothetical protein THAOC_28090 [Thalassiosira oceanica] diamond 1155 90.5 0.991160220994475 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31450718 31450718 PRJNA222400_P_NODE_6916_length_171_cov_1.442623_g6883_i0 PRJNA222400 6916 171 1.442623 2.46688533 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 62.4 8.54e-10   NR CAJ1966770.1 2856 g6883 i0 62.5 2.56140350877193 48 17 84.2 1 171 28 186 232 CAJ1966770.1 unnamed protein product [Cylindrotheca closterium] diamond 438 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31559551 31559551 PRJNA222400_P_NODE_3456_length_246_cov_0.984772_g3423_i0 PRJNA222400 3456 246 0.984772 2.42253912 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 71.6 2.27e-12   NR GFH49118.1 426638 g3423 i0 49.3 0.841463414634146 69 34 82.9 1 207 4 15 83 GFH49118.1 cyclin-domain-containing protein [Chaetoceros tenuissimus] diamond 207 71.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31829953 31829953 PRJNA222400_P_NODE_9457_length_162_cov_0.911504_g9424_i0 PRJNA222400 9457 162 0.911504 1.47663648 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 48.5 5.37e-5   NR EJK69679.1 159749 g9424 i0 44.7 2.61111111111111 47 26 87 0 162 22 114 160 EJK69679.1 hypothetical protein THAOC_09039 [Thalassiosira oceanica] diamond 423 48.5 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);;