contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622849 | 622849 | PRJNA657343_P_NODE_17781_length_217_cov_0.922619_g17757_i0 | PRJNA657343 | 17781 | 217 | 0.922619 | 2.00208323 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 357 | 3.63e-94 | NTclustered | gi|421976335|gb|JQ519484.1| | 5778 | g17757 | i0 | 97.156 | 43.7695852534562 | 211 | 6 | 97 | 0 | 6 | 216 | 361 | 151 | Vermamoeba vermiformis clone JGHverm1 beta-tubulin gene, partial cds | blastn | 9498 | 357 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 623114 | 623114 | PRJNA657343_P_NODE_401_length_805_cov_57.970899_g390_i0 | PRJNA657343 | 401 | 805 | 57.970899 | 466.66573695 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 327 | 1.2e-84 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g390 | i0 | 83.696 | 21.583850931677 | 368 | 38 | 44 | 14 | 190 | 543 | 1 | 360 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 17375 | 327 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 3712142 | 3712142 | PRJNA657343_P_NODE_39003_length_166_cov_0.888889_g38979_i0 | PRJNA657343 | 39003 | 166 | 0.888889 | 1.47555574 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 279 | 5.86e-71 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g38979 | i0 | 98.125 | 81.078313253012 | 160 | 3 | 96 | 0 | 3 | 162 | 5015 | 5174 | 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 | 13459 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4450788 | 4450788 | PRJNA657343_P_NODE_2064_length_478_cov_2.251748_g2041_i0 | PRJNA657343 | 2064 | 478 | 2.251748 | 10.76335544 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 752 | 0 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g2041 | i0 | 95.532 | 4.84937238493724 | 470 | 21 | 98 | 0 | 5 | 474 | 265 | 734 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 2318 | 752 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5727612 | 5727612 | PRJNA657343_S_NODE_31645_length_156_cov_2.074766_g31620_i0 | PRJNA657343 | 31645 | 156 | 2.074766 | 3.23663496 | Lobosea sp. Mb_5C | 507804 | Tubulinea | other_Eukaryota | 270 | 3.2599999999999996e-68 | NTclustered | gi|169264626|dbj|AB425950.1| | 507804 | g31620 | i0 | 98.077 | 9.41666666666667 | 156 | 1 | 100 | 2 | 1 | 156 | 637 | 790 | Lobosea sp. Mb_5C gene for 18S ribosomal RNA, partial sequence | blastn | 1469 | 270 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Mb_5C | ||||||
| 10088992 | 10088992 | PRJNA657343_P_NODE_108_length_1167_cov_72.902504_g105_i0 | PRJNA657343 | 108 | 1167 | 72.902504 | 850.77222168 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 1690 | 0 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g105 | i0 | 92.967 | 39.2245072836333 | 1166 | 73 | 99 | 8 | 3 | 1164 | 1161 | 1 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 45775 | 1690 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 | ||||||
| 12102360 | 12102360 | PRJNA657343_P_NODE_21910_length_200_cov_3.311258_g21886_i0 | PRJNA657343 | 21910 | 200 | 3.311258 | 6.622516 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 318 | 1.55e-82 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g21886 | i0 | 95.918 | 21.69 | 196 | 8 | 98 | 0 | 3 | 198 | 126 | 321 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 4338 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14652073 | 14652073 | PRJNA657343_P_NODE_37752_length_167_cov_0.881356_g37728_i0 | PRJNA657343 | 37752 | 167 | 0.881356 | 1.47186452 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 117 | 4.900000000000001e-22 | NTclustered | gi|88601207|gb|DQ384272.1| | 5778 | g37728 | i0 | 87.879 | 0.592814371257485 | 99 | 12 | 59 | 0 | 30 | 128 | 225 | 127 | Hartmannella vermiformis unknown mRNA | blastn | 99 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19011913 | 19011913 | PRJNA657343_P_NODE_30675_length_177_cov_2.718750_g30651_i0 | PRJNA657343 | 30675 | 177 | 2.71875 | 4.8121875 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 318 | 1.34e-82 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g30651 | i0 | 100 | 37.2146892655367 | 172 | 0 | 97 | 0 | 3 | 174 | 2716 | 2887 | 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 | 6587 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21562502 | 21562502 | PRJNA657343_S_NODE_28537_length_166_cov_21.940171_g28512_i0 | PRJNA657343 | 28537 | 166 | 21.940171 | 36.42068386 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 294 | 2.09e-75 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g28512 | i0 | 100 | 95.9397590361446 | 159 | 0 | 96 | 0 | 3 | 161 | 1044 | 1202 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 15926 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 25386863 | 25386863 | PRJNA657343_P_NODE_6380_length_316_cov_4.707865_g6356_i0 | PRJNA657343 | 6380 | 316 | 4.707865 | 14.8768534 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 577 | 3.9499999999999996e-160 | NTclustered | gi|2463802139|gb|OQ678078.1| | 5778 | g6356 | i0 | 99.683 | 99.6582278481013 | 315 | 1 | 99 | 0 | 1 | 315 | 11 | 325 | Vermamoeba vermiformis isolate IQ5E small subunit ribosomal RNA gene, partial sequence | blastn | 31492 | 577 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25386865 | 25386865 | PRJNA657343_P_NODE_9040_length_278_cov_40.349345_g9016_i0 | PRJNA657343 | 9040 | 278 | 40.349345 | 112.1711791 | Echinamoeba | 136449 | Tubulinea | other_Eukaryota | 342 | 1.36e-89 | NTclustered | gi|399764170|gb|JQ271681.1| | 1215984 | g9016 | i0 | 89.706 | 52.2194244604317 | 272 | 22 | 97 | 5 | 3 | 272 | 1542 | 1275 | Echinamoeba silvestris strain UKNCC:CCAP1519/1 18S ribosomal RNA gene, partial sequence | blastn | 14517 | 342 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba silvestris |
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);;