RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1136505" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA1136505 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
1559042 1559042 PRJNA1136505_P_NODE_116082_length_267_cov_2.721649_g109222_i0 PRJNA1136505 116082 267 2.721649 7.26680283 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82 6.53e-17   NR KAL3816936.1 382380 g109222 i0 51.3 12.123595505618 78 35 87.6 1 236 3 2 76 KAL3816936.1 hypothetical protein ACHAXA_009796 [Cyclostephanos tholiformis] diamond 3237 82.8 0.990338164251208 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
27027740 27027740 PRJNA1136505_P_NODE_129682_length_251_cov_1.494382_g122822_i0 PRJNA1136505 129682 251 1.494382 3.75089882 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 100 1.04e-22   NR CAJ1959219.1 2856 g122822 i0 61.7 3.89641434262948 81 27 96.8 1 5 247 265 341 CAJ1959219.1 unnamed protein product [Cylindrotheca closterium] diamond 978 101 0.99009900990099 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27449757 27449757 PRJNA1136505_P_NODE_103483_length_284_cov_0.943128_g96623_i0 PRJNA1136505 103483 284 0.943128 2.67848352 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 59.7 6.03e-8   NR KAL3795589.1 382360 g96623 i0 46.6 1.51056338028169 73 35 75 2 5 217 290 360 KAL3795589.1 hypothetical protein ACHAWO_001584 [Cyclotella atomus] diamond 429 59.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27544340 27544340 PRJNA1136505_P_NODE_110744_length_274_cov_1.532338_g103884_i0 PRJNA1136505 110744 274 1.532338 4.19860612 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 66.2 3.37e-11   NR GKY91320.1 2872254 g103884 i0 47.3 0.81021897810219 74 39 81 0 224 3 17 90 GKY91320.1 hypothetical protein MPSEU_000104200 [Mayamaea pseudoterrestris] diamond 222 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29691002 29691002 PRJNA1136505_P_NODE_27770_length_766_cov_2.148629_g21142_i0 PRJNA1136505 27770 766 2.148629 16.45849814 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 112 4.94e-25   NR GFH49118.1 426638 g21142 i0 45.7 1.21801566579634 151 78 59.1 3 48 500 41 187 GFH49118.1 cyclin-domain-containing protein [Chaetoceros tenuissimus] diamond 933 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30512662 30512662 PRJNA1136505_P_NODE_120093_length_263_cov_1.073684_g113233_i0 PRJNA1136505 120093 263 1.073684 2.82378892 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 59.3 7.06e-8   NR GKY98158.1 2872254 g113233 i0 55.6 2.96577946768061 45 20 51.3 0 256 122 332 376 GKY98158.1 hypothetical protein MPSEU_000773600 [Mayamaea pseudoterrestris] diamond 780 59.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31777090 31777090 PRJNA1136505_P_NODE_95157_length_296_cov_1.381166_g88297_i0 PRJNA1136505 95157 296 1.381166 4.08825136 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.36e-5   NR CAJ1949737.1 2856 g88297 i0 35.8 0.679054054054054 67 43 67.9 0 90 290 5 71 CAJ1949737.1 unnamed protein product [Cylindrotheca closterium] diamond 201 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31935180 31935180 PRJNA1136505_P_NODE_53957_length_419_cov_1.341040_g47097_i0 PRJNA1136505 53957 419 1.34104 5.6189576 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 184 9.76e-53   NR KAL3912746.1 3061772 g47097 i0 63.5 4.89021479713604 137 50 98.1 0 4 414 404 540 KAL3912746.1 MAG: hypothetical protein SGILL_006764 [Bacillariaceae sp.] diamond 2049 184 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.

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