contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA798511" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9719211 | 9719211 | PRJNA798511_P_NODE_81168_length_264_cov_1.591623_g76902_i0 | PRJNA798511 | 81168 | 264 | 1.591623 | 4.20188472 | Metazoa | 33208 | Annelida | Annelida | 121 | 7.73e-33 | NR | CCD27758.1 | 210783 | g76902 | i0 | 77.3 | 19.2840909090909 | 75 | 17 | 85.2 | 0 | 39 | 263 | 65 | 139 | CCD27758.1 ribosomal protein l17, partial [Apionsoma misakianum] | diamond | 5091 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Phascolosomatiformes | Phascolosomatidae | Apionsoma | Apionsoma misakianum | |
| 13543471 | 13543471 | PRJNA798511_P_NODE_17651_length_912_cov_1.673421_g13917_i0 | PRJNA798511 | 17651 | 912 | 1.673421 | 15.26159952 | Metazoa | 33208 | Annelida | Annelida | 201 | 8.77e-57 | NR | KAK2174841.1 | 27915 | g13917 | i0 | 37.3 | 3.85526315789474 | 287 | 178 | 94.1 | 2 | 859 | 2 | 11 | 296 | KAK2174841.1 hypothetical protein NP493_774g00007 [Ridgeia piscesae] | diamond | 3516 | 201 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 17369432 | 17369432 | PRJNA798511_P_NODE_77454_length_272_cov_1.547739_g73188_i0 | PRJNA798511 | 77454 | 272 | 1.547739 | 4.20985008 | Opisthokonta | 33154 | Annelida | Annelida | 101 | 2.18e-25 | NR | CAH1794544.1 | 6347 | g73188 | i0 | 63.2 | 15.2205882352941 | 87 | 31 | 94.9 | 1 | 269 | 12 | 39 | 125 | CAH1794544.1 unnamed protein product [Owenia fusiformis] | diamond | 4140 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26895975 | 26895975 | PRJNA798511_P_NODE_60121_length_317_cov_1.577869_g55855_i0 | PRJNA798511 | 60121 | 317 | 1.577869 | 5.00184473 | Capitella teleta | 283909 | Annelida | Annelida | 43.1 | 0.0135 | NR | ELU01614.1 | 283909 | g55855 | i0 | 50 | 0.67192429022082 | 36 | 18 | 34.1 | 0 | 183 | 76 | 32 | 67 | ELU01614.1 hypothetical protein CAPTEDRAFT_139171, partial [Capitella teleta] | diamond | 213 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27085634 | 27085634 | PRJNA798511_P_NODE_73982_length_280_cov_0.961353_g69716_i0 | PRJNA798511 | 73982 | 280 | 0.961353 | 2.6917884 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 44.7 | 0.0124 | NR | KAK2145615.1 | 53620 | g69716 | i0 | 34.3 | 0.717857142857143 | 67 | 41 | 68.6 | 1 | 250 | 59 | 182 | 248 | KAK2145615.1 hypothetical protein LSH36_669g04058 [Paralvinella palmiformis] | diamond | 201 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27780609 | 27780609 | PRJNA798511_P_NODE_104744_length_228_cov_2.516129_g100478_i0 | PRJNA798511 | 104744 | 228 | 2.516129 | 5.73677412 | Owenia fusiformis | 6347 | Annelida | Annelida | 43.5 | 0.0169 | NR | CAH1801914.1 | 6347 | g100478 | i0 | 50 | 0.394736842105263 | 30 | 15 | 39.5 | 0 | 194 | 105 | 2449 | 2478 | CAH1801914.1 unnamed protein product [Owenia fusiformis] | diamond | 90 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27812296 | 27812296 | PRJNA798511_P_NODE_47244_length_371_cov_2.224832_g42978_i0 | PRJNA798511 | 47244 | 371 | 2.224832 | 8.25412672 | Helobdella robusta | 6412 | Annelida | Annelida | 70.9 | 9.99e-12 | NR | XP_009021524.1 | 6412 | g42978 | i0 | 50 | 2.28032345013477 | 82 | 38 | 63.9 | 2 | 296 | 60 | 196 | 277 | XP_009021524.1 hypothetical protein HELRODRAFT_175915 [Helobdella robusta] | diamond | 846 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28096238 | 28096238 | PRJNA798511_P_NODE_74125_length_279_cov_1.781553_g69859_i0 | PRJNA798511 | 74125 | 279 | 1.781553 | 4.97053287 | Capitella teleta | 283909 | Annelida | Annelida | 42.7 | 0.0111 | NR | ELT95635.1 | 283909 | g69859 | i0 | 62.5 | 0.688172043010753 | 32 | 12 | 34.4 | 0 | 183 | 278 | 39 | 70 | ELT95635.1 hypothetical protein CAPTEDRAFT_138181, partial [Capitella teleta] | diamond | 192 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28159576 | 28159576 | PRJNA798511_P_NODE_16645_length_963_cov_8.900000_g13035_i0 | PRJNA798511 | 16645 | 963 | 8.9 | 85.707 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 61.6 | 1.01e-7 | NR | KAK2162938.1 | 53620 | g13035 | i0 | 100 | 0.0872274143302181 | 28 | 0 | 8.7 | 0 | 963 | 880 | 105 | 132 | KAK2162938.1 hypothetical protein LSH36_89g04027 [Paralvinella palmiformis] | diamond | 84 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28159619 | 28159619 | PRJNA798511_P_NODE_81085_length_264_cov_1.753927_g76819_i0 | PRJNA798511 | 81085 | 264 | 1.753927 | 4.63036728 | Ridgeia piscesae | 27915 | Annelida | Annelida | 56.6 | 1.88e-7 | NR | KAK2165611.1 | 27915 | g76819 | i0 | 40.3 | 1.64772727272727 | 72 | 43 | 81.8 | 0 | 49 | 264 | 23 | 94 | KAK2165611.1 hypothetical protein NP493_1358g00002 [Ridgeia piscesae] | diamond | 435 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28727739 | 28727739 | PRJNA798511_P_NODE_16547_length_970_cov_2.578595_g12947_i0 | PRJNA798511 | 16547 | 970 | 2.578595 | 25.0123715 | Capitella teleta | 283909 | Annelida | Annelida | 61.6 | 2.56e-6 | NR | ELU07992.1 | 283909 | g12947 | i0 | 42.9 | 0.194845360824742 | 63 | 36 | 19.5 | 0 | 515 | 703 | 1305 | 1367 | ELU07992.1 hypothetical protein CAPTEDRAFT_216620 [Capitella teleta] | diamond | 189 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28957990 | 28957990 | PRJNA798511_P_NODE_30868_length_525_cov_1.820796_g26624_i0 | PRJNA798511 | 30868 | 525 | 1.820796 | 9.559179 | Metazoa | 33208 | Annelida | Annelida | 46.6 | 0.0238 | NR | CAH1791901.1 | 6347 | g26624 | i0 | 52.5 | 2.19428571428571 | 40 | 19 | 22.9 | 0 | 105 | 224 | 244 | 283 | CAH1791901.1 unnamed protein product [Owenia fusiformis] | diamond | 1152 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29012185 | 29012185 | PRJNA798511_P_NODE_17428_length_923_cov_1.795294_g13724_i0 | PRJNA798511 | 17428 | 923 | 1.795294 | 16.57056362 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 197 | 6.29e-53 | NR | KAI0224709.1 | 104711 | g13724 | i0 | 50 | 4.90790899241603 | 196 | 98 | 63.7 | 0 | 694 | 107 | 762 | 957 | KAI0224709.1 hypothetical protein LSAT2_024312 [Lamellibrachia satsuma] | diamond | 4530 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 29296012 | 29296012 | PRJNA798511_P_NODE_26429_length_606_cov_1.283302_g22226_i0 | PRJNA798511 | 26429 | 606 | 1.283302 | 7.77681012 | Helobdella robusta | 6412 | Annelida | Annelida | 46.2 | 0.0187 | NR | XP_009022605.1 | 6412 | g22226 | i0 | 50 | 0.504950495049505 | 34 | 17 | 16.8 | 0 | 485 | 384 | 90 | 123 | XP_009022605.1 hypothetical protein HELRODRAFT_162029 [Helobdella robusta] | diamond | 306 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29801118 | 29801118 | PRJNA798511_P_NODE_92671_length_248_cov_0.880000_g88405_i0 | PRJNA798511 | 92671 | 248 | 0.88 | 2.1824 | Helobdella robusta | 6412 | Annelida | Annelida | 79.3 | 4.49e-15 | NR | XP_009011430.1 | 6412 | g88405 | i0 | 57.6 | 0.798387096774194 | 66 | 26 | 79.8 | 1 | 1 | 198 | 143 | 206 | XP_009011430.1 hypothetical protein HELRODRAFT_183591 [Helobdella robusta] | diamond | 198 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30410907 | 30410907 | PRJNA798511_P_NODE_95253_length_246_cov_0.890173_g90987_i0 | PRJNA798511 | 95253 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Annelida | Annelida | 47 | 9.5e-4 | NR | CAH1791497.1 | 6347 | g90987 | i0 | 54.5 | 5.86585365853659 | 33 | 15 | 40.2 | 0 | 2 | 100 | 174 | 206 | CAH1791497.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1443 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30631555 | 30631555 | PRJNA798511_P_NODE_71753_length_285_cov_1.089623_g67487_i0 | PRJNA798511 | 71753 | 285 | 1.089623 | 3.10542555 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00652 | NR | ELU11830.1 | 283909 | g67487 | i0 | 45.2 | 2.16842105263158 | 42 | 23 | 44.2 | 0 | 127 | 2 | 15 | 56 | ELU11830.1 hypothetical protein CAPTEDRAFT_188638 [Capitella teleta] | diamond | 618 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31412808 | 31412808 | PRJNA798511_P_NODE_74816_length_278_cov_1.126829_g70550_i0 | PRJNA798511 | 74816 | 278 | 1.126829 | 3.13258462 | Helobdella robusta | 6412 | Annelida | Annelida | 97.1 | 2.66e-21 | NR | XP_009011430.1 | 6412 | g70550 | i0 | 55.1 | 1.92086330935252 | 89 | 37 | 95 | 2 | 278 | 15 | 124 | 210 | XP_009011430.1 hypothetical protein HELRODRAFT_183591 [Helobdella robusta] | diamond | 534 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;