contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3021107 | 3021107 | PRJNA493827_P_NODE_13443_length_1109_cov_5.150579_g11965_i0 | PRJNA493827 | 13443 | 1109 | 5.150579 | 57.11992111 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 911 | 0 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g11965 | i0 | 82.004 | 93.2723174030658 | 1078 | 188 | 97 | 6 | 35 | 1109 | 1103 | 29 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 103439 | 911 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 4299902 | 4299902 | PRJNA493827_P_NODE_46724_length_526_cov_1.688742_g44535_i0 | PRJNA493827 | 46724 | 526 | 1.688742 | 8.88278292 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 331 | 5.92e-86 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g44535 | i0 | 78.788 | 8.65209125475285 | 495 | 103 | 94 | 2 | 9 | 502 | 494 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 4551 | 331 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 4300596 | 4300596 | PRJNA493827_P_NODE_73704_length_403_cov_2.312121_g71506_i0 | PRJNA493827 | 73704 | 403 | 2.312121 | 9.31784763 | Tubulinea group 04 sp. MSED2 | 1215997 | Tubulinea | other_Eukaryota | 732 | 0 | NTclustered | gi|399764277|gb|JQ271788.1| | 1215997 | g71506 | i0 | 99.749 | 71.4416873449131 | 399 | 1 | 99 | 0 | 2 | 400 | 660 | 1058 | Tubulinea group 04 sp. MSED2 18S ribosomal RNA gene, partial sequence | blastn | 28791 | 732 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. MSED2 | ||||||
| 9400987 | 9400987 | PRJNA493827_P_NODE_42448_length_556_cov_15.958592_g40262_i0 | PRJNA493827 | 42448 | 556 | 15.958592 | 88.72977152 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 191 | 1.1099999999999999e-43 | NTclustered | gi|173717|gb|M19222.1|AMPRRM | 5775 | g40262 | i0 | 81.78 | 29.8776978417266 | 236 | 36 | 42 | 6 | 202 | 434 | 417 | 186 | A.proteus 28S large subunit rRNA, 5' end | blastn | 16612 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 10033281 | 10033281 | PRJNA493827_P_NODE_138128_length_290_cov_2.350230_g135930_i0 | PRJNA493827 | 138128 | 290 | 2.35023 | 6.815667 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 536 | 6.079999999999999e-148 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g135930 | i0 | 100 | 98.2586206896552 | 290 | 0 | 100 | 0 | 1 | 290 | 5299 | 5588 | 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 | 28495 | 536 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13224231 | 13224231 | PRJNA493827_P_NODE_143511_length_285_cov_2.122642_g141313_i0 | PRJNA493827 | 143511 | 285 | 2.122642 | 6.0495297 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 350 | 8.34e-92 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g141313 | i0 | 90.53 | 0.926315789473684 | 264 | 25 | 93 | 0 | 18 | 281 | 879 | 616 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 264 | 350 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 13227729 | 13227729 | PRJNA493827_P_NODE_79551_length_386_cov_1.763578_g77353_i0 | PRJNA493827 | 79551 | 386 | 1.763578 | 6.80741108 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 172 | 2.709999999999999e-38 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g77353 | i0 | 87.013 | 1.64766839378238 | 154 | 19 | 40 | 1 | 1 | 153 | 965 | 812 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 636 | 172 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 13859852 | 13859852 | PRJNA493827_P_NODE_92391_length_357_cov_1.109155_g90193_i0 | PRJNA493827 | 92391 | 357 | 1.109155 | 3.95968335 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 649 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g90193 | i0 | 99.44 | 94.3305322128852 | 357 | 2 | 100 | 0 | 1 | 357 | 1549 | 1193 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 33676 | 649 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 15774302 | 15774302 | PRJNA493827_P_NODE_202033_length_247_cov_1.488506_g199835_i0 | PRJNA493827 | 202033 | 247 | 1.488506 | 3.67660982 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 424 | 4.1099999999999996e-114 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g199835 | i0 | 97.571 | 1.78947368421053 | 247 | 6 | 100 | 0 | 1 | 247 | 7096 | 6850 | 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 | 442 | 424 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18321347 | 18321347 | PRJNA493827_P_NODE_112995_length_322_cov_0.827309_g110797_i0 | PRJNA493827 | 112995 | 322 | 0.827309 | 2.66393498 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 154 | 8.05e-33 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g110797 | i0 | 77.778 | 2.32919254658385 | 270 | 46 | 81 | 10 | 62 | 322 | 1 | 265 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 750 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 18323428 | 18323428 | PRJNA493827_P_NODE_207095_length_246_cov_1.184971_g204897_i0 | PRJNA493827 | 207095 | 246 | 1.184971 | 2.91502866 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 411 | 3.1799999999999995e-110 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g204897 | i0 | 96.748 | 2.85365853658537 | 246 | 8 | 100 | 0 | 1 | 246 | 294 | 49 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 702 | 411 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20872356 | 20872356 | PRJNA493827_P_NODE_150017_length_279_cov_2.699029_g147819_i0 | PRJNA493827 | 150017 | 279 | 2.699029 | 7.53029091 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 449 | 7.799999999999999e-122 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g147819 | i0 | 95.699 | 38.9820788530466 | 279 | 12 | 100 | 0 | 1 | 279 | 2519 | 2241 | Cryptodifflugia operculata isolate 75 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 | 10876 | 449 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 22149305 | 22149305 | PRJNA493827_P_NODE_34918_length_626_cov_3.321881_g32762_i0 | PRJNA493827 | 34918 | 626 | 3.321881 | 20.79497506 | Nebela aliciae | 1247258 | Tubulinea | other_Eukaryota | 351 | 5.47e-92 | NTclustered | gi|356713505|gb|JN849023.1| | 1247258 | g32762 | i0 | 77.251 | 75.2188498402556 | 633 | 122 | 99 | 21 | 2 | 625 | 1 | 620 | Nebela aliciae isolate N_tin_gal20 COXI gene, partial sequence; mitochondrial | blastn | 47087 | 351 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Hyalospheniidae | Nebela | Nebela aliciae | ||
| 22150928 | 22150928 | PRJNA493827_P_NODE_99398_length_343_cov_5.511111_g97200_i0 | PRJNA493827 | 99398 | 343 | 5.511111 | 18.90311073 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 294 | 4.88e-75 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g97200 | i0 | 90.308 | 49.5510204081633 | 227 | 18 | 66 | 4 | 11 | 235 | 1 | 225 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 16996 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 24696101 | 24696101 | PRJNA493827_P_NODE_129700_length_300_cov_1.449339_g127502_i0 | PRJNA493827 | 129700 | 300 | 1.449339 | 4.348017 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 407 | 5.17e-109 | NTclustered | gi|88601207|gb|DQ384272.1| | 5778 | g127502 | i0 | 92.308 | 0.953333333333333 | 286 | 22 | 95 | 0 | 1 | 286 | 299 | 14 | Hartmannella vermiformis unknown mRNA | blastn | 286 | 407 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25332057 | 25332057 | PRJNA493827_P_NODE_40460_length_572_cov_3.442886_g38280_i0 | PRJNA493827 | 40460 | 572 | 3.442886 | 19.69330792 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 444 | 7.97e-120 | NTclustered | gi|304308754|gb|HM853708.1| | 497998 | g38280 | i0 | 80.903 | 98.7727272727273 | 576 | 98 | 99 | 12 | 2 | 571 | 113 | 682 | Arcella hemisphaerica strain blue&red clone act21 actin gene, partial cds | blastn | 56498 | 446 | 0.995515695067265 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica |
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);;