contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3494846 | 3494846 | PRJNA971593_P_NODE_15863_length_300_cov_1.356828_g15714_i0 | PRJNA971593 | 15863 | 300 | 1.356828 | 4.070484 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|1207923208|ref|XM_021494935.1| | 6573 | g15714 | i0 | 100 | 0.0933333333333333 | 28 | 0 | 9 | 0 | 273 | 300 | 1322 | 1295 | PREDICTED: Mizuhopecten yessoensis serine/threonine-protein phosphatase 2B catalytic subunit 2-like (LOC110448600), transcript variant X3, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 3818241 | 3818241 | PRJNA971593_P_NODE_21763_length_252_cov_1.284916_g21614_i0 | PRJNA971593 | 21763 | 252 | 1.284916 | 3.23798832 | Haliotis | 6452 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2194123832|ref|XM_046717931.1| | 36100 | g21614 | i0 | 100 | 0.333333333333333 | 28 | 0 | 11 | 0 | 86 | 113 | 873 | 846 | PREDICTED: Haliotis rubra coiled-coil domain-containing protein 149-B-like (LOC124281923), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 6047584 | 6047584 | PRJNA971593_P_NODE_5205_length_532_cov_1.169935_g5058_i0 | PRJNA971593 | 5205 | 532 | 1.169935 | 6.2240542 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.015 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g5058 | i0 | 96.875 | 0.0601503759398496 | 32 | 1 | 6 | 0 | 125 | 156 | 34929903 | 34929934 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8597344 | 8597344 | PRJNA971593_P_NODE_4727_length_557_cov_3.818182_g4581_i0 | PRJNA971593 | 4727 | 557 | 3.818182 | 21.26727374 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.7 | 0.015 | NTclustered | gi|1835549550|ref|XM_033904731.1| | 6579 | g4581 | i0 | 96.875 | 0.229802513464991 | 32 | 1 | 6 | 0 | 493 | 524 | 2079 | 2048 | PREDICTED: Pecten maximus uncharacterized LOC117342549 (LOC117342549), transcript variant X2, mRNA | blastn | 128 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 12423465 | 12423465 | PRJNA971593_P_NODE_23350_length_249_cov_1.835227_g23201_i0 | PRJNA971593 | 23350 | 249 | 1.835227 | 4.56971523 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2868663586|ref|XM_070355941.1| | 31220 | g23201 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 110 | 137 | 1886 | 1859 | PREDICTED: Littorina saxatilis early growth response protein 1-like (LOC138982611), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 12423597 | 12423597 | PRJNA971593_P_NODE_570_length_1397_cov_1.876888_g498_i0 | PRJNA971593 | 570 | 1397 | 1.876888 | 26.22012536 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 54.7 | 0.04 | NTclustered | gi|2693932198|ref|XM_063556611.1| | 6551 | g498 | i0 | 96.97 | 0.0236220472440945 | 33 | 0 | 2 | 1 | 387 | 419 | 858 | 827 | PREDICTED: Mytilus trossulus KICSTOR complex protein ITFG2-like (LOC134695381), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 13697863 | 13697863 | PRJNA971593_P_NODE_16031_length_298_cov_1.520000_g15882_i0 | PRJNA971593 | 16031 | 298 | 1.52 | 4.5296 | Liolophura japonica | 13599 | Mollusca | Mollusca | 60.2 | 1.66e-4 | NTclustered | gi|2724225090|ref|XM_064761512.1| | 13599 | g15882 | i0 | 94.737 | 1.69127516778523 | 38 | 2 | 13 | 0 | 2 | 39 | 1202 | 1239 | PREDICTED: Liolophura japonica calmodulin-A-like (LOC135481797), transcript variant X1, mRNA | blastn | 504 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 14972276 | 14972276 | PRJNA971593_P_NODE_27072_length_244_cov_0.900585_g26923_i0 | PRJNA971593 | 27072 | 244 | 0.900585 | 2.1974274 | Haliotis rubra | 36100 | Mollusca | Mollusca | 60.2 | 1.32e-4 | NTclustered | gi|2194098174|ref|XM_046705287.1| | 36100 | g26923 | i0 | 100 | 1.84016393442623 | 32 | 0 | 13 | 0 | 183 | 214 | 369 | 338 | PREDICTED: Haliotis rubra putative protein TPRXL (LOC124270250), mRNA | blastn | 449 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 18796122 | 18796122 | PRJNA971593_P_NODE_26995_length_244_cov_0.900585_g26846_i0 | PRJNA971593 | 26995 | 244 | 0.900585 | 2.1974274 | Argopecten irradians | 31199 | Mollusca | Mollusca | 196 | 9.61e-46 | NTclustered | gi|2835371225|ref|XM_069259879.1| | 31199 | g26846 | i0 | 82.667 | 2.81147540983607 | 225 | 35 | 91 | 4 | 1 | 223 | 1149 | 927 | PREDICTED: Argopecten irradians signal recognition particle subunit SRP54 (LOC138317909), mRNA | blastn | 686 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 20071083 | 20071083 | PRJNA971593_P_NODE_6396_length_481_cov_1.740196_g6248_i0 | PRJNA971593 | 6396 | 481 | 1.740196 | 8.37034276 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.047 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g6248 | i0 | 100 | 0.0582120582120582 | 28 | 0 | 6 | 0 | 180 | 207 | 22357829 | 22357856 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;