contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1073005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186981 | 186981 | PRJNA1073005_P_NODE_2021_length_782_cov_3.145275_g1919_i0 | PRJNA1073005 | 2021 | 782 | 3.145275 | 24.5960505 | Concholepas concholepas | 137544 | Mollusca | Mollusca | 1013 | 0 | NTclustered | gi|443298642|gb|KC107792.1| | 137544 | g1919 | i0 | 91.622 | 57.8618925831202 | 740 | 50 | 94 | 5 | 1 | 734 | 38 | 771 | Concholepas concholepas ferritin mRNA, complete cds | blastn | 45248 | 1013 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Concholepas | Concholepas concholepas | |
| 186985 | 186985 | PRJNA1073005_P_NODE_4701_length_447_cov_1.852941_g4582_i0 | PRJNA1073005 | 4701 | 447 | 1.852941 | 8.28264627 | Rapana venosa | 55521 | Mollusca | Mollusca | 798 | 0 | NTclustered | gi|197935839|ref|NC_011193.1| | 55521 | g4582 | i0 | 98.881 | 46.0178970917226 | 447 | 5 | 100 | 0 | 1 | 447 | 13281 | 12835 | Rapana venosa mitochondrion, complete genome | blastn | 20570 | 798 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 186994 | 186994 | PRJNA1073005_P_NODE_7541_length_300_cov_2.713656_g7422_i0 | PRJNA1073005 | 7541 | 300 | 2.713656 | 8.140968 | Rapana venosa | 55521 | Mollusca | Mollusca | 549 | 8.119999999999997e-152 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g7422 | i0 | 99.667 | 62.9966666666667 | 300 | 1 | 100 | 0 | 1 | 300 | 8554 | 8255 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 18899 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 2737552 | 2737552 | PRJNA1073005_P_NODE_9303_length_249_cov_0.875000_g9184_i0 | PRJNA1073005 | 9303 | 249 | 0.875 | 2.17875 | Rapana venosa | 55521 | Mollusca | Mollusca | 460 | 3.16e-125 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g9184 | i0 | 100 | 16.8755020080321 | 249 | 0 | 100 | 0 | 1 | 249 | 2967 | 2719 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 4202 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 5289761 | 5289761 | PRJNA1073005_P_NODE_4985_length_428_cov_1.301408_g4866_i0 | PRJNA1073005 | 4985 | 428 | 1.301408 | 5.57002624 | Aplysia californica | 6500 | Mollusca | Mollusca | 320 | 1.0199999999999998e-82 | NTclustered | gi|1897945200|ref|XM_005112946.3| | 6500 | g4866 | i0 | 80.278 | 99.7943925233645 | 431 | 79 | 100 | 5 | 1 | 428 | 494 | 921 | PREDICTED: Aplysia californica elongation factor 1-alpha (LOC101850460), transcript variant X1, mRNA | blastn | 42712 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 14215654 | 14215654 | PRJNA1073005_P_NODE_4232_length_484_cov_2.136253_g4113_i0 | PRJNA1073005 | 4232 | 484 | 2.136253 | 10.33946452 | Rapana venosa | 55521 | Mollusca | Mollusca | 889 | 0 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g4113 | i0 | 99.793 | 68.9070247933884 | 484 | 1 | 100 | 0 | 1 | 484 | 856 | 373 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 33351 | 889 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 16763890 | 16763890 | PRJNA1073005_P_NODE_10494_length_226_cov_2.503268_g10375_i0 | PRJNA1073005 | 10494 | 226 | 2.503268 | 5.65738568 | Rapana venosa | 55521 | Mollusca | Mollusca | 418 | 1.7199999999999998e-112 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g10375 | i0 | 100 | 64.9778761061947 | 226 | 0 | 100 | 0 | 1 | 226 | 12605 | 12830 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 14685 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 16763900 | 16763900 | PRJNA1073005_P_NODE_7814_length_289_cov_1.125000_g7695_i0 | PRJNA1073005 | 7814 | 289 | 1.125 | 3.25125 | Sinotaia quadrata | 200191 | Mollusca | Mollusca | 231 | 3.1999999999999994e-56 | NTclustered | gi|2687757672|gb|PP391284.1| | 200191 | g7695 | i0 | 81.625 | 0.97923875432526 | 283 | 49 | 97 | 3 | 9 | 289 | 334 | 53 | Sinotaia quadrata tropomyosin mRNA, complete cds, alternatively spliced | blastn | 283 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Viviparidae | Sinotaia | Sinotaia quadrata | |
| 18038682 | 18038682 | PRJNA1073005_P_NODE_6435_length_350_cov_1.245487_g6316_i0 | PRJNA1073005 | 6435 | 350 | 1.245487 | 4.3592045 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 339 | 2.27e-88 | NTclustered | gi|2868695927|ref|XM_070338880.1| | 31220 | g6316 | i0 | 85.938 | 64.4828571428571 | 320 | 41 | 91 | 3 | 33 | 350 | 104 | 421 | PREDICTED: Littorina saxatilis small ribosomal subunit protein uS10-like (LOC138966596), mRNA | blastn | 22569 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 19312654 | 19312654 | PRJNA1073005_P_NODE_4236_length_484_cov_1.206813_g4117_i0 | PRJNA1073005 | 4236 | 484 | 1.206813 | 5.84097492 | Rapana venosa | 55521 | Mollusca | Mollusca | 883 | 0 | NTclustered | gi|197935839|ref|NC_011193.1| | 55521 | g4117 | i0 | 99.587 | 80.4090909090909 | 484 | 2 | 100 | 0 | 1 | 484 | 5643 | 5160 | Rapana venosa mitochondrion, complete genome | blastn | 38918 | 883 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 20588043 | 20588043 | PRJNA1073005_P_NODE_7657_length_295_cov_2.324324_g7538_i0 | PRJNA1073005 | 7657 | 295 | 2.324324 | 6.8567558 | Rapana venosa | 55521 | Mollusca | Mollusca | 536 | 6.199999999999999e-148 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g7538 | i0 | 99.659 | 94.5762711864407 | 293 | 1 | 99 | 0 | 1 | 293 | 1889 | 2181 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 27900 | 536 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 21863830 | 21863830 | PRJNA1073005_P_NODE_4118_length_493_cov_2.016667_g3999_i0 | PRJNA1073005 | 4118 | 493 | 2.016667 | 9.94216831 | Rapana venosa | 55521 | Mollusca | Mollusca | 905 | 0 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g3999 | i0 | 99.797 | 98.3184584178499 | 493 | 1 | 100 | 0 | 1 | 493 | 1458 | 966 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 48471 | 905 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 24412877 | 24412877 | PRJNA1073005_P_NODE_5020_length_426_cov_1.308782_g4901_i0 | PRJNA1073005 | 5020 | 426 | 1.308782 | 5.57541132 | Rapana venosa | 55521 | Mollusca | Mollusca | 787 | 0 | NTclustered | gi|2319117147|gb|MZ435265.1| | 55521 | g4901 | i0 | 100 | 100.159624413146 | 426 | 0 | 100 | 0 | 1 | 426 | 6053 | 5628 | Rapana venosa voucher NTM P.55685 mitochondrion, complete genome | blastn | 42668 | 787 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa | |
| 24412890 | 24412890 | PRJNA1073005_P_NODE_8280_length_273_cov_1.260000_g8161_i0 | PRJNA1073005 | 8280 | 273 | 1.26 | 3.4398 | Rapana venosa | 55521 | Mollusca | Mollusca | 65.8 | 3.22e-6 | NTclustered | gi|642944481|gb|KJ667084.1| | 55521 | g8161 | i0 | 90.196 | 0.186813186813187 | 51 | 4 | 19 | 1 | 45 | 95 | 462 | 511 | Rapana venosa clone Amf31 microsatellite sequence | blastn | 51 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Rapana | Rapana venosa |
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);;