RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Cryptomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cryptomycota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
1054304 1054304 PRJNA168635_P_NODE_24181_length_171_cov_1.688525_g23765_i0 PRJNA168635 24181 171 1.688525 2.88737775 Rozella 276836 Fungi Fungi 217 4.8e-52   NTclustered gi|82398068|gb|DQ273766.1| 276837 g23765 i0 89.941 90.6959064327485 169 15 98 1 3 169 1602 1770 Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence blastn 15509 217 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp. JEL347
4191559 4191559 PRJNA168635_P_NODE_20584_length_180_cov_2.877863_g20168_i0 PRJNA168635 20584 180 2.877863 5.1801534 Rozella allomycis 281847 Fungi Fungi 117 5.34e-22   NTclustered gi|296035088|ref|NG_017174.1| 281847 g20168 i0 85.345 59.4444444444444 116 12 63 3 1 114 334 222 Rozella allomycis UCBMG BK 47-054 18S rRNA gene, partial sequence; from reference material blastn 10700 117 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
4191711 4191711 PRJNA168635_P_NODE_31384_length_162_cov_5.398230_g30968_i0 PRJNA168635 31384 162 5.39823 8.7451326 Cryptomycota sp. 2012228 Fungi Fungi 289 9.44e-74   NTclustered gi|2468791035|gb|OQ702926.1| 2012228 g30968 i0 99.371 96.7777777777778 159 1 98 0 1 159 1975 1817 Cryptomycota sp. isolate PSC258 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 15678 289 1 Eukaryota Opisthokonta Fungi Cryptomycota         Cryptomycota sp.
5467718 5467718 PRJNA168635_P_NODE_19325_length_184_cov_8.511111_g18909_i0 PRJNA168635 19325 184 8.511111 15.66044424 uncultured Cryptomycota 1130064 Fungi Fungi 340 2.99e-89   NTclustered gi|2086101831|gb|MZ923392.1| 1130064 g18909 i0 100 99.0054347826087 184 0 100 0 1 184 291 474 Uncultured Cryptomycota clone UMPB-875 small subunit ribosomal RNA gene, partial sequence blastn 18217 340 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota
5468010 5468010 PRJNA168635_P_NODE_5645_length_355_cov_15.774510_g5240_i0 PRJNA168635 5645 355 15.77451 55.9995105 uncultured Cryptomycota 1130064 Fungi Fungi 172 2.47e-38   NTclustered gi|665900118|dbj|AB971031.1| 1130064 g5240 i0 83.696 46.912676056338 184 29 52 1 1 184 763 581 Uncultured Cryptomycota gene for 18S ribosomal RNA, partial sequence, clone: Jp13Cm01E blastn 16654 172 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota
8017671 8017671 PRJNA168635_P_NODE_14527_length_211_cov_5.648148_g14111_i0 PRJNA168635 14527 211 5.648148 11.91759228 Rozella sp. 1932610 Fungi Fungi 108 3.9e-19   NTclustered gi|2468791040|gb|OQ702927.1| 1932610 g14111 i0 80.986 60.3222748815166 142 22 67 3 32 173 4228 4092 Rozella sp. isolate PSC259 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 12728 108 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp.
8017960 8017960 PRJNA168635_P_NODE_32647_length_161_cov_2.196429_g32231_i0 PRJNA168635 32647 161 2.196429 3.53625069 Cryptomycota sp. 2012228 Fungi Fungi 217 4.48e-52   NTclustered gi|2468791035|gb|OQ702926.1| 2012228 g32231 i0 93.197 0.91304347826087 147 10 91 0 15 161 2820 2674 Cryptomycota sp. isolate PSC258 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 147 217 1 Eukaryota Opisthokonta Fungi Cryptomycota         Cryptomycota sp.
9292450 9292450 PRJNA168635_P_NODE_16028_length_200_cov_1.801325_g15612_i0 PRJNA168635 16028 200 1.801325 3.60265 uncultured Cryptomycota 1130064 Fungi Fungi 313 7.22e-81   NTclustered gi|387156416|emb|HE806149.1| 1130064 g15612 i0 95 46.48 200 8 99 2 1 199 1372 1570 Uncultured Cryptomycota partial 26S rRNA gene, clone BcoYyyy3 blastn 9296 313 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota
10568317 10568317 PRJNA168635_P_NODE_10829_length_250_cov_4.034826_g10414_i0 PRJNA168635 10829 250 4.034826 10.087065 uncultured Cryptomycota 1130064 Fungi Fungi 411 3.239999999999999e-110   NTclustered gi|2086101684|gb|MZ923245.1| 1130064 g10414 i0 97.51 89.292 241 4 96 2 11 250 239 478 Uncultured Cryptomycota clone UMPB-2124 small subunit ribosomal RNA gene, partial sequence blastn 22323 411 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota
14393787 14393787 PRJNA168635_P_NODE_35492_length_151_cov_4.264706_g35076_i0 PRJNA168635 35492 151 4.264706 6.43970606 Rozella sp. 1932610 Fungi Fungi 95.3 2.02e-15   NTclustered gi|2468790814|gb|OQ702856.1| 1932610 g35076 i0 91.304 50.4503311258278 69 6 46 0 19 87 3994 4062 Rozella sp. isolate PSC038 internal transcribed spacer region, partial sequence blastn 7618 95.3 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp.
15081807 15081807 PRJNA168635_P_NODE_22332_length_175_cov_3.460317_g21916_i0 PRJNA168635 22332 175 3.460317 6.05555475 Eukaryota 2759 Fungi Fungi 89.8 1.12e-13   NTclustered gi|82398068|gb|DQ273766.1| 276837 g21916 i0 100 26.6457142857143 48 0 27 0 1 48 2614 2567 Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence blastn 4663 89.8 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp. JEL347
15667557 15667557 PRJNA168635_P_NODE_5533_length_359_cov_21.187097_g5128_i0 PRJNA168635 5533 359 21.187097 76.06167823 Rozella sp. 1932610 Fungi Fungi 154 9.06e-33   NTclustered gi|2468791040|gb|OQ702927.1| 1932610 g5128 i0 80.184 52.4345403899721 217 33 60 6 138 352 4099 4307 Rozella sp. isolate PSC259 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 18824 154 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp.
16941485 16941485 PRJNA168635_P_NODE_11014_length_247_cov_12.959596_g10599_i0 PRJNA168635 11014 247 12.959596 32.01020212 Rozella sp. 1932610 Fungi Fungi 185 2.11e-42   NTclustered gi|2468791023|gb|OQ702923.1| 1932610 g10599 i0 87.975 55.2267206477733 158 17 64 2 8 164 4360 4204 Rozella sp. isolate PSC249 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 13641 185 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp.
16941568 16941568 PRJNA168635_P_NODE_14994_length_207_cov_344.037975_g14578_i0 PRJNA168635 14994 207 344.037975 712.15860825 Cryptomycota sp. 2012228 Fungi Fungi 104 4.93e-18   NTclustered gi|2468791071|gb|OQ702935.1| 2012228 g14578 i0 95.455 30.8937198067633 66 1 31 2 1 64 4136 4201 Cryptomycota sp. isolate PSC281 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 6395 104 1 Eukaryota Opisthokonta Fungi Cryptomycota         Cryptomycota sp.
18216361 18216361 PRJNA168635_P_NODE_34595_length_154_cov_3.104762_g34179_i0 PRJNA168635 34595 154 3.104762 4.78133348 uncultured Cryptomycota 1130064 Fungi Fungi 268 1.15e-67   NTclustered gi|387155804|emb|HE806177.1| 1130064 g34179 i0 98.052 78.2402597402597 154 3 100 0 1 154 1210 1363 Uncultured Cryptomycota partial 26S rRNA gene, clone Bcomple6 blastn 12049 268 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota

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