RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA683902 · 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
3216099 3216099 PRJNA683902_S_NODE_20003_length_238_cov_2.666667_g19559_i0 PRJNA683902 20003 238 2.666667 6.34666746 Liebermannia sp. 2486767 Fungi Fungi 346 8.76e-91   NTclustered gi|1510577646|gb|MH396491.1| 2486767 g19559 i0 92.917 74.1134453781513 240 14 100 3 1 238 559 321 Liebermannia sp. isolate Lros1 small subunit ribosomal RNA gene, partial sequence blastn 17639 346 1 Eukaryota Opisthokonta Fungi Microsporidia       Liebermannia Liebermannia sp.
9593880 9593880 PRJNA683902_S_NODE_21368_length_226_cov_2.460317_g20924_i0 PRJNA683902 21368 226 2.460317 5.56031642 Liebermannia covasacrae 1169135 Fungi Fungi 327 2.98e-85   NTclustered gi|189409558|gb|EU709818.1| 1169135 g20924 i0 93.243 41.4247787610619 222 15 98 0 1 222 1186 965 Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence blastn 9362 327 1 Eukaryota Opisthokonta Fungi Microsporidia       Liebermannia Liebermannia covasacrae
10869381 10869381 PRJNA683902_S_NODE_39589_length_151_cov_1.368421_g39145_i0 PRJNA683902 39589 151 1.368421 2.06631571 Liebermannia covasacrae 1169135 Fungi Fungi 196 5.38e-46   NTclustered gi|189409558|gb|EU709818.1| 1169135 g39145 i0 90.196 2.02649006622517 153 12 100 3 1 151 829 980 Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence blastn 306 196 1 Eukaryota Opisthokonta Fungi Microsporidia       Liebermannia Liebermannia covasacrae
12144767 12144767 PRJNA683902_S_NODE_39010_length_152_cov_2.008696_g38566_i0 PRJNA683902 39010 152 2.008696 3.05321792 Alternosema sp. 2914448 Fungi Fungi 135 1.2e-27   NTclustered gi|2187826742|gb|OM501730.1| 2914448 g38566 i0 83.007 29.5065789473684 153 23 100 2 1 152 317 167 Alternosema sp. isolate virilis_WI47a small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 4485 135 1 Eukaryota Opisthokonta Fungi Microsporidia       Alternosema Alternosema sp.
13419245 13419245 PRJNA683902_S_NODE_24751_length_204_cov_3.245509_g24307_i0 PRJNA683902 24751 204 3.245509 6.62083836 Liebermannia covasacrae 1169135 Fungi Fungi 337 4.39e-88   NTclustered gi|189409558|gb|EU709818.1| 1169135 g24307 i0 97 97.7696078431373 200 6 98 0 5 204 598 797 Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence blastn 19945 337 1 Eukaryota Opisthokonta Fungi Microsporidia       Liebermannia Liebermannia covasacrae

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