contig_metadata
11 rows where bioproject = "PRJEB14175", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25511846 | 25511846 | PRJEB14175_P_NODE_83385_length_398_cov_30.510386_g81121_i0 | PRJEB14175 | 83385 | 398 | 30.510386 | 121.43133628 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 449 | 1.1599999999999999e-121 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g81121 | i0 | 89.802 | 94.7110552763819 | 353 | 33 | 88 | 3 | 48 | 398 | 1 | 352 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 37695 | 449 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 25641043 | 25641043 | PRJEB14175_P_NODE_190018_length_236_cov_2.794286_g187751_i0 | PRJEB14175 | 190018 | 236 | 2.794286 | 6.59451496 | Heleopera rosea | 499111 | Tubulinea | other_Eukaryota | 156 | 1.57e-33 | NTclustered | gi|166203599|gb|EU392157.1| | 499111 | g187751 | i0 | 80.905 | 73.0974576271186 | 199 | 36 | 83 | 2 | 40 | 236 | 428 | 626 | Heleopera rosea from Switzerland small subunit ribosomal RNA gene, partial sequence | blastn | 17251 | 156 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Heleoperidae | Heleopera | Heleopera rosea | ||
| 25644645 | 25644645 | PRJEB14175_P_NODE_279378_length_170_cov_4.009174_g277110_i0 | PRJEB14175 | 279378 | 170 | 4.009174 | 6.8155958 | Leptomyxa silvatica | 2865940 | Tubulinea | other_Eukaryota | 302 | 1.28e-77 | NTclustered | gi|2075694065|gb|MZ687121.1| | 2865940 | g277110 | i0 | 98.824 | 99.0117647058824 | 170 | 1 | 100 | 1 | 1 | 170 | 5 | 173 | Leptomyxa silvatica strain Tomsk small subunit ribosomal RNA gene, partial sequence | blastn | 16832 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Leptomyxidae | Leptomyxa | Leptomyxa silvatica | ||
| 25773838 | 25773838 | PRJEB14175_P_NODE_117971_length_323_cov_3.664122_g115705_i0 | PRJEB14175 | 117971 | 323 | 3.664122 | 11.83511406 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 403 | 7.27e-108 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g115705 | i0 | 90.728 | 46.3157894736842 | 302 | 28 | 93 | 0 | 22 | 323 | 2313 | 2614 | 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 | 14960 | 403 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25779731 | 25779731 | PRJEB14175_P_NODE_250179_length_203_cov_1.373239_g247911_i0 | PRJEB14175 | 250179 | 203 | 1.373239 | 2.78767517 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 364 | 2e-96 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g247911 | i0 | 99.015 | 95.807881773399 | 203 | 2 | 100 | 0 | 1 | 203 | 2235 | 2033 | 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 | 19449 | 364 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26015251 | 26015251 | PRJEB14175_P_NODE_100116_length_357_cov_9.192568_g97850_i0 | PRJEB14175 | 100116 | 357 | 9.192568 | 32.81746776 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 597 | 3.4599999999999986e-166 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g97850 | i0 | 98.806 | 92.0028011204482 | 335 | 4 | 94 | 0 | 1 | 335 | 1210 | 876 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 32845 | 603 | 0.990049751243781 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 26018829 | 26018829 | PRJEB14175_P_NODE_38324_length_602_cov_49.602588_g36147_i0 | PRJEB14175 | 38324 | 602 | 49.602588 | 298.60757976 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 963 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g36147 | i0 | 98.185 | 52.6644518272425 | 551 | 10 | 92 | 0 | 52 | 602 | 5244 | 5794 | 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 | 31704 | 963 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26049370 | 26049370 | PRJEB14175_P_NODE_189669_length_236_cov_7.931429_g187402_i0 | PRJEB14175 | 189669 | 236 | 7.931429 | 18.71817244 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 259 | 1.16e-64 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g187402 | i0 | 88.785 | 89.5254237288136 | 214 | 21 | 89 | 2 | 4 | 214 | 1511 | 1298 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 21128 | 259 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 26153604 | 26153604 | PRJEB14175_P_NODE_220133_length_213_cov_4.631579_g217865_i0 | PRJEB14175 | 220133 | 213 | 4.631579 | 9.86526327 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 375 | 9.79e-100 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g217865 | i0 | 100 | 6.89201877934272 | 203 | 0 | 95 | 0 | 11 | 213 | 997 | 1199 | 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 | 1468 | 375 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26323205 | 26323205 | PRJEB14175_P_NODE_234095_length_207_cov_1.945205_g231827_i0 | PRJEB14175 | 234095 | 207 | 1.945205 | 4.02657435 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 117 | 6.33e-22 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g231827 | i0 | 84.298 | 31.56038647343 | 121 | 18 | 58 | 1 | 17 | 137 | 3703 | 3822 | 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 | 6533 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 26324729 | 26324729 | PRJEB14175_P_NODE_273071_length_185_cov_5.516129_g270803_i0 | PRJEB14175 | 273071 | 185 | 5.516129 | 10.20483865 | Ptolemeba bulliensis | 1525729 | Tubulinea | other_Eukaryota | 285 | 1.43e-72 | NTclustered | gi|2723225182|gb|PP732398.1| | 1525729 | g270803 | i0 | 98.171 | 79.2864864864865 | 164 | 2 | 88 | 1 | 23 | 185 | 444 | 607 | Ptolemeba bulliensis isolate P4F0 EUK small subunit ribosomal RNA gene, partial sequence | blastn | 14668 | 285 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba bulliensis |
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);;