contig_metadata
11 rows where bioproject = "PRJNA1046144", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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);;