RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA637219 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26732458 26732458 PRJNA637219_S_NODE_8601_length_180_cov_1.167939_g8556_i0 PRJNA637219 8601 180 1.167939 2.1022902 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 93.2 2.39e-20   NR EJK50234.1 159749 g8556 i0 72.9 2.85 59 16 98.3 0 179 3 304 362 EJK50234.1 hypothetical protein THAOC_30825 [Thalassiosira oceanica] diamond 513 93.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27238972 27238972 PRJNA637219_S_NODE_10903_length_167_cov_0.864407_g10858_i0 PRJNA637219 10903 167 0.864407 1.44355969 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.94e-6   NR GAX20673.1 1519565 g10858 i0 50 0.862275449101796 48 24 86.2 0 148 5 163 210 GAX20673.1 hypothetical protein FisN_32Hh062 [Fistulifera solaris] diamond 144 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27491857 27491857 PRJNA637219_S_NODE_17063_length_161_cov_0.910714_g17018_i0 PRJNA637219 17063 161 0.910714 1.46624954 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.16e-15   NR KAI2490620.1 210448 g17018 i0 76.5 0.950310559006211 51 12 95 0 1 153 332 382 KAI2490620.1 hypothetical protein MHU86_23948 [Fragilaria crotonensis] diamond 153 79.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28072522 28072522 PRJNA637219_S_NODE_6165_length_204_cov_1.129032_g6120_i0 PRJNA637219 6165 204 1.129032 2.30322528 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 91.7 6.7e-21   NR CAB9502681.1 568900 g6120 i0 95.6 3.30882352941176 45 2 66.2 0 3 137 178 222 CAB9502681.1 40S ribosomal protein S20 [Seminavis robusta] diamond 675 92 0.996739130434783 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28849277 28849277 PRJNA637219_S_NODE_8028_length_185_cov_1.125000_g7983_i0 PRJNA637219 8028 185 1.125 2.08125 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 71.6 9.04e-13   NR XP_002183207.1 556484 g7983 i0 61.7 3.27567567567568 47 18 76.2 0 184 44 164 210 XP_002183207.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 606 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29146481 29146481 PRJNA637219_S_NODE_5109_length_218_cov_1.810651_g5064_i0 PRJNA637219 5109 218 1.810651 3.94721918 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 112 1.4700000000000002e-27   NR GFH58295.1 426638 g5064 i0 73.2 2.94495412844037 71 19 97.7 0 2 214 285 355 GFH58295.1 precursor of dehydrogenase pyruvate dehydrogenase E1 component beta subunit [Chaetoceros tenuissimus] diamond 642 113 0.991150442477876 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29430052 29430052 PRJNA637219_S_NODE_1609_length_350_cov_1.817276_g1564_i0 PRJNA637219 1609 350 1.817276 6.360466 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 3.67e-32   NR EJK47833.1 159749 g1564 i0 59.1 4.36285714285714 88 36 75.4 0 2 265 280 367 EJK47833.1 hypothetical protein THAOC_33424 [Thalassiosira oceanica] diamond 1527 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30143817 30143817 PRJNA637219_S_NODE_11772_length_166_cov_0.871795_g11727_i0 PRJNA637219 11772 166 0.871795 1.4471797 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 68.9 7.6e-12   NR CAB9521483.1 568900 g11727 i0 69 0.759036144578313 42 13 75.9 0 5 130 546 587 CAB9521483.1 expressed unknown protein [Seminavis robusta] diamond 126 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30156401 30156401 PRJNA637219_S_NODE_5472_length_213_cov_1.243902_g5427_i0 PRJNA637219 5472 213 1.243902 2.64951126 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.49e-5   NR GFH47969.1 426638 g5427 i0 75 0.985915492957746 24 6 33.8 0 2 73 444 467 GFH47969.1 hypothetical protein CTEN210_04445 [Chaetoceros tenuissimus] diamond 210 51.6 0.992248062015504 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31515854 31515854 PRJNA637219_S_NODE_16296_length_162_cov_0.902655_g16251_i0 PRJNA637219 16296 162 0.902655 1.4623011 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.11e-4   NR CAJ1954685.1 2856 g16251 i0 55.9 3.62962962962963 34 15 63 0 113 12 2207 2240 CAJ1954685.1 unnamed protein product [Cylindrotheca closterium] diamond 588 48.1 0.993762993762994 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31534930 31534930 PRJNA637219_S_NODE_13036_length_165_cov_0.879310_g12991_i0 PRJNA637219 13036 165 0.87931 1.4508615 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 109 4.17e-27   NR KAL3790377.1 29204 g12991 i0 87.3 1 55 7 100 0 1 165 267 321 KAL3790377.1 hypothetical protein HJC23_002763 [Cyclotella cryptica] diamond 165 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31895123 31895123 PRJNA637219_S_NODE_17357_length_161_cov_0.910714_g17312_i0 PRJNA637219 17357 161 0.910714 1.46624954 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 108 5.870000000000001e-26   NR KAL3797493.1 29204 g17312 i0 100 3.95031055900621 53 0 98.8 0 3 161 1166 1218 KAL3797493.1 hypothetical protein HJC23_009857 [Cyclotella cryptica] diamond 636 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31914319 31914319 PRJNA637219_S_NODE_4097_length_237_cov_2.946809_g4052_i0 PRJNA637219 4097 237 2.946809 6.98393733 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.86e-5   NR EJK50186.1 159749 g4052 i0 52.5 0.506329113924051 40 18 50.6 1 235 116 106 144 EJK50186.1 hypothetical protein THAOC_30872 [Thalassiosira oceanica] diamond 120 49.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32040928 32040928 PRJNA637219_S_NODE_9378_length_174_cov_2.032000_g9333_i0 PRJNA637219 9378 174 2.032 3.53568 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.13e-11   NR KAL3821798.1 382380 g9333 i0 97.1 1.75862068965517 34 1 58.6 0 172 71 457 490 KAL3821798.1 hypothetical protein ACHAXA_008791 [Cyclostephanos tholiformis] diamond 306 68.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32167644 32167644 PRJNA637219_S_NODE_16338_length_162_cov_0.884956_g16293_i0 PRJNA637219 16338 162 0.884956 1.43362872 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.33e-5   NR CAB9507965.1 568900 g16293 i0 43.2 2.37037037037037 44 25 81.5 0 4 135 1007 1050 CAB9507965.1 Sushi domain-containing protein 2 [Seminavis robusta] diamond 384 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32243570 32243570 PRJNA637219_S_NODE_15378_length_162_cov_1.805310_g15333_i0 PRJNA637219 15378 162 1.80531 2.9246022 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.54e-9   NR KAL3797500.1 29204 g15333 i0 96.2 1.92592592592593 26 1 48.1 0 162 85 319 344 KAL3797500.1 hypothetical protein HJC23_009864 [Cyclotella cryptica] diamond 312 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32559913 32559913 PRJNA637219_S_NODE_10619_length_167_cov_0.864407_g10574_i0 PRJNA637219 10619 167 0.864407 1.44355969 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 57.4 4.09e-8   NR XP_002183677.1 556484 g10574 i0 70.3 8.64071856287425 37 11 66.5 0 165 55 168 204 XP_002183677.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1443 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32578899 32578899 PRJNA637219_S_NODE_9719_length_172_cov_1.243902_g9674_i0 PRJNA637219 9719 172 1.243902 2.13951144 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 55.5 5.89e-8   NR AID23596.1 2850 g9674 i0 56.9 0.88953488372093 51 21 89 1 20 172 64 113 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 153 55.5 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);;