RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA599208" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA599208 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
28785043 28785043 PRJNA599208_P_NODE_15947_length_155_cov_1.322034_g15751_i0 PRJNA599208 15947 155 1.322034 2.0491527 Pseudoloma neurophilia 146866 Fungi Fungi 80.1 7.48e-16   NR KRH92949.1 146866 g15751 i0 100 0.870967741935484 45 0 87.1 0 155 21 522 566 KRH92949.1 hypothetical protein M153_1976000584 [Pseudoloma neurophilia] diamond 135 80.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
29637341 29637341 PRJNA599208_P_NODE_13730_length_172_cov_1.133333_g13534_i0 PRJNA599208 13730 172 1.133333 1.94933276 Pseudoloma neurophilia 146866 Fungi Fungi 114 2.59e-28   NR KRH93141.1 146866 g13534 i0 98.2 0.976744186046512 56 1 97.7 0 170 3 88 143 KRH93141.1 hypothetical protein M153_14260002472 [Pseudoloma neurophilia] diamond 168 114 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
29763824 29763824 PRJNA599208_P_NODE_9991_length_216_cov_2.430168_g9795_i0 PRJNA599208 9991 216 2.430168 5.24916288 Pseudoloma neurophilia 146866 Fungi Fungi 128 2.36e-32   NR KRH94565.1 146866 g9795 i0 100 1 72 0 100 0 1 216 657 728 KRH94565.1 hypothetical protein M153_2090009003 [Pseudoloma neurophilia] diamond 216 128 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
31027939 31027939 PRJNA599208_P_NODE_13635_length_172_cov_2.296296_g13439_i0 PRJNA599208 13635 172 2.296296 3.94962912 Pseudoloma neurophilia 146866 Fungi Fungi 117 2.58e-29   NR KRH93612.1 146866 g13439 i0 100 0.994186046511628 57 0 99.4 0 171 1 4 60 KRH93612.1 peptide elongation factor 1 alpha [Pseudoloma neurophilia] diamond 171 117 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
32514689 32514689 PRJNA599208_P_NODE_4259_length_403_cov_1.658470_g4065_i0 PRJNA599208 4259 403 1.6584700000000001 6.6836341 Pseudoloma neurophilia 146866 Fungi Fungi 256 1.48e-76   NR KRH94565.1 146866 g4065 i0 100 0.997518610421836 134 0 99.8 0 2 403 271 404 KRH94565.1 hypothetical protein M153_2090009003 [Pseudoloma neurophilia] diamond 402 256 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
32609116 32609116 PRJNA599208_P_NODE_5480_length_337_cov_1.060000_g5284_i0 PRJNA599208 5480 337 1.06 3.5722 Pseudoloma neurophilia 146866 Fungi Fungi 89 2e-19   NR KRH93526.1 146866 g5284 i0 100 0.364985163204748 41 0 36.5 0 123 1 3 43 KRH93526.1 putative spore wall protein 2, partial [Pseudoloma neurophilia] diamond 123 89 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia

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