RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA550047", 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 · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA550047 · 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
1793886 1793886 PRJNA550047_P_NODE_590242_length_201_cov_5.710938_g588269_i0 PRJNA550047 590242 201 5.710938 11.47898538 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 102 1.71e-17   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g588269 i0 80.714 49.0597014925373 140 20 68 6 54 189 12594 12458 Odontella regia mitochondrion, complete genome blastn 9861 102 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
4344171 4344171 PRJNA550047_P_NODE_489264_length_234_cov_6.012422_g487291_i0 PRJNA550047 489264 234 6.012422 14.06906748 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 392 1.0899999999999999e-104   NTclustered gi|74325165|ref|NC_007405.1| 35128 g487291 i0 96.996 105.034188034188 233 7 99 0 2 234 12579 12347 Thalassiosira pseudonana mitochondrion, complete genome blastn 24578 392 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
5617231 5617231 PRJNA550047_P_NODE_186665_length_344_cov_15.461255_g184704_i0 PRJNA550047 186665 344 15.461255 53.1867172 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 84.7 2.15e-16   NR XP_002186434.1 556484 g184704 i0 89.8 1.28197674418605 49 5 42.7 0 198 344 139 187 XP_002186434.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 441 84.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11323641 11323641 PRJNA550047_P_NODE_241749_length_300_cov_15.096916_g239780_i0 PRJNA550047 241749 300 15.096916 45.290748 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 435 2.3700000000000003e-117   NTclustered gi|27262897|emb|Y10566.2| 92081 g239780 i0 92.025 108.676666666667 326 0 100 1 1 300 1285 1610 Peridinium balticum endosymbiont partial 18S rRNA gene blastn 32603 435 1 Eukaryota Sar   Bacillariophyta         Peridinium balticum endosymbiont
11994532 11994532 PRJNA550047_P_NODE_373390_length_275_cov_12.891089_g371418_i0 PRJNA550047 373390 275 12.891089 35.45049475 Acanthoceras zachariasii 451788 SAR_Eukaryotes SAR_Eukaryotes 187 6.639999999999998e-43   NTclustered gi|1418588907|ref|NC_038009.1| 451788 g371418 i0 84.375 21.6690909090909 192 29 69 1 31 221 88120 88311 Acanthoceras zachariasii chloroplast, complete genome blastn 5959 187 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Acanthocerataceae Acanthoceras Acanthoceras zachariasii
18370625 18370625 PRJNA550047_P_NODE_97255_length_345_cov_8.702206_g95295_i0 PRJNA550047 97255 345 8.702206 30.0226107 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 143 4.08e-38   NR YP_010134181.1 138539 g95295 i0 59 58.1304347826087 134 35 99.1 1 1 342 122 255 YP_010134181.1 hypothetical protein RF45 [Navicula veneta] diamond 20055 144 0.993055555555556 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
22193579 22193579 PRJNA550047_P_NODE_465658_length_242_cov_5.307692_g463685_i0 PRJNA550047 465658 242 5.307692 12.84461464 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 167 7.46e-37   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g463685 i0 92.373 56.3636363636364 118 8 49 1 21 138 55552 55436 Nitzschia reversa mitochondrion, complete genome blastn 13640 167 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
22797586 22797586 PRJNA550047_P_NODE_206838_length_323_cov_10.828000_g204870_i0 PRJNA550047 206838 323 10.828 34.97444 Pleurosigma 197752 SAR_Eukaryotes SAR_Eukaryotes 579 1.1299999999999997e-160   NTclustered gi|2301269116|ref|NC_066077.1| 197753 g204870 i0 99.068 195.613003095975 322 3 99 0 1 322 76421 76742 Pleurosigma intermedium isolate Jiaozhou Bay in China chloroplast, complete genome blastn 63183 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma intermedium
26698189 26698189 PRJNA550047_P_NODE_603061_length_197_cov_8.064516_g601088_i0 PRJNA550047 603061 197 8.064516 15.88709652 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 67.8 9.52e-12   NR GKZ00577.1 2872254 g601088 i0 50 0.852791878172589 56 23 85.3 1 195 28 76 126 GKZ00577.1 hypothetical protein MPSEU_001009900 [Mayamaea pseudoterrestris] diamond 168 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27615221 27615221 PRJNA550047_P_NODE_158504_length_345_cov_4.169118_g156544_i0 PRJNA550047 158504 345 4.169118 14.3834571 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.6 5.8e-16   NR GKY94691.1 2872254 g156544 i0 77.6 0.426086956521739 49 11 42.6 0 197 343 372 420 GKY94691.1 hypothetical protein MPSEU_000434600 [Mayamaea pseudoterrestris] diamond 147 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28531039 28531039 PRJNA550047_P_NODE_510127_length_227_cov_8.435065_g508154_i0 PRJNA550047 510127 227 8.435065 19.14759755 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.41e-9   NR GFH59504.1 426638 g508154 i0 50.8 2.41850220264317 61 30 80.6 0 184 2 142 202 GFH59504.1 hypothetical protein CTEN210_15980 [Chaetoceros tenuissimus] diamond 549 63.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29604100 29604100 PRJNA550047_P_NODE_62690_length_345_cov_14.102941_g60730_i0 PRJNA550047 62690 345 14.102941 48.65514645 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.62e-8   NR CAB9498246.1 568900 g60730 i0 58 0.434782608695652 50 21 43.5 0 196 345 917 966 CAB9498246.1 Lactococcin-G-processing and transport ATP-binding protein LagD [Seminavis robusta] diamond 150 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29698578 29698578 PRJNA550047_P_NODE_220690_length_301_cov_11.425439_g218721_i0 PRJNA550047 220690 301 11.425439 34.39057139 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 91.7 4.63e-19   NR GKZ01346.1 2872254 g218721 i0 50 1.13621262458472 114 22 81.7 3 3 248 323 433 GKZ01346.1 hypothetical protein MPSEU_001085600 [Mayamaea pseudoterrestris] diamond 342 91.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30899754 30899754 PRJNA550047_P_NODE_529054_length_220_cov_18.625850_g527081_i0 PRJNA550047 529054 220 18.62585 40.97687 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 109 3.1100000000000004e-26   NR YP_004376616.1 1519565 g527081 i0 77.8 0.981818181818182 72 16 98.2 0 3 218 91 162 YP_004376616.1 preprotein translocase subunit SecY [Fistulifera solaris] diamond 216 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31578223 31578223 PRJNA550047_P_NODE_296436_length_297_cov_15.977679_g294467_i0 PRJNA550047 296436 297 15.977679 47.45370663 root 1 Root_unresolved Root_unresolved 103 1.99e-24   NR OEU21956.1 635003 g294467 i0 48.4 7.16161616161616 91 44 88.9 1 34 297 44 134 OEU21956.1 Arginase/deacetylase [Fragilariopsis cylindrus CCMP1102] diamond 2127 103 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
31830981 31830981 PRJNA550047_P_NODE_246557_length_300_cov_11.149780_g244588_i0 PRJNA550047 246557 300 11.14978 33.44934 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.89e-6   NR GAX26976.1 1519565 g244588 i0 54.1 1.09 37 17 37 0 1 111 301 337 GAX26976.1 aminopeptidase 2 [Fistulifera solaris] diamond 327 56.2 0.99288256227758 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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