contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7049627 | 7049627 | PRJNA690592_S_NODE_144866_length_281_cov_1.480769_g143852_i0 | PRJNA690592 | 144866 | 281 | 1.480769 | 4.16096089 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 106 | 1.96e-18 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g143852 | i0 | 87.912 | 0.647686832740214 | 91 | 10 | 32 | 1 | 1 | 91 | 19957 | 19868 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 182 | 106 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7557007 | 7557007 | PRJNA690592_S_NODE_76346_length_366_cov_1.979522_g75332_i0 | PRJNA690592 | 76346 | 366 | 1.979522 | 7.24505052 | Echinamoeba | 136449 | Tubulinea | other_Eukaryota | 586 | 7.699999999999998e-163 | NTclustered | gi|165968562|gb|EU377602.1| | 136450 | g75332 | i0 | 95.628 | 70.8032786885246 | 366 | 15 | 100 | 1 | 1 | 366 | 388 | 24 | Echinamoeba exundans strain CRIB40 18S ribosomal RNA gene, partial sequence | blastn | 25914 | 586 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 10876133 | 10876133 | PRJNA690592_S_NODE_88249_length_344_cov_4.904059_g87235_i0 | PRJNA690592 | 88249 | 344 | 4.904059 | 16.86996296 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 636 | 7.059999999999998e-178 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g87235 | i0 | 100 | 81.2761627906977 | 344 | 0 | 100 | 0 | 1 | 344 | 380 | 37 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 27959 | 636 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 13425318 | 13425318 | PRJNA690592_S_NODE_210751_length_242_cov_2.485207_g209737_i0 | PRJNA690592 | 210751 | 242 | 2.485207 | 6.01420094 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 219 | 2.0299999999999993e-52 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g209737 | i0 | 83.133 | 37.9214876033058 | 249 | 33 | 100 | 9 | 1 | 242 | 1363 | 1609 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 9177 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 13425563 | 13425563 | PRJNA690592_S_NODE_40351_length_482_cov_33.630807_g39337_i0 | PRJNA690592 | 40351 | 482 | 33.630807 | 162.10048974 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 154 | 1.2499999999999998e-32 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g39337 | i0 | 82.011 | 42.2406639004149 | 189 | 27 | 38 | 7 | 298 | 482 | 4309 | 4124 | 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 | 20360 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 18523633 | 18523633 | PRJNA690592_S_NODE_29155_length_559_cov_2.314815_g28156_i0 | PRJNA690592 | 29155 | 559 | 2.314815 | 12.93981585 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 621 | 3.3499999999999986e-173 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g28156 | i0 | 87.64 | 40.0232558139535 | 534 | 66 | 96 | 0 | 24 | 557 | 576 | 43 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 22373 | 621 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 21074036 | 21074036 | PRJNA690592_S_NODE_220757_length_217_cov_5.875000_g219743_i0 | PRJNA690592 | 220757 | 217 | 5.875 | 12.74875 | Nolandella sp. ATCC PRA-27 | 498006 | Tubulinea | other_Eukaryota | 318 | 1.71e-82 | NTclustered | gi|167859744|gb|EU273453.1| | 498006 | g219743 | i0 | 93.119 | 105.751152073733 | 218 | 13 | 100 | 2 | 1 | 217 | 352 | 136 | Nolandella sp. ATCC PRA-27 clone 2 actin gene, partial cds | blastn | 22948 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Nolandella | Nolandella sp. ATCC PRA-27 | ||
| 21581160 | 21581160 | PRJNA690592_S_NODE_145617_length_280_cov_2.594203_g144603_i0 | PRJNA690592 | 145617 | 280 | 2.594203 | 7.2637684 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 291 | 5.02e-74 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g144603 | i0 | 98.193 | 34.0107142857143 | 166 | 3 | 59 | 0 | 115 | 280 | 1808 | 1643 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 9523 | 291 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 22349342 | 22349342 | PRJNA690592_S_NODE_79698_length_359_cov_3.290210_g78684_i0 | PRJNA690592 | 79698 | 359 | 3.29021 | 11.8118539 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 658 | 0 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g78684 | i0 | 99.721 | 73.3983286908078 | 359 | 1 | 100 | 0 | 1 | 359 | 949 | 591 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 26350 | 658 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 24130964 | 24130964 | PRJNA690592_S_NODE_47459_length_449_cov_4.095745_g46445_i0 | PRJNA690592 | 47459 | 449 | 4.095745 | 18.38989505 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 821 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g46445 | i0 | 99.776 | 96.0178173719376 | 447 | 1 | 99 | 0 | 3 | 449 | 1201 | 1647 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 43112 | 821 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 24897867 | 24897867 | PRJNA690592_S_NODE_26220_length_588_cov_3.308738_g25228_i0 | PRJNA690592 | 26220 | 588 | 3.308738 | 19.45537944 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 555 | 3.6299999999999997e-153 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g25228 | i0 | 83.871 | 4.14625850340136 | 589 | 87 | 99 | 7 | 4 | 588 | 753 | 1337 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2438 | 555 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;