RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA685607", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA685607 · 20 ✖

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
666315 666315 PRJNA685607_P_NODE_41641_length_296_cov_1.251121_g41282_i0 PRJNA685607 41641 296 1.251121 3.70331816 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 294 4.14e-75   NTclustered gi|657012367|gb|KF302531.1| 2850 g41282 i0 89.61 87.4966216216216 231 24 78 0 60 290 23 253 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 25899 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
3217277 3217277 PRJNA685607_P_NODE_65803_length_251_cov_0.865169_g65444_i0 PRJNA685607 65803 251 0.865169 2.17157419 root 1 Root_unresolved Root_unresolved 149 7.15e-41   NR CAB9510954.1 568900 g65444 i0 84.3 3.9681274900398402 83 13 99.2 0 249 1 7 89 CAB9510954.1 adenosylhomocysteinase [Seminavis robusta] diamond 996 149 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
7045043 7045043 PRJNA685607_P_NODE_62866_length_254_cov_1.530387_g62507_i0 PRJNA685607 62866 254 1.530387 3.88718298 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 159 1.44e-43   NR GAX09346.1 1519565 g62507 i0 88.8 104.173228346457 80 9 94.5 0 253 14 68 147 GAX09346.1 ATP-binding cassette, sub-family E, member 1 [Fistulifera solaris] diamond 26460 159 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
12145565 12145565 PRJNA685607_P_NODE_14630_length_422_cov_2.765043_g14272_i0 PRJNA685607 14630 422 2.765043 11.66848146 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 115 5.110000000000001e-21   NTclustered gi|2046217437|gb|MW729336.1| 451786 g14272 i0 81.081 22.2796208530806 148 24 34 4 278 422 38334 38480 Attheya longicornis mitochondrion, complete genome blastn 9402 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
16479281 16479281 PRJNA685607_P_NODE_70013_length_249_cov_1.715909_g69654_i0 PRJNA685607 70013 249 1.715909 4.27261341 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 130 4.26e-33   NR GFH47328.1 426638 g69654 i0 69.9 3.95180722891566 83 25 100 0 1 249 208 290 GFH47328.1 hypothetical protein CTEN210_03803 [Chaetoceros tenuissimus] diamond 984 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
18518322 18518322 PRJNA685607_P_NODE_14295_length_426_cov_1.679887_g13937_i0 PRJNA685607 14295 426 1.679887 7.15631862 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 133 2.3e-37   NR EJK75259.1 159749 g13937 i0 64.1 0.725352112676056 103 36 71.8 1 107 412 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 133 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
20302585 20302585 PRJNA685607_P_NODE_19996_length_376_cov_1.970297_g19638_i0 PRJNA685607 19996 376 1.970297 7.40831672 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 194 3.6199999999999984e-55   NR GFH46872.1 426638 g19638 i0 77.7 5.88031914893617 121 27 96.5 0 2 364 134 254 GFH46872.1 hypothetical protein CTEN210_03346 [Chaetoceros tenuissimus] diamond 2211 194 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29040365 29040365 PRJNA685607_P_NODE_59168_length_261_cov_1.228723_g58809_i0 PRJNA685607 59168 261 1.228723 3.20696703 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 98.2 1.43e-21   NR GAX25286.1 1519565 g58809 i0 57.5 2 87 34 96.6 1 254 3 489 575 GAX25286.1 very-long-chain (3R)-3-hydroxyacyl-CoA dehydratase [Fistulifera solaris] diamond 522 98.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29071879 29071879 PRJNA685607_P_NODE_14568_length_423_cov_1.497143_g14210_i0 PRJNA685607 14568 423 1.497143 6.33291489 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 143 2.38e-39   NR KAG7338683.1 303405 g14210 i0 62.6 4.53900709219858 107 40 75.9 0 418 98 4 110 KAG7338683.1 myosin heavy-chain kinase [Nitzschia inconspicua] diamond 1920 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29178159 29178159 PRJNA685607_P_NODE_77869_length_247_cov_0.885057_g77510_i0 PRJNA685607 77869 247 0.885057 2.18609079 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 128 1.74e-33   NR EJK47833.1 159749 g77510 i0 68.3 6.91093117408907 82 26 99.6 0 2 247 57 138 EJK47833.1 hypothetical protein THAOC_33424 [Thalassiosira oceanica] diamond 1707 128 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29556751 29556751 PRJNA685607_P_NODE_32650_length_321_cov_1.241935_g32291_i0 PRJNA685607 32650 321 1.241935 3.98661135 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.15e-18   NR KAL3784596.1 29204 g32291 i0 60 2.53271028037383 80 31 73.8 1 238 2 65 144 KAL3784596.1 hypothetical protein HJC23_007052 [Cyclotella cryptica] diamond 813 91.3 0.995618838992333 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29935969 29935969 PRJNA685607_P_NODE_55611_length_267_cov_1.664948_g55252_i0 PRJNA685607 55611 267 1.664948 4.44541116 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 110 3.84e-27   NR CAJ1931814.1 2856 g55252 i0 61.2 6.70786516853933 85 33 95.5 0 3 257 30 114 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 1791 110 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29999173 29999173 PRJNA685607_P_NODE_66111_length_251_cov_0.865169_g65752_i0 PRJNA685607 66111 251 0.865169 2.17157419 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 92 4.6100000000000006e-21   NR KAL3821671.1 382380 g65752 i0 57.9 1.8406374501992 76 32 90.8 0 1 228 96 171 KAL3821671.1 hypothetical protein ACHAXA_006091 [Cyclostephanos tholiformis] diamond 462 92.8 0.991379310344828 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30283806 30283806 PRJNA685607_P_NODE_28452_length_335_cov_1.786260_g28093_i0 PRJNA685607 28452 335 1.78626 5.983971 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 97.1 3.49e-23   NR KAG7373989.1 303405 g28093 i0 61.9 3.0089552238806 84 31 75.2 1 3 254 45 127 KAG7373989.1 50S ribosomal protein L14e [Nitzschia inconspicua] diamond 1008 97.4 0.996919917864476 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31294463 31294463 PRJNA685607_P_NODE_79595_length_246_cov_0.890173_g79236_i0 PRJNA685607 79595 246 0.890173 2.18982558 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 52 2.13e-5   NR EJK72261.1 159749 g79236 i0 44 1.82926829268293 75 40 89 1 245 27 811 885 EJK72261.1 hypothetical protein THAOC_06218 [Thalassiosira oceanica] diamond 450 52.4 0.99236641221374 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31377929 31377929 PRJNA685607_P_NODE_62896_length_254_cov_1.447514_g62537_i0 PRJNA685607 62896 254 1.447514 3.67668556 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 137 9.509999999999999e-39   NR KAK1737117.1 267567 g62537 i0 74.7 3.92125984251969 83 20 98 1 3 251 61 142 KAK1737117.1 vicinal oxygen chelate family protein [Skeletonema marinoi] diamond 996 137 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31832014 31832014 PRJNA685607_P_NODE_37997_length_305_cov_2.159483_g37638_i0 PRJNA685607 37997 305 2.159483 6.58642315 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.3 4.350000000000001e-21   NR XP_002186290.1 556484 g37638 i0 52 2.72459016393443 98 46 96.4 1 303 10 33 129 XP_002186290.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 831 91.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32073760 32073760 PRJNA685607_P_NODE_36958_length_308_cov_1.872340_g36599_i0 PRJNA685607 36958 308 1.87234 5.7668072 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 68.2 9.52e-11   NR KAL3794984.1 2934178 g36599 i0 45.7 0.681818181818182 70 38 68.2 0 232 23 619 688 KAL3794984.1 hypothetical protein ACHAW5_002153 [Stephanodiscus triporus] diamond 210 68.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
32085259 32085259 PRJNA685607_P_NODE_69798_length_250_cov_0.870056_g69439_i0 PRJNA685607 69798 250 0.870056 2.17514 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.9 5.17e-13   NR KAL3757103.1 259834 g69439 i0 39 11.892 82 50 98.4 0 1 246 37 118 KAL3757103.1 hypothetical protein ACHAWU_002942 [Discostella pseudostelligera] diamond 2973 71.6 0.990223463687151 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32358799 32358799 PRJNA685607_P_NODE_16699_length_402_cov_0.936170_g16341_i0 PRJNA685607 16699 402 0.93617 3.7634034 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 53.9 2.67e-5   NR GKY96299.1 2872254 g16341 i0 38.2 0.567164179104478 76 45 56.7 1 323 96 486 559 GKY96299.1 hypothetical protein MPSEU_000589600 [Mayamaea pseudoterrestris] diamond 228 53.9 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);;