contig_metadata
10 rows where bioproject = "PRJNA715461" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 705125 | 705125 | PRJNA715461_S_NODE_441_length_411_cov_1.967456_g367_i0 | PRJNA715461 | 441 | 411 | 1.967456 | 8.08624416 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 521 | 2.5e-143 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g367 | i0 | 98.316 | 19.8880778588808 | 297 | 5 | 72 | 0 | 56 | 352 | 2597 | 2301 | 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 | 8174 | 521 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 2467560 | 2467560 | PRJNA715461_S_NODE_142_length_694_cov_10.135266_g98_i0 | PRJNA715461 | 142 | 694 | 10.135266 | 70.33874604 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1181 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g98 | i0 | 100 | 41.7608069164265 | 639 | 0 | 92 | 0 | 4 | 642 | 4892 | 5530 | 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 | 28982 | 1181 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7083796 | 7083796 | PRJNA715461_S_NODE_366_length_451_cov_15.648148_g293_i0 | PRJNA715461 | 366 | 451 | 15.648148 | 70.57314748 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 787 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g293 | i0 | 100 | 39.8292682926829 | 426 | 0 | 94 | 0 | 4 | 429 | 6672 | 7097 | 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 | 17963 | 787 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7083797 | 7083797 | PRJNA715461_S_NODE_586_length_352_cov_16920.913978_g512_i0 | PRJNA715461 | 586 | 352 | 16920.913978 | 59561.61720256 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 496 | 1.28e-135 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g512 | i0 | 100 | 101.772727272727 | 268 | 0 | 76 | 0 | 82 | 349 | 3687 | 3420 | 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 | 35824 | 496 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9633661 | 9633661 | PRJNA715461_S_NODE_1168_length_231_cov_7.360759_g1094_i0 | PRJNA715461 | 1168 | 231 | 7.360759 | 17.00335329 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 379 | 8.339999999999999e-101 | NTclustered | gi|1345607048|gb|MG969837.1| | 5778 | g1094 | i0 | 99.519 | 90.0476190476191 | 208 | 1 | 90 | 0 | 3 | 210 | 177 | 384 | Vermamoeba vermiformis isolate Hart4F small subunit ribosomal RNA gene, partial sequence | blastn | 20801 | 379 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10120772 | 10120772 | PRJNA715461_S_NODE_1868_length_200_cov_4.417323_g1794_i0 | PRJNA715461 | 1868 | 200 | 4.417323 | 8.834646 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 300 | 5.62e-77 | NTclustered | gi|399764177|gb|JQ271688.1| | 5778 | g1794 | i0 | 100 | 80.965 | 162 | 0 | 81 | 0 | 3 | 164 | 627 | 788 | Hartmannella vermiformis strain ECH26 18S ribosomal RNA gene, partial sequence | blastn | 16193 | 300 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10120779 | 10120779 | PRJNA715461_S_NODE_628_length_333_cov_27.373077_g554_i0 | PRJNA715461 | 628 | 333 | 27.373077 | 91.15234641 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 525 | 1.5399999999999994e-144 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g554 | i0 | 100 | 33.1381381381381 | 284 | 0 | 85 | 0 | 47 | 330 | 3869 | 3586 | 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 | 11035 | 525 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13946055 | 13946055 | PRJNA715461_S_NODE_1231_length_226_cov_16171.529412_g1157_i0 | PRJNA715461 | 1231 | 226 | 16171.529412 | 36547.65647112 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 259 | 1.1e-64 | NTclustered | gi|315318893|gb|HQ632781.1| | 5778 | g1157 | i0 | 99.301 | 62.0884955752212 | 143 | 1 | 63 | 0 | 81 | 223 | 532 | 390 | Hartmannella vermiformis strain H-7H 18S ribosomal RNA gene, partial sequence | blastn | 14032 | 259 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20318622 | 20318622 | PRJNA715461_S_NODE_696_length_307_cov_4.307692_g622_i0 | PRJNA715461 | 696 | 307 | 4.307692 | 13.22461444 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 468 | 2.4e-127 | NTclustered | gi|399764177|gb|JQ271688.1| | 5778 | g622 | i0 | 100 | 82.4104234527687 | 253 | 0 | 82 | 0 | 52 | 304 | 390 | 138 | Hartmannella vermiformis strain ECH26 18S ribosomal RNA gene, partial sequence | blastn | 25300 | 468 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24143814 | 24143814 | PRJNA715461_S_NODE_1479_length_212_cov_4.798561_g1405_i0 | PRJNA715461 | 1479 | 212 | 4.798561 | 10.17294932 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 315 | 2.15e-81 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g1405 | i0 | 100 | 80.1556603773585 | 170 | 0 | 80 | 0 | 40 | 209 | 1159 | 990 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 16993 | 315 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans |
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);;