contig_metadata
12 rows where bioproject = "PRJEB6584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523720 | 25523720 | PRJEB6584d_S_NODE_16625_length_157_cov_1.450820_g16557_i0 | PRJEB6584 | 16625 | 157 | 1.45082 | 2.2777874 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 135 | 1.25e-27 | NTclustered | gi|345452564|gb|JF694300.1| | 1078836 | g16557 | i0 | 82.166 | 22.2866242038217 | 157 | 28 | 100 | 0 | 1 | 157 | 764 | 608 | Cryptodifflugia operculata clone 4 actin gene, partial cds | blastn | 3499 | 135 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25524754 | 25524754 | PRJEB6584o_S_NODE_26233_length_187_cov_4.993421_g26125_i0 | PRJEB6584 | 26233 | 187 | 4.993421 | 9.33769727 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 278 | 2.43e-70 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g26125 | i0 | 98.718 | 81.0374331550802 | 156 | 2 | 83 | 0 | 1 | 156 | 2662 | 2507 | 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 | 15154 | 278 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25659746 | 25659746 | PRJEB6584h_S_NODE_2770_length_298_cov_4.182510_g2708_i0 | PRJEB6584 | 2770 | 298 | 4.18251 | 12.4638798 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 145 | 4.44e-30 | NTclustered | gi|173717|gb|M19222.1|AMPRRM | 5775 | g2708 | i0 | 92.233 | 40.4664429530201 | 103 | 7 | 35 | 1 | 6 | 108 | 417 | 316 | A.proteus 28S large subunit rRNA, 5' end | blastn | 12059 | 145 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 25932021 | 25932021 | PRJEB6584h_S_NODE_10196_length_202_cov_1.610778_g10134_i0 | PRJEB6584 | 10196 | 202 | 1.610778 | 3.25377156 | Spumochlamys perforata | 675831 | Tubulinea | other_Eukaryota | 63.9 | 8.12e-6 | NTclustered | gi|259595675|gb|FJ705339.1| | 675831 | g10134 | i0 | 97.297 | 15.9356435643564 | 37 | 1 | 18 | 0 | 86 | 122 | 897 | 861 | Spumochlamys perforata clone 2504 18S ribosomal RNA gene, partial sequence | blastn | 3219 | 63.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys perforata | |||
| 25932086 | 25932086 | PRJEB6584h_S_NODE_7380_length_219_cov_18.260870_g7318_i0 | PRJEB6584 | 7380 | 219 | 18.26087 | 39.9913053 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 322 | 1.34e-83 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g7318 | i0 | 100 | 72.3698630136986 | 174 | 0 | 79 | 0 | 24 | 197 | 2667 | 2494 | 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 | 15849 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25933444 | 25933444 | PRJEB6584o_S_NODE_58004_length_163_cov_5.460938_g57896_i0 | PRJEB6584 | 58004 | 163 | 5.460938 | 8.90132894 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 291 | 2.64e-74 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g57896 | i0 | 98.773 | 1.5521472392638 | 163 | 2 | 100 | 0 | 1 | 163 | 2350 | 2512 | 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 | 253 | 291 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 26024604 | 26024604 | PRJEB6584p_S_NODE_2420_length_228_cov_5.709845_g2389_i0 | PRJEB6584 | 2420 | 228 | 5.709845 | 13.0184466 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 405 | 1.35e-108 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g2389 | i0 | 99.111 | 43.0043859649123 | 225 | 2 | 99 | 0 | 4 | 228 | 1220 | 996 | 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 | 9805 | 405 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26160164 | 26160164 | PRJEB6584a_S_NODE_1701_length_276_cov_9.867220_g1681_i0 | PRJEB6584 | 1701 | 276 | 9.86722 | 27.2335272 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 488 | 1.6299999999999995e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1681 | i0 | 98.551 | 37.8442028985507 | 276 | 4 | 100 | 0 | 1 | 276 | 947 | 1222 | 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 | 10445 | 488 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26204333 | 26204333 | PRJEB6584h_S_NODE_20918_length_178_cov_3.391608_g20856_i0 | PRJEB6584 | 20918 | 178 | 3.391608 | 6.03706224 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 324 | 2.89e-84 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g20856 | i0 | 99.438 | 1.50561797752809 | 178 | 1 | 100 | 0 | 1 | 178 | 2514 | 2337 | 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 | 268 | 324 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 26296508 | 26296508 | PRJEB6584o_S_NODE_9422_length_282_cov_29.720648_g9314_i0 | PRJEB6584 | 9422 | 282 | 29.720648 | 83.81222736 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 494 | 3.6e-135 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g9314 | i0 | 98.227 | 37.1879432624113 | 282 | 5 | 100 | 0 | 1 | 282 | 941 | 1222 | 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 | 10487 | 494 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26340985 | 26340985 | PRJEB6584o_S_NODE_20703_length_200_cov_2.575758_g20595_i0 | PRJEB6584 | 20703 | 200 | 2.575758 | 5.151516 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 337 | 4.28e-88 | NTclustered | gi|2517949732|gb|OR125031.1| | 1165352 | g20595 | i0 | 97 | 73.64 | 200 | 6 | 100 | 0 | 1 | 200 | 967 | 768 | Cryptodifflugia oviformis isolate strain_6 small subunit ribosomal RNA gene, partial sequence | blastn | 14728 | 337 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 26568246 | 26568246 | PRJEB6584n_S_NODE_264_length_263_cov_9.767544_g258_i0 | PRJEB6584 | 264 | 263 | 9.767544 | 25.68864072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 435 | 2.04e-117 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g258 | i0 | 98 | 21.2091254752852 | 250 | 5 | 95 | 0 | 14 | 263 | 1190 | 941 | 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 | 5578 | 435 | 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);;