RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA432257" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA432257 · 12 ✖

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
9358477 9358477 PRJNA432257_S_NODE_94928_length_180_cov_9.020979_g94547_i0 PRJNA432257 94928 180 9.020979 16.2377622 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 139 1.14e-28   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g94547 i0 86.614 53.4833333333333 127 15 70 2 16 141 6685 6810 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 9627 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
22765512 22765512 PRJNA432257_S_NODE_115178_length_161_cov_1.620968_g114797_i0 PRJNA432257 115178 161 1.620968 2.60975848 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 68.6 8.74e-12   NR KAG7336649.1 303405 g114797 i0 85.7 1.56521739130435 42 6 78.3 0 3 128 268 309 KAG7336649.1 hypothetical protein IV203_024880 [Nitzschia inconspicua] diamond 252 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27676284 27676284 PRJNA432257_S_NODE_5164_length_517_cov_12.760417_g4901_i0 PRJNA432257 5164 517 12.760417 65.97135589 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 169 1.66e-48   NR CAB9512089.1 568900 g4901 i0 73 0.731141199226306 126 28 72.5 2 466 92 187 307 CAB9512089.1 expressed unknown protein [Seminavis robusta] diamond 378 169 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27755909 27755909 PRJNA432257_S_NODE_31084_length_275_cov_245.525210_g30703_i0 PRJNA432257 31084 275 245.52521 675.1943275 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 73.9 3.65e-13   NR KAG7374325.1 303405 g30703 i0 59.4 1.39636363636364 64 26 69.8 0 237 46 259 322 KAG7374325.1 annexin [Nitzschia inconspicua] diamond 384 73.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27928691 27928691 PRJNA432257_S_NODE_94965_length_180_cov_7.552448_g94584_i0 PRJNA432257 94965 180 7.552448 13.5944064 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00513   NR GAX24851.1 1519565 g94584 i0 90.9 0.733333333333333 22 2 36.7 0 147 82 174 195 GAX24851.1 hypothetical protein FisN_6Hh200 [Fistulifera solaris] diamond 132 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28450454 28450454 PRJNA432257_S_NODE_103806_length_173_cov_1.705882_g103425_i0 PRJNA432257 103806 173 1.705882 2.95117586 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57 1.33e-7   NR EJK70282.1 159749 g103425 i0 96 12.5722543352601 25 1 43.4 0 172 98 456 480 EJK70282.1 hypothetical protein THAOC_08372 [Thalassiosira oceanica] diamond 2175 57.4 0.993031358885017 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28812383 28812383 PRJNA432257_S_NODE_42308_length_246_cov_1.952153_g41927_i0 PRJNA432257 42308 246 1.952153 4.80229638 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 67 1.04e-10   NR KAL3935693.1 3061772 g41927 i0 55.2 2.01219512195122 67 28 81.7 1 46 246 232 296 KAL3935693.1 MAG: hypothetical protein SGBAC_008834 [Bacillariaceae sp.] diamond 495 67 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29664803 29664803 PRJNA432257_S_NODE_102490_length_174_cov_2.459854_g102109_i0 PRJNA432257 102490 174 2.459854 4.28014596 Pleurosigma intermedium 197753 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.83e-4   NR YP_010472362.1 197753 g102109 i0 85.2 0.931034482758621 27 4 46.6 0 149 69 688 714 YP_010472362.1 RNA polymerase beta'' subunit [Pleurosigma intermedium] diamond 162 48.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma intermedium
30138607 30138607 PRJNA432257_S_NODE_57772_length_219_cov_2.021978_g57391_i0 PRJNA432257 57772 219 2.021978 4.42813182 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 82.8 2.1e-16   NR KAL3780471.1 382360 g57391 i0 59.2 1.04109589041096 76 27 98.6 1 2 217 723 798 KAL3780471.1 hypothetical protein ACHAWO_011794 [Cyclotella atomus] diamond 228 82.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30787384 30787384 PRJNA432257_S_NODE_123874_length_153_cov_3.362069_g123493_i0 PRJNA432257 123874 153 3.362069 5.14396557 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.64e-14   NR WPV76557.1 2126271 g123493 i0 75 6.66666666666667 40 10 78.4 0 6 125 15 54 WPV76557.1 ribosomal protein L36 [Naviculales sp.] diamond 1020 70.5 0.994326241134752 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
31276382 31276382 PRJNA432257_S_NODE_28315_length_285_cov_1.854839_g27934_i0 PRJNA432257 28315 285 1.854839 5.28629115 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 137 1.3000000000000001e-37   NR GKY99907.1 2872254 g27934 i0 65.6 1.01052631578947 96 29 98.9 3 284 3 84 177 GKY99907.1 hypothetical protein MPSEU_000944300 [Mayamaea pseudoterrestris] diamond 288 137 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32383700 32383700 PRJNA432257_S_NODE_102719_length_174_cov_1.708029_g102338_i0 PRJNA432257 102719 174 1.708029 2.97197046 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 82.8 4.82e-17   NR KAG7364085.1 303405 g102338 i0 66.7 0.982758620689655 57 19 98.3 0 172 2 254 310 KAG7364085.1 WD40 repeat-containing protein [Nitzschia inconspicua] diamond 171 82.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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