contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB75230" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6515072 | 6515072 | PRJEB75230_P_NODE_2326_length_873_cov_6.753750_g2178_i0 | PRJEB75230 | 2326 | 873 | 6.75375 | 58.9602375 | Metazoa | 33208 | Annelida | Annelida | 291 | 1.55e-94 | NR | XP_009021786.1 | 6412 | g2178 | i0 | 57.8 | 8.04810996563574 | 244 | 99 | 83.5 | 2 | 830 | 102 | 7 | 247 | XP_009021786.1 hypothetical protein HELRODRAFT_185784 [Helobdella robusta] | diamond | 7026 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 17987683 | 17987683 | PRJEB75230_P_NODE_1315_length_1112_cov_1.343600_g1188_i0 | PRJEB75230 | 1315 | 1112 | 1.3436 | 14.940832 | Ridgeia piscesae | 27915 | Annelida | Annelida | 205 | 2.3599999999999996e-55 | NR | KAK2174015.1 | 27915 | g1188 | i0 | 62.3 | 2.66276978417266 | 167 | 61 | 45.1 | 1 | 649 | 149 | 286 | 450 | KAK2174015.1 hypothetical protein NP493_835g00021 [Ridgeia piscesae] | diamond | 2961 | 205 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 26646843 | 26646843 | PRJEB75230_P_NODE_65361_length_293_cov_1.750000_g65179_i0 | PRJEB75230 | 65361 | 293 | 1.75 | 5.1275 | Metazoa | 33208 | Annelida | Annelida | 66.2 | 3.76e-10 | NR | XP_009030989.1 | 6412 | g65179 | i0 | 40.7 | 14.9283276450512 | 81 | 48 | 82.9 | 0 | 243 | 1 | 610 | 690 | XP_009030989.1 hypothetical protein HELRODRAFT_104310 [Helobdella robusta] | diamond | 4374 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27445327 | 27445327 | PRJEB75230_P_NODE_158983_length_245_cov_0.866279_g158801_i0 | PRJEB75230 | 158983 | 245 | 0.866279 | 2.12238355 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 47.8 | 6.45e-4 | NR | KAK2144722.1 | 53620 | g158801 | i0 | 63.3 | 0.36734693877551 | 30 | 11 | 36.7 | 0 | 243 | 154 | 215 | 244 | KAK2144722.1 hypothetical protein LSH36_736g01009 [Paralvinella palmiformis] | diamond | 90 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28297477 | 28297477 | PRJEB75230_P_NODE_93206_length_269_cov_1.178571_g93024_i0 | PRJEB75230 | 93206 | 269 | 1.178571 | 3.17035599 | Owenia fusiformis | 6347 | Annelida | Annelida | 66.2 | 2.81e-10 | NR | CAH1798657.1 | 6347 | g93024 | i0 | 41.8 | 6.84758364312268 | 91 | 45 | 92.6 | 1 | 8 | 256 | 1407 | 1497 | CAH1798657.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1842 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28834286 | 28834286 | PRJEB75230_P_NODE_56668_length_303_cov_2.008696_g56486_i0 | PRJEB75230 | 56668 | 303 | 2.008696 | 6.08634888 | Enchytraeus japonensis | 228735 | Annelida | Annelida | 48.5 | 7.32e-4 | NR | BAF76796.1 | 228735 | g56486 | i0 | 34 | 0.99009900990099 | 100 | 61 | 97 | 2 | 4 | 297 | 133 | 229 | BAF76796.1 Vasa-related protein [Enchytraeus japonensis] | diamond | 300 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus japonensis | |
| 28992478 | 28992478 | PRJEB75230_P_NODE_10388_length_464_cov_2.373402_g10206_i0 | PRJEB75230 | 10388 | 464 | 2.373402 | 11.01258528 | Capitella teleta | 283909 | Annelida | Annelida | 140 | 3.4599999999999995e-35 | NR | ELT93316.1 | 283909 | g10206 | i0 | 64.2 | 1.36422413793103 | 106 | 37 | 68.5 | 1 | 142 | 459 | 4 | 108 | ELT93316.1 hypothetical protein CAPTEDRAFT_125179 [Capitella teleta] | diamond | 633 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29433911 | 29433911 | PRJEB75230_P_NODE_91150_length_270_cov_1.939086_g90968_i0 | PRJEB75230 | 91150 | 270 | 1.939086 | 5.2355322 | Ridgeia piscesae | 27915 | Annelida | Annelida | 44.7 | 0.0107 | NR | KAK2173189.1 | 27915 | g90968 | i0 | 31.9 | 1.88888888888889 | 91 | 51 | 88.9 | 1 | 2 | 241 | 90 | 180 | KAK2173189.1 hypothetical protein NP493_894g00040 [Ridgeia piscesae] | diamond | 510 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29497342 | 29497342 | PRJEB75230_P_NODE_172070_length_242_cov_1.727811_g171888_i0 | PRJEB75230 | 172070 | 242 | 1.727811 | 4.18130262 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 78.6 | 2.95e-15 | NR | CAD5124425.1 | 2664684 | g171888 | i0 | 62 | 0.979338842975207 | 79 | 26 | 97.9 | 2 | 241 | 5 | 198 | 272 | CAD5124425.1 unnamed protein product [Dimorphilus gyrociliatus] | diamond | 237 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29812990 | 29812990 | PRJEB75230_P_NODE_29211_length_351_cov_1.532374_g29029_i0 | PRJEB75230 | 29211 | 351 | 1.532374 | 5.37863274 | Owenia fusiformis | 6347 | Annelida | Annelida | 45.8 | 0.0106 | NR | CAH1782554.1 | 6347 | g29029 | i0 | 29.4 | 1.86324786324786 | 109 | 68 | 87.2 | 2 | 323 | 18 | 562 | 668 | CAH1782554.1 unnamed protein product [Owenia fusiformis] | diamond | 654 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31354188 | 31354188 | PRJEB75230_P_NODE_108016_length_257_cov_2.385870_g107834_i0 | PRJEB75230 | 108016 | 257 | 2.38587 | 6.1316859 | Metazoa | 33208 | Annelida | Annelida | 74.7 | 2.46e-13 | NR | KAK2143694.1 | 53620 | g107834 | i0 | 38.8 | 2.97665369649805 | 85 | 52 | 99.2 | 0 | 257 | 3 | 460 | 544 | KAK2143694.1 hypothetical protein LSH36_819g00003 [Paralvinella palmiformis] | diamond | 765 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31677598 | 31677598 | PRJEB75230_P_NODE_14577_length_418_cov_1.446377_g14395_i0 | PRJEB75230 | 14577 | 418 | 1.446377 | 6.04585586 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 127 | 9.14e-31 | NR | KAK2151603.1 | 53620 | g14395 | i0 | 44.8 | 10.3062200956938 | 143 | 73 | 99 | 4 | 414 | 1 | 1744 | 1885 | KAK2151603.1 hypothetical protein LSH36_357g01012 [Paralvinella palmiformis] | diamond | 4308 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32532159 | 32532159 | PRJEB75230_P_NODE_83999_length_276_cov_1.517241_g83817_i0 | PRJEB75230 | 83999 | 276 | 1.517241 | 4.18758516 | Ridgeia piscesae | 27915 | Annelida | Annelida | 53.9 | 4.16e-6 | NR | KAK2181905.1 | 27915 | g83817 | i0 | 52.5 | 0.66304347826087 | 61 | 26 | 64.1 | 2 | 9 | 185 | 119 | 178 | KAK2181905.1 hypothetical protein NP493_370g06036 [Ridgeia piscesae] | diamond | 183 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;