contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27009135 | 27009135 | PRJNA1199330_P_NODE_10342_length_648_cov_4.351304_g9677_i0 | PRJNA1199330 | 10342 | 648 | 4.351304 | 28.19644992 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 137 | 1.11e-33 | NR | XP_055896909.1 | 6526 | g9677 | i0 | 56.8 | 1.125 | 118 | 45 | 53.2 | 3 | 575 | 231 | 7 | 121 | XP_055896909.1 tyramine beta-hydroxylase-like [Biomphalaria glabrata] | diamond | 729 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27483339 | 27483339 | PRJNA1199330_P_NODE_102183_length_252_cov_0.871508_g101484_i0 | PRJNA1199330 | 102183 | 252 | 0.871508 | 2.19620016 | Magallana gigas | 29159 | Mollusca | Mollusca | 55.8 | 9.91e-7 | NR | XP_011446104.3 | 29159 | g101484 | i0 | 41.3 | 1.48809523809524 | 63 | 33 | 75 | 2 | 195 | 7 | 135 | 193 | XP_011446104.3 galactose-3-O-sulfotransferase 2 [Magallana gigas] | diamond | 375 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27546487 | 27546487 | PRJNA1199330_P_NODE_102684_length_251_cov_2.365169_g101985_i0 | PRJNA1199330 | 102684 | 251 | 2.365169 | 5.93657419 | Solemya velum | 13268 | Mollusca | Mollusca | 61.6 | 6.59e-9 | NR | KAL5016063.1 | 13268 | g101985 | i0 | 45.1 | 3.32270916334661 | 71 | 35 | 83.7 | 3 | 211 | 2 | 85 | 152 | KAL5016063.1 hypothetical protein ScPMuIL_005652 [Solemya velum] | diamond | 834 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 28165325 | 28165325 | PRJNA1199330_P_NODE_114105_length_243_cov_2.552941_g113406_i0 | PRJNA1199330 | 114105 | 243 | 2.552941 | 6.20364663 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 3.34e-29 | NR | KAH9513846.1 | 55810 | g113406 | i0 | 60.5 | 25.9506172839506 | 81 | 32 | 100 | 0 | 243 | 1 | 247 | 327 | KAH9513846.1 hypothetical protein Btru_031546 [Bulinus truncatus] | diamond | 6306 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 28272492 | 28272492 | PRJNA1199330_P_NODE_32246_length_364_cov_3.364261_g31549_i0 | PRJNA1199330 | 32246 | 364 | 3.364261 | 12.24591004 | Liolophura japonica | 13599 | Mollusca | Mollusca | 137 | 5.82e-36 | NR | XP_064607890.1 | 13599 | g31549 | i0 | 57.1 | 0.980769230769231 | 119 | 49 | 97.3 | 2 | 355 | 2 | 103 | 220 | XP_064607890.1 methionine adenosyltransferase 2 subunit beta-like [Liolophura japonica] | diamond | 357 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 28670602 | 28670602 | PRJNA1199330_P_NODE_77827_length_274_cov_4.144279_g77128_i0 | PRJNA1199330 | 77827 | 274 | 4.144279 | 11.35532446 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.0112 | NR | KAK6186241.1 | 87958 | g77128 | i0 | 31.4 | 1.55474452554745 | 70 | 45 | 76.6 | 1 | 264 | 55 | 292 | 358 | KAK6186241.1 hypothetical protein SNE40_008316 [Patella caerulea] | diamond | 426 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 29617349 | 29617349 | PRJNA1199330_P_NODE_63530_length_287_cov_2.691589_g62831_i0 | PRJNA1199330 | 63530 | 287 | 2.691589 | 7.72486043 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 4.01e-26 | NR | XP_064610840.1 | 13599 | g62831 | i0 | 59.1 | 43.01393728223 | 93 | 38 | 97.2 | 0 | 285 | 7 | 78 | 170 | XP_064610840.1 uncharacterized protein LOC135475036 [Liolophura japonica] | diamond | 12345 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 29788077 | 29788077 | PRJNA1199330_P_NODE_51151_length_301_cov_3.131579_g50452_i0 | PRJNA1199330 | 51151 | 301 | 3.131579 | 9.42605279 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 50.4 | 1.54e-4 | NR | KAL3872338.1 | 1069815 | g50452 | i0 | 38.4 | 0.857142857142857 | 86 | 41 | 83.7 | 2 | 4 | 255 | 3189 | 3264 | KAL3872338.1 hypothetical protein ACJMK2_040269 [Sinanodonta woodiana] | diamond | 258 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 29883200 | 29883200 | PRJNA1199330_P_NODE_80451_length_272_cov_2.085427_g79752_i0 | PRJNA1199330 | 80451 | 272 | 2.085427 | 5.67236144 | Elysia crispata | 231223 | Mollusca | Mollusca | 62 | 9.04e-9 | NR | KAK3729151.1 | 231223 | g79752 | i0 | 41.6 | 0.981617647058823 | 89 | 47 | 94.9 | 2 | 261 | 4 | 444 | 530 | KAK3729151.1 hypothetical protein RRG08_025492 [Elysia crispata] | diamond | 267 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 30483350 | 30483350 | PRJNA1199330_P_NODE_51873_length_301_cov_2.679825_g51174_i0 | PRJNA1199330 | 51873 | 301 | 2.679825 | 8.06627325 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 50.4 | 1.49e-4 | NR | KAJ8311568.1 | 220873 | g51174 | i0 | 51.2 | 0.817275747508306 | 43 | 21 | 42.9 | 0 | 150 | 22 | 643 | 685 | KAJ8311568.1 hypothetical protein KUTeg_010923 [Tegillarca granosa] | diamond | 246 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 30502193 | 30502193 | PRJNA1199330_P_NODE_26973_length_396_cov_4.554180_g26277_i0 | PRJNA1199330 | 26973 | 396 | 4.55418 | 18.0345528 | root | 1 | Root_unresolved | Root_unresolved | 115 | 2.88e-27 | NR | XP_033743587.1 | 6579 | g26277 | i0 | 46 | 17.0151515151515 | 124 | 64 | 92.4 | 2 | 370 | 5 | 305 | 427 | XP_033743587.1 probable glycosyltransferase STELLO2 isoform X2 [Pecten maximus] | diamond | 6738 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 30735991 | 30735991 | PRJNA1199330_P_NODE_69394_length_282_cov_2.105263_g68695_i0 | PRJNA1199330 | 69394 | 282 | 2.105263 | 5.93684166 | Littorina littorea | 31216 | Mollusca | Mollusca | 61.6 | 1.04e-8 | NR | AJA37869.1 | 31216 | g68695 | i0 | 54 | 1.06382978723404 | 50 | 22 | 52.1 | 1 | 154 | 8 | 52 | 101 | AJA37869.1 galectin-2-2 [Littorina littorea] | diamond | 300 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina littorea | |
| 30786550 | 30786550 | PRJNA1199330_P_NODE_76814_length_275_cov_3.405941_g76115_i0 | PRJNA1199330 | 76814 | 275 | 3.405941 | 9.36633775 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 127 | 1.17e-33 | NR | XP_046574472.1 | 36100 | g76115 | i0 | 63 | 20.0727272727273 | 92 | 33 | 99.3 | 1 | 3 | 275 | 61 | 152 | XP_046574472.1 probable glycosyltransferase STELLO1 [Haliotis rubra] | diamond | 5520 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 31114951 | 31114951 | PRJNA1199330_P_NODE_113375_length_244_cov_0.912281_g112676_i0 | PRJNA1199330 | 113375 | 244 | 0.912281 | 2.22596564 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 44.3 | 0.0101 | NR | KAH9487905.1 | 55810 | g112676 | i0 | 36.4 | 0.811475409836066 | 66 | 38 | 81.1 | 1 | 8 | 205 | 20 | 81 | KAH9487905.1 hypothetical protein Btru_067429 [Bulinus truncatus] | diamond | 198 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 31747603 | 31747603 | PRJNA1199330_P_NODE_29077_length_383_cov_1.277419_g28381_i0 | PRJNA1199330 | 29077 | 383 | 1.277419 | 4.89251477 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 50.1 | 2.18e-4 | NR | KAL4237939.1 | 2302425 | g28381 | i0 | 43.4 | 0.595300261096606 | 76 | 33 | 59.5 | 2 | 370 | 143 | 120 | 185 | KAL4237939.1 hypothetical protein ACF0H5_002649 [Mactra antiquata] | diamond | 228 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 32822161 | 32822161 | PRJNA1199330_P_NODE_21380_length_443_cov_1.456757_g20686_i0 | PRJNA1199330 | 21380 | 443 | 1.456757 | 6.45343351 | Mya arenaria | 6604 | Mollusca | Mollusca | 70.5 | 6.57e-11 | NR | WAR31782.1 | 6604 | g20686 | i0 | 65.2 | 0.623024830699774 | 46 | 16 | 31.2 | 0 | 441 | 304 | 145 | 190 | WAR31782.1 TEMPT-like protein, partial [Mya arenaria] | diamond | 276 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;