contig_metadata
7 rows where bioproject = "PRJNA927284", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3452720 | 3452720 | PRJNA927284_P_NODE_1663_length_561_cov_2.827068_g1492_i0 | PRJNA927284 | 1663 | 561 | 2.827068 | 15.85985148 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 904 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g1492 | i0 | 95.722 | 81.8360071301248 | 561 | 24 | 100 | 0 | 1 | 561 | 2049 | 1489 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 45910 | 904 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 7630682 | 7630682 | PRJNA927284_P_NODE_5426_length_241_cov_2.433962_g5219_i0 | PRJNA927284 | 5426 | 241 | 2.433962 | 5.86584842 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.5299999999999999e-68 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5219 | i0 | 97.484 | 2.81327800829876 | 159 | 4 | 66 | 0 | 1 | 159 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 678 | 272 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8905361 | 8905361 | PRJNA927284_P_NODE_6247_length_214_cov_1.800000_g6040_i0 | PRJNA927284 | 6247 | 214 | 1.8 | 3.852 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.66e-92 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6040 | i0 | 96.262 | 100 | 214 | 8 | 100 | 0 | 1 | 214 | 2552 | 2765 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21400 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13655598 | 13655598 | PRJNA927284_P_NODE_8811_length_160_cov_1.114504_g8604_i0 | PRJNA927284 | 8811 | 160 | 1.114504 | 1.7832064 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.5799999999999998e-74 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g8604 | i0 | 99.375 | 1 | 160 | 1 | 100 | 0 | 1 | 160 | 21 | 180 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 160 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14929795 | 14929795 | PRJNA927284_P_NODE_5832_length_226_cov_2.786802_g5625_i0 | PRJNA927284 | 5832 | 226 | 2.786802 | 6.29817252 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 3.73e-109 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g5625 | i0 | 99.115 | 80.3628318584071 | 226 | 2 | 100 | 0 | 1 | 226 | 671 | 896 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 18162 | 407 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 17830057 | 17830057 | PRJNA927284_P_NODE_1694_length_555_cov_2.602662_g1522_i0 | PRJNA927284 | 1694 | 555 | 2.602662 | 14.4447741 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 782 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1522 | i0 | 92.072 | 74.4486486486486 | 555 | 44 | 100 | 0 | 1 | 555 | 13 | 567 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 41319 | 782 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25479160 | 25479160 | PRJNA927284_P_NODE_3680_length_330_cov_2.362126_g3475_i0 | PRJNA927284 | 3680 | 330 | 2.362126 | 7.7950158 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 9.17e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3475 | i0 | 94.848 | 36.1787878787879 | 330 | 17 | 100 | 0 | 1 | 330 | 13 | 342 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 11939 | 516 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;