contig_metadata
7 rows where bioproject = "PRJNA922890", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20025379 | 20025379 | PRJNA922890_P_NODE_77556_length_231_cov_0.888889_g77146_i0 | PRJNA922890 | 77556 | 231 | 0.888889 | 2.05333359 | Lottia gigantea | 225164 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|676455154|ref|XM_009055665.1| | 225164 | g77146 | i0 | 100 | 0.12987012987013 | 30 | 0 | 13 | 0 | 196 | 225 | 2594 | 2565 | Lottia gigantea hypothetical protein mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 27972256 | 27972256 | PRJNA922890_P_NODE_54925_length_264_cov_1.107692_g54515_i0 | PRJNA922890 | 54925 | 264 | 1.107692 | 2.92430688 | Reishia bronni | 578817 | Mollusca | Mollusca | 76.3 | 7.7e-14 | NR | QIQ54702.1 | 578817 | g54515 | i0 | 42.2 | 2.875 | 83 | 48 | 94.3 | 0 | 249 | 1 | 277 | 359 | QIQ54702.1 capsule gland specific secretory protein [Reishia bronni] | diamond | 759 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Muricidae | Reishia | Reishia bronni | |
| 29368833 | 29368833 | PRJNA922890_P_NODE_69709_length_235_cov_0.867470_g69299_i0 | PRJNA922890 | 69709 | 235 | 0.86747 | 2.0385545 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 1.88e-9 | NR | XP_052077796.1 | 6549 | g69299 | i0 | 52.8 | 3.35744680851064 | 53 | 24 | 67.7 | 1 | 77 | 235 | 80 | 131 | XP_052077796.1 eukaryotic translation initiation factor 3 subunit F-like [Mytilus californianus] | diamond | 789 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 29835073 | 29835073 | PRJNA922890_P_NODE_61891_length_247_cov_2.949438_g61481_i0 | PRJNA922890 | 61891 | 247 | 2.949438 | 7.28511186 | Haliotis rubra | 36100 | Mollusca | Mollusca | 45.4 | 0.0042 | NR | XP_046576515.1 | 36100 | g61481 | i0 | 34.6 | 0.631578947368421 | 52 | 30 | 63.2 | 1 | 10 | 165 | 194 | 241 | XP_046576515.1 uncharacterized skeletal organic matrix protein 2-like [Haliotis rubra] | diamond | 156 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 30126516 | 30126516 | PRJNA922890_P_NODE_69472_length_235_cov_0.879518_g69062_i0 | PRJNA922890 | 69472 | 235 | 0.879518 | 2.0668673 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00362 | NR | XP_050391094.1 | 6465 | g69062 | i0 | 34.9 | 2.4 | 63 | 38 | 80.4 | 1 | 224 | 36 | 97 | 156 | XP_050391094.1 probable glutathione S-transferase 7 [Patella vulgata] | diamond | 564 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32023433 | 32023433 | PRJNA922890_P_NODE_33438_length_331_cov_2.736641_g33028_i0 | PRJNA922890 | 33438 | 331 | 2.736641 | 9.05828171 | Metazoa | 33208 | Mollusca | Mollusca | 160 | 8.049999999999999e-46 | NR | KAL5019371.1 | 13268 | g33028 | i0 | 67.3 | 11.6555891238671 | 110 | 35 | 99.7 | 1 | 1 | 330 | 3 | 111 | KAL5019371.1 hypothetical protein ScPMuIL_005093 [Solemya velum] | diamond | 3858 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32047831 | 32047831 | PRJNA922890_P_NODE_49338_length_277_cov_2.615385_g48928_i0 | PRJNA922890 | 49338 | 277 | 2.615385 | 7.24461645 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 52 | 1.94e-5 | NR | XP_060081351.1 | 509963 | g48928 | i0 | 34.6 | 3.34657039711191 | 78 | 51 | 84.5 | 0 | 31 | 264 | 98 | 175 | XP_060081351.1 glutathione S-transferase Mu 4-like [Ylistrum balloti] | diamond | 927 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti |
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);;