contig_metadata
12 rows where bioproject = "PRJNA681822", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 653209 | 653209 | PRJNA681822_P_NODE_232141_length_291_cov_0.903670_g230652_i0 | PRJNA681822 | 232141 | 291 | 0.90367 | 2.6296797 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 449 | 8.180000000000001e-122 | NTclustered | gi|345452574|gb|JF694305.1| | 1078836 | g230652 | i0 | 94.502 | 71.2783505154639 | 291 | 16 | 100 | 0 | 1 | 291 | 703 | 413 | Cryptodifflugia operculata clone 9 actin gene, partial cds | blastn | 20742 | 449 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 1170543 | 1170543 | PRJNA681822_P_NODE_342741_length_262_cov_2.280423_g341252_i0 | PRJNA681822 | 342741 | 262 | 2.280423 | 5.97470826 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 139 | 8.219999999999999e-40 | NR | AFX73059.1 | 1078836 | g341252 | i0 | 81.4 | 0.984732824427481 | 86 | 16 | 98.5 | 0 | 260 | 3 | 64 | 149 | AFX73059.1 14-3-3 protein, partial [Cryptodifflugia operculata] | diamond | 258 | 139 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 2446081 | 2446081 | PRJNA681822_P_NODE_37662_length_610_cov_2.668529_g36240_i0 | PRJNA681822 | 37662 | 610 | 2.668529 | 16.2780269 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 630 | 6.0999999999999996e-176 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g36240 | i0 | 86.69 | 88.9229508196721 | 571 | 72 | 93 | 4 | 5 | 573 | 607 | 39 | Glaeseria mira actin mRNA, partial cds | blastn | 54243 | 630 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 7031189 | 7031189 | PRJNA681822_P_NODE_181766_length_319_cov_1.739837_g180278_i0 | PRJNA681822 | 181766 | 319 | 1.739837 | 5.55008003 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 590 | 5.1299999999999986e-164 | NTclustered | gi|2402051306|gb|OP984113.1| | 5778 | g180278 | i0 | 100 | 100 | 319 | 0 | 100 | 0 | 1 | 319 | 392 | 74 | Vermamoeba vermiformis clone AD4C_R small subunit ribosomal RNA gene, partial sequence | blastn | 31900 | 590 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12131205 | 12131205 | PRJNA681822_P_NODE_137610_length_351_cov_5.500000_g136122_i0 | PRJNA681822 | 137610 | 351 | 5.5 | 19.305 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 638 | 1.9999999999999996e-178 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g136122 | i0 | 99.43 | 50.2022792022792 | 351 | 2 | 100 | 0 | 1 | 351 | 4027 | 4377 | 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 | 17621 | 638 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12132756 | 12132756 | PRJNA681822_P_NODE_241150_length_288_cov_2.381395_g239661_i0 | PRJNA681822 | 241150 | 288 | 2.381395 | 6.8584176 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 499 | 7.92e-137 | NTclustered | gi|345452574|gb|JF694305.1| | 1078836 | g239661 | i0 | 97.917 | 97.3923611111111 | 288 | 6 | 100 | 0 | 1 | 288 | 161 | 448 | Cryptodifflugia operculata clone 9 actin gene, partial cds | blastn | 28049 | 499 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 12136268 | 12136268 | PRJNA681822_P_NODE_66290_length_461_cov_1.481959_g64816_i0 | PRJNA681822 | 66290 | 461 | 1.481959 | 6.83183099 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 394 | 6.45e-105 | NTclustered | gi|421976286|gb|JQ519399.1| | 1078836 | g64816 | i0 | 88.308 | 14.3492407809111 | 325 | 38 | 70 | 0 | 137 | 461 | 475 | 151 | Cryptodifflugia operculata clone JG11.5_7 14-3-3 protein gene, partial cds | blastn | 6615 | 394 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 13407284 | 13407284 | PRJNA681822_P_NODE_23371_length_785_cov_3.271067_g22095_i0 | PRJNA681822 | 23371 | 785 | 3.271067 | 25.67787595 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 1013 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g22095 | i0 | 89.975 | 35.8662420382166 | 788 | 74 | 100 | 5 | 1 | 785 | 3038 | 2253 | 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 | 28155 | 1013 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 19780198 | 19780198 | PRJNA681822_P_NODE_23656_length_780_cov_6.721358_g22372_i0 | PRJNA681822 | 23656 | 780 | 6.721358 | 52.4265924 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 1020 | 0 | NTclustered | gi|345452574|gb|JF694305.1| | 1078836 | g22372 | i0 | 95.069 | 94.1076923076923 | 649 | 30 | 83 | 2 | 133 | 780 | 795 | 148 | Cryptodifflugia operculata clone 9 actin gene, partial cds | blastn | 73404 | 1020 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 22329198 | 22329198 | PRJNA681822_P_NODE_131798_length_357_cov_1.084507_g130311_i0 | PRJNA681822 | 131798 | 357 | 1.084507 | 3.87168999 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 243 | 1.8700000000000001e-59 | NTclustered | gi|421976286|gb|JQ519399.1| | 1078836 | g130311 | i0 | 82.784 | 3.40336134453782 | 273 | 45 | 76 | 2 | 84 | 355 | 74 | 345 | Cryptodifflugia operculata clone JG11.5_7 14-3-3 protein gene, partial cds | blastn | 1215 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 24122441 | 24122441 | PRJNA681822_P_NODE_32159_length_664_cov_2.304569_g30767_i0 | PRJNA681822 | 32159 | 664 | 2.304569 | 15.30233816 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1116 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g30767 | i0 | 96.997 | 56.480421686747 | 666 | 16 | 100 | 3 | 1 | 664 | 5773 | 5110 | 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 | 37503 | 1116 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30461580 | 30461580 | PRJNA681822_P_NODE_380953_length_251_cov_1.730337_g379464_i0 | PRJNA681822 | 380953 | 251 | 1.730337 | 4.34314587 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 61.6 | 9.72e-10 | NR | ABD72565.1 | 5778 | g379464 | i0 | 80 | 0.418326693227092 | 35 | 7 | 41.8 | 0 | 106 | 2 | 2 | 36 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 105 | 61.6 | 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);;