contig_metadata
8 rows where bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17342059 | 17342059 | PRJNA782551_P_NODE_9474_length_305_cov_1.991379_g9352_i0 | PRJNA782551 | 9474 | 305 | 1.991379 | 6.07370595 | Liolophura japonica | 13599 | Mollusca | Mollusca | 195 | 4.46e-45 | NTclustered | gi|2724251389|ref|XM_064751378.1| | 13599 | g9352 | i0 | 79.286 | 65.3639344262295 | 280 | 56 | 91 | 2 | 27 | 305 | 1155 | 1433 | PREDICTED: Liolophura japonica tubulin beta-2B chain-like (LOC135471935), transcript variant X1, mRNA | blastn | 19936 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 26864085 | 26864085 | PRJNA782551_P_NODE_5941_length_382_cov_1.495146_g5819_i0 | PRJNA782551 | 5941 | 382 | 1.495146 | 5.71145772 | Magallana gigas | 29159 | Mollusca | Mollusca | 53.1 | 2.94e-5 | NR | XP_034313778.2 | 29159 | g5819 | i0 | 37.1 | 0.549738219895288 | 70 | 44 | 55 | 0 | 242 | 33 | 62 | 131 | XP_034313778.2 R3H domain-containing protein 4 [Magallana gigas] | diamond | 210 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27622434 | 27622434 | PRJNA782551_P_NODE_23544_length_242_cov_0.911243_g23422_i0 | PRJNA782551 | 23544 | 242 | 0.911243 | 2.20520806 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 73.2 | 7.02e-13 | NR | XP_022293402.1 | 6565 | g23422 | i0 | 62.5 | 5.72727272727273 | 56 | 21 | 69.4 | 0 | 202 | 35 | 775 | 830 | XP_022293402.1 LOW QUALITY PROTEIN: src substrate cortactin-like [Crassostrea virginica] | diamond | 1386 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 28105071 | 28105071 | PRJNA782551_P_NODE_6365_length_369_cov_1.557432_g6243_i0 | PRJNA782551 | 6365 | 369 | 1.557432 | 5.74692408 | Metazoa | 33208 | Mollusca | Mollusca | 184 | 2.5e-53 | NR | XP_046360100.2 | 6454 | g6243 | i0 | 74.6 | 5.94308943089431 | 122 | 31 | 99.2 | 0 | 3 | 368 | 351 | 472 | XP_046360100.2 4-hydroxybutyrate coenzyme A transferase-like [Haliotis rufescens] | diamond | 2193 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 28190391 | 28190391 | PRJNA782551_P_NODE_22746_length_243_cov_0.905882_g22624_i0 | PRJNA782551 | 22746 | 243 | 0.905882 | 2.20129326 | Pecten maximus | 6579 | Mollusca | Mollusca | 69.7 | 8.73e-13 | NR | XP_033733120.1 | 6579 | g22624 | i0 | 55 | 2.95061728395062 | 60 | 27 | 74.1 | 0 | 241 | 62 | 92 | 151 | XP_033733120.1 ATP synthase lipid-binding protein, mitochondrial-like isoform X2 [Pecten maximus] | diamond | 717 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 29548107 | 29548107 | PRJNA782551_P_NODE_10090_length_296_cov_1.381166_g9968_i0 | PRJNA782551 | 10090 | 296 | 1.381166 | 4.08825136 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 63.9 | 2.52e-9 | NR | XP_048251116.1 | 6454 | g9968 | i0 | 36.5 | 0.861486486486487 | 85 | 53 | 85.1 | 1 | 275 | 24 | 834 | 918 | XP_048251116.1 glutamyl aminopeptidase-like isoform X3 [Haliotis rufescens] | diamond | 255 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31317520 | 31317520 | PRJNA782551_P_NODE_21095_length_245_cov_0.895349_g20973_i0 | PRJNA782551 | 21095 | 245 | 0.895349 | 2.19360505 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 58.2 | 7.56e-8 | NR | KAK3605256.1 | 2493646 | g20973 | i0 | 46.9 | 0.991836734693878 | 81 | 41 | 96.7 | 2 | 245 | 9 | 78 | 158 | KAK3605256.1 hypothetical protein CHS0354_037657 [Potamilus streckersoni] | diamond | 243 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 31453520 | 31453520 | PRJNA782551_P_NODE_10536_length_290_cov_1.691244_g10414_i0 | PRJNA782551 | 10536 | 290 | 1.691244 | 4.9046076 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 0.00215 | NR | XP_070204869.1 | 31220 | g10414 | i0 | 39.5 | 2.2551724137931 | 76 | 43 | 75.5 | 2 | 227 | 9 | 88 | 163 | XP_070204869.1 uncharacterized protein [Littorina saxatilis] | diamond | 654 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis |
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);;