contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1998915 | 1998915 | PRJNA744060_P_NODE_12482_length_453_cov_26.694737_g12154_i0 | PRJNA744060 | 12482 | 453 | 26.694737 | 120.92715861 | Karpovia croatica | 2925417 | Root_unresolved | Root_unresolved | 100 | 1.55e-16 | NTclustered | gi|2206682173|gb|OM966646.1| | 2925417 | g12154 | i0 | 88.235 | 13.5540838852097 | 85 | 9 | 19 | 1 | 341 | 425 | 6020 | 6103 | Karpovia croatica strain CRO19P6 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 | 6140 | 100 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Karpovia | Karpovia croatica | ||||
| 4551714 | 4551714 | PRJNA744060_P_NODE_25364_length_322_cov_12.188755_g25035_i0 | PRJNA744060 | 25364 | 322 | 12.188755 | 39.2477911 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 159 | 1.7299999999999999e-34 | NTclustered | gi|923119727|ref|XM_013897883.1| | 461836 | g25035 | i0 | 85 | 24.695652173913 | 160 | 20 | 49 | 2 | 165 | 322 | 350 | 193 | Thecamonas trahens ATCC 50062 ubiquitin-60S ribosomal protein L40 (AMSG_10625), partial mRNA | blastn | 7952 | 159 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5826490 | 5826490 | PRJNA744060_P_NODE_13345_length_439_cov_2.289617_g13016_i0 | PRJNA744060 | 13345 | 439 | 2.289617 | 10.05141863 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 76.8 | 2.52e-9 | NTclustered | gi|923134692|ref|XM_013905358.1| | 461836 | g13016 | i0 | 89.831 | 0.134396355353075 | 59 | 6 | 13 | 0 | 1 | 59 | 208 | 266 | Thecamonas trahens ATCC 50062 60S ribosomal protein L37-A (AMSG_02263), partial mRNA | blastn | 59 | 76.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8376596 | 8376596 | PRJNA744060_P_NODE_3107_length_878_cov_2.078261_g2847_i0 | PRJNA744060 | 3107 | 878 | 2.078261 | 18.24713158 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 411 | 1.27e-109 | NTclustered | gi|923127182|ref|XM_013901604.1| | 461836 | g2847 | i0 | 81.31 | 13.4236902050114 | 519 | 85 | 58 | 12 | 1 | 513 | 682 | 1194 | Thecamonas trahens ATCC 50062 deoxyhypusine synthase (AMSG_06376), partial mRNA | blastn | 11786 | 411 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12202748 | 12202748 | PRJNA744060_P_NODE_32050_length_290_cov_1.852535_g31721_i0 | PRJNA744060 | 32050 | 290 | 1.852535 | 5.3723515 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 302 | 2.41e-77 | NTclustered | gi|923129133|ref|XM_013902579.1| | 461836 | g31721 | i0 | 86.014 | 52.5068965517241 | 286 | 34 | 98 | 6 | 8 | 290 | 1119 | 837 | Thecamonas trahens ATCC 50062 RuvB-like 1 (AMSG_05323), partial mRNA | blastn | 15227 | 302 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 13477332 | 13477332 | PRJNA744060_P_NODE_44431_length_252_cov_1.307263_g44102_i0 | PRJNA744060 | 44431 | 252 | 1.307263 | 3.29430276 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 191 | 4.64e-44 | NTclustered | gi|923125065|ref|XM_013900547.1| | 461836 | g44102 | i0 | 85.635 | 43.8015873015873 | 181 | 26 | 72 | 0 | 36 | 216 | 859 | 679 | Thecamonas trahens ATCC 50062 60S ribosomal protein L3 (AMSG_07514), mRNA | blastn | 11038 | 191 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 18574845 | 18574845 | PRJNA744060_P_NODE_2235_length_1011_cov_4.398721_g2013_i0 | PRJNA744060 | 2235 | 1011 | 4.398721 | 44.47106931 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 132 | 1.28e-25 | NTclustered | gi|923136453|ref|XM_013906238.1| | 461836 | g2013 | i0 | 85.827 | 0.168150346191889 | 127 | 14 | 12 | 3 | 748 | 873 | 265 | 142 | Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA | blastn | 170 | 132 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19850104 | 19850104 | PRJNA744060_P_NODE_20436_length_357_cov_6.323944_g20107_i0 | PRJNA744060 | 20436 | 357 | 6.323944 | 22.57648008 | Cavaliersmithia chaoae | 3003318 | Root_unresolved | Root_unresolved | 206 | 2.4499999999999998e-48 | NTclustered | gi|2206682172|gb|OM966645.1| | 3003318 | g20107 | i0 | 89.937 | 42.7983193277311 | 159 | 16 | 45 | 0 | 1 | 159 | 6450 | 6608 | Cavaliersmithia chaoae strain FABANU 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 | 15279 | 206 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Cavaliersmithia | Cavaliersmithia chaoae | ||||
| 19850296 | 19850296 | PRJNA744060_P_NODE_30096_length_298_cov_2.315556_g29767_i0 | PRJNA744060 | 30096 | 298 | 2.315556 | 6.90035688 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 159 | 1.59e-34 | NTclustered | gi|923134014|ref|XM_013905019.1| | 461836 | g29767 | i0 | 83.815 | 1.3758389261745 | 173 | 22 | 57 | 6 | 8 | 177 | 1685 | 1854 | Thecamonas trahens ATCC 50062 ABC transporter E family member 2 (AMSG_03144), mRNA | blastn | 410 | 159 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23676625 | 23676625 | PRJNA744060_P_NODE_51539_length_241_cov_5.398810_g51210_i0 | PRJNA744060 | 51539 | 241 | 5.39881 | 13.0111321 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 163 | 9.61e-36 | NTclustered | gi|923130274|ref|XM_013903149.1| | 461836 | g51210 | i0 | 88.235 | 29.9087136929461 | 136 | 16 | 56 | 0 | 104 | 239 | 742 | 607 | Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA | blastn | 7208 | 163 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens |
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);;