contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 442962 | 442962 | PRJNA454503_P_NODE_85261_length_202_cov_0.921986_g84932_i0 | PRJNA454503 | 85261 | 202 | 0.921986 | 1.86241172 | Magallana angulata | 2784310 | Mollusca | Mollusca | 263 | 7.46e-66 | NTclustered | gi|2416898718|ref|XR_008241844.1| | 2784310 | g84932 | i0 | 90.594 | 2 | 202 | 14 | 100 | 4 | 1 | 202 | 5874 | 5678 | PREDICTED: Crassostrea angulata uncharacterized LOC128170470 (LOC128170470), transcript variant X2, ncRNA | blastn | 404 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 8095732 | 8095732 | PRJNA454503_P_NODE_5467_length_491_cov_2.123256_g5141_i0 | PRJNA454503 | 5467 | 491 | 2.123256 | 10.42518696 | Haliotis rubra | 36100 | Mollusca | Mollusca | 222 | 3.45e-53 | NTclustered | gi|2194121661|ref|XM_046716832.1| | 36100 | g5141 | i0 | 81.55 | 17.4643584521385 | 271 | 48 | 55 | 2 | 206 | 475 | 389 | 120 | PREDICTED: Haliotis rubra dynein light chain 2, cytoplasmic (LOC124280844), transcript variant X4, mRNA | blastn | 8575 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 11296640 | 11296640 | PRJNA454503_P_NODE_13989_length_307_cov_1.056911_g13660_i0 | PRJNA454503 | 13989 | 307 | 1.056911 | 3.24471677 | Opisthokonta | 33154 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912388332|ref|XM_071306682.1| | 6550 | g13660 | i0 | 92.105 | 0.30618892508143303 | 38 | 2 | 12 | 1 | 147 | 183 | 497 | 534 | PREDICTED: Mytilus edulis protein FAM50A-B-like (LOC139516520), mRNA | blastn | 94 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 11921150 | 11921150 | PRJNA454503_P_NODE_37290_length_230_cov_1.538462_g36961_i0 | PRJNA454503 | 37290 | 230 | 1.538462 | 3.5384626 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 73.1 | 1.58e-8 | NTclustered | gi|2364329892|ref|XM_052386426.1| | 45954 | g36961 | i0 | 81.443 | 7.63913043478261 | 97 | 11 | 39 | 4 | 28 | 117 | 2927 | 3023 | PREDICTED: Dreissena polymorpha mucin-2-like (LOC127852471), mRNA | blastn | 1757 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 12572786 | 12572786 | PRJNA454503_P_NODE_79430_length_204_cov_0.909091_g79101_i0 | PRJNA454503 | 79430 | 204 | 0.909091 | 1.85454564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 189 | 1.2999999999999996e-43 | NTclustered | gi|2296443956|ref|XM_050562754.1| | 6465 | g79101 | i0 | 83.415 | 36.7941176470588 | 205 | 33 | 100 | 1 | 1 | 204 | 257 | 53 | PREDICTED: Patella vulgata tubulin beta chain-like (LOC126832076), mRNA | blastn | 7506 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 14470719 | 14470719 | PRJNA454503_P_NODE_15892_length_291_cov_2.173913_g15563_i0 | PRJNA454503 | 15892 | 291 | 2.173913 | 6.32608683 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.79e-4 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g15563 | i0 | 92.683 | 1.70103092783505 | 41 | 2 | 14 | 1 | 4 | 43 | 30838660 | 30838700 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 495 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15744801 | 15744801 | PRJNA454503_P_NODE_22133_length_260_cov_3.311558_g21804_i0 | PRJNA454503 | 22133 | 260 | 3.311558 | 8.6100508 | Physella acuta | 109671 | Mollusca | Mollusca | 470 | 5.519999999999998e-128 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g21804 | i0 | 99.611 | 4.86923076923077 | 257 | 1 | 99 | 0 | 4 | 260 | 3642 | 3386 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 1266 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 18294365 | 18294365 | PRJNA454503_P_NODE_65955_length_208_cov_0.884354_g65626_i0 | PRJNA454503 | 65955 | 208 | 0.884354 | 1.83945632 | Magallana angulata | 2784310 | Mollusca | Mollusca | 285 | 1.6499999999999998e-72 | NTclustered | gi|2416903872|ref|XM_052838884.1| | 2784310 | g65626 | i0 | 91.827 | 8.75 | 208 | 11 | 100 | 3 | 1 | 208 | 3462 | 3663 | PREDICTED: Crassostrea angulata mothers against decapentaplegic homolog 2-like (LOC128173169), mRNA | blastn | 1820 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 19568044 | 19568044 | PRJNA454503_P_NODE_27416_length_243_cov_1.291209_g27087_i0 | PRJNA454503 | 27416 | 243 | 1.291209 | 3.13763787 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 147 | 9.77e-31 | NTclustered | gi|2502149611|ref|XM_056020795.1| | 6526 | g27087 | i0 | 86.923 | 6.04938271604938 | 130 | 17 | 53 | 0 | 114 | 243 | 156 | 285 | PREDICTED: Biomphalaria glabrata 40S ribosomal protein S14 (LOC106056330), mRNA | blastn | 1470 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 20844498 | 20844498 | PRJNA454503_P_NODE_74137_length_205_cov_0.902778_g73808_i0 | PRJNA454503 | 74137 | 205 | 0.902778 | 1.8506949 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|1397694405|ref|XM_025240812.1| | 400727 | g73808 | i0 | 100 | 4.58048780487805 | 30 | 0 | 15 | 0 | 4 | 33 | 700 | 671 | PREDICTED: Pomacea canaliculata uncharacterized LOC112565387 (LOC112565387), mRNA | blastn | 939 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 23395044 | 23395044 | PRJNA454503_P_NODE_7499_length_411_cov_1.228571_g7170_i0 | PRJNA454503 | 7499 | 411 | 1.228571 | 5.04942681 | Patella vulgata | 6465 | Mollusca | Mollusca | 132 | 4.93e-26 | NTclustered | gi|2506327506|ref|XM_050548262.2| | 6465 | g7170 | i0 | 81.988 | 0.776155717761557 | 161 | 23 | 38 | 5 | 150 | 307 | 714 | 557 | PREDICTED: Patella vulgata nascent polypeptide-associated complex subunit alpha (LOC126820362), mRNA | blastn | 319 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata |
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);;