RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA285816 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
4887119 4887119 PRJNA285816_S_NODE_5844_length_286_cov_302.000000_g5742_i0 PRJNA285816 5844 286 302 863.72 root 1 Root_unresolved Root_unresolved 135 2.5500000000000003e-27   NTclustered gi|300078496|gb|GU001158.1| 5778 g5742 i0 82.822 12.6223776223776 163 16 53 6 1 152 3399 3560 Hartmannella vermiformis 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 3610 135 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
8025151 8025151 PRJNA285816_S_NODE_1167_length_604_cov_5.565766_g1076_i0 PRJNA285816 1167 604 5.565766 33.61722664 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 416 1.84e-111   NTclustered gi|421976335|gb|JQ519484.1| 5778 g1076 i0 80.141 81.0132450331126 569 103 93 9 22 585 253 816 Vermamoeba vermiformis clone JGHverm1 beta-tubulin gene, partial cds blastn 48932 416 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
8711794 8711794 PRJNA285816_S_NODE_11747_length_217_cov_467.416667_g11645_i0 PRJNA285816 11747 217 467.416667 1014.29416739 Tubulinea 555369 Tubulinea other_Eukaryota 383 5.98e-102   NTclustered gi|11527302|gb|AF293895.1|AF293895 136450 g11645 i0 99.524 96.9124423963134 210 1 97 0 1 210 1676 1467 Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence blastn 21030 383 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida   Echinamoebidae Echinamoeba Echinamoeba exundans
15674839 15674839 PRJNA285816_S_NODE_4193_length_332_cov_4.462898_g4091_i0 PRJNA285816 4193 332 4.462898 14.81682136 Centropyxis laevigata 318528 Tubulinea other_Eukaryota 608 1.479999999999999e-169   NTclustered gi|61655689|gb|AY848965.1| 318528 g4091 i0 99.699 6.94578313253012 332 1 100 0 1 332 37 368 Centropyxis laevigata small subunit ribosomal RNA gene, partial sequence blastn 2306 608 1 Eukaryota Amoebozoa   Tubulinea Elardia Arcellinida Centropyxidae Centropyxis Centropyxis laevigata
16361599 16361599 PRJNA285816_S_NODE_1393_length_555_cov_312.798419_g1297_i0 PRJNA285816 1393 555 312.798419 1736.03122545 Tubulinea 555369 Tubulinea other_Eukaryota 821 0   NTclustered gi|11527302|gb|AF293895.1|AF293895 136450 g1297 i0 93.502 78.2738738738739 554 33 99 3 2 553 620 1172 Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence blastn 43442 821 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida   Echinamoebidae Echinamoeba Echinamoeba exundans
18910572 18910572 PRJNA285816_S_NODE_20255_length_179_cov_333.776923_g20153_i0 PRJNA285816 20255 179 333.776923 597.46069217 Tubulinea 555369 Tubulinea other_Eukaryota 320 3.76e-83   NTclustered gi|11527302|gb|AF293895.1|AF293895 136450 g20153 i0 98.889 100.245810055866 180 1 100 1 1 179 1478 1299 Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence blastn 17944 320 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida   Echinamoebidae Echinamoeba Echinamoeba exundans

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