contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153543 | 153543 | PRJNA1005695_P_NODE_28861_length_278_cov_1.629268_g28009_i0 | PRJNA1005695 | 28861 | 278 | 1.629268 | 4.52936504 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 453 | 5.999999999999999e-123 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g28009 | i0 | 96.39 | 22.0143884892086 | 277 | 6 | 99 | 2 | 2 | 278 | 5462 | 5734 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6120 | 453 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 153676 | 153676 | PRJNA1005695_P_NODE_4821_length_725_cov_32.984663_g4050_i0 | PRJNA1005695 | 4821 | 725 | 32.984663 | 239.13880675 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 990 | 0 | NTclustered | gi|443299290|gb|JX101955.1| | 1284676 | g4050 | i0 | 91.153 | 28.2537931034483 | 746 | 42 | 99 | 23 | 1 | 724 | 744 | 1 | Endolimax piscium clone PM2 18S ribosomal RNA gene, partial sequence | blastn | 20484 | 990 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 1428232 | 1428232 | PRJNA1005695_P_NODE_24362_length_304_cov_1.705628_g23510_i0 | PRJNA1005695 | 24362 | 304 | 1.705628 | 5.18510912 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 254 | 7.24e-63 | NTclustered | gi|304308758|gb|HM853710.1| | 497998 | g23510 | i0 | 82.237 | 57.3519736842105 | 304 | 44 | 98 | 10 | 4 | 302 | 351 | 53 | Arcella hemisphaerica strain blue&red clone act23 actin gene, partial cds | blastn | 17435 | 254 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 2703590 | 2703590 | PRJNA1005695_P_NODE_11243_length_462_cov_66.709512_g10391_i0 | PRJNA1005695 | 11243 | 462 | 66.709512 | 308.19794544 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 191 | 9.11e-44 | NTclustered | gi|173717|gb|M19222.1|AMPRRM | 5775 | g10391 | i0 | 81.78 | 35.95670995671 | 236 | 36 | 50 | 6 | 106 | 338 | 417 | 186 | A.proteus 28S large subunit rRNA, 5' end | blastn | 16612 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 5256379 | 5256379 | PRJNA1005695_P_NODE_20325_length_334_cov_9.160920_g19473_i0 | PRJNA1005695 | 20325 | 334 | 9.16092 | 30.5974728 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 294 | 4.74e-75 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g19473 | i0 | 88.259 | 3.01796407185629 | 247 | 28 | 74 | 1 | 86 | 331 | 812 | 1058 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 1008 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 5256583 | 5256583 | PRJNA1005695_P_NODE_5325_length_687_cov_41.035831_g4516_i0 | PRJNA1005695 | 5325 | 687 | 41.035831 | 281.91615897 | Vannella croatica | 1778588 | Discosea | other_Eukaryota | 1221 | 0 | NTclustered | gi|973761167|gb|KT345693.1| | 1778588 | g4516 | i0 | 98.834 | 82.4425036390102 | 686 | 6 | 99 | 2 | 2 | 686 | 523 | 1207 | Vannella croatica isolate KRKA 29.9.7.6.1 small subunit ribosomal RNA gene, partial sequence | blastn | 56638 | 1221 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella croatica | |||
| 7806214 | 7806214 | PRJNA1005695_P_NODE_42447_length_206_cov_4.654135_g41595_i0 | PRJNA1005695 | 42447 | 206 | 4.654135 | 9.5875181 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 215 | 2.17e-51 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g41595 | i0 | 87.568 | 10.2184466019417 | 185 | 23 | 90 | 0 | 21 | 205 | 1946 | 1762 | D.iridis LSU rRNA gene | blastn | 2105 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 8654222 | 8654222 | PRJNA1005695_P_NODE_22567_length_316_cov_1.683128_g21715_i0 | PRJNA1005695 | 22567 | 316 | 1.683128 | 5.31868448 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 4.579999999999999e-55 | NTclustered | gi|1914009752|gb|MT975626.1| | 1017091 | g21715 | i0 | 79.874 | 91.0284810126582 | 318 | 58 | 99 | 3 | 5 | 316 | 449 | 132 | Cochliopodium larifeili cytochrome C oxidase subunit 1 gene, partial cds; mitochondrial | blastn | 28765 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 9081049 | 9081049 | PRJNA1005695_P_NODE_33148_length_259_cov_1.059140_g32296_i0 | PRJNA1005695 | 33148 | 259 | 1.05914 | 2.7431726 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 243 | 1.3e-59 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g32296 | i0 | 86.425 | 83.4864864864865 | 221 | 30 | 85 | 0 | 37 | 257 | 633 | 413 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 21623 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 12907180 | 12907180 | PRJNA1005695_P_NODE_21891_length_321_cov_2.262097_g21039_i0 | PRJNA1005695 | 21891 | 321 | 2.262097 | 7.26133137 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 497 | 3.22e-136 | NTclustered | gi|365928255|gb|JN825705.1| | 590481 | g21039 | i0 | 99.632 | 69.1121495327103 | 272 | 1 | 85 | 0 | 50 | 321 | 748 | 1019 | Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence | blastn | 22185 | 497 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 14182272 | 14182272 | PRJNA1005695_P_NODE_35172_length_252_cov_0.871508_g34320_i0 | PRJNA1005695 | 35172 | 252 | 0.871508 | 2.19620016 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 466 | 6.89e-127 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g34320 | i0 | 100 | 101.071428571429 | 252 | 0 | 100 | 0 | 1 | 252 | 2699 | 2448 | Paravannella minima mitochondrion, complete genome | blastn | 25470 | 466 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 18005415 | 18005415 | PRJNA1005695_P_NODE_5915_length_650_cov_3.140381_g5091_i0 | PRJNA1005695 | 5915 | 650 | 3.140381 | 20.4124765 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 335 | 5.729999999999999e-87 | NTclustered | gi|23452830|gb|AF543583.1| | 108607 | g5091 | i0 | 76.352 | 26.5784615384615 | 647 | 139 | 98 | 9 | 1 | 640 | 2728 | 2089 | Mastigamoeba balamuthi putative pyruvate phosphate dikinase (ppdk) gene, complete cds | blastn | 17276 | 335 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 20127586 | 20127586 | PRJNA1005695_P_NODE_3256_length_887_cov_2.630221_g2631_i0 | PRJNA1005695 | 3256 | 887 | 2.630221 | 23.33006027 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 394 | 1.2899999999999997e-104 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g2631 | i0 | 77.075 | 17.5896279594138 | 711 | 145 | 79 | 16 | 1 | 702 | 610 | 1311 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 15602 | 394 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23105742 | 23105742 | PRJNA1005695_P_NODE_2539_length_999_cov_25.580994_g1982_i0 | PRJNA1005695 | 2539 | 999 | 25.580994 | 255.55413006 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 1090 | 0 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g1982 | i0 | 86.5 | 26.2572572572573 | 1037 | 87 | 99 | 35 | 1 | 996 | 925 | 1949 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 26231 | 1090 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium |
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);;