RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA558770 · 15 ✖

analysis 1

  • diamond · 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
27236896 27236896 PRJNA558770_P_NODE_223163_length_234_cov_3.000000_g221158_i0 PRJNA558770 223163 234 3 7.02 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.8 9.58e-5   NR CAB9515262.1 568900 g221158 i0 72.7 1.14102564102564 22 6 28.2 0 70 5 15 36 CAB9515262.1 ankyrin repeat protein [Seminavis robusta] diamond 267 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27395169 27395169 PRJNA558770_P_NODE_215343_length_234_cov_3.236181_g213338_i0 PRJNA558770 215343 234 3.236181 7.57266354 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.55e-5   NR KAL3778575.1 2934178 g213338 i0 50.8 0.782051282051282 61 1 78.2 1 189 7 620 651 KAL3778575.1 hypothetical protein ACHAW5_007030 [Stephanodiscus triporus] diamond 183 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
27963291 27963291 PRJNA558770_P_NODE_235745_length_234_cov_2.648241_g233740_i0 PRJNA558770 235745 234 2.648241 6.19688394 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0328   NR OEU16593.1 635003 g233740 i0 70.8 0.307692307692308 24 7 30.8 0 3 74 48 71 OEU16593.1 hypothetical protein FRACYDRAFT_185457, partial [Fragilariopsis cylindrus CCMP1102] diamond 72 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28040598 28040598 PRJNA558770_P_NODE_335985_length_233_cov_4.742424_g333980_i0 PRJNA558770 335985 233 4.742424 11.04984792 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 49.7 7.07e-5   NR KAK1747097.1 267567 g333980 i0 87 0.592274678111588 23 3 29.6 0 74 6 175 197 KAK1747097.1 40S ribosomal protein S8 [Skeletonema marinoi] diamond 138 50.1 0.992015968063872 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28057975 28057975 PRJNA558770_P_NODE_222625_length_234_cov_3.015075_g220620_i0 PRJNA558770 222625 234 3.015075 7.0552755 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 46.2 2.26e-4   NR EJK58442.1 159749 g220620 i0 87.5 0.307692307692308 24 3 30.8 0 232 161 22 45 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 72 46.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28121178 28121178 PRJNA558770_P_NODE_232245_length_234_cov_2.743719_g230240_i0 PRJNA558770 232245 234 2.743719 6.42030246 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0453   NR GKY94005.1 2872254 g230240 i0 87.5 0.307692307692308 24 3 30.8 0 74 3 129 152 GKY94005.1 hypothetical protein MPSEU_000367300 [Mayamaea pseudoterrestris] diamond 72 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28166895 28166895 PRJNA558770_P_NODE_258085_length_234_cov_2.135678_g256080_i0 PRJNA558770 258085 234 2.135678 4.99748652 root 1 Root_unresolved Root_unresolved 41.6 0.0302   NR CAB9526381.1 568900 g256080 i0 75 0.897435897435897 24 6 30.8 0 162 233 8 31 CAB9526381.1 ankyrin repeat protein [Seminavis robusta] diamond 210 42 0.990476190476191 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29194874 29194874 PRJNA558770_P_NODE_216069_length_234_cov_3.216080_g214064_i0 PRJNA558770 216069 234 3.21608 7.5256272 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00393   NR GAX29599.1 1519565 g214064 i0 87.5 0.307692307692308 24 3 30.8 0 75 4 970 993 GAX29599.1 hypothetical protein FisN_24Lh058 [Fistulifera solaris] diamond 72 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29320958 29320958 PRJNA558770_P_NODE_385869_length_192_cov_2.382166_g383864_i0 PRJNA558770 385869 192 2.382166 4.57375872 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.12e-6   NR KAL3945117.1 3061772 g383864 i0 77.4 0.96875 31 7 48.4 0 94 2 14 44 KAL3945117.1 MAG: hypothetical protein SGBAC_000785 [Bacillariaceae sp.] diamond 186 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30078762 30078762 PRJNA558770_P_NODE_221972_length_234_cov_3.035176_g219967_i0 PRJNA558770 221972 234 3.035176 7.10231184 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.4e-5   NR KAI2509714.1 210448 g219967 i0 40 1.92307692307692 75 20 96.2 1 233 9 733 782 KAI2509714.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 450 51.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30236881 30236881 PRJNA558770_P_NODE_225412_length_234_cov_2.934673_g223407_i0 PRJNA558770 225412 234 2.934673 6.86713482 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.002   NR CAB9500209.1 568900 g223407 i0 40.8 0.974358974358974 76 43 94.9 2 3 224 1213 1288 CAB9500209.1 Probable histone acetyltransferase HAC-like [Seminavis robusta] diamond 228 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30377708 30377708 PRJNA558770_P_NODE_253792_length_234_cov_2.226131_g251787_i0 PRJNA558770 253792 234 2.226131 5.20914654 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.00523   NR EJK53522.1 159749 g251787 i0 78.3 0.884615384615385 23 5 29.5 0 164 232 59 81 EJK53522.1 hypothetical protein THAOC_27029 [Thalassiosira oceanica] diamond 207 43.5 0.990804597701149 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31564515 31564515 PRJNA558770_P_NODE_169396_length_234_cov_5.201005_g167391_i0 PRJNA558770 169396 234 5.201005 12.1703517 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52 8.81e-6   NR CAB9512099.1 568900 g167391 i0 88 0.320512820512821 25 3 32.1 0 3 77 137 161 CAB9512099.1 chloroplastic [Seminavis robusta] diamond 75 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31564561 31564561 PRJNA558770_P_NODE_323836_length_233_cov_7.833333_g321831_i0 PRJNA558770 323836 233 7.833333 18.25166589 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00213   NR CAB9504284.1 568900 g321831 i0 83.3 0.927038626609442 24 4 30.9 0 4 75 53 76 CAB9504284.1 10 kDa chaperonin [Seminavis robusta] diamond 216 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32306279 32306279 PRJNA558770_P_NODE_281739_length_234_cov_1.708543_g279734_i0 PRJNA558770 281739 234 1.708543 3.99799062 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 83.2 1.5e-16   NR XP_002179349.1 556484 g279734 i0 62.3 10.8589743589744 77 17 98.7 1 232 2 64 128 XP_002179349.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 2541 83.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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