RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1086823 · 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
16770609 16770609 PRJNA1086823_P_NODE_13214_length_251_cov_1.415730_g13097_i0 PRJNA1086823 13214 251 1.41573 3.5534823 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 66.6 4.4e-11   NR KAL3944141.1 3061772 g13097 i0 47.7 0.776892430278884 65 31 75.3 2 61 249 134 197 KAL3944141.1 MAG: hypothetical protein SGBAC_001788 [Bacillariaceae sp.] diamond 195 66.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26624285 26624285 PRJNA1086823_P_NODE_4341_length_376_cov_2.333333_g4224_i0 PRJNA1086823 4341 376 2.333333 8.77333208 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.34e-17   NR GKY99117.1 2872254 g4224 i0 62 0.63031914893617 79 27 61.4 3 45 275 4 81 GKY99117.1 hypothetical protein MPSEU_000867200 [Mayamaea pseudoterrestris] diamond 237 81.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26782863 26782863 PRJNA1086823_P_NODE_9861_length_274_cov_1.189055_g9744_i0 PRJNA1086823 9861 274 1.189055 3.2580107 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 61.6 7.39e-9   NR GAX23522.1 1519565 g9744 i0 43.9 0.897810218978102 82 36 89.8 2 274 29 113 184 GAX23522.1 RNA-binding protein 5/10 [Fistulifera solaris] diamond 246 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
26972520 26972520 PRJNA1086823_P_NODE_11582_length_257_cov_1.255435_g11465_i0 PRJNA1086823 11582 257 1.255435 3.22646795 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 62 6.49e-9   NR KAL3764087.1 259834 g11465 i0 66 1.30739299610895 53 16 61.9 1 186 28 77 127 KAL3764087.1 hypothetical protein ACHAWU_003899 [Discostella pseudostelligera] diamond 336 62 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28046605 28046605 PRJNA1086823_P_NODE_14485_length_249_cov_0.886364_g14368_i0 PRJNA1086823 14485 249 0.886364 2.20704636 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 73.6 5.56e-13   NR GAX17943.1 1519565 g14368 i0 72.1 0.518072289156627 43 12 51.8 0 5 133 715 757 GAX17943.1 inorganic pyrophosphatase [Fistulifera solaris] diamond 129 73.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28109649 28109649 PRJNA1086823_P_NODE_5425_length_344_cov_1.151292_g5308_i0 PRJNA1086823 5425 344 1.151292 3.96044448 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 75.1 2.46e-13   NR XP_002184718.1 556484 g5308 i0 73.3 0.392441860465116 45 12 39.2 0 1 135 174 218 XP_002184718.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 135 75.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28141603 28141603 PRJNA1086823_P_NODE_12225_length_253_cov_0.866667_g12108_i0 PRJNA1086823 12225 253 0.866667 2.19266751 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 59.3 6.06e-8   NR OEU20890.1 635003 g12108 i0 42.1 1.69565217391304 76 43 88.9 1 225 1 23 98 OEU20890.1 N-acyl-L-amino-acid [Fragilariopsis cylindrus CCMP1102] diamond 429 59.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28615048 28615048 PRJNA1086823_P_NODE_16607_length_246_cov_0.901734_g16490_i0 PRJNA1086823 16607 246 0.901734 2.21826564 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 48.9 2.73e-4   NR CAB9511403.1 568900 g16490 i0 36 0.914634146341463 75 45 91.5 1 4 228 1313 1384 CAB9511403.1 Coiled-coil domain containing 132 [Seminavis robusta] diamond 225 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28678286 28678286 PRJNA1086823_P_NODE_18767_length_243_cov_0.876471_g18650_i0 PRJNA1086823 18767 243 0.876471 2.12982453 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 99.8 6.73e-25   NR GAX18388.1 1519565 g18650 i0 60 0.987654320987654 80 32 98.8 0 3 242 26 105 GAX18388.1 hypothetical protein FisN_15Lh317 [Fistulifera solaris] diamond 240 99.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29088678 29088678 PRJNA1086823_P_NODE_15888_length_247_cov_0.896552_g15771_i0 PRJNA1086823 15888 247 0.896552 2.21448344 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.58e-4   NR XP_002288175.1 296543 g15771 i0 80.8 0.315789473684211 26 5 31.6 0 246 169 74 99 XP_002288175.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 78 49.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29941324 29941324 PRJNA1086823_P_NODE_8911_length_283_cov_1.738095_g8794_i0 PRJNA1086823 8911 283 1.738095 4.91880885 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 150 6.569999999999999e-40   NR GAX09501.1 1519565 g8794 i0 76.6 1.99293286219081 94 22 99.6 0 283 2 1551 1644 GAX09501.1 hypothetical protein FisN_6Lh111 [Fistulifera solaris] diamond 564 150 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30130343 30130343 PRJNA1086823_P_NODE_13072_length_252_cov_0.871508_g12955_i0 PRJNA1086823 13072 252 0.871508 2.19620016 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 139 4.84e-36   NR KAG7352865.1 303405 g12955 i0 75.9 1.97619047619048 83 20 98.8 0 249 1 3039 3121 KAG7352865.1 heat shock protein DnaJ domain protein [Nitzschia inconspicua] diamond 498 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30257417 30257417 PRJNA1086823_P_NODE_11492_length_258_cov_1.183784_g11375_i0 PRJNA1086823 11492 258 1.183784 3.05416272 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 140 1.98e-36   NR KAL3936744.1 3061772 g11375 i0 69.4 1.97674418604651 85 26 98.8 0 256 2 1833 1917 KAL3936744.1 MAG: hypothetical protein SGBAC_008008 [Bacillariaceae sp.] diamond 510 140 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30722321 30722321 PRJNA1086823_P_NODE_16874_length_245_cov_1.569767_g16757_i0 PRJNA1086823 16874 245 1.569767 3.84592915 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.27e-5   NR KAL3786824.1 29204 g16757 i0 53.2 2.81632653061224 47 22 57.6 0 101 241 409 455 KAL3786824.1 hypothetical protein HJC23_008098 [Cyclotella cryptica] diamond 690 51.2 0.9921875 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31964006 31964006 PRJNA1086823_P_NODE_7998_length_293_cov_0.840909_g7881_i0 PRJNA1086823 7998 293 0.840909 2.46386337 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 129 2.54e-33   NR GAX14045.1 1519565 g7881 i0 66 0.993174061433447 97 33 99.3 0 292 2 73 169 GAX14045.1 hypothetical protein FisN_5Lh031 [Fistulifera solaris] diamond 291 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32090686 32090686 PRJNA1086823_P_NODE_7258_length_306_cov_0.982833_g7141_i0 PRJNA1086823 7258 306 0.982833 3.00746898 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 146 1.13e-39   NR GKY96460.1 2872254 g7141 i0 74.3 0.990196078431373 101 26 99 0 3 305 331 431 GKY96460.1 hypothetical protein MPSEU_000605500 [Mayamaea pseudoterrestris] diamond 303 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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