contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 974005 | 974005 | PRJNA986481_P_NODE_6361_length_637_cov_4.311224_g5885_i0 | PRJNA986481 | 6361 | 637 | 4.311224 | 27.46249688 | Opisthokonta | 33154 | Annelida | Annelida | 131 | 5.669999999999998e-35 | NR | ABW90377.1 | 6446 | g5885 | i0 | 53.5 | 9.6828885400314 | 127 | 49 | 55.1 | 3 | 111 | 461 | 1 | 127 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 6168 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 19123537 | 19123537 | PRJNA986481_P_NODE_6475_length_632_cov_9.217839_g5998_i0 | PRJNA986481 | 6475 | 632 | 9.217839 | 58.25674248 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 7.77e-35 | NR | ABW90377.1 | 6446 | g5998 | i0 | 55.8 | 16.381329113924 | 113 | 45 | 51.3 | 2 | 534 | 211 | 1 | 113 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 10353 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 20099711 | 20099711 | PRJNA986481_P_NODE_14596_length_429_cov_4.697368_g14071_i0 | PRJNA986481 | 14596 | 429 | 4.697368 | 20.15170872 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 213 | 3.2399999999999995e-66 | NR | CAH1793798.1 | 6347 | g14071 | i0 | 70.7 | 33.3636363636364 | 140 | 41 | 97.9 | 0 | 4 | 423 | 8 | 147 | CAH1793798.1 unnamed protein product [Owenia fusiformis] | diamond | 14313 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26677935 | 26677935 | PRJNA986481_P_NODE_55061_length_247_cov_0.954545_g54536_i0 | PRJNA986481 | 55061 | 247 | 0.954545 | 2.35772615 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 60.5 | 2.2e-8 | NR | CAD5115533.1 | 2664684 | g54536 | i0 | 52.5 | 2.24696356275304 | 59 | 24 | 70.4 | 2 | 14 | 187 | 17 | 72 | CAD5115533.1 unnamed protein product [Dimorphilus gyrociliatus] | diamond | 555 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28258006 | 28258006 | PRJNA986481_P_NODE_36846_length_268_cov_2.356164_g36321_i0 | PRJNA986481 | 36846 | 268 | 2.356164 | 6.31451952 | Ridgeia piscesae | 27915 | Annelida | Annelida | 48.5 | 4.88e-4 | NR | KAK2179886.1 | 27915 | g36321 | i0 | 53.5 | 0.48134328358209 | 43 | 17 | 48.1 | 1 | 129 | 1 | 1697 | 1736 | KAK2179886.1 hypothetical protein NP493_468g02010 [Ridgeia piscesae] | diamond | 129 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28358699 | 28358699 | PRJNA986481_P_NODE_7666_length_586_cov_2.944134_g7165_i0 | PRJNA986481 | 7666 | 586 | 2.944134 | 17.25262524 | Metazoa | 33208 | Annelida | Annelida | 151 | 1.2699999999999999e-42 | NR | CAH1775341.1 | 6347 | g7165 | i0 | 42.8 | 3.68600682593857 | 187 | 95 | 92.7 | 6 | 33 | 575 | 13 | 193 | CAH1775341.1 unnamed protein product [Owenia fusiformis] | diamond | 2160 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28422171 | 28422171 | PRJNA986481_P_NODE_5046_length_704_cov_1.570992_g4615_i0 | PRJNA986481 | 5046 | 704 | 1.570992 | 11.05978368 | Opisthokonta | 33154 | Annelida | Annelida | 280 | 2.2400000000000002e-91 | NR | CAH1784578.1 | 6347 | g4615 | i0 | 60.8 | 54.4474431818182 | 240 | 74 | 96.3 | 4 | 25 | 702 | 1 | 234 | CAH1784578.1 unnamed protein product [Owenia fusiformis] | diamond | 38331 | 281 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28579943 | 28579943 | PRJNA986481_P_NODE_34047_length_280_cov_1.744589_g33522_i0 | PRJNA986481 | 34047 | 280 | 1.744589 | 4.8848492 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 128 | 3.9699999999999996e-32 | NR | CAH1792238.1 | 6347 | g33522 | i0 | 53.2 | 22.0285714285714 | 94 | 40 | 98.6 | 2 | 1 | 276 | 12 | 103 | CAH1792238.1 unnamed protein product [Owenia fusiformis] | diamond | 6168 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29274313 | 29274313 | PRJNA986481_P_NODE_62529_length_227_cov_2.241573_g62004_i0 | PRJNA986481 | 62529 | 227 | 2.241573 | 5.08837071 | Metazoa | 33208 | Annelida | Annelida | 47.4 | 2.42e-4 | NR | KAK2150531.1 | 53620 | g62004 | i0 | 36.5 | 1.38766519823789 | 52 | 33 | 68.7 | 0 | 46 | 201 | 89 | 140 | KAK2150531.1 hypothetical protein LSH36_401g00065 [Paralvinella palmiformis] | diamond | 315 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29931806 | 29931806 | PRJNA986481_P_NODE_23631_length_337_cov_2.583333_g23106_i0 | PRJNA986481 | 23631 | 337 | 2.583333 | 8.70583221 | Capitella teleta | 283909 | Annelida | Annelida | 87 | 2.96e-17 | NR | ELU00420.1 | 283909 | g23106 | i0 | 47.6 | 1.97626112759644 | 105 | 47 | 90.8 | 4 | 333 | 28 | 65 | 164 | ELU00420.1 hypothetical protein CAPTEDRAFT_169505 [Capitella teleta] | diamond | 666 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30089543 | 30089543 | PRJNA986481_P_NODE_7092_length_607_cov_15.845878_g6602_i0 | PRJNA986481 | 7092 | 607 | 15.845878 | 96.18447946 | Eisenia fetida | 6396 | Annelida | Annelida | 95.9 | 1.18e-20 | NR | AUS83917.1 | 6396 | g6602 | i0 | 37.8 | 1.53706754530478 | 156 | 90 | 74.6 | 2 | 11 | 463 | 37 | 190 | AUS83917.1 glutathion S-transferase pi [Eisenia fetida] | diamond | 933 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 30790611 | 30790611 | PRJNA986481_P_NODE_28454_length_307_cov_2.600775_g27929_i0 | PRJNA986481 | 28454 | 307 | 2.600775 | 7.98437925 | Metazoa | 33208 | Annelida | Annelida | 132 | 1.17e-37 | NR | KAI0211331.1 | 104711 | g27929 | i0 | 62.8 | 35.4332247557003 | 94 | 35 | 91.9 | 0 | 296 | 15 | 3 | 96 | KAI0211331.1 U6 snRNA-associated Sm-like protein LSm8 [Lamellibrachia satsuma] | diamond | 10878 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31296192 | 31296192 | PRJNA986481_P_NODE_25015_length_328_cov_2.172043_g24490_i0 | PRJNA986481 | 25015 | 328 | 2.172043 | 7.12430104 | Metazoa | 33208 | Annelida | Annelida | 82.4 | 1.02e-15 | NR | XP_009017773.1 | 6412 | g24490 | i0 | 41.5 | 2.1219512195122 | 118 | 58 | 99.7 | 5 | 1 | 327 | 122 | 237 | XP_009017773.1 hypothetical protein HELRODRAFT_186308 [Helobdella robusta] | diamond | 696 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31732981 | 31732981 | PRJNA986481_P_NODE_12957_length_455_cov_2.684729_g12433_i0 | PRJNA986481 | 12957 | 455 | 2.684729 | 12.21551695 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 84 | 1.6e-15 | NR | KAK2144879.1 | 53620 | g12433 | i0 | 32.4 | 1.97142857142857 | 148 | 95 | 94.3 | 1 | 12 | 440 | 979 | 1126 | KAK2144879.1 hypothetical protein LSH36_722g00029 [Paralvinella palmiformis] | diamond | 897 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31764707 | 31764707 | PRJNA986481_P_NODE_13237_length_450_cov_2.653367_g12713_i0 | PRJNA986481 | 13237 | 450 | 2.653367 | 11.9401515 | Sipunculus nudus | 6446 | Annelida | Annelida | 124 | 7.24e-33 | NR | ABW90377.1 | 6446 | g12713 | i0 | 55.2 | 9.19333333333333 | 116 | 42 | 70.7 | 3 | 440 | 123 | 12 | 127 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 4137 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 32144465 | 32144465 | PRJNA986481_P_NODE_58078_length_243_cov_1.072165_g57553_i0 | PRJNA986481 | 58078 | 243 | 1.072165 | 2.60536095 | Owenia fusiformis | 6347 | Annelida | Annelida | 112 | 3.2900000000000004e-27 | NR | CAH1793904.1 | 6347 | g57553 | i0 | 60 | 0.987654320987654 | 80 | 32 | 98.8 | 0 | 242 | 3 | 86 | 165 | CAH1793904.1 unnamed protein product [Owenia fusiformis] | diamond | 240 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32593359 | 32593359 | PRJNA986481_P_NODE_51759_length_250_cov_1.004975_g51234_i0 | PRJNA986481 | 51759 | 250 | 1.004975 | 2.5124375 | Opisthokonta | 33154 | Annelida | Annelida | 50.8 | 2.75e-5 | NR | XP_009016532.1 | 6412 | g51234 | i0 | 46 | 1.944 | 50 | 27 | 60 | 0 | 244 | 95 | 134 | 183 | XP_009016532.1 hypothetical protein HELRODRAFT_77994 [Helobdella robusta] | diamond | 486 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32807647 | 32807647 | PRJNA986481_P_NODE_45300_length_257_cov_2.514423_g44775_i0 | PRJNA986481 | 45300 | 257 | 2.514423 | 6.46206711 | Owenia fusiformis | 6347 | Annelida | Annelida | 63.2 | 1.88e-9 | NR | CAH1799795.1 | 6347 | g44775 | i0 | 48.2 | 1.99610894941634 | 56 | 26 | 65.4 | 1 | 27 | 194 | 227 | 279 | CAH1799795.1 unnamed protein product [Owenia fusiformis] | diamond | 513 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;