contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2722520 | 2722520 | PRJNA1046144_P_NODE_27403_length_318_cov_2.658635_g27108_i0 | PRJNA1046144 | 27403 | 318 | 2.658635 | 8.4544593 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 488 | 1.9199999999999997e-133 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g27108 | i0 | 94.357 | 75.4905660377358 | 319 | 16 | 100 | 2 | 1 | 318 | 1615 | 1932 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 24006 | 488 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 3998752 | 3998752 | PRJNA1046144_P_NODE_37324_length_279_cov_10.438095_g37029_i0 | PRJNA1046144 | 37324 | 279 | 10.438095 | 29.12228505 | Protacanthamoeba sp. GERE3 | 1002215 | Discosea | other_Eukaryota | 211 | 4.01e-50 | NTclustered | gi|327391627|gb|HM363625.1| | 1002215 | g37029 | i0 | 81.72 | 27.8960573476703 | 279 | 27 | 100 | 17 | 1 | 279 | 304 | 558 | Protacanthamoeba sp. GERE3 small subunit ribosomal RNA gene, partial sequence | blastn | 7783 | 211 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba sp. GERE3 | |||
| 6550428 | 6550428 | PRJNA1046144_P_NODE_44386_length_260_cov_2.638743_g44091_i0 | PRJNA1046144 | 44386 | 260 | 2.638743 | 6.8607318 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 364 | 2.679999999999999e-96 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g44091 | i0 | 91.76 | 1.02692307692308 | 267 | 15 | 100 | 6 | 1 | 260 | 5658 | 5924 | 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 | 267 | 364 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12925791 | 12925791 | PRJNA1046144_P_NODE_28371_length_314_cov_1.257143_g28076_i0 | PRJNA1046144 | 28371 | 314 | 1.257143 | 3.94742902 | Vannella planctonica | 1678069 | Discosea | other_Eukaryota | 553 | 6.609999999999998e-153 | NTclustered | gi|861554250|gb|KP719193.1| | 1678069 | g28076 | i0 | 98.408 | 96.171974522293 | 314 | 5 | 100 | 0 | 1 | 314 | 616 | 929 | Vannella planctonica strain A2FBB small subunit ribosomal RNA gene, partial sequence | blastn | 30198 | 553 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella planctonica | |||
| 12926076 | 12926076 | PRJNA1046144_P_NODE_42851_length_264_cov_1.605128_g42556_i0 | PRJNA1046144 | 42851 | 264 | 1.605128 | 4.23753792 | Amoebozoa sp. Pugl67W | 1637493 | Root_unresolved | Root_unresolved | 473 | 4.3399999999999986e-129 | NTclustered | gi|799102480|gb|KP792398.1| | 1637493 | g42556 | i0 | 99.237 | 94.4924242424242 | 262 | 2 | 99 | 0 | 3 | 264 | 317 | 56 | Amoebozoa sp. Pugl67W 18S ribosomal RNA gene, partial sequence | blastn | 24946 | 473 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. Pugl67W | |||||||
| 13762508 | 13762508 | PRJNA1046144_P_NODE_31691_length_299_cov_2.504348_g31396_i0 | PRJNA1046144 | 31691 | 299 | 2.504348 | 7.48800052 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 553 | 6.25e-153 | NTclustered | gi|1427939342|gb|MH620776.1| | 5756 | g31396 | i0 | 100 | 99.9899665551839 | 299 | 0 | 100 | 0 | 1 | 299 | 663 | 961 | Acanthamoeba sp. strain Krym small subunit ribosomal RNA gene, partial sequence | blastn | 29897 | 553 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 13762816 | 13762816 | PRJNA1046144_P_NODE_66231_length_228_cov_0.905660_g65936_i0 | PRJNA1046144 | 66231 | 228 | 0.90566 | 2.0649048 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 422 | 1.34e-113 | NTclustered | gi|1497462138|gb|MG945010.1| | 5755 | g65936 | i0 | 100 | 100 | 228 | 0 | 100 | 0 | 1 | 228 | 879 | 1106 | Acanthamoeba castellanii isolate PRZT013 18S ribosomal RNA gene, partial sequence | blastn | 22800 | 422 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14201117 | 14201117 | PRJNA1046144_P_NODE_46492_length_255_cov_3.290323_g46197_i0 | PRJNA1046144 | 46492 | 255 | 3.290323 | 8.39032365 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 113 | 1.05e-20 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g46197 | i0 | 86.111 | 40.0509803921569 | 108 | 11 | 42 | 2 | 1 | 108 | 4470 | 4367 | Cryptodifflugia operculata isolate 75 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 | 10213 | 113 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 14201205 | 14201205 | PRJNA1046144_P_NODE_50632_length_246_cov_1.807910_g50337_i0 | PRJNA1046144 | 50632 | 246 | 1.80791 | 4.4474586 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 211 | 3.46e-50 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g50337 | i0 | 94.203 | 2.13821138211382 | 138 | 8 | 56 | 0 | 31 | 168 | 13866 | 14003 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 526 | 211 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 18023630 | 18023630 | PRJNA1046144_P_NODE_12955_length_444_cov_2.448000_g12660_i0 | PRJNA1046144 | 12955 | 444 | 2.448 | 10.86912 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 656 | 0 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g12660 | i0 | 93.512 | 47.8693693693694 | 447 | 19 | 100 | 8 | 1 | 444 | 1303 | 864 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 21254 | 656 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 18860500 | 18860500 | PRJNA1046144_P_NODE_15015_length_415_cov_2.826590_g14720_i0 | PRJNA1046144 | 15015 | 415 | 2.82659 | 11.7303485 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 710 | 0 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g14720 | i0 | 97.59 | 22.7638554216867 | 415 | 9 | 99 | 1 | 1 | 414 | 4029 | 4443 | 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 | 9447 | 717 | 0.99023709902371 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19297605 | 19297605 | PRJNA1046144_P_NODE_13676_length_433_cov_5.887363_g13381_i0 | PRJNA1046144 | 13676 | 433 | 5.887363 | 25.49228179 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 717 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g13381 | i0 | 96.552 | 41.554272517321 | 435 | 11 | 100 | 4 | 1 | 433 | 7098 | 6666 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 17993 | 717 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20135552 | 20135552 | PRJNA1046144_P_NODE_3676_length_808_cov_4.235453_g3433_i0 | PRJNA1046144 | 3676 | 808 | 4.235453 | 34.22246024 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1332 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3433 | i0 | 96.411 | 49.8898514851485 | 808 | 29 | 100 | 0 | 1 | 808 | 5784 | 4977 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 40311 | 1338 | 0.995515695067265 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20573265 | 20573265 | PRJNA1046144_P_NODE_32997_length_294_cov_3.728889_g32702_i0 | PRJNA1046144 | 32997 | 294 | 3.728889 | 10.96293366 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 508 | 1.35e-139 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g32702 | i0 | 97.959 | 33.4761904761905 | 294 | 4 | 100 | 2 | 1 | 294 | 5363 | 5654 | 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 | 9842 | 508 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21848959 | 21848959 | PRJNA1046144_P_NODE_26498_length_323_cov_1.700787_g26203_i0 | PRJNA1046144 | 26498 | 323 | 1.700787 | 5.49354201 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 544 | 4.1e-150 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g26203 | i0 | 97.214 | 41.5201238390093 | 323 | 5 | 100 | 2 | 1 | 323 | 7487 | 7805 | 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 | 13411 | 544 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21849131 | 21849131 | PRJNA1046144_P_NODE_36858_length_281_cov_1.778302_g36563_i0 | PRJNA1046144 | 36858 | 281 | 1.778302 | 4.99702862 | Dictydiaethalium plumbeum | 1334544 | Evosea | other_Eukaryota | 231 | 3.0999999999999994e-56 | NTclustered | gi|501417077|gb|JX481291.1| | 1334544 | g36563 | i0 | 83.534 | 85.1423487544484 | 249 | 39 | 88 | 2 | 34 | 281 | 1377 | 1624 | Dictydiaethalium plumbeum voucher AMFD185 18S ribosomal RNA gene, partial sequence | blastn | 23925 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Dictydiaethaliaceae | Dictydiaethalium | Dictydiaethalium plumbeum | ||
| 22685870 | 22685870 | PRJNA1046144_P_NODE_25618_length_327_cov_2.782946_g25323_i0 | PRJNA1046144 | 25618 | 327 | 2.782946 | 9.10023342 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 566 | 8.879999999999998e-157 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g25323 | i0 | 97.859 | 41.1009174311927 | 327 | 7 | 100 | 0 | 1 | 327 | 1228 | 902 | Hartmannella vermiformis 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 | 13440 | 566 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23124417 | 23124417 | PRJNA1046144_P_NODE_31919_length_298_cov_4.777293_g31624_i0 | PRJNA1046144 | 31919 | 298 | 4.777293 | 14.23633314 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 484 | 2.3e-132 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g31624 | i0 | 95.973 | 23.6879194630872 | 298 | 12 | 100 | 0 | 1 | 298 | 1240 | 1537 | Hartmannella vermiformis 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 | 7059 | 484 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25235379 | 25235379 | PRJNA1046144_P_NODE_31560_length_300_cov_1.246753_g31265_i0 | PRJNA1046144 | 31560 | 300 | 1.246753 | 3.740259 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 555 | 1.7399999999999995e-153 | NTclustered | gi|909719646|gb|KT185626.1| | 5755 | g31265 | i0 | 100 | 61.9766666666667 | 300 | 0 | 100 | 0 | 1 | 300 | 3585 | 3884 | Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18593 | 555 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;