contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2950464 | 2950464 | PRJNA376117_P_NODE_26843_length_276_cov_1.896552_g26541_i0 | PRJNA376117 | 26843 | 276 | 1.896552 | 5.23448352 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 416 | 7.809999999999998e-112 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g26541 | i0 | 93.841 | 103.101449275362 | 276 | 17 | 100 | 0 | 1 | 276 | 662 | 387 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 28456 | 416 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 4227340 | 4227340 | PRJNA376117_P_NODE_7864_length_478_cov_1.439506_g7563_i0 | PRJNA376117 | 7864 | 478 | 1.439506 | 6.88083868 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 728 | 0 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g7563 | i0 | 94.142 | 98.4832635983264 | 478 | 28 | 100 | 0 | 1 | 478 | 920 | 443 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 47075 | 728 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 4227360 | 4227360 | PRJNA376117_P_NODE_9704_length_432_cov_1.211699_g9402_i0 | PRJNA376117 | 9704 | 432 | 1.211699 | 5.23453968 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 750 | 0 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g9402 | i0 | 98.152 | 73.8518518518518 | 433 | 3 | 99 | 3 | 2 | 432 | 687 | 258 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 31904 | 750 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 5503232 | 5503232 | PRJNA376117_P_NODE_12025_length_390_cov_2.154574_g11723_i0 | PRJNA376117 | 12025 | 390 | 2.154574 | 8.4028386 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 660 | 0 | NTclustered | gi|423292025|gb|JQ519458.1| | 704142 | g11723 | i0 | 97.179 | 100.348717948718 | 390 | 11 | 100 | 0 | 1 | 390 | 740 | 351 | Saccamoeba lacustris clone JG10.115_b9 actin gene, partial cds | blastn | 39136 | 660 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 7451721 | 7451721 | PRJNA376117_P_NODE_38866_length_246_cov_1.427746_g38564_i0 | PRJNA376117 | 38866 | 246 | 1.427746 | 3.51225516 | Vannellidae | 95227 | Discosea | other_Eukaryota | 414 | 2.46e-111 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g38564 | i0 | 97.908 | 96.8211382113821 | 239 | 5 | 97 | 0 | 1 | 239 | 1477 | 1239 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 23818 | 414 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 8726398 | 8726398 | PRJNA376117_P_NODE_31947_length_257_cov_3.211957_g31645_i0 | PRJNA376117 | 31947 | 257 | 3.211957 | 8.25472949 | Flabellulidae | 136457 | Tubulinea | other_Eukaryota | 431 | 2.57e-116 | NTclustered | gi|30721610|gb|AY277797.1| | 136459 | g31645 | i0 | 96.887 | 98.3618677042802 | 257 | 8 | 100 | 0 | 1 | 257 | 1093 | 837 | Paraflabellula hoguae 18S ribosomal RNA gene, partial sequence | blastn | 25279 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 10603885 | 10603885 | PRJNA376117_P_NODE_44669_length_241_cov_0.916667_g44367_i0 | PRJNA376117 | 44669 | 241 | 0.916667 | 2.20916747 | Physarum melleum | 289959 | Evosea | other_Eukaryota | 422 | 1.44e-113 | NTclustered | gi|380864315|gb|JQ277926.1| | 289959 | g44367 | i0 | 98.739 | 3.60995850622407 | 238 | 1 | 99 | 2 | 4 | 241 | 955 | 720 | Physarum melleum 18S ribosomal RNA gene, partial sequence | blastn | 870 | 422 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum melleum | ||
| 10603908 | 10603908 | PRJNA376117_P_NODE_5329_length_590_cov_2.220503_g5033_i0 | PRJNA376117 | 5329 | 590 | 2.220503 | 13.1009677 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 791 | 0 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g5033 | i0 | 93.738 | 93.4440677966102 | 527 | 33 | 89 | 0 | 64 | 590 | 1131 | 605 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 55132 | 791 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 11878391 | 11878391 | PRJNA376117_P_NODE_14610_length_358_cov_2.985965_g14308_i0 | PRJNA376117 | 14610 | 358 | 2.985965 | 10.6897547 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 278 | 5.14e-70 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g14308 | i0 | 83.168 | 18.4329608938547 | 303 | 51 | 85 | 0 | 11 | 313 | 315 | 13 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 6599 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13153555 | 13153555 | PRJNA376117_P_NODE_22491_length_291_cov_2.825688_g22189_i0 | PRJNA376117 | 22491 | 291 | 2.825688 | 8.22275208 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 366 | 8.48e-97 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g22189 | i0 | 89.347 | 87.6185567010309 | 291 | 31 | 100 | 0 | 1 | 291 | 764 | 474 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 25497 | 366 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 14428922 | 14428922 | PRJNA376117_P_NODE_9632_length_433_cov_1.827778_g9330_i0 | PRJNA376117 | 9632 | 433 | 1.827778 | 7.91427874 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 693 | 0 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g9330 | i0 | 95.853 | 99.6697459584296 | 434 | 9 | 99 | 7 | 1 | 428 | 1045 | 615 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 43157 | 693 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 16977025 | 16977025 | PRJNA376117_P_NODE_12934_length_378_cov_1.836066_g12632_i0 | PRJNA376117 | 12934 | 378 | 1.836066 | 6.94032948 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 235 | 3.3299999999999995e-57 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g12632 | i0 | 77.926 | 96.5952380952381 | 376 | 83 | 99 | 0 | 3 | 378 | 693 | 1068 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 36513 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 16977367 | 16977367 | PRJNA376117_P_NODE_37434_length_248_cov_0.880000_g37132_i0 | PRJNA376117 | 37434 | 248 | 0.88 | 2.1824 | Dermamoeba algensis | 242549 | Discosea | other_Eukaryota | 263 | 9.519999999999998e-66 | NTclustered | gi|33946360|gb|AY294159.1| | 242549 | g37132 | i0 | 86.555 | 96.1854838709677 | 238 | 32 | 96 | 0 | 4 | 241 | 81 | 318 | Dermamoeba algensis actin mRNA, partial cds | blastn | 23854 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Dermamoeba | Dermamoeba algensis | ||||
| 16977410 | 16977410 | PRJNA376117_P_NODE_40254_length_245_cov_0.895349_g39952_i0 | PRJNA376117 | 40254 | 245 | 0.895349 | 2.19360505 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 340 | 4.209999999999999e-89 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g39952 | i0 | 91.803 | 84.2571428571429 | 244 | 20 | 99 | 0 | 1 | 244 | 622 | 865 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 20643 | 340 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 18251300 | 18251300 | PRJNA376117_P_NODE_1375_length_1426_cov_9.886918_g1193_i0 | PRJNA376117 | 1375 | 1426 | 9.886918 | 140.98745068 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1236 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g1193 | i0 | 82.925 | 35.6199158485273 | 1388 | 222 | 96 | 11 | 16 | 1391 | 1 | 1385 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 50794 | 1236 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18251790 | 18251790 | PRJNA376117_P_NODE_6015_length_550_cov_1.129979_g5715_i0 | PRJNA376117 | 6015 | 550 | 1.129979 | 6.2148845 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 475 | 2.7099999999999994e-129 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g5715 | i0 | 82.482 | 97.28 | 548 | 90 | 99 | 6 | 1 | 545 | 2339 | 1795 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 53504 | 475 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19525623 | 19525623 | PRJNA376117_P_NODE_20816_length_303_cov_1.165217_g20514_i0 | PRJNA376117 | 20816 | 303 | 1.165217 | 3.53060751 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 361 | 4.13e-95 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g20514 | i0 | 95.197 | 81.2937293729373 | 229 | 9 | 75 | 2 | 76 | 303 | 1134 | 907 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 24632 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 20801185 | 20801185 | PRJNA376117_P_NODE_17417_length_330_cov_6.614786_g17115_i0 | PRJNA376117 | 17417 | 330 | 6.614786 | 21.8287938 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 305 | 2.16e-78 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g17115 | i0 | 90.336 | 73.030303030303 | 238 | 16 | 72 | 6 | 93 | 330 | 3747 | 3977 | Rhizamoeba saxonica 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 | 24100 | 305 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 23351639 | 23351639 | PRJNA376117_P_NODE_1399_length_1412_cov_9.300224_g1193_i1 | PRJNA376117 | 1399 | 1412 | 9.300224 | 131.31916288 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1260 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g1193 | i1 | 83.225 | 35.0148725212465 | 1389 | 218 | 98 | 11 | 16 | 1392 | 1 | 1386 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 49441 | 1260 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 23351929 | 23351929 | PRJNA376117_P_NODE_34639_length_250_cov_1.644068_g34337_i0 | PRJNA376117 | 34639 | 250 | 1.644068 | 4.11017 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 436 | 5.349999999999999e-118 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g34337 | i0 | 98.024 | 61.136 | 253 | 2 | 100 | 1 | 1 | 250 | 2619 | 2871 | Vannella septentrionalis 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 | 15284 | 436 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis |
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);;