RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1098727" 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

bioproject 1

  • PRJNA1098727 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
26687758 26687758 PRJNA1098727_P_NODE_9901_length_193_cov_1.034722_g9660_i0 PRJNA1098727 9901 193 1.034722 1.99701346 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 118 3.81e-29   NR KAL3784137.1 29204 g9660 i0 87.3 0.979274611398964 63 8 97.9 0 3 191 637 699 KAL3784137.1 hypothetical protein HJC23_005795 [Cyclotella cryptica] diamond 189 118 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26814598 26814598 PRJNA1098727_P_NODE_14881_length_164_cov_0.904348_g14640_i0 PRJNA1098727 14881 164 0.904348 1.48313072 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 64.3 3.11e-10   NR KAL3794402.1 29204 g14640 i0 85.7 0.640243902439024 35 5 64 0 3 107 481 515 KAL3794402.1 hypothetical protein HJC23_012939 [Cyclotella cryptica] diamond 105 64.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27320605 27320605 PRJNA1098727_P_NODE_12003_length_174_cov_1.248000_g11762_i0 PRJNA1098727 12003 174 1.248 2.17152 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 80.9 3.34e-16   NR KAL3777777.1 29204 g11762 i0 90.2 0.706896551724138 41 4 70.7 0 124 2 219 259 KAL3777777.1 hypothetical protein HJC23_008894 [Cyclotella cryptica] diamond 123 80.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27478450 27478450 PRJNA1098727_P_NODE_15263_length_163_cov_0.912281_g15022_i0 PRJNA1098727 15263 163 0.912281 1.48701803 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.23e-18   NR KAL3804780.1 2934178 g15022 i0 70.4 0.993865030674847 54 16 99.4 0 162 1 530 583 KAL3804780.1 hypothetical protein ACHAW5_001887 [Stephanodiscus triporus] diamond 162 88.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28046761 28046761 PRJNA1098727_P_NODE_15745_length_162_cov_0.920354_g15504_i0 PRJNA1098727 15745 162 0.920354 1.49097348 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 99 1.92e-22   NR KAL3786440.1 29204 g15504 i0 88.5 0.962962962962963 52 6 96.3 0 5 160 1701 1752 KAL3786440.1 hypothetical protein HJC23_011021 [Cyclotella cryptica] diamond 156 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28994288 28994288 PRJNA1098727_P_NODE_14648_length_164_cov_1.782609_g14407_i0 PRJNA1098727 14648 164 1.782609 2.92347876 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 57 1.18e-7   NR KAL3776376.1 29204 g14407 i0 89.3 1.02439024390244 28 3 51.2 0 3 86 1007 1034 KAL3776376.1 hypothetical protein HJC23_010212 [Cyclotella cryptica] diamond 168 57 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29341411 29341411 PRJNA1098727_P_NODE_15549_length_162_cov_1.663717_g15308_i0 PRJNA1098727 15549 162 1.663717 2.69522154 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 81.6 2.35e-16   NR KAL3781033.1 29204 g15308 i0 73.6 0.981481481481482 53 14 98.1 0 2 160 338 390 KAL3781033.1 hypothetical protein HJC23_007929 [Cyclotella cryptica] diamond 159 81.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29467282 29467282 PRJNA1098727_P_NODE_15750_length_162_cov_0.920354_g15509_i0 PRJNA1098727 15750 162 0.920354 1.49097348 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 74.3 8.82e-14   NR EJK61660.1 159749 g15509 i0 66 1.96296296296296 53 18 98.1 0 3 161 542 594 EJK61660.1 hypothetical protein THAOC_17811 [Thalassiosira oceanica] diamond 318 74.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30352552 30352552 PRJNA1098727_P_NODE_15872_length_162_cov_0.920354_g15631_i0 PRJNA1098727 15872 162 0.920354 1.49097348 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 57.4 8.31e-8   NR KAL3786440.1 29204 g15631 i0 76.3 0.703703703703704 38 9 70.4 0 48 161 1110 1147 KAL3786440.1 hypothetical protein HJC23_011021 [Cyclotella cryptica] diamond 114 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30415534 30415534 PRJNA1098727_P_NODE_10313_length_189_cov_1.378571_g10072_i0 PRJNA1098727 10313 189 1.378571 2.60549919 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 75.9 3.77e-14   NR KAL3790472.1 29204 g10072 i0 82.2 0.714285714285714 45 8 71.4 0 188 54 44 88 KAL3790472.1 hypothetical protein HJC23_012028 [Cyclotella cryptica] diamond 135 75.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31458271 31458271 PRJNA1098727_P_NODE_15816_length_162_cov_0.920354_g15575_i0 PRJNA1098727 15816 162 0.920354 1.49097348 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.95e-17   NR ACA60901.1 35128 g15575 i0 71.7 0.981481481481482 53 15 98.1 0 2 160 1287 1339 ACA60901.1 pol protein, partial [Thalassiosira pseudonana] diamond 159 84.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32059106 32059106 PRJNA1098727_P_NODE_14898_length_164_cov_0.904348_g14657_i0 PRJNA1098727 14898 164 0.904348 1.48313072 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 77.4 5.42e-15   NR KAL3796948.1 29204 g14657 i0 79.2 0.969512195121951 53 11 97 0 161 3 229 281 KAL3796948.1 hypothetical protein HJC23_000701 [Cyclotella cryptica] diamond 159 77.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32145439 32145439 PRJNA1098727_P_NODE_12558_length_170_cov_0.809917_g12317_i0 PRJNA1098727 12558 170 0.809917 1.3768589 root 1 Root_unresolved Root_unresolved 83.2 7.74e-17   NR KAL3802339.1 29204 g12317 i0 72.2 1.92352941176471 54 15 95.3 0 169 8 1069 1122 KAL3802339.1 hypothetical protein HJC23_007164 [Cyclotella cryptica] diamond 327 83.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32533956 32533956 PRJNA1098727_P_NODE_13339_length_168_cov_0.873950_g13098_i0 PRJNA1098727 13339 168 0.87395 1.468236 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 96.7 8.91e-22   NR KAL3797257.1 29204 g13098 i0 75.9 0.964285714285714 54 13 96.4 0 165 4 309 362 KAL3797257.1 hypothetical protein HJC23_004549 [Cyclotella cryptica] diamond 162 96.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32597026 32597026 PRJNA1098727_P_NODE_8580_length_210_cov_1.155280_g8339_i0 PRJNA1098727 8580 210 1.15528 2.426088 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 64.7 4.54e-10   NR KAL3785736.1 29204 g8339 i0 68.2 0.628571428571429 44 14 62.9 0 168 37 1 44 KAL3785736.1 hypothetical protein HJC23_006305 [Cyclotella cryptica] diamond 132 64.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32785674 32785674 PRJNA1098727_P_NODE_13680_length_167_cov_0.881356_g13439_i0 PRJNA1098727 13680 167 0.881356 1.47186452 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.8e-14   NR KAL3786440.1 29204 g13439 i0 82.6 0.826347305389222 46 5 77.2 1 36 164 640 685 KAL3786440.1 hypothetical protein HJC23_011021 [Cyclotella cryptica] diamond 138 75.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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