contig_metadata
13 rows where bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2680622 | 2680622 | PRJEB66218_P_NODE_106763_length_294_cov_4.381974_g104334_i0 | PRJEB66218 | 106763 | 294 | 4.381974 | 12.88300356 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 228 | 4.219999999999999e-55 | NTclustered | gi|2468790980|gb|OQ702912.1| | 2012228 | g104334 | i0 | 83.2 | 47.5170068027211 | 250 | 41 | 85 | 1 | 45 | 294 | 3811 | 4059 | Cryptomycota sp. isolate PSC211 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 | 13970 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 3957363 | 3957363 | PRJEB66218_P_NODE_142664_length_248_cov_1.759358_g140235_i0 | PRJEB66218 | 142664 | 248 | 1.759358 | 4.36320784 | Rozella sp. | 1932610 | Fungi | Fungi | 104 | 6.11e-18 | NTclustered | gi|2468791023|gb|OQ702923.1| | 1932610 | g140235 | i0 | 92 | 40.3870967741936 | 75 | 4 | 30 | 2 | 145 | 218 | 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 | 10016 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 10337556 | 10337556 | PRJEB66218_P_NODE_85889_length_337_cov_2.688406_g83462_i0 | PRJEB66218 | 85889 | 337 | 2.688406 | 9.05992822 | Eukaryota | 2759 | Fungi | Fungi | 176 | 1.7799999999999998e-54 | NR | EPZ30830.1 | 988480 | g83462 | i0 | 81.1 | 8.59940652818991 | 106 | 20 | 94.4 | 0 | 337 | 20 | 28 | 133 | EPZ30830.1 Histone H2A [Rozella allomycis CSF55] | diamond | 2898 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 11612216 | 11612216 | PRJEB66218_P_NODE_54070_length_455_cov_1.548223_g51651_i0 | PRJEB66218 | 54070 | 455 | 1.548223 | 7.04441465 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 229 | 3.28e-74 | NR | PJF20044.1 | 1246581 | g51651 | i0 | 76.9 | 0.969230769230769 | 147 | 34 | 96.9 | 0 | 1 | 441 | 20 | 166 | PJF20044.1 hypothetical protein PSACC_00140 [Paramicrosporidium saccamoebae] | diamond | 441 | 229 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 17982388 | 17982388 | PRJEB66218_P_NODE_122355_length_271_cov_4.438095_g119926_i0 | PRJEB66218 | 122355 | 271 | 4.438095 | 12.02723745 | Rozella sp. JEL347 | 276837 | Fungi | Fungi | 80.5 | 1.14e-10 | NTclustered | gi|82398068|gb|DQ273766.1| | 276837 | g119926 | i0 | 92.727 | 0.328413284132841 | 55 | 4 | 20 | 0 | 1 | 55 | 62 | 8 | Rozella sp. JEL347 isolate AFTOL-ID 16 28S ribosomal RNA gene, partial sequence | blastn | 89 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. JEL347 | ||||
| 19258116 | 19258116 | PRJEB66218_P_NODE_22016_length_823_cov_2.581365_g19889_i0 | PRJEB66218 | 22016 | 823 | 2.581365 | 21.24463395 | root | 1 | Root_unresolved | Root_unresolved | 233 | 1.5e-69 | NR | RKP20138.1 | 988480 | g19889 | i0 | 60.2 | 9.91494532199271 | 196 | 76 | 70.7 | 1 | 583 | 2 | 15 | 210 | RKP20138.1 pyruvate kinase [Rozella allomycis CSF55] | diamond | 8160 | 234 | 0.995726495726496 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 20533316 | 20533316 | PRJEB66218_P_NODE_210297_length_208_cov_1.333333_g207867_i0 | PRJEB66218 | 210297 | 208 | 1.333333 | 2.77333264 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 135 | 7.729999999999998e-35 | NR | PJF19231.1 | 1246581 | g207867 | i0 | 87 | 0.995192307692308 | 69 | 9 | 99.5 | 0 | 207 | 1 | 1217 | 1285 | PJF19231.1 Aminoacyl-tRNA synthetase, class Ia domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 207 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28076310 | 28076310 | PRJEB66218_P_NODE_97745_length_311_cov_1.252000_g95317_i0 | PRJEB66218 | 97745 | 311 | 1.252 | 3.89372 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 74.3 | 5.74e-13 | NR | EPZ32488.1 | 988480 | g95317 | i0 | 63.8 | 0.559485530546624 | 58 | 20 | 55.9 | 1 | 310 | 137 | 340 | 396 | EPZ32488.1 Cyclic nucleotide-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 174 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29876110 | 29876110 | PRJEB66218_P_NODE_128471_length_264_cov_1.113300_g126042_i0 | PRJEB66218 | 128471 | 264 | 1.1133 | 2.939112 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 98.2 | 1.5300000000000002e-21 | NR | PJF19231.1 | 1246581 | g126042 | i0 | 55.3 | 0.965909090909091 | 85 | 36 | 96.6 | 1 | 256 | 2 | 1492 | 1574 | PJF19231.1 Aminoacyl-tRNA synthetase, class Ia domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 255 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30160232 | 30160232 | PRJEB66218_P_NODE_63092_length_411_cov_2.862857_g60670_i0 | PRJEB66218 | 63092 | 411 | 2.862857 | 11.76634227 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 50.8 | 3.59e-4 | NR | EPZ35544.1 | 988480 | g60670 | i0 | 31.2 | 0.795620437956204 | 109 | 73 | 78.8 | 2 | 82 | 405 | 636 | 743 | EPZ35544.1 Lipoxygenase, LH2 domain-containing protein [Rozella allomycis CSF55] | diamond | 327 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30413426 | 30413426 | PRJEB66218_P_NODE_136133_length_255_cov_1.340206_g133704_i0 | PRJEB66218 | 136133 | 255 | 1.340206 | 3.4175253 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 45.1 | 0.00675 | NR | EPZ35357.1 | 988480 | g133704 | i0 | 39.2 | 0.870588235294118 | 74 | 41 | 82.4 | 1 | 1 | 210 | 524 | 597 | EPZ35357.1 78 kDa glucose-regulated-like protein [Rozella allomycis CSF55] | diamond | 222 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30974901 | 30974901 | PRJEB66218_P_NODE_207734_length_209_cov_0.878378_g205304_i0 | PRJEB66218 | 207734 | 209 | 0.878378 | 1.83581002 | Fungi | 4751 | Fungi | Fungi | 107 | 4.05e-25 | NR | PJF19119.1 | 1246581 | g205304 | i0 | 78.1 | 8.51196172248804 | 64 | 14 | 91.9 | 0 | 194 | 3 | 22 | 85 | PJF19119.1 4-hydroxyphenylpyruvate dioxygenase [Paramicrosporidium saccamoebae] | diamond | 1779 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32720806 | 32720806 | PRJEB66218_P_NODE_11920_length_1241_cov_3.336441_g10333_i0 | PRJEB66218 | 11920 | 1241 | 3.336441 | 41.40523281 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 284 | 1.95e-90 | NR | PJF16902.1 | 1246581 | g10333 | i0 | 64 | 9.99838839645447 | 236 | 82 | 56.8 | 3 | 1079 | 375 | 24 | 257 | PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] | diamond | 12408 | 284 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae |
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);;