contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475534 | 475534 | PRJNA494251_P_NODE_43281_length_246_cov_0.890173_g42967_i0 | PRJNA494251 | 43281 | 246 | 0.890173 | 2.18982558 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 388 | 1.49e-103 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g42967 | i0 | 95.122 | 2 | 246 | 12 | 100 | 0 | 1 | 246 | 123 | 368 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 492 | 388 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 475719 | 475719 | PRJNA494251_S_NODE_541_length_292_cov_0.913242_g526_i0 | PRJNA494251 | 541 | 292 | 0.913242 | 2.66666664 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 444 | 3.82e-120 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g526 | i0 | 98.413 | 89.8561643835616 | 252 | 4 | 86 | 0 | 41 | 292 | 1 | 252 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 26238 | 444 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1750285 | 1750285 | PRJNA494251_P_NODE_32022_length_265_cov_1.468750_g31708_i0 | PRJNA494251 | 32022 | 265 | 1.46875 | 3.8921875 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 148 | 3.0000000000000003e-31 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g31708 | i0 | 87.023 | 45.3622641509434 | 131 | 17 | 49 | 0 | 135 | 265 | 948 | 1078 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12021 | 148 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 1750582 | 1750582 | PRJNA494251_S_NODE_842_length_234_cov_2.540373_g827_i0 | PRJNA494251 | 842 | 234 | 2.540373 | 5.94447282 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 390 | 3.909999999999999e-104 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g827 | i0 | 98.636 | 2.96581196581197 | 220 | 3 | 94 | 0 | 15 | 234 | 5566 | 5785 | 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 | 694 | 390 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3026271 | 3026271 | PRJNA494251_P_NODE_31563_length_266_cov_3.088083_g31249_i0 | PRJNA494251 | 31563 | 266 | 3.088083 | 8.21430078 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 442 | 1.2399999999999995e-119 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g31249 | i0 | 97.665 | 74.3947368421053 | 257 | 6 | 97 | 0 | 1 | 257 | 2433 | 2689 | 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 | 19789 | 442 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 4302525 | 4302525 | PRJNA494251_S_NODE_304_length_384_cov_6.672026_g289_i0 | PRJNA494251 | 304 | 384 | 6.672026 | 25.62057984 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 652 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g289 | i0 | 98.383 | 29.1197916666667 | 371 | 6 | 97 | 0 | 14 | 384 | 6734 | 7104 | 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 | 11182 | 652 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5579183 | 5579183 | PRJNA494251_S_NODE_225_length_429_cov_1.803371_g210_i0 | PRJNA494251 | 225 | 429 | 1.803371 | 7.73646159 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 736 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g210 | i0 | 98.558 | 23.2540792540793 | 416 | 6 | 97 | 0 | 14 | 429 | 1219 | 1634 | 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 | 9976 | 736 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9403252 | 9403252 | PRJNA494251_P_NODE_25328_length_289_cov_2.296296_g25014_i0 | PRJNA494251 | 25328 | 289 | 2.296296 | 6.63629544 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 414 | 2.96e-111 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g25014 | i0 | 92.542 | 1.74740484429066 | 295 | 12 | 99 | 6 | 2 | 289 | 826 | 535 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 505 | 414 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10035427 | 10035427 | PRJNA494251_S_NODE_328_length_372_cov_3.632107_g313_i0 | PRJNA494251 | 328 | 372 | 3.632107 | 13.51143804 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 662 | 0 | NTclustered | gi|459376662|gb|KC669516.1| | 5778 | g313 | i0 | 100 | 96.1801075268817 | 358 | 0 | 96 | 0 | 1 | 358 | 386 | 29 | Vermamoeba vermiformis strain D_FLA14 18S ribosomal RNA gene, partial sequence | blastn | 35779 | 662 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10679276 | 10679276 | PRJNA494251_S_NODE_569_length_285_cov_0.768868_g554_i0 | PRJNA494251 | 569 | 285 | 0.768868 | 2.1912738 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 372 | 1.78e-98 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g554 | i0 | 91.636 | 1.61754385964912 | 275 | 13 | 95 | 7 | 14 | 285 | 559 | 826 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 461 | 372 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11310122 | 11310122 | PRJNA494251_S_NODE_509_length_301_cov_3.951754_g494_i0 | PRJNA494251 | 509 | 301 | 3.951754 | 11.89477954 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 521 | 1.7799999999999999e-143 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g494 | i0 | 99.306 | 41.0830564784053 | 288 | 2 | 96 | 0 | 1 | 288 | 1226 | 939 | 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 | 12366 | 521 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14504386 | 14504386 | PRJNA494251_S_NODE_592_length_280_cov_3.801932_g577_i0 | PRJNA494251 | 592 | 280 | 3.801932 | 10.6454096 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 490 | 4.61e-134 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g577 | i0 | 100 | 32.9285714285714 | 265 | 0 | 95 | 0 | 3 | 267 | 3680 | 3416 | 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 | 9220 | 490 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17052527 | 17052527 | PRJNA494251_P_NODE_20034_length_317_cov_1.381148_g19720_i0 | PRJNA494251 | 20034 | 317 | 1.381148 | 4.37823916 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 470 | 6.92e-128 | NTclustered | gi|421976355|gb|JQ519494.1| | 5778 | g19720 | i0 | 93.375 | 13.5709779179811 | 317 | 21 | 100 | 0 | 1 | 317 | 781 | 465 | Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds | blastn | 4302 | 470 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20877449 | 20877449 | PRJNA494251_S_NODE_837_length_238_cov_2.448485_g822_i0 | PRJNA494251 | 837 | 238 | 2.448485 | 5.8273943 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 416 | 6.579999999999998e-112 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g822 | i0 | 100 | 95.0084033613445 | 225 | 0 | 95 | 0 | 1 | 225 | 4887 | 4663 | 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 | 22612 | 416 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23428047 | 23428047 | PRJNA494251_P_NODE_9479_length_433_cov_1.502778_g9174_i0 | PRJNA494251 | 9479 | 433 | 1.502778 | 6.50702874 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 558 | 2.02e-154 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g9174 | i0 | 95.677 | 0.89838337182448 | 347 | 15 | 80 | 0 | 2 | 348 | 347 | 1 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 389 | 558 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25333266 | 25333266 | PRJNA494251_S_NODE_140_length_531_cov_3.292576_g125_i0 | PRJNA494251 | 140 | 531 | 3.292576 | 17.48357856 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 941 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g125 | i0 | 99.421 | 68.2335216572505 | 518 | 3 | 98 | 0 | 1 | 518 | 5575 | 5058 | 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 | 36232 | 941 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;