contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6282353 | 6282353 | PRJNA690124_P_NODE_24445_length_332_cov_0.891892_g24079_i0 | PRJNA690124 | 24445 | 332 | 0.891892 | 2.96108144 | Metazoa | 33208 | Mollusca | Mollusca | 174 | 6.4e-39 | NTclustered | gi|28411617|dbj|AB103134.1| | 106318 | g24079 | i0 | 77.644 | 42.0451807228916 | 331 | 45 | 99 | 18 | 3 | 332 | 3142 | 2840 | Parvamussium intuscostatum gene for ITS2, 28S rRNA, partial sequence, country:Japan: central Honshu (Misaki) | blastn | 13959 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Propeamussiidae | Parvamussium | Parvamussium intuscostatum | |
| 9597563 | 9597563 | PRJNA690124_P_NODE_21868_length_348_cov_1.629091_g21502_i0 | PRJNA690124 | 21868 | 348 | 1.629091 | 5.66923668 | Argopecten irradians | 31199 | Mollusca | Mollusca | 265 | 3.89e-66 | NTclustered | gi|2835371159|ref|XM_069259847.1| | 31199 | g21502 | i0 | 81.424 | 90.0804597701149 | 323 | 60 | 93 | 0 | 24 | 346 | 150 | 472 | PREDICTED: Argopecten irradians actin, cytoplasmic-like (LOC138317873), mRNA | blastn | 31348 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 10107320 | 10107320 | PRJNA690124_P_NODE_46288_length_250_cov_1.322034_g45922_i0 | PRJNA690124 | 46288 | 250 | 1.322034 | 3.305085 | Haliotis | 6452 | Mollusca | Mollusca | 80.5 | 1.04e-10 | NTclustered | gi|2245661101|ref|XM_046473226.2| | 6454 | g45922 | i0 | 88.06 | 0.536 | 67 | 8 | 27 | 0 | 17 | 83 | 948 | 882 | PREDICTED: Haliotis rufescens calponin-1-like (LOC124113004), mRNA | blastn | 134 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 10873287 | 10873287 | PRJNA690124_P_NODE_33349_length_287_cov_1.822430_g32983_i0 | PRJNA690124 | 33349 | 287 | 1.82243 | 5.2303741 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 139 | 1.98e-28 | NTclustered | gi|2868674442|ref|XM_070346359.1| | 31220 | g32983 | i0 | 77.5 | 2.50871080139373 | 240 | 48 | 83 | 4 | 51 | 287 | 954 | 718 | PREDICTED: Littorina saxatilis calponin-1-like (LOC138973627), transcript variant X3, mRNA | blastn | 720 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 10873852 | 10873852 | PRJNA690124_P_NODE_7269_length_595_cov_1.208812_g6908_i0 | PRJNA690124 | 7269 | 595 | 1.208812 | 7.1924314 | Ostrea edulis | 37623 | Mollusca | Mollusca | 156 | 4.36e-33 | NTclustered | gi|2507407891|ref|XM_048917896.2| | 37623 | g6908 | i0 | 77.821 | 3.33613445378151 | 257 | 53 | 43 | 4 | 51 | 306 | 2531 | 2278 | PREDICTED: Ostrea edulis polyadenylate-binding protein 4-like (LOC125679019), mRNA | blastn | 1985 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 17246749 | 17246749 | PRJNA690124_P_NODE_13834_length_433_cov_1.688889_g13469_i0 | PRJNA690124 | 13834 | 433 | 1.688889 | 7.31288937 | Platevindex sp. XL-2018 | 2136288 | Mollusca | Mollusca | 213 | 1.81e-50 | NTclustered | gi|1369214222|gb|KY646463.1| | 2136288 | g13469 | i0 | 76.247 | 62.4087759815243 | 421 | 88 | 96 | 11 | 5 | 419 | 3574 | 3160 | Platevindex sp. XL-2018 myosin heavy chain mRNA, complete cds | blastn | 27023 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Systellommatophora | Onchidiidae | Platevindex | Platevindex sp. XL-2018 | |
| 23622055 | 23622055 | PRJNA690124_P_NODE_30999_length_297_cov_2.178571_g30633_i0 | PRJNA690124 | 30999 | 297 | 2.178571 | 6.47035587 | Liolophura japonica | 13599 | Mollusca | Mollusca | 209 | 1.55e-49 | NTclustered | gi|2724235633|ref|XM_064742816.1| | 13599 | g30633 | i0 | 84.689 | 47.0841750841751 | 209 | 32 | 70 | 0 | 5 | 213 | 209 | 1 | PREDICTED: Liolophura japonica tubulin beta chain (LOC135465566), mRNA | blastn | 13984 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 24896108 | 24896108 | PRJNA690124_P_NODE_9400_length_524_cov_1.860310_g9035_i0 | PRJNA690124 | 9400 | 524 | 1.86031 | 9.7480244 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 307 | 9.93e-79 | NTclustered | gi|2868614015|ref|XM_070321681.1| | 31220 | g9035 | i0 | 79.075 | 39.6679389312977 | 454 | 89 | 86 | 6 | 23 | 473 | 567 | 117 | PREDICTED: Littorina saxatilis eukaryotic translation elongation factor 2-like (LOC138949893), mRNA | blastn | 20786 | 307 | 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);;