contig_metadata
14 rows where bioproject = "PRJNA1010780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1429989 | 1429989 | PRJNA1010780_S_NODE_53262_length_167_cov_3.803030_g51973_i0 | PRJNA1010780 | 53262 | 167 | 3.80303 | 6.3510601 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 303 | 3.5e-78 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g51973 | i0 | 100 | 1.95209580838323 | 164 | 0 | 98 | 0 | 4 | 167 | 173 | 10 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 326 | 303 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3981519 | 3981519 | PRJNA1010780_S_NODE_25204_length_315_cov_1.607143_g23915_i0 | PRJNA1010780 | 25204 | 315 | 1.607143 | 5.06250045 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 555 | 1.8399999999999994e-153 | NTclustered | gi|66270666|gb|AY950658.1| | 5778 | g23915 | i0 | 98.413 | 1 | 315 | 5 | 100 | 0 | 1 | 315 | 502 | 188 | Hartmannella vermiformis Nop58p mRNA, partial cds | blastn | 315 | 555 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3981586 | 3981586 | PRJNA1010780_S_NODE_41044_length_203_cov_1.488095_g39755_i0 | PRJNA1010780 | 41044 | 203 | 1.488095 | 3.02083285 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 364 | 2e-96 | NTclustered | gi|88601165|gb|DQ384330.1| | 5778 | g39755 | i0 | 99.015 | 2 | 203 | 2 | 100 | 0 | 1 | 203 | 430 | 228 | Hartmannella vermiformis succinyl-diaminopimelate desuccinylase-like protein B mRNA, partial cds | blastn | 406 | 364 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6533330 | 6533330 | PRJNA1010780_S_NODE_41426_length_201_cov_2.343373_g40137_i0 | PRJNA1010780 | 41426 | 201 | 2.343373 | 4.71017973 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 329 | 7.21e-86 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g40137 | i0 | 97.895 | 47.6119402985075 | 190 | 4 | 95 | 0 | 12 | 201 | 1 | 190 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 9570 | 329 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7807781 | 7807781 | PRJNA1010780_S_NODE_61647_length_152_cov_3.025641_g60358_i0 | PRJNA1010780 | 61647 | 152 | 3.025641 | 4.59897432 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 243 | 6.87e-60 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g60358 | i0 | 95.973 | 18.4078947368421 | 149 | 6 | 98 | 0 | 4 | 152 | 468 | 320 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 2798 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12908831 | 12908831 | PRJNA1010780_S_NODE_33871_length_237_cov_2.386139_g32582_i0 | PRJNA1010780 | 33871 | 237 | 2.386139 | 5.65514943 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 228 | 3.2899999999999986e-55 | NTclustered | gi|89357439|gb|DQ407657.1| | 5778 | g32582 | i0 | 98.45 | 1.08860759493671 | 129 | 2 | 54 | 0 | 1 | 129 | 129 | 1 | Hartmannella vermiformis chitinase-like protein cluster B mRNA, partial cds | blastn | 258 | 228 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14183804 | 14183804 | PRJNA1010780_S_NODE_41272_length_202_cov_1.712575_g39983_i0 | PRJNA1010780 | 41272 | 202 | 1.712575 | 3.4594015 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 374 | 3.3e-99 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g39983 | i0 | 100 | 3.00990099009901 | 202 | 0 | 100 | 0 | 1 | 202 | 2938 | 3139 | 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 | 608 | 374 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16732057 | 16732057 | PRJNA1010780_S_NODE_41314_length_202_cov_1.526946_g40025_i0 | PRJNA1010780 | 41314 | 202 | 1.526946 | 3.08443092 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 368 | 1.54e-97 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g40025 | i0 | 99.505 | 24.7277227722772 | 202 | 1 | 100 | 0 | 1 | 202 | 4354 | 4153 | 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 | 4995 | 368 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18006828 | 18006828 | PRJNA1010780_S_NODE_20555_length_390_cov_3.473239_g19266_i0 | PRJNA1010780 | 20555 | 390 | 3.473239 | 13.5456321 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 416 | 1.15e-111 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g19266 | i0 | 97.531 | 1.24615384615385 | 243 | 6 | 62 | 0 | 1 | 243 | 169 | 411 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 486 | 416 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19280755 | 19280755 | PRJNA1010780_S_NODE_60016_length_155_cov_1.625000_g58727_i0 | PRJNA1010780 | 60016 | 155 | 1.625 | 2.51875 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 287 | 3.21e-73 | NTclustered | gi|88601207|gb|DQ384272.1| | 5778 | g58727 | i0 | 100 | 1 | 155 | 0 | 100 | 0 | 1 | 155 | 167 | 321 | Hartmannella vermiformis unknown mRNA | blastn | 155 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23107501 | 23107501 | PRJNA1010780_S_NODE_53419_length_167_cov_1.962121_g52130_i0 | PRJNA1010780 | 53419 | 167 | 1.962121 | 3.27674207 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 292 | 7.58e-75 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g52130 | i0 | 98.78 | 28.8622754491018 | 164 | 2 | 98 | 0 | 1 | 164 | 639 | 802 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 4820 | 292 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23107522 | 23107522 | PRJNA1010780_S_NODE_58159_length_158_cov_1.829268_g56870_i0 | PRJNA1010780 | 58159 | 158 | 1.829268 | 2.89024344 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 243 | 7.219999999999999e-60 | NTclustered | gi|421976355|gb|JQ519494.1| | 5778 | g56870 | i0 | 94.304 | 1 | 158 | 9 | 100 | 0 | 1 | 158 | 405 | 248 | Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds | blastn | 158 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23107575 | 23107575 | PRJNA1010780_S_NODE_8759_length_855_cov_10.417073_g7895_i0 | PRJNA1010780 | 8759 | 855 | 10.417073 | 89.06597415 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1399 | 0 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g7895 | i0 | 99.608 | 3.0374269005848 | 766 | 3 | 90 | 0 | 1 | 766 | 766 | 1 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 2597 | 1399 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30824438 | 30824438 | PRJNA1010780_S_NODE_24874_length_319_cov_1.823944_g23585_i0 | PRJNA1010780 | 24874 | 319 | 1.823944 | 5.81838136 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 65.9 | 4.14e-10 | NR | AKN09692.1 | 5775 | g23585 | i0 | 35.2 | 0.987460815047022 | 105 | 66 | 96.9 | 1 | 1 | 309 | 152 | 256 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 315 | 65.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;