RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA1240805 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
20750947 20750947 PRJNA1240805_P_NODE_2977_length_272_cov_4.587444_g2928_i0 PRJNA1240805 2977 272 4.587444 12.47784768 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 91.7 2.36e-21   NR GFH59294.1 426638 g2928 i0 56.7 0.738970588235294 67 29 73.9 0 260 60 69 135 GFH59294.1 large subunit ribosomal protein L31e [Chaetoceros tenuissimus] diamond 201 91.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27705767 27705767 PRJNA1240805_P_NODE_5684_length_191_cov_7.035211_g5635_i0 PRJNA1240805 5684 191 7.035211 13.43725301 Halamphora calidilacuna 2133758 SAR_Eukaryotes SAR_Eukaryotes 65.1 8.47e-12   NR AVR57717.1 2133758 g5635 i0 76.2 0.659685863874346 42 10 66 0 127 2 1 42 AVR57717.1 hypothetical protein [Halamphora calidilacuna] diamond 126 65.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
28400017 28400017 PRJNA1240805_P_NODE_6026_length_186_cov_4.445255_g5977_i0 PRJNA1240805 6026 186 4.445255 8.2681743 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 66.2 8.02e-11   NR GKY94348.1 2872254 g5977 i0 61.4 1.75806451612903 57 22 91.9 0 13 183 287 343 GKY94348.1 hypothetical protein MPSEU_000400700 [Mayamaea pseudoterrestris] diamond 327 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28747330 28747330 PRJNA1240805_P_NODE_5087_length_202_cov_33.973856_g5038_i0 PRJNA1240805 5087 202 33.973856 68.62718912 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.26e-7   NR GKY93303.1 2872254 g5038 i0 72.2 0.534653465346535 36 10 53.5 0 24 131 170 205 GKY93303.1 60S ribosomal protein L15-2 [Mayamaea pseudoterrestris] diamond 108 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28968426 28968426 PRJNA1240805_P_NODE_5988_length_187_cov_2.195652_g5939_i0 PRJNA1240805 5988 187 2.195652 4.10586924 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 79.3 8e-17   NR XLG39631.1 2014769 g5939 i0 75.9 7.89304812834225 54 13 86.6 0 25 186 68 121 XLG39631.1 CF0 subunit II of ATP synthase [Navicula incertata] diamond 1476 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
30263414 30263414 PRJNA1240805_P_NODE_6432_length_180_cov_9.061069_g6383_i0 PRJNA1240805 6432 180 9.061069 16.3099242 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.44e-6   NR KAG7343174.1 303405 g6383 i0 80.6 0.516666666666667 31 6 51.7 0 160 68 168 198 KAG7343174.1 ribosomal protein L13e [Nitzschia inconspicua] diamond 93 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30407952 30407952 PRJNA1240805_P_NODE_3273_length_258_cov_1.933014_g3224_i0 PRJNA1240805 3273 258 1.933014 4.98717612 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 92 4.5500000000000006e-21   NR YP_009059240.1 1458866 g3224 i0 60 6.88372093023256 85 34 98.8 0 257 3 44 128 YP_009059240.1 ATP synthase CF1 subunit delta [Eunotia naegelii] diamond 1776 92.8 0.991379310344828 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
30502428 30502428 PRJNA1240805_P_NODE_5073_length_203_cov_2.422078_g5024_i0 PRJNA1240805 5073 203 2.422078 4.91681834 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.14e-6   NR KAL3794201.1 382360 g5024 i0 85.2 1.19704433497537 27 4 39.9 0 23 103 8 34 KAL3794201.1 hypothetical protein ACHAWO_010205 [Cyclotella atomus] diamond 243 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31274208 31274208 PRJNA1240805_P_NODE_6175_length_184_cov_2.918519_g6126_i0 PRJNA1240805 6175 184 2.918519 5.37007496 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 45.8 5.27e-4   NR WPV72501.1 1923966 g6126 i0 85.7 0.717391304347826 21 3 34.2 0 117 179 1 21 WPV72501.1 putative LAGLIDADG homing endonuclease [Navicula sp.] diamond 132 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
31292275 31292275 PRJNA1240805_P_NODE_4915_length_206_cov_3.152866_g4866_i0 PRJNA1240805 4915 206 3.152866 6.49490396 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 59.7 5.1e-9   NR 8J5K_1 29205 g4866 i0 96.3 2.75242718446602 27 1 39.3 0 190 110 137 163 8J5K_1 Chain 1, FCPII-H1, fucoxanthin chlorophyll a/c binding protein [Stephanocyclus meneghinianus] diamond 567 59.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
32255273 32255273 PRJNA1240805_P_NODE_4658_length_212_cov_3.773006_g4609_i0 PRJNA1240805 4658 212 3.773006 7.99877272 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 112 7.63e-30   NR XP_002185212.1 556484 g4609 i0 93 2.41981132075472 57 4 80.7 0 199 29 87 143 XP_002185212.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 513 112 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);;