contig_metadata
20 rows where bioproject = "PRJNA964500", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5093765 | 5093765 | PRJNA964500_S_NODE_1184_length_417_cov_34.525773_g1093_i0 | PRJNA964500 | 1184 | 417 | 34.525773 | 143.97247341 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1093 | i0 | 97.97 | 72.89448441247 | 394 | 8 | 94 | 0 | 24 | 417 | 1492 | 1885 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 30397 | 684 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6045013 | 6045013 | PRJNA964500_S_NODE_1085_length_430_cov_8.785536_g995_i0 | PRJNA964500 | 1085 | 430 | 8.785536 | 37.7778048 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 752 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g995 | i0 | 99.048 | 94.7 | 420 | 3 | 98 | 1 | 7 | 426 | 1030 | 1448 | Vorticella sp. 4 JG-2011 clone 2 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 | 40721 | 752 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 6045019 | 6045019 | PRJNA964500_S_NODE_11285_length_178_cov_5.127517_g11193_i0 | PRJNA964500 | 11285 | 178 | 5.127517 | 9.12698026 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.35e-77 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g11193 | i0 | 99.398 | 93.0674157303371 | 166 | 1 | 93 | 0 | 1 | 166 | 933 | 1098 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 16566 | 302 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 6045092 | 6045092 | PRJNA964500_S_NODE_8865_length_196_cov_324.131737_g8773_i0 | PRJNA964500 | 8865 | 196 | 324.131737 | 635.29820452 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.99e-71 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g8773 | i0 | 100 | 77.9540816326531 | 152 | 0 | 78 | 0 | 35 | 186 | 1823 | 1672 | Vorticella sp. 4 JG-2011 clone 2 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 | 15279 | 281 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 7643449 | 7643449 | PRJNA964500_S_NODE_1026_length_437_cov_16.073529_g937_i0 | PRJNA964500 | 1026 | 437 | 16.073529 | 70.24132173 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.012 | NTclustered | gi|390988043|gb|JN885111.1| | 35097 | g937 | i0 | 100 | 0.528604118993135 | 29 | 0 | 7 | 0 | 207 | 235 | 1703 | 1675 | Cohnilembus verminus isolate FXP2009051101 large subunit ribsomal RNA gene, partial sequence | blastn | 231 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Cohnilembidae | Cohnilembus | Cohnilembus verminus | ||
| 8918308 | 8918308 | PRJNA964500_S_NODE_1467_length_386_cov_14.445378_g1375_i0 | PRJNA964500 | 1467 | 386 | 14.445378 | 55.75915908 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.3599999999999994e-165 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1375 | i0 | 96.399 | 37.1088082901554 | 361 | 13 | 94 | 0 | 1 | 361 | 361 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 14324 | 595 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9869966 | 9869966 | PRJNA964500_S_NODE_1468_length_386_cov_12.616246_g1376_i0 | PRJNA964500 | 1468 | 386 | 12.616246 | 48.69870956 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 6.41e-154 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1376 | i0 | 94.46 | 42.8911917098446 | 361 | 20 | 94 | 0 | 1 | 361 | 361 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16556 | 556 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10194195 | 10194195 | PRJNA964500_S_NODE_16368_length_154_cov_3.360000_g16276_i0 | PRJNA964500 | 16368 | 154 | 3.36 | 5.1744 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.14e-72 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g16276 | i0 | 100 | 100 | 154 | 0 | 100 | 0 | 1 | 154 | 626 | 779 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 15400 | 285 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 11145453 | 11145453 | PRJNA964500_S_NODE_13309_length_167_cov_7.485507_g13217_i0 | PRJNA964500 | 13309 | 167 | 7.485507 | 12.50079669 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g13217 | i0 | 100 | 100.017964071856 | 167 | 0 | 100 | 0 | 1 | 167 | 2431 | 2265 | Vorticella sp. 4 JG-2011 clone 2 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 | 16703 | 309 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 12744747 | 12744747 | PRJNA964500_S_NODE_6650_length_220_cov_295.445026_g6558_i0 | PRJNA964500 | 6650 | 220 | 295.445026 | 649.97905720000006 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.87e-90 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6558 | i0 | 100 | 85.7818181818182 | 186 | 0 | 85 | 0 | 1 | 186 | 1139 | 954 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 18872 | 344 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 14019260 | 14019260 | PRJNA964500_S_NODE_15511_length_157_cov_9.328125_g15419_i0 | PRJNA964500 | 15511 | 157 | 9.328125 | 14.64515625 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.52e-71 | NTclustered | gi|347439265|gb|JN111978.1| | 151077 | g15419 | i0 | 99.355 | 100.165605095541 | 155 | 1 | 99 | 0 | 1 | 155 | 867 | 1021 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 15726 | 281 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14969760 | 14969760 | PRJNA964500_S_NODE_1632_length_372_cov_11.830904_g1540_i0 | PRJNA964500 | 1632 | 372 | 11.830904 | 44.01096288 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 562 | 1.32e-155 | NTclustered | gi|347439265|gb|JN111978.1| | 151077 | g1540 | i0 | 95.251 | 78.8413978494624 | 358 | 12 | 96 | 5 | 17 | 372 | 912 | 558 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 29329 | 562 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16244656 | 16244656 | PRJNA964500_S_NODE_1513_length_381_cov_6.744318_g1421_i0 | PRJNA964500 | 1513 | 381 | 6.744318 | 25.69585158 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 7.33e-49 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g1421 | i0 | 84.615 | 20.2808398950131 | 208 | 32 | 55 | 0 | 48 | 255 | 1076 | 1283 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 7727 | 207 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 17519922 | 17519922 | PRJNA964500_S_NODE_914_length_455_cov_160.190141_g826_i0 | PRJNA964500 | 914 | 455 | 160.190141 | 728.86514155 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g826 | i0 | 96.437 | 66.4351648351648 | 421 | 15 | 93 | 0 | 35 | 455 | 2332 | 1912 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 30228 | 695 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 19116842 | 19116842 | PRJNA964500_S_NODE_11415_length_177_cov_13.891892_g11323_i0 | PRJNA964500 | 11415 | 177 | 13.891892 | 24.58864884 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.09e-75 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g11323 | i0 | 98.78 | 17.225988700565 | 164 | 2 | 93 | 0 | 1 | 164 | 1454 | 1291 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3049 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20391830 | 20391830 | PRJNA964500_S_NODE_8816_length_197_cov_3.577381_g8724_i0 | PRJNA964500 | 8816 | 197 | 3.577381 | 7.04744057 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 4.21e-88 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g8724 | i0 | 97.462 | 8.58883248730965 | 197 | 5 | 100 | 0 | 1 | 197 | 2371 | 2567 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1692 | 337 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 21343926 | 21343926 | PRJNA964500_S_NODE_2077_length_342_cov_190.996805_g1985_i0 | PRJNA964500 | 2077 | 342 | 190.996805 | 653.2090731 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 3.529999999999999e-121 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g1985 | i0 | 92.88 | 134.874269005848 | 309 | 20 | 90 | 2 | 1 | 308 | 1723 | 1416 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 46127 | 448 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 21667791 | 21667791 | PRJNA964500_S_NODE_4217_length_264_cov_40664.187234_g4125_i0 | PRJNA964500 | 4217 | 264 | 40664.187234 | 107353.45429776 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.26e-99 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g4125 | i0 | 100 | 76.8939393939394 | 203 | 0 | 77 | 0 | 54 | 256 | 1465 | 1263 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 20300 | 375 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 23894381 | 23894381 | PRJNA964500_S_NODE_7919_length_205_cov_370.068182_g7827_i0 | PRJNA964500 | 7919 | 205 | 370.068182 | 758.6397731 | Stentor sp. | 1431124 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 5.75e-82 | NTclustered | gi|1820251602|gb|MT175596.1| | 1431124 | g7827 | i0 | 100 | 232.575609756098 | 171 | 0 | 83 | 0 | 1 | 171 | 100 | 270 | Stentor sp. isolate CY2019012101 large subunit ribosomal RNA gene, partial sequence | blastn | 47678 | 316 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor sp. | ||
| 25168012 | 25168012 | PRJNA964500_S_NODE_980_length_442_cov_24005.903148_g891_i0 | PRJNA964500 | 980 | 442 | 24005.903148 | 106106.09191416 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 689 | 0 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g891 | i0 | 99.734 | 78.8348416289593 | 376 | 1 | 85 | 0 | 11 | 386 | 1839 | 1464 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 34845 | 689 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 |
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);;