contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2308971 | 2308971 | PRJNA1146029_P_NODE_4082_length_424_cov_1.316239_g3804_i0 | PRJNA1146029 | 4082 | 424 | 1.316239 | 5.58085336 | Metazoa | 33208 | Mollusca | Mollusca | 100 | 1.44e-16 | NTclustered | gi|1207980031|ref|XM_021483861.1| | 6573 | g3804 | i0 | 81.203 | 1.86792452830189 | 133 | 17 | 30 | 7 | 6 | 134 | 481 | 609 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S5 (LOC110440710), mRNA | blastn | 792 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 2841108 | 2841108 | PRJNA1146029_P_NODE_9663_length_293_cov_2.100000_g9382_i0 | PRJNA1146029 | 9663 | 293 | 2.1 | 6.153 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 305 | 1.89e-78 | NTclustered | gi|2245706711|ref|XM_048385483.1| | 6454 | g9382 | i0 | 88.492 | 81.8259385665529 | 252 | 29 | 86 | 0 | 1 | 252 | 290 | 39 | PREDICTED: Haliotis rufescens tubulin beta chain-like (LOC124142795), transcript variant X3, mRNA | blastn | 23975 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 4861810 | 4861810 | PRJNA1146029_P_NODE_9164_length_300_cov_2.022026_g8883_i0 | PRJNA1146029 | 9164 | 300 | 2.022026 | 6.066078 | Metazoa | 33208 | Mollusca | Mollusca | 183 | 9.479999999999998e-42 | NTclustered | gi|325297036|ref|NM_001204593.1| | 6500 | g8883 | i0 | 80.498 | 57.0633333333333 | 241 | 46 | 80 | 1 | 2 | 242 | 29 | 268 | Aplysia californica ribosomal protein L27a (LOC100533291), mRNA | blastn | 17119 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 5393507 | 5393507 | PRJNA1146029_P_NODE_9445_length_296_cov_2.417040_g9164_i0 | PRJNA1146029 | 9445 | 296 | 2.41704 | 7.1544384 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 191 | 5.58e-44 | NTclustered | gi|2868622250|ref|XM_070342082.1| | 31220 | g9164 | i0 | 79.11 | 3.16216216216216 | 292 | 49 | 97 | 10 | 1 | 286 | 3029 | 3314 | PREDICTED: Littorina saxatilis myosin heavy chain, striated muscle-like (LOC138969316), mRNA | blastn | 936 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 6668033 | 6668033 | PRJNA1146029_P_NODE_20586_length_243_cov_4.123529_g20305_i0 | PRJNA1146029 | 20586 | 243 | 4.1235290000000004 | 10.02017547 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g20305 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 215 | 242 | 66561567 | 66561540 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6668139 | 6668139 | PRJNA1146029_P_NODE_7306_length_331_cov_1.492248_g7028_i0 | PRJNA1146029 | 7306 | 331 | 1.492248 | 4.93934088 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 265 | 3.68e-66 | NTclustered | gi|2868657593|ref|XM_070331548.1| | 31220 | g7028 | i0 | 81.595 | 68.6102719033233 | 326 | 54 | 98 | 6 | 2 | 324 | 2515 | 2193 | PREDICTED: Littorina saxatilis myosin heavy chain, striated muscle-like (LOC138959884), transcript variant X6, mRNA | blastn | 22710 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 9218219 | 9218219 | PRJNA1146029_P_NODE_4728_length_397_cov_4.805556_g4450_i0 | PRJNA1146029 | 4728 | 397 | 4.805556 | 19.07805732 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 433 | 1.1599999999999999e-116 | NTclustered | gi|2868695775|ref|XM_070338800.1| | 31220 | g4450 | i0 | 91.429 | 79.0654911838791 | 315 | 27 | 79 | 0 | 1 | 315 | 464 | 150 | PREDICTED: Littorina saxatilis tubulin alpha-1A chain (LOC138966535), mRNA | blastn | 31389 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 13043645 | 13043645 | PRJNA1146029_P_NODE_10771_length_286_cov_1.154930_g10490_i0 | PRJNA1146029 | 10771 | 286 | 1.15493 | 3.3030998 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|1914623226|ref|XM_029801219.2| | 2607531 | g10490 | i0 | 100 | 0.195804195804196 | 28 | 0 | 10 | 0 | 39 | 66 | 1765 | 1792 | PREDICTED: Octopus sinensis G kinase-anchoring protein 1 (LOC115231126), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 14319111 | 14319111 | PRJNA1146029_P_NODE_4232_length_417_cov_1.186047_g3954_i0 | PRJNA1146029 | 4232 | 417 | 1.186047 | 4.94581599 | Aplysia californica | 6500 | Mollusca | Mollusca | 259 | 2.2e-64 | NTclustered | gi|1897933277|ref|XM_035971296.1| | 6500 | g3954 | i0 | 79.028 | 78.9184652278177 | 391 | 72 | 93 | 10 | 1 | 386 | 3597 | 3212 | PREDICTED: Aplysia californica myosin heavy chain, striated muscle (LOC101851430), mRNA | blastn | 32909 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 19416078 | 19416078 | PRJNA1146029_P_NODE_13036_length_271_cov_1.555556_g12755_i0 | PRJNA1146029 | 13036 | 271 | 1.555556 | 4.21555676 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2592064882|ref|XM_060212040.1| | 509963 | g12755 | i0 | 100 | 0.103321033210332 | 28 | 0 | 10 | 0 | 15 | 42 | 4621 | 4594 | PREDICTED: Ylistrum balloti protein CDV3 homolog (LOC132548218), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 20691686 | 20691686 | PRJNA1146029_P_NODE_22617_length_226_cov_2.013072_g22335_i0 | PRJNA1146029 | 22617 | 226 | 2.013072 | 4.54954272 | Aplysia californica | 6500 | Mollusca | Mollusca | 176 | 1.14e-39 | NTclustered | gi|1897922439|ref|XM_013081821.2| | 6500 | g22335 | i0 | 82.126 | 12.8628318584071 | 207 | 35 | 91 | 2 | 1 | 206 | 1208 | 1003 | PREDICTED: Aplysia californica catalase (LOC101860167), mRNA | blastn | 2907 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;