RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA983848 · 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
967986 967986 PRJNA983848_P_NODE_154621_length_244_cov_2.450292_g148738_i0 PRJNA983848 154621 244 2.450292 5.97871248 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.01e-10   NTclustered gi|1819718724|gb|MN956530.1| 2850 g148738 i0 77.953 1.04098360655738 127 28 52 0 1 127 3449 3575 Phaeodactylum tricornutum strain ICE-H mitochondrion, complete genome blastn 254 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
9897709 9897709 PRJNA983848_P_NODE_47208_length_516_cov_1.302483_g41338_i0 PRJNA983848 47208 516 1.302483 6.72081228 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 411 7.239999999999999e-110   NTclustered gi|657012367|gb|KF302531.1| 2850 g41338 i0 87.088 71.2887596899225 364 45 70 2 16 378 23 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 36785 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14997211 14997211 PRJNA983848_P_NODE_40392_length_595_cov_3.496169_g34562_i0 PRJNA983848 40392 595 3.496169 20.80220555 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 394 8.49e-105   NTclustered gi|657012562|gb|KF302618.1| 2850 g34562 i0 81.874 57.4571428571429 491 68 81 17 12 492 759 280 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 34187 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14997936 14997936 PRJNA983848_P_NODE_59232_length_426_cov_3.019830_g53351_i0 PRJNA983848 59232 426 3.01983 12.8644758 Nitzschia alba 2858 SAR_Eukaryotes SAR_Eukaryotes 202 3.849999999999999e-47   NTclustered gi|1418576962|ref|NC_037729.1| 2858 g53351 i0 82.759 57.2511737089202 232 35 54 5 68 297 33293 33065 Nitzschia alba mitochondrion, complete genome blastn 24389 202 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia alba
17548975 17548975 PRJNA983848_P_NODE_88154_length_326_cov_2.102767_g82271_i0 PRJNA983848 88154 326 2.102767 6.85502042 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 137 8.22e-28   NTclustered gi|2020303798|gb|MW417227.1| 265543 g82271 i0 77.917 1.3159509202454 240 39 72 10 92 325 8715 8484 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 429 137 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
17849201 17849201 PRJNA983848_P_NODE_44914_length_539_cov_4.334764_g39049_i0 PRJNA983848 44914 539 4.334764 23.36437796 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 913 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g39049 i0 97.222 200.029684601113 540 13 100 2 1 539 68685 68147 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 107816 913 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19122844 19122844 PRJNA983848_P_NODE_135955_length_254_cov_3.447514_g130072_i0 PRJNA983848 135955 254 3.447514 8.75668556 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 459 1.1599999999999999e-124   NTclustered gi|1735236539|ref|NC_044464.1| 2133758 g130072 i0 99.213 199 254 2 100 0 1 254 87255 87508 Halamphora calidilacuna chloroplast, complete genome blastn 50546 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
23922797 23922797 PRJNA983848_P_NODE_65599_length_395_cov_2.298137_g59716_i0 PRJNA983848 65599 395 2.298137 9.07764115 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 556 6.57e-154   NTclustered gi|146762526|gb|EF553458.1| 2850 g59716 i0 92.583 99.3113924050633 391 24 98 5 6 394 4102 4489 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 39228 556 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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