RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA900028" 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

  • PRJNA900028 · 8 ✖

analysis 1

  • blastn · 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
875902 875902 PRJNA900028_P_NODE_68421_length_190_cov_1.297872_g67672_i0 PRJNA900028 68421 190 1.297872 2.4659568 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 255 1.16e-63   NTclustered gi|2862228862|gb|PQ645496.1| 1923966 g67672 i0 91.053 53.8105263157895 190 16 100 1 1 190 3785 3597 Navicula sp. isolate AGSB0345 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 10224 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
8528182 8528182 PRJNA900028_P_NODE_28807_length_242_cov_7.455959_g28058_i0 PRJNA900028 28807 242 7.455959 18.04342078 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 442 1.1099999999999995e-119   NTclustered gi|2091535207|ref|NC_057645.1| 444606 g28058 i0 99.587 196 242 1 100 0 1 242 16545 16786 Eucampia zodiacus strain CNS00061 chloroplast, complete genome blastn 47432 442 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
10173164 10173164 PRJNA900028_P_NODE_115008_length_168_cov_3.092437_g114259_i0 PRJNA900028 115008 168 3.092437 5.19529416 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 311 2.11e-80   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g114259 i0 100 200 168 0 100 0 1 168 56842 57009 Bacillaria paxillifer chloroplast, complete genome blastn 33600 311 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
10173763 10173763 PRJNA900028_P_NODE_32528_length_234_cov_1.102703_g31779_i0 PRJNA900028 32528 234 1.102703 2.58032502 root 1 Root_unresolved Root_unresolved 130 9.41e-26   NTclustered gi|1418588907|ref|NC_038009.1| 451788 g31779 i0 82.119 114.534188034188 151 27 65 0 84 234 71471 71321 Acanthoceras zachariasii chloroplast, complete genome blastn 26801 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Acanthocerataceae Acanthoceras Acanthoceras zachariasii
11449450 11449450 PRJNA900028_P_NODE_87289_length_182_cov_0.969925_g86540_i0 PRJNA900028 87289 182 0.969925 1.7652635 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 298 1.8e-76   NTclustered gi|1829658085|gb|MN319637.1| 1089216 g86540 i0 96.154 100.038461538462 182 7 100 0 1 182 540 721 Caloneis silicula voucher Cal 890 TM 28S ribosomal RNA gene, partial sequence blastn 18207 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Caloneis Caloneis silicula
17452524 17452524 PRJNA900028_P_NODE_10614_length_342_cov_1.614334_g9866_i0 PRJNA900028 10614 342 1.614334 5.52102228 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 588 1.9899999999999998e-163   NTclustered gi|146762526|gb|EF553458.1| 2850 g9866 i0 97.661 100.163742690058 342 8 100 0 1 342 3872 3531 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 34256 588 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23826508 23826508 PRJNA900028_P_NODE_108979_length_171_cov_1.696721_g108230_i0 PRJNA900028 108979 171 1.696721 2.90139291 Nitzschia sp. pyKryTriq1 3034176 SAR_Eukaryotes SAR_Eukaryotes 303 3.58e-78   NTclustered gi|2524387100|emb|OY101133.1| 3034176 g108230 i0 98.824 196.947368421053 170 2 99 0 2 171 33532 33363 Nitzschia sp. pyKryTriq1 genome assembly, organelle: plastid:chloroplast blastn 33678 303 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1
25101728 25101728 PRJNA900028_P_NODE_5600_length_453_cov_1.801980_g4859_i0 PRJNA900028 5600 453 1.80198 8.1629694 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 787 0   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g4859 i0 98.013 100.483443708609 453 9 100 0 1 453 3959 3507 Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 45519 787 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa

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