contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6050901 | 6050901 | PRJNA976345_P_NODE_116965_length_179_cov_2.597222_g115357_i0 | PRJNA976345 | 116965 | 179 | 2.597222 | 4.64902738 | Metazoa | 33208 | Annelida | Annelida | 61.6 | 3.44e-9 | NR | ELU12121.1 | 283909 | g115357 | i0 | 74.4 | 10.4581005586592 | 39 | 10 | 65.4 | 0 | 179 | 63 | 165 | 203 | ELU12121.1 hypothetical protein CAPTEDRAFT_175811 [Capitella teleta] | diamond | 1872 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 26645924 | 26645924 | PRJNA976345_P_NODE_150161_length_166_cov_1.893130_g148553_i0 | PRJNA976345 | 150161 | 166 | 1.89313 | 3.1425958 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 42 | 0.0235 | NR | KAI0234418.1 | 104711 | g148553 | i0 | 72 | 0.451807228915663 | 25 | 7 | 45.2 | 0 | 77 | 3 | 178 | 202 | KAI0234418.1 hypothetical protein LSAT2_015316 [Lamellibrachia satsuma] | diamond | 75 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28295493 | 28295493 | PRJNA976345_P_NODE_36166_length_284_cov_2.020080_g34559_i0 | PRJNA976345 | 36166 | 284 | 2.02008 | 5.7370272 | Metazoa | 33208 | Annelida | Annelida | 43.9 | 0.0245 | NR | CAH1791581.1 | 6347 | g34559 | i0 | 46.7 | 2.88380281690141 | 45 | 20 | 47.5 | 1 | 5 | 139 | 248 | 288 | CAH1791581.1 unnamed protein product [Owenia fusiformis] | diamond | 819 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28327019 | 28327019 | PRJNA976345_P_NODE_33706_length_293_cov_1.713178_g32099_i0 | PRJNA976345 | 33706 | 293 | 1.713178 | 5.01961154 | Metazoa | 33208 | Annelida | Annelida | 50.4 | 1.34e-4 | NR | CAH1794381.1 | 6347 | g32099 | i0 | 84 | 33.0204778156997 | 25 | 4 | 25.6 | 0 | 219 | 293 | 734 | 758 | CAH1794381.1 unnamed protein product [Owenia fusiformis] | diamond | 9675 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28453644 | 28453644 | PRJNA976345_P_NODE_72526_length_213_cov_3.539326_g70918_i0 | PRJNA976345 | 72526 | 213 | 3.539326 | 7.53876438 | Metazoa | 33208 | Annelida | Annelida | 57.8 | 1.25e-7 | NR | XP_009014591.1 | 6412 | g70918 | i0 | 52.1 | 3.67605633802817 | 48 | 23 | 67.6 | 0 | 198 | 55 | 353 | 400 | XP_009014591.1 hypothetical protein HELRODRAFT_110729 [Helobdella robusta] | diamond | 783 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28825898 | 28825898 | PRJNA976345_P_NODE_25628_length_332_cov_11.202020_g24025_i0 | PRJNA976345 | 25628 | 332 | 11.20202 | 37.1907064 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 57 | 1.05e-6 | NR | CAD5115077.1 | 2664684 | g24025 | i0 | 45.2 | 2.35843373493976 | 62 | 34 | 56 | 0 | 29 | 214 | 411 | 472 | CAD5115077.1 DgyrCDS4092 [Dimorphilus gyrociliatus] | diamond | 783 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29110406 | 29110406 | PRJNA976345_P_NODE_148068_length_167_cov_1.780303_g146460_i0 | PRJNA976345 | 148068 | 167 | 1.780303 | 2.97310601 | Owenia fusiformis | 6347 | Annelida | Annelida | 68.2 | 1.03e-11 | NR | CAH1793914.1 | 6347 | g146460 | i0 | 59.3 | 0.970059880239521 | 54 | 15 | 97 | 1 | 164 | 3 | 234 | 280 | CAH1793914.1 unnamed protein product [Owenia fusiformis] | diamond | 162 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29110464 | 29110464 | PRJNA976345_P_NODE_8608_length_600_cov_5.557522_g2826_i1 | PRJNA976345 | 8608 | 600 | 5.557522 | 33.345132 | Ridgeia piscesae | 27915 | Annelida | Annelida | 164 | 9.3e-46 | NR | KAK2153426.1 | 27915 | g2826 | i1 | 44.3 | 1.935 | 194 | 108 | 97 | 0 | 600 | 19 | 72 | 265 | KAK2153426.1 hypothetical protein NP493_2315g00004 [Ridgeia piscesae] | diamond | 1161 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29552112 | 29552112 | PRJNA976345_P_NODE_126430_length_177_cov_1.957746_g124822_i0 | PRJNA976345 | 126430 | 177 | 1.957746 | 3.46521042 | Ridgeia piscesae | 27915 | Annelida | Annelida | 53.1 | 6.19e-7 | NR | KAK2186526.1 | 27915 | g124822 | i0 | 67.7 | 2.10169491525424 | 31 | 10 | 52.5 | 0 | 2 | 94 | 94 | 124 | KAK2186526.1 hypothetical protein NP493_197g02014 [Ridgeia piscesae] | diamond | 372 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29583554 | 29583554 | PRJNA976345_P_NODE_102390_length_188_cov_1.908497_g100782_i0 | PRJNA976345 | 102390 | 188 | 1.908497 | 3.58797436 | Owenia fusiformis | 6347 | Annelida | Annelida | 41.6 | 0.0473 | NR | CAH1774611.1 | 6347 | g100782 | i0 | 30.6 | 0.98936170212766 | 62 | 43 | 98.9 | 0 | 2 | 187 | 1203 | 1264 | CAH1774611.1 unnamed protein product [Owenia fusiformis] | diamond | 186 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30063749 | 30063749 | PRJNA976345_P_NODE_174651_length_157_cov_1.926230_g173043_i0 | PRJNA976345 | 174651 | 157 | 1.92623 | 3.0241811 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 4.76e-10 | NR | KAI0229732.1 | 104711 | g173043 | i0 | 60.4 | 2.7515923566879 | 48 | 19 | 91.7 | 0 | 2 | 145 | 140 | 187 | KAI0229732.1 Aldose 1-epimerase [Lamellibrachia satsuma] | diamond | 432 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30531463 | 30531463 | PRJNA976345_P_NODE_116273_length_180_cov_1.282759_g114665_i0 | PRJNA976345 | 116273 | 180 | 1.282759 | 2.3089662 | Helobdella robusta | 6412 | Annelida | Annelida | 41.6 | 0.0426 | NR | XP_009024113.1 | 6412 | g114665 | i0 | 73.1 | 2.16666666666667 | 26 | 7 | 43.3 | 0 | 93 | 16 | 474 | 499 | XP_009024113.1 hypothetical protein HELRODRAFT_177702 [Helobdella robusta] | diamond | 390 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30664156 | 30664156 | PRJNA976345_P_NODE_127893_length_176_cov_2.695035_g126285_i0 | PRJNA976345 | 127893 | 176 | 2.695035 | 4.7432616 | Metazoa | 33208 | Annelida | Annelida | 43.5 | 0.00635 | NR | KAK2182824.1 | 27915 | g126285 | i0 | 40 | 5.55681818181818 | 55 | 29 | 93.8 | 2 | 12 | 176 | 12 | 62 | KAK2182824.1 hypothetical protein NP493_334g00017 [Ridgeia piscesae] | diamond | 978 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31011670 | 31011670 | PRJNA976345_P_NODE_177714_length_156_cov_1.933884_g176106_i0 | PRJNA976345 | 177714 | 156 | 1.933884 | 3.01685904 | Metazoa | 33208 | Annelida | Annelida | 53.1 | 2.36e-6 | NR | CAH1798042.1 | 6347 | g176106 | i0 | 55.1 | 8.28846153846154 | 49 | 22 | 94.2 | 0 | 149 | 3 | 155 | 203 | CAH1798042.1 unnamed protein product [Owenia fusiformis] | diamond | 1293 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31100139 | 31100139 | PRJNA976345_P_NODE_17935_length_398_cov_7.311295_g16341_i0 | PRJNA976345 | 17935 | 398 | 7.311295 | 29.0989541 | Capitella teleta | 283909 | Annelida | Annelida | 48.5 | 0.00181 | NR | ELT96442.1 | 283909 | g16341 | i0 | 42.3 | 0.391959798994975 | 52 | 24 | 34.7 | 1 | 162 | 299 | 436 | 487 | ELT96442.1 hypothetical protein CAPTEDRAFT_192684 [Capitella teleta] | diamond | 156 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32118758 | 32118758 | PRJNA976345_P_NODE_180458_length_155_cov_2.266667_g178850_i0 | PRJNA976345 | 180458 | 155 | 2.266667 | 3.51333385 | Metazoa | 33208 | Annelida | Annelida | 53.1 | 3.24e-7 | NR | CAH1778178.1 | 6347 | g178850 | i0 | 43.5 | 10.2967741935484 | 46 | 26 | 89 | 0 | 15 | 152 | 58 | 103 | CAH1778178.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1596 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32144072 | 32144072 | PRJNA976345_P_NODE_194818_length_151_cov_1.750000_g193210_i0 | PRJNA976345 | 194818 | 151 | 1.75 | 2.6425 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 39.3 | 0.0387 | NR | KAI0224075.1 | 104711 | g193210 | i0 | 73.9 | 0.456953642384106 | 23 | 6 | 45.7 | 0 | 3 | 71 | 12 | 34 | KAI0224075.1 hypothetical protein LSAT2_024896 [Lamellibrachia satsuma] | diamond | 69 | 39.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32302581 | 32302581 | PRJNA976345_P_NODE_109659_length_183_cov_5.209459_g108051_i0 | PRJNA976345 | 109659 | 183 | 5.209459 | 9.53330997 | Helobdella robusta | 6412 | Annelida | Annelida | 53.5 | 2.54e-6 | NR | XP_009030288.1 | 6412 | g108051 | i0 | 50.9 | 1.86885245901639 | 55 | 27 | 90.2 | 0 | 176 | 12 | 36 | 90 | XP_009030288.1 hypothetical protein HELRODRAFT_165469 [Helobdella robusta] | diamond | 342 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32302596 | 32302596 | PRJNA976345_P_NODE_159679_length_162_cov_2.527559_g158071_i0 | PRJNA976345 | 159679 | 162 | 2.527559 | 4.09464558 | Sabellaria alveolata | 251482 | Annelida | Annelida | 41.2 | 0.0459 | NR | AHX26710.1 | 251482 | g158071 | i0 | 44.7 | 0.87037037037037 | 47 | 23 | 83.3 | 3 | 1 | 135 | 879 | 924 | AHX26710.1 chitin synthase [Sabellaria alveolata] | diamond | 141 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Sabellaria | Sabellaria alveolata | |
| 32655759 | 32655759 | PRJNA976345_P_NODE_12780_length_478_cov_6.128668_g11217_i0 | PRJNA976345 | 12780 | 478 | 6.128668 | 29.29503304 | Metazoa | 33208 | Annelida | Annelida | 91.7 | 1.21e-18 | NR | KAK2153426.1 | 27915 | g11217 | i0 | 46.9 | 5.24058577405858 | 98 | 49 | 61.5 | 1 | 296 | 3 | 60 | 154 | KAK2153426.1 hypothetical protein NP493_2315g00004 [Ridgeia piscesae] | diamond | 2505 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32681157 | 32681157 | PRJNA976345_P_NODE_77120_length_209_cov_1.143678_g75512_i0 | PRJNA976345 | 77120 | 209 | 1.143678 | 2.39028702 | Capitella teleta | 283909 | Annelida | Annelida | 50.4 | 4.54e-5 | NR | ELT88839.1 | 283909 | g75512 | i0 | 79.2 | 60.2870813397129 | 24 | 5 | 34.4 | 0 | 74 | 3 | 189 | 212 | ELT88839.1 hypothetical protein CAPTEDRAFT_220552 [Capitella teleta] | diamond | 12600 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32807299 | 32807299 | PRJNA976345_P_NODE_148740_length_167_cov_1.265152_g147132_i0 | PRJNA976345 | 148740 | 167 | 1.265152 | 2.11280384 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 81.3 | 7.46e-17 | NR | KAK2143641.1 | 53620 | g147132 | i0 | 70.8 | 5.26347305389222 | 48 | 14 | 86.2 | 0 | 1 | 144 | 144 | 191 | KAK2143641.1 hypothetical protein LSH36_824g01019 [Paralvinella palmiformis] | diamond | 879 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;