contig_metadata
7 rows where bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5672722 | 5672722 | PRJNA597223_P_NODE_26325_length_301_cov_4.409774_g24480_i0 | PRJNA597223 | 26325 | 301 | 4.409774 | 13.27341974 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 499 | 8.32e-137 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g24480 | i0 | 96.98 | 94.8571428571429 | 298 | 8 | 99 | 1 | 1 | 298 | 3700 | 3404 | 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 | 28552 | 499 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 13323145 | 13323145 | PRJNA597223_P_NODE_51291_length_194_cov_17.811321_g49445_i0 | PRJNA597223 | 51291 | 194 | 17.811321 | 34.55396274 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 322 | 1.16e-83 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g49445 | i0 | 96.875 | 38.5618556701031 | 192 | 6 | 99 | 0 | 1 | 192 | 3260 | 3069 | 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 | 7481 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 18420706 | 18420706 | PRJNA597223_P_NODE_11015_length_519_cov_21.216942_g9317_i0 | PRJNA597223 | 11015 | 519 | 21.216942 | 110.11592898 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 643 | 6.599999999999998e-180 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g9317 | i0 | 89.06 | 29.5838150289017 | 521 | 53 | 99 | 3 | 1 | 518 | 3036 | 2517 | 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 | 15354 | 643 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 18421190 | 18421190 | PRJNA597223_P_NODE_53315_length_190_cov_56.219355_g51469_i0 | PRJNA597223 | 53315 | 190 | 56.219355 | 106.8167745 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 268 | 1.49e-67 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g51469 | i0 | 97.452 | 82.0947368421053 | 157 | 4 | 83 | 0 | 10 | 166 | 1675 | 1831 | 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 | 15598 | 268 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 19695509 | 19695509 | PRJNA597223_P_NODE_39536_length_228_cov_1.880829_g37690_i0 | PRJNA597223 | 39536 | 228 | 1.880829 | 4.28829012 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 322 | 1.4e-83 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g37690 | i0 | 92.793 | 52.2763157894737 | 222 | 16 | 97 | 0 | 6 | 227 | 2226 | 2447 | 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 | 11919 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 20971207 | 20971207 | PRJNA597223_P_NODE_27517_length_292_cov_4.898833_g25671_i0 | PRJNA597223 | 27517 | 292 | 4.898833 | 14.30459236 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 207 | 5.46e-49 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g25671 | i0 | 85.507 | 10.736301369863 | 207 | 20 | 69 | 9 | 1 | 202 | 202 | 1 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 3135 | 207 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 23521422 | 23521422 | PRJNA597223_P_NODE_4099_length_860_cov_6.333333_g3016_i0 | PRJNA597223 | 4099 | 860 | 6.333333 | 54.4666638 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 1144 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g3016 | i0 | 91.176 | 34.4755813953488 | 850 | 63 | 99 | 11 | 11 | 858 | 4777 | 3938 | 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 | 29649 | 1144 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata |
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);;