contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2217688 | 2217688 | PRJNA966993_P_NODE_66422_length_275_cov_2.079208_g65970_i0 | PRJNA966993 | 66422 | 275 | 2.079208 | 5.717822 | Vittaforma corneae | 42399 | Fungi | Fungi | 224 | 5.059999999999999e-54 | NTclustered | gi|667641093|ref|XM_007604801.1| | 993615 | g65970 | i0 | 81.784 | 0.978181818181818 | 269 | 47 | 97 | 2 | 8 | 275 | 46 | 313 | Vittaforma corneae ATCC 50505 ribosomal protein L22 (VICG_01417), partial mRNA | blastn | 269 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 6045321 | 6045321 | PRJNA966993_P_NODE_35585_length_359_cov_1.475524_g35133_i0 | PRJNA966993 | 35585 | 359 | 1.475524 | 5.29713116 | Vittaforma corneae | 42399 | Fungi | Fungi | 322 | 2.35e-83 | NTclustered | gi|667638812|ref|XM_007603663.1| | 993615 | g35133 | i0 | 83.008 | 1 | 359 | 57 | 99 | 4 | 3 | 359 | 25 | 381 | Vittaforma corneae ATCC 50505 ribosomal protein L10.e (VICG_00272), partial mRNA | blastn | 359 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 8595241 | 8595241 | PRJNA966993_P_NODE_50347_length_305_cov_6.413793_g49895_i0 | PRJNA966993 | 50347 | 305 | 6.413793 | 19.56206865 | uncultured Microsporidia | 546760 | Fungi | Fungi | 484 | 2.3699999999999996e-132 | NTclustered | gi|374706411|gb|JN619406.1| | 546760 | g49895 | i0 | 95.695 | 99.6491803278688 | 302 | 11 | 99 | 2 | 5 | 305 | 330 | 30 | Uncultured Microsporidia clone Chula_Myositis 1 small subunit ribosomal RNA gene, partial sequence | blastn | 30393 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 8595348 | 8595348 | PRJNA966993_P_NODE_62327_length_281_cov_1.918269_g61875_i0 | PRJNA966993 | 62327 | 281 | 1.918269 | 5.39033589 | Vittaforma corneae | 42399 | Fungi | Fungi | 364 | 2.929999999999999e-96 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g61875 | i0 | 91.386 | 21.3701067615658 | 267 | 21 | 95 | 2 | 16 | 281 | 1789 | 2054 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6005 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 9870363 | 9870363 | PRJNA966993_P_NODE_44788_length_322_cov_2.975904_g44336_i0 | PRJNA966993 | 44788 | 322 | 2.975904 | 9.58241088 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 265 | 3.57e-66 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g44336 | i0 | 82.943 | 99.5031055900621 | 299 | 45 | 92 | 6 | 1 | 296 | 5146 | 5441 | Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, 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 | 32040 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 11146100 | 11146100 | PRJNA966993_P_NODE_76129_length_260_cov_4.577540_g75677_i0 | PRJNA966993 | 76129 | 260 | 4.57754 | 11.901604 | Microsporidium sp. PL03 | 3072851 | Fungi | Fungi | 366 | 7.45e-97 | NTclustered | gi|2571792811|gb|OR500624.1| | 3072851 | g75677 | i0 | 92.578 | 99.0230769230769 | 256 | 17 | 98 | 2 | 2 | 256 | 849 | 1103 | Microsporidium sp. PL03 isolate AT.p2G4 small subunit ribosomal RNA gene, partial sequence | blastn | 25746 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. PL03 | ||||
| 12421023 | 12421023 | PRJNA966993_P_NODE_14910_length_542_cov_2.665245_g14468_i0 | PRJNA966993 | 14910 | 542 | 2.665245 | 14.4456279 | Vittaforma corneae | 42399 | Fungi | Fungi | 244 | 8.19e-60 | NTclustered | gi|667641753|ref|XM_007605131.1| | 993615 | g14468 | i0 | 82.847 | 0.505535055350554 | 274 | 45 | 50 | 2 | 256 | 528 | 687 | 415 | Vittaforma corneae ATCC 50505 uncharacterized protein (VICG_01748), partial mRNA | blastn | 274 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 13696048 | 13696048 | PRJNA966993_P_NODE_67691_length_273_cov_2.625000_g67239_i0 | PRJNA966993 | 67691 | 273 | 2.625 | 7.16625 | Vittaforma corneae | 42399 | Fungi | Fungi | 248 | 2.98e-61 | NTclustered | gi|667639228|ref|XM_007603871.1| | 993615 | g67239 | i0 | 83.15 | 1 | 273 | 44 | 99 | 2 | 1 | 272 | 293 | 22 | Vittaforma corneae ATCC 50505 uncharacterized protein (VICG_00481), partial mRNA | blastn | 273 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 16244773 | 16244773 | PRJNA966993_P_NODE_16233_length_519_cov_4.733184_g15791_i0 | PRJNA966993 | 16233 | 519 | 4.733184 | 24.56522496 | uncultured Microsporidia | 546760 | Fungi | Fungi | 745 | 0 | NTclustered | gi|374706411|gb|JN619406.1| | 546760 | g15791 | i0 | 94.781 | 99.7398843930636 | 479 | 23 | 92 | 2 | 42 | 519 | 797 | 320 | Uncultured Microsporidia clone Chula_Myositis 1 small subunit ribosomal RNA gene, partial sequence | blastn | 51765 | 745 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 16245056 | 16245056 | PRJNA966993_P_NODE_49853_length_307_cov_1.799145_g49401_i0 | PRJNA966993 | 49853 | 307 | 1.799145 | 5.52337515 | Vittaforma corneae | 42399 | Fungi | Fungi | 228 | 4.429999999999999e-55 | NTclustered | gi|667641253|ref|XM_007604881.1| | 993615 | g49401 | i0 | 81.404 | 0.928338762214984 | 285 | 47 | 92 | 5 | 1 | 282 | 21 | 302 | Vittaforma corneae ATCC 50505 uncharacterized protein (VICG_01497), partial mRNA | blastn | 285 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 17519960 | 17519960 | PRJNA966993_P_NODE_1434_length_1574_cov_6.513658_g1279_i0 | PRJNA966993 | 1434 | 1574 | 6.513658 | 102.52497692 | Vittaforma corneae | 42399 | Fungi | Fungi | 1890 | 0 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g1279 | i0 | 88.387 | 11.289707750953 | 1593 | 155 | 100 | 27 | 1 | 1574 | 1594 | 13 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 17770 | 1890 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae |
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);;