contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8825453 | 8825453 | PRJNA682078_P_NODE_189587_length_269_cov_1.428571_g187810_i0 | PRJNA682078 | 189587 | 269 | 1.428571 | 3.84285599 | Rhizopus | 4842 | Fungi | Fungi | 181 | 4.29e-56 | NR | KAG1255229.1 | 58291 | g187810 | i0 | 98.9 | 3.95910780669145 | 88 | 1 | 98.1 | 0 | 266 | 3 | 20 | 107 | KAG1255229.1 hypothetical protein G6F68_010478 [Rhizopus microsporus] | diamond | 1065 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 22339338 | 22339338 | PRJNA682078_P_NODE_279698_length_242_cov_2.479290_g277921_i0 | PRJNA682078 | 279698 | 242 | 2.47929 | 5.9998818 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 176 | 2.02e-51 | NR | KAG0954862.1 | 64495 | g277921 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 2 | 241 | 9 | 88 | KAG0954862.1 hypothetical protein G6F31_013031 [Rhizopus arrhizus] | diamond | 240 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 27018789 | 27018789 | PRJNA682078_P_NODE_194022_length_266_cov_2.005181_g192245_i0 | PRJNA682078 | 194022 | 266 | 2.005181 | 5.33378146 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 171 | 4.06e-51 | NR | KAG0934770.1 | 64495 | g192245 | i0 | 100 | 1.93984962406015 | 86 | 0 | 97 | 0 | 8 | 265 | 1 | 86 | KAG0934770.1 hypothetical protein G6F31_016048 [Rhizopus arrhizus] | diamond | 516 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 27524429 | 27524429 | PRJNA682078_P_NODE_189683_length_269_cov_1.362245_g187906_i0 | PRJNA682078 | 189683 | 269 | 1.362245 | 3.66443905 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 90.9 | 5.7e-19 | NR | XP_069248817.1 | 911321 | g187906 | i0 | 60.3 | 5.02973977695167 | 63 | 25 | 70.3 | 0 | 243 | 55 | 214 | 276 | XP_069248817.1 uncharacterized protein VTP21DRAFT_3938 [Calcarisporiella thermophila] | diamond | 1353 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 27871677 | 27871677 | PRJNA682078_P_NODE_109785_length_338_cov_1.162264_g108008_i0 | PRJNA682078 | 109785 | 338 | 1.162264 | 3.92845232 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 99 | 1.36e-24 | NR | KAG1241904.1 | 64495 | g108008 | i0 | 79.7 | 0.612426035502959 | 69 | 14 | 61.2 | 0 | 15 | 221 | 5 | 73 | KAG1241904.1 hypothetical protein G6F65_023287 [Rhizopus arrhizus] | diamond | 207 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 28356922 | 28356922 | PRJNA682078_P_NODE_218866_length_252_cov_1.765363_g217089_i0 | PRJNA682078 | 218866 | 252 | 1.765363 | 4.44871476 | root | 1 | Root_unresolved | Root_unresolved | 170 | 8.85e-53 | NR | KAG1246182.1 | 64495 | g217089 | i0 | 98.8 | 2.96428571428571 | 83 | 1 | 98.8 | 0 | 250 | 2 | 1 | 83 | KAG1246182.1 hypothetical protein G6F65_020823 [Rhizopus arrhizus] | diamond | 747 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 28629709 | 28629709 | PRJNA682078_P_NODE_144927_length_299_cov_1.482301_g143150_i0 | PRJNA682078 | 144927 | 299 | 1.482301 | 4.43207999 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 210 | 2.08e-67 | NR | KAG1436200.1 | 64495 | g143150 | i0 | 100 | 0.953177257525084 | 95 | 0 | 95.3 | 0 | 286 | 2 | 1 | 95 | KAG1436200.1 hypothetical protein G6F57_020773 [Rhizopus arrhizus] | diamond | 285 | 210 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 28787214 | 28787214 | PRJNA682078_P_NODE_261807_length_245_cov_0.895349_g260030_i0 | PRJNA682078 | 261807 | 245 | 0.895349 | 2.19360505 | Parasitella parasitica | 35722 | Fungi | Fungi | 104 | 2.6200000000000003e-27 | NR | KAI8637104.1 | 35722 | g260030 | i0 | 86 | 0.697959183673469 | 57 | 8 | 69.8 | 0 | 235 | 65 | 16 | 72 | KAI8637104.1 hypothetical protein BD408DRAFT_425109, partial [Parasitella parasitica] | diamond | 171 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Parasitella | Parasitella parasitica | |
| 28830525 | 28830525 | PRJNA682078_P_NODE_205548_length_260_cov_1.122995_g203771_i0 | PRJNA682078 | 205548 | 260 | 1.122995 | 2.919787 | root | 1 | Root_unresolved | Root_unresolved | 168 | 7.5e-52 | NR | KAG1166952.1 | 64495 | g203771 | i0 | 98.8 | 1.98461538461538 | 86 | 1 | 99.2 | 0 | 3 | 260 | 37 | 122 | KAG1166952.1 hypothetical protein G6F35_017899 [Rhizopus arrhizus] | diamond | 516 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 29714373 | 29714373 | PRJNA682078_P_NODE_288510_length_241_cov_0.916667_g286733_i0 | PRJNA682078 | 288510 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Fungi | Fungi | 90.5 | 5.79e-19 | NR | KAG2173106.1 | 91625 | g286733 | i0 | 69.5 | 22.8921161825726 | 59 | 18 | 73.4 | 0 | 240 | 64 | 821 | 879 | KAG2173106.1 hypothetical protein INT43_004479 [Umbelopsis isabellina] | diamond | 5517 | 91.3 | 0.991237677984666 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 30599150 | 30599150 | PRJNA682078_P_NODE_235033_length_249_cov_1.011364_g233256_i0 | PRJNA682078 | 235033 | 249 | 1.011364 | 2.51829636 | root | 1 | Root_unresolved | Root_unresolved | 93.2 | 6.34e-22 | NR | KAG1319254.1 | 64495 | g233256 | i0 | 69.5 | 1.95180722891566 | 82 | 25 | 98.8 | 0 | 247 | 2 | 10 | 91 | KAG1319254.1 hypothetical protein G6F63_014828 [Rhizopus arrhizus] | diamond | 486 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 30871905 | 30871905 | PRJNA682078_P_NODE_232254_length_250_cov_0.870056_g230477_i0 | PRJNA682078 | 232254 | 250 | 0.870056 | 2.17514 | Umbelopsis isabellina | 91625 | Fungi | Fungi | 62 | 6.48e-9 | NR | KAG2173626.1 | 91625 | g230477 | i0 | 45 | 1.98 | 60 | 30 | 68.4 | 1 | 248 | 78 | 797 | 856 | KAG2173626.1 hypothetical protein INT43_005044 [Umbelopsis isabellina] | diamond | 495 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 30903633 | 30903633 | PRJNA682078_P_NODE_226994_length_250_cov_2.067797_g225217_i0 | PRJNA682078 | 226994 | 250 | 2.067797 | 5.1694925 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 165 | 4.36e-50 | NR | KAG0924110.1 | 64495 | g225217 | i0 | 97.6 | 2.988 | 83 | 2 | 99.6 | 0 | 2 | 250 | 47 | 129 | KAG0924110.1 hypothetical protein G6F31_019237 [Rhizopus arrhizus] | diamond | 747 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 31199167 | 31199167 | PRJNA682078_P_NODE_277295_length_243_cov_0.905882_g275518_i0 | PRJNA682078 | 277295 | 243 | 0.905882 | 2.20129326 | Mucoromycota | 1913637 | Fungi | Fungi | 52.4 | 1.65e-6 | NR | KAG2177529.1 | 44442 | g275518 | i0 | 75.9 | 4.76543209876543 | 29 | 7 | 35.8 | 0 | 241 | 155 | 66 | 94 | KAG2177529.1 hypothetical protein INT44_008041 [Umbelopsis vinacea] | diamond | 1158 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis vinacea | |
| 31484494 | 31484494 | PRJNA682078_P_NODE_270276_length_244_cov_0.900585_g268499_i0 | PRJNA682078 | 270276 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 176 | 3.4899999999999995e-54 | NR | KAG1245921.1 | 58291 | g268499 | i0 | 100 | 2.98770491803279 | 81 | 0 | 99.6 | 0 | 1 | 243 | 83 | 163 | KAG1245921.1 hypothetical protein G6F68_014858 [Rhizopus microsporus] | diamond | 729 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 32401825 | 32401825 | PRJNA682078_P_NODE_227379_length_250_cov_1.711864_g225602_i0 | PRJNA682078 | 227379 | 250 | 1.711864 | 4.27966 | root | 1 | Root_unresolved | Root_unresolved | 144 | 3.1499999999999992e-40 | NR | KAG1254206.1 | 64495 | g225602 | i0 | 98.6 | 1.776 | 74 | 1 | 88.8 | 0 | 223 | 2 | 75 | 148 | KAG1254206.1 hypothetical protein G6F65_017138 [Rhizopus arrhizus] | diamond | 444 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus |
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);;