contig_metadata
13 rows where bioproject = "PRJNA631119", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3703619 | 3703619 | PRJNA631119_P_NODE_5243_length_496_cov_4.026005_g5125_i0 | PRJNA631119 | 5243 | 496 | 4.026005 | 19.9689848 | Rozella | 276836 | Fungi | Fungi | 268 | 4.419999999999999e-67 | NTclustered | gi|82398068|gb|DQ273766.1| | 276837 | g5125 | i0 | 85.496 | 79.3991935483871 | 262 | 32 | 52 | 6 | 177 | 434 | 1969 | 1710 | Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence | blastn | 39382 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 5706824 | 5706824 | PRJNA631119_P_NODE_25065_length_273_cov_1.455000_g24947_i0 | PRJNA631119 | 25065 | 273 | 1.455 | 3.97215 | Fungi | 4751 | Fungi | Fungi | 140 | 9.02e-41 | NR | EPZ33627.1 | 988480 | g24947 | i0 | 73 | 12.7472527472527 | 89 | 24 | 97.8 | 0 | 267 | 1 | 24 | 112 | EPZ33627.1 2Fe-2S ferredoxin-type domain-containing protein [Rozella allomycis CSF55] | diamond | 3480 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 9531800 | 9531800 | PRJNA631119_P_NODE_40368_length_231_cov_5.639241_g40250_i0 | PRJNA631119 | 40368 | 231 | 5.639241 | 13.02664671 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 81.3 | 1.76e-16 | NR | EPZ34692.1 | 988480 | g40250 | i0 | 66.2 | 4.07792207792208 | 65 | 21 | 83.1 | 1 | 219 | 28 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 17181138 | 17181138 | PRJNA631119_P_NODE_10674_length_373_cov_4.360000_g10556_i0 | PRJNA631119 | 10674 | 373 | 4.36 | 16.2628 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 206 | 4.72e-65 | NR | EPZ33870.1 | 988480 | g10556 | i0 | 75.6 | 2.94369973190349 | 123 | 30 | 98.9 | 0 | 4 | 372 | 1 | 123 | EPZ33870.1 60S ribosomal protein L13a [Rozella allomycis CSF55] | diamond | 1098 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 18455234 | 18455234 | PRJNA631119_P_NODE_17395_length_312_cov_3.652720_g17277_i0 | PRJNA631119 | 17395 | 312 | 3.65272 | 11.3964864 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 162 | 1.4499999999999998e-48 | NR | PJF20044.1 | 1246581 | g17277 | i0 | 76.8 | 5.48076923076923 | 95 | 22 | 91.3 | 0 | 310 | 26 | 72 | 166 | PJF20044.1 hypothetical protein PSACC_00140 [Paramicrosporidium saccamoebae] | diamond | 1710 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 19729897 | 19729897 | PRJNA631119_P_NODE_40136_length_234_cov_3.366460_g40018_i0 | PRJNA631119 | 40136 | 234 | 3.36646 | 7.8775164 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 81.6 | 1.26e-16 | NR | EPZ34692.1 | 988480 | g40018 | i0 | 66.2 | 4.02564102564103 | 65 | 21 | 82.1 | 1 | 217 | 26 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 24829539 | 24829539 | PRJNA631119_P_NODE_35360_length_245_cov_3.825581_g35242_i0 | PRJNA631119 | 35360 | 245 | 3.825581 | 9.37267345 | Rozella sp. | 1932610 | Fungi | Fungi | 99 | 2.8e-16 | NTclustered | gi|2468791023|gb|OQ702923.1| | 1932610 | g35242 | i0 | 90.667 | 31.6938775510204 | 75 | 5 | 30 | 2 | 166 | 239 | 4117 | 4044 | 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 | 7765 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 24829582 | 24829582 | PRJNA631119_P_NODE_580_length_1224_cov_10.016507_g531_i0 | PRJNA631119 | 580 | 1224 | 10.016507 | 122.60204568 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 287 | 7.05e-92 | NR | PJF16902.1 | 1246581 | g531 | i0 | 64.4 | 6.04656862745098 | 236 | 81 | 57.6 | 3 | 165 | 869 | 24 | 257 | PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] | diamond | 7401 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27460245 | 27460245 | PRJNA631119_P_NODE_15143_length_329_cov_1.074219_g15025_i0 | PRJNA631119 | 15143 | 329 | 1.074219 | 3.53418051 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 47 | 0.00327 | NR | EPZ35014.1 | 988480 | g15025 | i0 | 34.4 | 0.875379939209726 | 96 | 41 | 87.5 | 2 | 9 | 296 | 603 | 676 | EPZ35014.1 Initiation factor eIF-4 gamma, MA3 domain-containing protein [Rozella allomycis CSF55] | diamond | 288 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27838833 | 27838833 | PRJNA631119_P_NODE_39924_length_237_cov_2.390244_g39806_i0 | PRJNA631119 | 39924 | 237 | 2.390244 | 5.66487828 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 137 | 1.18e-38 | NR | EPZ35492.1 | 988480 | g39806 | i0 | 89.7 | 28.6329113924051 | 78 | 8 | 98.7 | 0 | 3 | 236 | 1 | 78 | EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55] | diamond | 6786 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30080705 | 30080705 | PRJNA631119_P_NODE_23652_length_279_cov_1.985437_g23534_i0 | PRJNA631119 | 23652 | 279 | 1.985437 | 5.53936923 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 63.5 | 2.7e-9 | NR | EPZ31296.1 | 988480 | g23534 | i0 | 39.6 | 4.81720430107527 | 91 | 55 | 97.8 | 0 | 2 | 274 | 524 | 614 | EPZ31296.1 Ribosomal protein S3Ae domain-containing protein [Rozella allomycis CSF55] | diamond | 1344 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30143694 | 30143694 | PRJNA631119_P_NODE_10072_length_381_cov_8.694805_g9954_i0 | PRJNA631119 | 10072 | 381 | 8.694805 | 33.12720705 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 168 | 5.11e-51 | NR | EPZ31907.1 | 988480 | g9954 | i0 | 69.1 | 12.4015748031496 | 123 | 38 | 96.9 | 0 | 381 | 13 | 1 | 123 | EPZ31907.1 60S ribosomal protein L26-2 [Rozella allomycis CSF55] | diamond | 4725 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30460456 | 30460456 | PRJNA631119_P_NODE_29473_length_255_cov_2.939560_g29355_i0 | PRJNA631119 | 29473 | 255 | 2.93956 | 7.495878 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 114 | 8.86e-30 | NR | EPZ32213.1 | 988480 | g29355 | i0 | 57.3 | 0.964705882352941 | 82 | 35 | 96.5 | 0 | 9 | 254 | 1 | 82 | EPZ32213.1 60S ribosomal protein L20-B [Rozella allomycis CSF55] | diamond | 246 | 114 | 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);;