contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1108487" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213402 | 213402 | PRJNA1108487_P_NODE_2161_length_461_cov_3.319588_g2095_i0 | PRJNA1108487 | 2161 | 461 | 3.319588 | 15.30330068 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 259 | 2.46e-64 | NTclustered | gi|470420864|ref|XM_004337293.1| | 1257118 | g2095 | i0 | 82.026 | 50.0802603036876 | 306 | 53 | 66 | 2 | 1 | 305 | 328 | 24 | Acanthamoeba castellanii str. Neff Peptidylprolyl cis-trans isomerase (ACA1_221090), partial mRNA | blastn | 23087 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1488101 | 1488101 | PRJNA1108487_P_NODE_3782_length_354_cov_1.882562_g3716_i0 | PRJNA1108487 | 3782 | 354 | 1.882562 | 6.66426948 | Didymium quitense | 2059305 | Evosea | other_Eukaryota | 222 | 2.41e-53 | NTclustered | gi|2329703132|gb|MW239927.1| | 2059305 | g3716 | i0 | 79.141 | 80.9604519774011 | 326 | 64 | 92 | 4 | 16 | 339 | 214 | 537 | Didymium quitense strain MA-Fungi 88326 alpha tubulin (aTUB) gene, partial cds | blastn | 28660 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium quitense | ||
| 4040240 | 4040240 | PRJNA1108487_P_NODE_8504_length_252_cov_1.743017_g8438_i0 | PRJNA1108487 | 8504 | 252 | 1.743017 | 4.39240284 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 89.8 | 1.74e-13 | NTclustered | gi|187764061|ref|NC_010653.1| | 261658 | g8438 | i0 | 98.039 | 0.428571428571429 | 51 | 1 | 20 | 0 | 122 | 172 | 21177 | 21227 | Dictyostelium fasciculatum mitochondrion, complete genome | blastn | 108 | 89.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 5316314 | 5316314 | PRJNA1108487_P_NODE_3805_length_353_cov_1.489286_g3739_i0 | PRJNA1108487 | 3805 | 353 | 1.489286 | 5.25717958 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 7.17e-4 | NTclustered | gi|470469416|ref|XM_004341948.1| | 1257118 | g3739 | i0 | 83.077 | 0.18413597733711 | 65 | 9 | 18 | 2 | 216 | 279 | 884 | 821 | Acanthamoeba castellanii str. Neff MORN repeatcontaining protein (ACA1_050500), partial mRNA | blastn | 65 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6591520 | 6591520 | PRJNA1108487_P_NODE_3846_length_352_cov_0.992832_g3780_i0 | PRJNA1108487 | 3846 | 352 | 0.992832 | 3.49476864 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 276 | 1.81e-69 | NTclustered | gi|66818754|ref|XM_637945.1| | 352472 | g3780 | i0 | 81.02 | 1.00284090909091 | 353 | 61 | 99 | 6 | 2 | 351 | 223 | 572 | Dictyostelium discoideum AX4 tyrosine-tRNA ligase (tyrS) mRNA, complete cds | blastn | 353 | 276 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 6591538 | 6591538 | PRJNA1108487_P_NODE_726_length_758_cov_18.759124_g667_i0 | PRJNA1108487 | 726 | 758 | 18.759124 | 142.19415992 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 344 | 1.12e-89 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g667 | i0 | 79.31 | 61.0488126649077 | 522 | 85 | 67 | 18 | 197 | 707 | 522 | 13 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 46275 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7398383 | 7398383 | PRJNA1108487_P_NODE_3466_length_367_cov_2.653061_g3400_i0 | PRJNA1108487 | 3466 | 367 | 2.653061 | 9.73673387 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 678 | 0 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g3400 | i0 | 100 | 75.1798365122616 | 367 | 0 | 100 | 0 | 1 | 367 | 1013 | 647 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 27591 | 678 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 7866159 | 7866159 | PRJNA1108487_P_NODE_1907_length_491_cov_2.468900_g1841_i0 | PRJNA1108487 | 1907 | 491 | 2.4689 | 12.122299 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 154 | 1.28e-32 | NTclustered | gi|831753332|ref|XM_012892328.1| | 1410327 | g1841 | i0 | 80.184 | 0.883910386965377 | 217 | 33 | 43 | 7 | 262 | 473 | 782 | 571 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 434 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 7866167 | 7866167 | PRJNA1108487_P_NODE_2427_length_435_cov_2.560773_g2361_i0 | PRJNA1108487 | 2427 | 435 | 2.560773 | 11.13936255 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 165 | 5.17e-36 | NTclustered | gi|831770213|ref|XM_012897483.1| | 1410327 | g2361 | i0 | 74.163 | 16.1770114942529 | 418 | 98 | 95 | 10 | 21 | 432 | 181 | 594 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 7037 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10416872 | 10416872 | PRJNA1108487_P_NODE_5969_length_292_cov_1.424658_g5903_i0 | PRJNA1108487 | 5969 | 292 | 1.424658 | 4.16000136 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 115 | 3.4e-21 | NTclustered | gi|831792201|ref|XM_012904512.1| | 1410327 | g5903 | i0 | 79.412 | 21.7945205479452 | 170 | 29 | 57 | 6 | 48 | 214 | 1166 | 1000 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 6364 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 15516043 | 15516043 | PRJNA1108487_P_NODE_533_length_875_cov_2.316708_g480_i0 | PRJNA1108487 | 533 | 875 | 2.316708 | 20.271195 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 544 | 1.19e-149 | NTclustered | gi|470510585|ref|XM_004351497.1| | 1257118 | g480 | i0 | 78.207 | 92.2822857142857 | 881 | 170 | 99 | 16 | 6 | 875 | 493 | 1362 | Acanthamoeba castellanii str. Neff transport protein Sec61 alpha subunit, putative (ACA1_149400), partial mRNA | blastn | 80747 | 544 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24439300 | 24439300 | PRJNA1108487_P_NODE_1020_length_652_cov_2.027634_g957_i0 | PRJNA1108487 | 1020 | 652 | 2.027634 | 13.22017368 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 355 | 4.41e-93 | NTclustered | gi|470512227|ref|XM_004352398.1| | 1257118 | g957 | i0 | 78.061 | 75.0061349693252 | 588 | 112 | 89 | 13 | 17 | 597 | 31 | 608 | Acanthamoeba castellanii str. Neff succinyl coenzyme A synthetase alpha subunit (ACA1_359750), partial mRNA | blastn | 48904 | 355 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;