contig_metadata
13 rows where bioproject = "PRJNA1032461" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167093 | 167093 | PRJNA1032461_S_NODE_6321_length_233_cov_33.711957_g6223_i0 | PRJNA1032461 | 6321 | 233 | 33.711957 | 78.54885981 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 420 | 4.96e-113 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g6223 | i0 | 100 | 97.9957081545064 | 227 | 0 | 97 | 0 | 6 | 232 | 3088 | 3314 | Vermamoeba sp. isolate 22 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 | 22833 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 167107 | 167107 | PRJNA1032461_S_NODE_8341_length_210_cov_1.291925_g8243_i0 | PRJNA1032461 | 8341 | 210 | 1.291925 | 2.7130425 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 342 | 9.769999999999999e-90 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g8243 | i0 | 96.19 | 27.2952380952381 | 210 | 6 | 100 | 2 | 1 | 210 | 26982 | 26775 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 5732 | 342 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 167114 | 167114 | PRJNA1032461_S_NODE_9241_length_201_cov_1.730263_g9143_i0 | PRJNA1032461 | 9241 | 201 | 1.730263 | 3.47782863 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 324 | 3.36e-84 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g9143 | i0 | 95.98 | 108.910447761194 | 199 | 8 | 99 | 0 | 1 | 199 | 27643 | 27841 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 21891 | 324 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1007166 | 1007166 | PRJNA1032461_S_NODE_201_length_912_cov_35.296640_g141_i0 | PRJNA1032461 | 201 | 912 | 35.29664 | 321.9053568 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1496 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g141 | i0 | 96.872 | 47.3826754385965 | 895 | 26 | 98 | 2 | 17 | 910 | 4893 | 5786 | 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 | 43213 | 1507 | 0.992700729927007 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1441770 | 1441770 | PRJNA1032461_S_NODE_12962_length_174_cov_12.680000_g12864_i0 | PRJNA1032461 | 12962 | 174 | 12.68 | 22.0632 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 322 | 1.01e-83 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g12864 | i0 | 100 | 104.33908045977 | 174 | 0 | 100 | 0 | 1 | 174 | 1625 | 1798 | 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 | 18155 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5269896 | 5269896 | PRJNA1032461_S_NODE_1585_length_416_cov_37.013624_g1487_i0 | PRJNA1032461 | 1585 | 416 | 37.013624 | 153.97667584 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 736 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g1487 | i0 | 98.558 | 36.8365384615385 | 416 | 6 | 100 | 0 | 1 | 416 | 6683 | 7098 | 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 | 15324 | 736 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6545105 | 6545105 | PRJNA1032461_S_NODE_1606_length_414_cov_24.983562_g1508_i0 | PRJNA1032461 | 1606 | 414 | 24.983562 | 103.43194668 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 710 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1508 | i0 | 97.585 | 24.2391304347826 | 414 | 10 | 100 | 0 | 1 | 414 | 1631 | 1218 | 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 | 10035 | 710 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6545148 | 6545148 | PRJNA1032461_S_NODE_22486_length_150_cov_23.613861_g22388_i0 | PRJNA1032461 | 22486 | 150 | 23.613861 | 35.4207915 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 272 | 8.609999999999998e-69 | NTclustered | gi|157688394|gb|DQ123623.2| | 5778 | g22388 | i0 | 99.333 | 100.213333333333 | 150 | 1 | 100 | 0 | 1 | 150 | 2644 | 2793 | Hartmannella vermiformis strain CRIB-06 18S ribosomal RNA gene, complete sequence | blastn | 15032 | 272 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7384962 | 7384962 | PRJNA1032461_S_NODE_3986_length_285_cov_29.550847_g3888_i0 | PRJNA1032461 | 3986 | 285 | 29.550847 | 84.21991395 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 488 | 1.6899999999999999e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g3888 | i0 | 97.544 | 36.8175438596491 | 285 | 7 | 100 | 0 | 1 | 285 | 1224 | 940 | 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 | 10493 | 488 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9094647 | 9094647 | PRJNA1032461_S_NODE_4528_length_269_cov_41.618182_g4430_i0 | PRJNA1032461 | 4528 | 269 | 41.618182 | 111.95290958 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 496 | 9.47e-136 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g4430 | i0 | 100 | 12.3494423791822 | 268 | 0 | 99 | 0 | 1 | 268 | 6055 | 6322 | 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 | 3322 | 496 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14195734 | 14195734 | PRJNA1032461_S_NODE_7532_length_218_cov_3.071006_g7434_i0 | PRJNA1032461 | 7532 | 218 | 3.071006 | 6.69479308 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 178 | 3.0499999999999993e-40 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g7434 | i0 | 81.651 | 8.92201834862385 | 218 | 37 | 99 | 2 | 1 | 217 | 25649 | 25864 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 1945 | 178 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19292944 | 19292944 | PRJNA1032461_S_NODE_6976_length_225_cov_2.011364_g6878_i0 | PRJNA1032461 | 6976 | 225 | 2.011364 | 4.525569 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 311 | 2.99e-80 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g6878 | i0 | 92.958 | 1.88 | 213 | 15 | 95 | 0 | 1 | 213 | 26954 | 27166 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 423 | 311 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20568258 | 20568258 | PRJNA1032461_S_NODE_7797_length_215_cov_8.765060_g7699_i0 | PRJNA1032461 | 7797 | 215 | 8.76506 | 18.844879 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 390 | 3.54e-104 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g7699 | i0 | 99.533 | 98.6604651162791 | 214 | 1 | 99 | 0 | 1 | 214 | 3672 | 3885 | 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 | 21212 | 390 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;