contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9111259 | 9111259 | PRJNA1068830_P_NODE_78628_length_249_cov_0.886364_g77925_i0 | PRJNA1068830 | 78628 | 249 | 0.886364 | 2.20704636 | Naididae | 2109251 | Annelida | Annelida | 128 | 1.4999999999999999e-33 | NR | QUJ10054.1 | 6386 | g77925 | i0 | 68.3 | 2.96385542168675 | 82 | 26 | 98.8 | 0 | 2 | 247 | 184 | 265 | QUJ10054.1 cytochrome b [Tubifex tubifex] | diamond | 738 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Tubifex | Tubifex tubifex | |
| 10386202 | 10386202 | PRJNA1068830_P_NODE_49309_length_312_cov_1.903766_g48606_i0 | PRJNA1068830 | 49309 | 312 | 1.903766 | 5.93974992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 2.44e-39 | NR | CAH1796415.1 | 6347 | g48606 | i0 | 66.3 | 134 | 104 | 35 | 100 | 0 | 1 | 312 | 699 | 802 | CAH1796415.1 unnamed protein product [Owenia fusiformis] | diamond | 41808 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 12936180 | 12936180 | PRJNA1068830_P_NODE_27451_length_440_cov_2.871935_g26748_i0 | PRJNA1068830 | 27451 | 440 | 2.871935 | 12.636514 | Metazoa | 33208 | Annelida | Annelida | 201 | 9.09e-57 | NR | KAK2151607.1 | 53620 | g26748 | i0 | 67.4 | 59.5977272727273 | 144 | 46 | 98.2 | 1 | 435 | 4 | 2014 | 2156 | KAK2151607.1 hypothetical protein LSH36_357g02035 [Paralvinella palmiformis] | diamond | 26223 | 202 | 0.995049504950495 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 12937341 | 12937341 | PRJNA1068830_P_NODE_74431_length_252_cov_0.871508_g73728_i0 | PRJNA1068830 | 74431 | 252 | 0.871508 | 2.19620016 | Capitella teleta | 283909 | Annelida | Annelida | 172 | 2.0699999999999997e-48 | NR | ELU04259.1 | 283909 | g73728 | i0 | 92.9 | 20.7857142857143 | 84 | 6 | 100 | 0 | 252 | 1 | 274 | 357 | ELU04259.1 hypothetical protein CAPTEDRAFT_153069 [Capitella teleta] | diamond | 5238 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 20583660 | 20583660 | PRJNA1068830_P_NODE_32957_length_395_cov_0.847826_g32254_i0 | PRJNA1068830 | 32957 | 395 | 0.847826 | 3.3489127 | Clitellata | 42113 | Annelida | Annelida | 179 | 1.29e-52 | NR | WVD50229.1 | 6386 | g32254 | i0 | 69.2 | 7.92911392405063 | 130 | 40 | 98.7 | 0 | 393 | 4 | 133 | 262 | WVD50229.1 glyceraldehyde-3-phosphate dehydrogenase [Tubifex tubifex] | diamond | 3132 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Tubifex | Tubifex tubifex | |
| 23135001 | 23135001 | PRJNA1068830_P_NODE_38739_length_359_cov_1.090909_g38036_i0 | PRJNA1068830 | 38739 | 359 | 1.090909 | 3.91636331 | Metazoa | 33208 | Annelida | Annelida | 151 | 1.28e-39 | NR | KAK2170270.1 | 53620 | g38036 | i0 | 77.4 | 25.2451253481894 | 93 | 21 | 77.7 | 0 | 281 | 3 | 16 | 108 | KAK2170270.1 hypothetical protein LSH36_3g01040 [Paralvinella palmiformis] | diamond | 9063 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 24409430 | 24409430 | PRJNA1068830_P_NODE_71620_length_254_cov_1.535912_g70917_i0 | PRJNA1068830 | 71620 | 254 | 1.535912 | 3.90121648 | Metazoa | 33208 | Annelida | Annelida | 122 | 6.759999999999999e-31 | NR | KAK2189949.1 | 27915 | g70917 | i0 | 79.7 | 33.2125984251969 | 74 | 15 | 87.4 | 0 | 223 | 2 | 1 | 74 | KAK2189949.1 hypothetical protein NP493_92g00034 [Ridgeia piscesae] | diamond | 8436 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 26592260 | 26592260 | PRJNA1068830_P_NODE_76661_length_250_cov_0.881356_g75958_i0 | PRJNA1068830 | 76661 | 250 | 0.881356 | 2.20339 | Ridgeia piscesae | 27915 | Annelida | Annelida | 90.9 | 1.21e-19 | NR | KAK2175794.1 | 27915 | g75958 | i0 | 65.6 | 1.464 | 61 | 20 | 73.2 | 1 | 184 | 2 | 11 | 70 | KAK2175794.1 hypothetical protein NP493_707g01044 [Ridgeia piscesae] | diamond | 366 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 26774192 | 26774192 | PRJNA1068830_P_NODE_23461_length_485_cov_3.252427_g22760_i0 | PRJNA1068830 | 23461 | 485 | 3.252427 | 15.77427095 | Metazoa | 33208 | Annelida | Annelida | 119 | 3.4799999999999993e-31 | NR | CAH1776824.1 | 6347 | g22760 | i0 | 60.2 | 119.115463917526 | 98 | 39 | 60.6 | 0 | 393 | 100 | 18 | 115 | CAH1776824.1 unnamed protein product [Owenia fusiformis] | diamond | 57771 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26782688 | 26782688 | PRJNA1068830_P_NODE_60041_length_281_cov_1.125000_g59338_i0 | PRJNA1068830 | 60041 | 281 | 1.125 | 3.16125 | Helobdella robusta | 6412 | Annelida | Annelida | 124 | 1.72e-30 | NR | XP_009026502.1 | 6412 | g59338 | i0 | 58.7 | 0.98220640569395 | 92 | 38 | 98.2 | 0 | 276 | 1 | 197 | 288 | XP_009026502.1 hypothetical protein HELRODRAFT_193557 [Helobdella robusta] | diamond | 276 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27415261 | 27415261 | PRJNA1068830_P_NODE_50083_length_309_cov_2.864407_g49380_i0 | PRJNA1068830 | 50083 | 309 | 2.864407 | 8.85101763 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 127 | 4.65e-32 | NR | CAD5119386.1 | 2664684 | g49380 | i0 | 53 | 3.88349514563107 | 100 | 47 | 97.1 | 0 | 1 | 300 | 388 | 487 | CAD5119386.1 DgyrCDS8000 [Dimorphilus gyrociliatus] | diamond | 1200 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27699480 | 27699480 | PRJNA1068830_P_NODE_51024_length_306_cov_1.961373_g50321_i0 | PRJNA1068830 | 51024 | 306 | 1.961373 | 6.00180138 | Helobdella robusta | 6412 | Annelida | Annelida | 97.1 | 1.69e-22 | NR | XP_009019383.1 | 6412 | g50321 | i0 | 49.5 | 0.990196078431373 | 101 | 50 | 98 | 1 | 2 | 301 | 1 | 101 | XP_009019383.1 hypothetical protein HELRODRAFT_155763 [Helobdella robusta] | diamond | 303 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28417080 | 28417080 | PRJNA1068830_P_NODE_79386_length_248_cov_0.891429_g78683_i0 | PRJNA1068830 | 79386 | 248 | 0.891429 | 2.21074392 | Opisthokonta | 33154 | Annelida | Annelida | 50.1 | 3.37e-5 | NR | ELU00650.1 | 283909 | g78683 | i0 | 35.1 | 2.57661290322581 | 77 | 47 | 93.1 | 1 | 5 | 235 | 42 | 115 | ELU00650.1 hypothetical protein CAPTEDRAFT_207513 [Capitella teleta] | diamond | 639 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28709690 | 28709690 | PRJNA1068830_P_NODE_75467_length_251_cov_0.876404_g74764_i0 | PRJNA1068830 | 75467 | 251 | 0.876404 | 2.19977404 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 100 | 1.4399999999999994e-23 | NR | KAI0207937.1 | 104711 | g74764 | i0 | 67.7 | 1.47011952191235 | 62 | 19 | 74.1 | 1 | 225 | 40 | 14 | 74 | KAI0207937.1 hypothetical protein LSAT2_007383 [Lamellibrachia satsuma] | diamond | 369 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28930615 | 28930615 | PRJNA1068830_P_NODE_88588_length_242_cov_0.923077_g87885_i0 | PRJNA1068830 | 88588 | 242 | 0.923077 | 2.23384634 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 58.5 | 9.94e-8 | NR | KAI0213400.1 | 104711 | g87885 | i0 | 41.3 | 0.991735537190083 | 80 | 46 | 97.9 | 1 | 5 | 241 | 302 | 381 | KAI0213400.1 Sulfate transporter [Lamellibrachia satsuma] | diamond | 240 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28985540 | 28985540 | PRJNA1068830_P_NODE_18888_length_552_cov_2.718163_g18193_i0 | PRJNA1068830 | 18888 | 552 | 2.718163 | 15.00425976 | Metazoa | 33208 | Annelida | Annelida | 142 | 7.15e-38 | NR | CAH1798522.1 | 6347 | g18193 | i0 | 49.1 | 1.69565217391304 | 159 | 72 | 82.1 | 5 | 458 | 6 | 51 | 208 | CAH1798522.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 936 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29909537 | 29909537 | PRJNA1068830_P_NODE_90511_length_228_cov_3.212903_g89808_i0 | PRJNA1068830 | 90511 | 228 | 3.212903 | 7.32541884 | Capitella teleta | 283909 | Annelida | Annelida | 62.8 | 2.73e-9 | NR | ELU07211.1 | 283909 | g89808 | i0 | 42.1 | 1 | 76 | 42 | 97.4 | 1 | 225 | 4 | 441 | 516 | ELU07211.1 hypothetical protein CAPTEDRAFT_150577 [Capitella teleta] | diamond | 228 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30635831 | 30635831 | PRJNA1068830_P_NODE_11153_length_750_cov_3.357459_g10500_i0 | PRJNA1068830 | 11153 | 750 | 3.357459 | 25.1809425 | Helobdella robusta | 6412 | Annelida | Annelida | 177 | 2.38e-48 | NR | XP_009028146.1 | 6412 | g10500 | i0 | 46.6 | 4.112 | 206 | 106 | 82.4 | 1 | 131 | 748 | 304 | 505 | XP_009028146.1 hypothetical protein HELRODRAFT_186070 [Helobdella robusta] | diamond | 3084 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30659198 | 30659198 | PRJNA1068830_P_NODE_16073_length_607_cov_2.876404_g15389_i0 | PRJNA1068830 | 16073 | 607 | 2.876404 | 17.45977228 | Metazoa | 33208 | Annelida | Annelida | 247 | 1.3900000000000001e-77 | NR | KAK2190728.1 | 27915 | g15389 | i0 | 63.5 | 13.4332784184514 | 181 | 66 | 89.5 | 0 | 605 | 63 | 195 | 375 | KAK2190728.1 hypothetical protein NP493_71g00035 [Ridgeia piscesae] | diamond | 8154 | 249 | 0.991967871485944 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31141189 | 31141189 | PRJNA1068830_P_NODE_79635_length_248_cov_0.891429_g78932_i0 | PRJNA1068830 | 79635 | 248 | 0.891429 | 2.21074392 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 61.2 | 1.13e-8 | NR | CAD5117427.1 | 2664684 | g78932 | i0 | 41.3 | 0.967741935483871 | 80 | 47 | 96.8 | 0 | 248 | 9 | 96 | 175 | CAD5117427.1 DgyrCDS6197 [Dimorphilus gyrociliatus] | diamond | 240 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 31923766 | 31923766 | PRJNA1068830_P_NODE_29077_length_425_cov_1.661932_g28374_i0 | PRJNA1068830 | 29077 | 425 | 1.661932 | 7.063211 | Metazoa | 33208 | Annelida | Annelida | 171 | 1.89e-52 | NR | CAH1789098.1 | 6347 | g28374 | i0 | 95.2 | 15.5858823529412 | 84 | 4 | 59.3 | 0 | 9 | 260 | 18 | 101 | CAH1789098.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 6624 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31963825 | 31963825 | PRJNA1068830_P_NODE_58618_length_284_cov_1.682464_g57915_i0 | PRJNA1068830 | 58618 | 284 | 1.682464 | 4.77819776 | Capitella teleta | 283909 | Annelida | Annelida | 67 | 1.09e-10 | NR | ELT94827.1 | 283909 | g57915 | i0 | 41 | 2.7887323943662 | 83 | 47 | 85.6 | 1 | 261 | 19 | 10 | 92 | ELT94827.1 hypothetical protein CAPTEDRAFT_226902 [Capitella teleta] | diamond | 792 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32502058 | 32502058 | PRJNA1068830_P_NODE_89059_length_241_cov_5.333333_g88356_i0 | PRJNA1068830 | 89059 | 241 | 5.333333 | 12.85333253 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 58.5 | 2.39e-8 | NR | KAI0221400.1 | 104711 | g88356 | i0 | 42.9 | 0.871369294605809 | 70 | 37 | 87.1 | 1 | 210 | 1 | 1 | 67 | KAI0221400.1 TCTP domain-containing protein [Lamellibrachia satsuma] | diamond | 210 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32745692 | 32745692 | PRJNA1068830_P_NODE_38860_length_358_cov_1.638596_g38157_i0 | PRJNA1068830 | 38860 | 358 | 1.638596 | 5.86617368 | Metazoa | 33208 | Annelida | Annelida | 117 | 6.97e-28 | NR | KAI0226808.1 | 104711 | g38157 | i0 | 51.8 | 44.4217877094972 | 112 | 52 | 93.9 | 2 | 357 | 22 | 382 | 491 | KAI0226808.1 Neurobeachin [Lamellibrachia satsuma] | diamond | 15903 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma |
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);;