RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax_phylum = "Cryptomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cryptomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1118794 · 5 ✖

analysis 1

  • diamond · 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
7883818 7883818 PRJNA1118794_P_NODE_54487_length_249_cov_0.875000_g53737_i0 PRJNA1118794 54487 249 0.875 2.17875 Rozella allomycis CSF55 988480 Fungi Fungi 95.9 4.02e-21   NR EPZ32488.1 988480 g53737 i0 63.4 7.48192771084337 71 26 85.5 0 248 36 186 256 EPZ32488.1 Cyclic nucleotide-binding domain-containing protein [Rozella allomycis CSF55] diamond 1863 95.9 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
10433802 10433802 PRJNA1118794_P_NODE_1349_length_1263_cov_5.815966_g914_i0 PRJNA1118794 1349 1263 5.815966 73.45565058 Paramicrosporidium saccamoebae 1246581 Fungi Fungi 287 1.08e-91   NR PJF16902.1 1246581 g914 i0 64.4 5.85985748218527 236 81 55.8 3 1106 402 24 257 PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] diamond 7401 287 1 Eukaryota Opisthokonta Fungi Cryptomycota       Paramicrosporidium Paramicrosporidium saccamoebae
15533507 15533507 PRJNA1118794_P_NODE_5353_length_610_cov_2.152700_g4622_i0 PRJNA1118794 5353 610 2.1527 13.13147 Rozella allomycis CSF55 988480 Fungi Fungi 290 4.619999999999998e-96   NR EPZ33659.1 988480 g4622 i0 74.6 6.12295081967213 177 45 87 0 601 71 74 250 EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] diamond 3735 290 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
28647246 28647246 PRJNA1118794_P_NODE_64487_length_244_cov_5.304094_g63737_i0 PRJNA1118794 64487 244 5.304094 12.941989360000001 Rozella allomycis CSF55 988480 Fungi Fungi 82.8 5.13e-17   NR EPZ34692.1 988480 g63737 i0 66.2 3.86065573770492 65 21 78.7 1 18 209 190 254 EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] diamond 942 82.8 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
29373332 29373332 PRJNA1118794_P_NODE_4949_length_637_cov_1.567376_g4224_i0 PRJNA1118794 4949 637 1.567376 9.98418512 Paramicrosporidium saccamoebae 1246581 Fungi Fungi 94.4 1.96e-19   NR PJF20084.1 1246581 g4224 i0 41.7 0.54160125588697 115 66 54.2 1 437 93 46 159 PJF20084.1 hypothetical protein PSACC_00119 [Paramicrosporidium saccamoebae] diamond 345 94.4 1 Eukaryota Opisthokonta Fungi Cryptomycota       Paramicrosporidium Paramicrosporidium saccamoebae

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