contig_metadata
9 rows where bioproject = "PRJNA911178", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3443818 | 3443818 | PRJNA911178_P_NODE_305563_length_226_cov_2.490196_g303089_i0 | PRJNA911178 | 305563 | 226 | 2.490196 | 5.62784296 | uncultured Cryptomycota | 1130064 | Fungi | Fungi | 75 | 4.29e-9 | NTclustered | gi|387155805|emb|HE806178.1| | 1130064 | g303089 | i0 | 100 | 3.34070796460177 | 40 | 0 | 18 | 0 | 2 | 41 | 1813 | 1852 | Uncultured Cryptomycota partial 26S rRNA gene, clone Bcomple7 | blastn | 755 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | uncultured Cryptomycota | |||||
| 10178910 | 10178910 | PRJNA911178_P_NODE_290888_length_241_cov_1.761905_g288414_i0 | PRJNA911178 | 290888 | 241 | 1.761905 | 4.24619105 | Rozella | 276836 | Fungi | Fungi | 110 | 1.27e-19 | NTclustered | gi|82398068|gb|DQ273766.1| | 276837 | g288414 | i0 | 76.543 | 41.3360995850622 | 243 | 32 | 99 | 15 | 3 | 241 | 1636 | 1857 | Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence | blastn | 9962 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 16195335 | 16195335 | PRJNA911178_P_NODE_24853_length_677_cov_6.198675_g22569_i0 | PRJNA911178 | 24853 | 677 | 6.198675 | 41.96502975 | Eukaryota | 2759 | Fungi | Fungi | 360 | 2.2400000000000003e-123 | NR | EPZ33659.1 | 988480 | g22569 | i0 | 76.9 | 17.8847858197932 | 212 | 49 | 93.9 | 0 | 638 | 3 | 1 | 212 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 12108 | 360 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 18743415 | 18743415 | PRJNA911178_P_NODE_171055_length_288_cov_1.758140_g168582_i0 | PRJNA911178 | 171055 | 288 | 1.75814 | 5.0634432 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 142 | 8.46e-37 | NR | PJF19132.1 | 1246581 | g168582 | i0 | 73.9 | 0.958333333333333 | 92 | 24 | 95.8 | 0 | 278 | 3 | 105 | 196 | PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 276 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 18745181 | 18745181 | PRJNA911178_P_NODE_9435_length_1080_cov_3.396226_g7870_i0 | PRJNA911178 | 9435 | 1080 | 3.396226 | 36.6792408 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 553 | 1.36e-187 | NR | PJF19132.1 | 1246581 | g7870 | i0 | 83.1 | 0.988888888888889 | 356 | 59 | 98.9 | 1 | 11 | 1078 | 381 | 735 | PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 1068 | 553 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28066739 | 28066739 | PRJNA911178_P_NODE_123785_length_330_cov_3.260700_g121313_i0 | PRJNA911178 | 123785 | 330 | 3.2607 | 10.76031 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 78.2 | 3.67e-14 | NR | PJF18591.1 | 1246581 | g121313 | i0 | 37.8 | 1.98181818181818 | 111 | 62 | 97.3 | 3 | 8 | 328 | 455 | 562 | PJF18591.1 ABC-2 type transporter domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 654 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31161633 | 31161633 | PRJNA911178_P_NODE_266775_length_246_cov_0.890173_g264301_i0 | PRJNA911178 | 266775 | 246 | 0.890173 | 2.18982558 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 57.8 | 1.93e-7 | NR | PJF19671.1 | 1246581 | g264301 | i0 | 35 | 0.975609756097561 | 80 | 50 | 95.1 | 1 | 235 | 2 | 310 | 389 | PJF19671.1 Integral membrane protein [Paramicrosporidium saccamoebae] | diamond | 240 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31510000 | 31510000 | PRJNA911178_P_NODE_88696_length_380_cov_1.482085_g86226_i0 | PRJNA911178 | 88696 | 380 | 1.482085 | 5.631923 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 172 | 4.249999999999999e-47 | NR | PJF19132.1 | 1246581 | g86226 | i0 | 69.6 | 0.986842105263158 | 125 | 36 | 98.7 | 1 | 378 | 4 | 735 | 857 | PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 375 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32900139 | 32900139 | PRJNA911178_P_NODE_75340_length_407_cov_6.326347_g72877_i0 | PRJNA911178 | 75340 | 407 | 6.326347 | 25.74823229 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 159 | 3.1399999999999997e-47 | NR | EPZ31907.1 | 988480 | g72877 | i0 | 68 | 2.79361179361179 | 125 | 39 | 92.1 | 1 | 33 | 407 | 1 | 124 | EPZ31907.1 60S ribosomal protein L26-2 [Rozella allomycis CSF55] | diamond | 1137 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis |
Advanced export
JSON shape: default, array, newline-delimited
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);;