contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554720 | 554720 | PRJNA565584_P_NODE_127981_length_277_cov_1.014706_g126829_i0 | PRJNA565584 | 127981 | 277 | 1.014706 | 2.81073562 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 193 | 1.44e-44 | NTclustered | gi|923125359|ref|XM_013900694.1| | 461836 | g126829 | i0 | 84 | 19.5703971119134 | 200 | 32 | 72 | 0 | 36 | 235 | 330 | 529 | Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA | blastn | 5421 | 193 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 556352 | 556352 | PRJNA565584_P_NODE_220241_length_231_cov_2.734177_g219089_i0 | PRJNA565584 | 220241 | 231 | 2.734177 | 6.31594887 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 239 | 1.48e-58 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g219089 | i0 | 85.654 | 1.02597402597403 | 237 | 22 | 100 | 11 | 1 | 231 | 6943 | 6713 | Singekia franciliensis strain ORSAYFEB19APU1 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 | 237 | 239 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 3105289 | 3105289 | PRJNA565584_P_NODE_108303_length_289_cov_1.425926_g107151_i0 | PRJNA565584 | 108303 | 289 | 1.425926 | 4.12092614 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 268 | 2.44e-67 | NTclustered | gi|923137248|ref|XM_013906635.1| | 461836 | g107151 | i0 | 83.681 | 98.5536332179931 | 288 | 43 | 99 | 2 | 1 | 286 | 1217 | 1502 | Thecamonas trahens ATCC 50062 inositol-3-phosphate synthase (AMSG_00912), mRNA | blastn | 28482 | 268 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5661232 | 5661232 | PRJNA565584_P_NODE_66985_length_363_cov_1.486207_g65834_i0 | PRJNA565584 | 66985 | 363 | 1.486207 | 5.39493141 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 156 | 2.55e-33 | NTclustered | gi|923125900|ref|XM_013900964.1| | 461836 | g65834 | i0 | 85.811 | 9.6831955922865 | 148 | 19 | 40 | 2 | 202 | 348 | 147 | 1 | Thecamonas trahens ATCC 50062 60S ribosomal protein L39 (AMSG_06579), partial mRNA | blastn | 3515 | 156 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5661546 | 5661546 | PRJNA565584_P_NODE_85785_length_321_cov_1.161290_g84633_i0 | PRJNA565584 | 85785 | 321 | 1.16129 | 3.7277409 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 254 | 7.69e-63 | NTclustered | gi|923130274|ref|XM_013903149.1| | 461836 | g84633 | i0 | 88.942 | 74.3115264797508 | 208 | 19 | 64 | 4 | 64 | 269 | 53 | 258 | Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA | blastn | 23854 | 254 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9483551 | 9483551 | PRJNA565584_P_NODE_148168_length_263_cov_2.105263_g147016_i0 | PRJNA565584 | 148168 | 263 | 2.105263 | 5.53684169 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 121 | 6.489999999999999e-23 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g147016 | i0 | 79.365 | 1.24334600760456 | 189 | 25 | 68 | 10 | 83 | 261 | 200 | 384 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 327 | 121 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10758987 | 10758987 | PRJNA565584_P_NODE_119649_length_282_cov_1.373206_g118497_i0 | PRJNA565584 | 119649 | 282 | 1.373206 | 3.87244092 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 167 | 8.9e-37 | NTclustered | gi|923125065|ref|XM_013900547.1| | 461836 | g118497 | i0 | 80.93 | 8.3936170212766 | 215 | 37 | 76 | 4 | 43 | 255 | 866 | 654 | Thecamonas trahens ATCC 50062 60S ribosomal protein L3 (AMSG_07514), mRNA | blastn | 2367 | 167 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 13308927 | 13308927 | PRJNA565584_P_NODE_133811_length_273_cov_1.300000_g132659_i0 | PRJNA565584 | 133811 | 273 | 1.3 | 3.549 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 143 | 1.45e-29 | NTclustered | gi|923125900|ref|XM_013900964.1| | 461836 | g132659 | i0 | 90 | 19.5018315018315 | 110 | 11 | 40 | 0 | 8 | 117 | 37 | 146 | Thecamonas trahens ATCC 50062 60S ribosomal protein L39 (AMSG_06579), partial mRNA | blastn | 5324 | 143 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14583296 | 14583296 | PRJNA565584_P_NODE_109852_length_288_cov_1.432558_g108700_i0 | PRJNA565584 | 109852 | 288 | 1.432558 | 4.12576704 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 134 | 9.25e-27 | NTclustered | gi|923139350|ref|XM_013907686.1| | 461836 | g108700 | i0 | 79.793 | 3.67361111111111 | 193 | 31 | 66 | 8 | 100 | 288 | 275 | 463 | Thecamonas trahens ATCC 50062 S-phase kinase-associated protein 1 (AMSG_00283), mRNA | blastn | 1058 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15859624 | 15859624 | PRJNA565584_P_NODE_44593_length_447_cov_2.216578_g43442_i0 | PRJNA565584 | 44593 | 447 | 2.216578 | 9.90810366 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 193 | 2.44e-44 | NTclustered | gi|923135694|ref|XM_013905859.1| | 461836 | g43442 | i0 | 82.222 | 23.1051454138702 | 225 | 38 | 50 | 2 | 163 | 386 | 913 | 690 | Thecamonas trahens ATCC 50062 V-type H(+)-translocating pyrophosphatase, variant (AMSG_01802), mRNA | blastn | 10328 | 193 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20957346 | 20957346 | PRJNA565584_P_NODE_148377_length_263_cov_1.621053_g147225_i0 | PRJNA565584 | 148377 | 263 | 1.621053 | 4.26336939 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 65.8 | 3.08e-6 | NTclustered | gi|923130972|ref|XM_013903498.1| | 461836 | g147225 | i0 | 91.489 | 1.75285171102662 | 47 | 4 | 18 | 0 | 195 | 241 | 2627 | 2673 | Thecamonas trahens ATCC 50062 cell division control protein (AMSG_04168), partial mRNA | blastn | 461 | 65.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 22234551 | 22234551 | PRJNA565584_P_NODE_69858_length_355_cov_2.670213_g68707_i0 | PRJNA565584 | 69858 | 355 | 2.670213 | 9.47925615 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 124 | 7.02e-24 | NTclustered | gi|923118232|ref|XM_013897139.1| | 461836 | g68707 | i0 | 83.969 | 0.738028169014085 | 131 | 19 | 37 | 2 | 221 | 350 | 233 | 362 | Thecamonas trahens ATCC 50062 60S ribosomal protein L7 (AMSG_11553), partial mRNA | blastn | 262 | 124 | 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);;