RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA474911" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA474911 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1722393 1722393 PRJNA474911_P_NODE_5742_length_235_cov_2.022989_g5615_i0 PRJNA474911 5742 235 2.022989 4.75402415 Pleistophora mulleri 249366 Fungi Fungi 370 5.12e-98   NTclustered gi|134147422|gb|EF119339.1| 249366 g5615 i0 95.633 26.8595744680851 229 10 97 0 6 234 3313 3541 Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 6312 370 1 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Pleistophora Pleistophora mulleri
13201277 13201277 PRJNA474911_P_NODE_8451_length_194_cov_2.954887_g8324_i0 PRJNA474911 8451 194 2.954887 5.73248078 Pseudoloma neurophilia 146866 Fungi Fungi 359 8.809999999999999e-95   NTclustered gi|11993647|gb|AF322654.1| 146866 g8324 i0 100 101.288659793814 194 0 100 0 1 194 1712 1519 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19650 359 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
14476194 14476194 PRJNA474911_P_NODE_572_length_855_cov_3.260705_g477_i0 PRJNA474911 572 855 3.260705 27.87902775 Pseudoloma neurophilia 146866 Fungi Fungi 1576 0   NTclustered gi|11993647|gb|AF322654.1| 146866 g477 i0 99.883 91.3134502923977 855 1 100 0 1 855 1322 468 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 78073 1576 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
18299184 18299184 PRJNA474911_P_NODE_1095_length_613_cov_2.353261_g977_i0 PRJNA474911 1095 613 2.353261 14.42548993 Pseudoloma neurophilia 146866 Fungi Fungi 809 0   NTclustered gi|11993647|gb|AF322654.1| 146866 g977 i0 99.773 69.141924959217 440 1 72 0 174 613 2 441 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 42384 809 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
18948544 18948544 PRJNA474911_P_NODE_2035_length_437_cov_1.361702_g1910_i0 PRJNA474911 2035 437 1.361702 5.95063774 Pleistophoridae 35232 Fungi Fungi 479 1.6299999999999997e-130   NTclustered gi|134147422|gb|EF119339.1| 249366 g1910 i0 86.577 16.0892448512586 447 45 100 15 1 437 2100 2541 Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 7031 483 0.991718426501035 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Pleistophora Pleistophora mulleri

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