contig_metadata
20 rows where bioproject = "PRJNA915212", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4723646 | 4723646 | PRJNA915212_P_NODE_13024_length_165_cov_0.879310_g12986_i0 | PRJNA915212 | 13024 | 165 | 0.87931 | 1.4508615 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g12986 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 36 | 63 | 15037862 | 15037889 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9822979 | 9822979 | PRJNA915212_P_NODE_10108_length_182_cov_1.150376_g10070_i0 | PRJNA915212 | 10108 | 182 | 1.150376 | 2.09368432 | Platynereis dumerilii | 6359 | Annelida | Annelida | 102 | 1.52e-17 | NTclustered | gi|83307353|emb|CT033327.1| | 6359 | g10070 | i0 | 79.487 | 42.8406593406593 | 156 | 22 | 81 | 7 | 1 | 148 | 434 | 281 | Platynereis dumerilii EST IB0AAA22BG09EM1 | blastn | 7797 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 16198067 | 16198067 | PRJNA915212_P_NODE_5433_length_255_cov_0.941748_g5395_i0 | PRJNA915212 | 5433 | 255 | 0.941748 | 2.4014574 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.38e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g5395 | i0 | 94.737 | 12.6823529411765 | 38 | 2 | 15 | 0 | 31 | 68 | 666494 | 666531 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 3234 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27530110 | 27530110 | PRJNA915212_P_NODE_10583_length_177_cov_1.195312_g10545_i0 | PRJNA915212 | 10583 | 177 | 1.195312 | 2.11570224 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 63.5 | 6.93e-10 | NR | CAD5123944.1 | 2664684 | g10545 | i0 | 53.4 | 0.983050847457627 | 58 | 25 | 98.3 | 1 | 175 | 2 | 751 | 806 | CAD5123944.1 DgyrCDS12251 [Dimorphilus gyrociliatus] | diamond | 174 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28256182 | 28256182 | PRJNA915212_P_NODE_12326_length_166_cov_0.871795_g12288_i0 | PRJNA915212 | 12326 | 166 | 0.871795 | 1.4471797 | Capitella teleta | 283909 | Annelida | Annelida | 77 | 9.46e-15 | NR | ELT87509.1 | 283909 | g12288 | i0 | 63.5 | 0.939759036144578 | 52 | 19 | 94 | 0 | 9 | 164 | 312 | 363 | ELT87509.1 hypothetical protein CAPTEDRAFT_208298 [Capitella teleta] | diamond | 156 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28287730 | 28287730 | PRJNA915212_P_NODE_5326_length_258_cov_1.220096_g5288_i0 | PRJNA915212 | 5326 | 258 | 1.220096 | 3.14784768 | Owenia fusiformis | 6347 | Annelida | Annelida | 100 | 3e-22 | NR | CAH1789021.1 | 6347 | g5288 | i0 | 50.5 | 2.18604651162791 | 101 | 35 | 100 | 3 | 258 | 1 | 497 | 597 | CAH1789021.1 unnamed protein product [Owenia fusiformis] | diamond | 564 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28382619 | 28382619 | PRJNA915212_P_NODE_8566_length_199_cov_1.140000_g8528_i0 | PRJNA915212 | 8566 | 199 | 1.14 | 2.2686 | Owenia fusiformis | 6347 | Annelida | Annelida | 59.3 | 3.02e-8 | NR | CAH1795822.1 | 6347 | g8528 | i0 | 51.7 | 0.874371859296482 | 58 | 26 | 84.4 | 1 | 22 | 189 | 751 | 808 | CAH1795822.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 174 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29116315 | 29116315 | PRJNA915212_P_NODE_7168_length_218_cov_1.804734_g7130_i0 | PRJNA915212 | 7168 | 218 | 1.804734 | 3.93432012 | Opisthokonta | 33154 | Annelida | Annelida | 61.2 | 6.44e-9 | NR | XP_009023418.1 | 6412 | g7130 | i0 | 48.5 | 14.6009174311927 | 66 | 28 | 89.4 | 2 | 3 | 197 | 57 | 117 | XP_009023418.1 hypothetical protein HELRODRAFT_185829 [Helobdella robusta] | diamond | 3183 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29140648 | 29140648 | PRJNA915212_P_NODE_3869_length_313_cov_1.306818_g3831_i0 | PRJNA915212 | 3869 | 313 | 1.306818 | 4.09034034 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 53.9 | 1.01e-5 | NR | KAI0242793.1 | 104711 | g3831 | i0 | 36 | 6.06709265175719 | 89 | 53 | 85.3 | 3 | 47 | 313 | 37 | 121 | KAI0242793.1 hypothetical protein LSAT2_011099, partial [Lamellibrachia satsuma] | diamond | 1899 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 29771722 | 29771722 | PRJNA915212_P_NODE_5951_length_242_cov_1.295337_g5913_i0 | PRJNA915212 | 5951 | 242 | 1.295337 | 3.13471554 | Thoracophelia sp. 1 KU-2 | 2909824 | Annelida | Annelida | 138 | 1.93e-37 | NR | BDA39159.1 | 2866647 | g5913 | i0 | 72.5 | 4.95867768595041 | 80 | 22 | 99.2 | 0 | 241 | 2 | 203 | 282 | BDA39159.1 creatine kinase [Thoracophelia sp. 1 KU-2021] | diamond | 1200 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Opheliidae | Thoracophelia | Thoracophelia sp. 1 KU-2021 | ||
| 29993074 | 29993074 | PRJNA915212_P_NODE_12571_length_166_cov_0.863248_g12533_i0 | PRJNA915212 | 12571 | 166 | 0.863248 | 1.43299168 | Ridgeia piscesae | 27915 | Annelida | Annelida | 49.3 | 6.48e-5 | NR | KAK2193563.1 | 27915 | g12533 | i0 | 61.8 | 1.1566265060241 | 34 | 13 | 61.4 | 0 | 166 | 65 | 36 | 69 | KAK2193563.1 hypothetical protein NP493_10g08074 [Ridgeia piscesae] | diamond | 192 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30316806 | 30316806 | PRJNA915212_P_NODE_12112_length_166_cov_1.307692_g12074_i0 | PRJNA915212 | 12112 | 166 | 1.307692 | 2.17076872 | Metazoa | 33208 | Annelida | Annelida | 100 | 8.229999999999999e-23 | NR | CAH1794200.1 | 6347 | g12074 | i0 | 85.5 | 14.9096385542169 | 55 | 8 | 99.4 | 0 | 166 | 2 | 81 | 135 | CAH1794200.1 unnamed protein product [Owenia fusiformis] | diamond | 2475 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30372524 | 30372524 | PRJNA915212_P_NODE_1392_length_568_cov_1.439306_g1359_i0 | PRJNA915212 | 1392 | 568 | 1.439306 | 8.17525808 | Ridgeia piscesae | 27915 | Annelida | Annelida | 51.6 | 6.29e-4 | NR | KAK2184177.1 | 27915 | g1359 | i0 | 28.3 | 3.3169014084507 | 219 | 112 | 94.5 | 11 | 539 | 3 | 209 | 422 | KAK2184177.1 hypothetical protein NP493_277g02032 [Ridgeia piscesae] | diamond | 1884 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30537467 | 30537467 | PRJNA915212_P_NODE_7333_length_216_cov_1.089820_g7295_i0 | PRJNA915212 | 7333 | 216 | 1.08982 | 2.3540112 | Opisthokonta | 33154 | Annelida | Annelida | 45.4 | 0.00255 | NR | KAK2155102.1 | 53620 | g7295 | i0 | 32.9 | 1.94444444444444 | 70 | 46 | 97.2 | 1 | 212 | 3 | 162 | 230 | KAK2155102.1 hypothetical protein LSH36_249g03018 [Paralvinella palmiformis] | diamond | 420 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30561463 | 30561463 | PRJNA915212_P_NODE_7613_length_212_cov_0.926380_g7575_i0 | PRJNA915212 | 7613 | 212 | 0.92638 | 1.9639256 | Helobdella robusta | 6412 | Annelida | Annelida | 54.3 | 2.06e-7 | NR | XP_009025143.1 | 6412 | g7575 | i0 | 62.2 | 3.01415094339623 | 45 | 17 | 63.7 | 0 | 212 | 78 | 59 | 103 | XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta] | diamond | 639 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30687968 | 30687968 | PRJNA915212_P_NODE_8473_length_200_cov_1.013245_g8435_i0 | PRJNA915212 | 8473 | 200 | 1.013245 | 2.02649 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 42 | 0.0405 | NR | KAK2156640.1 | 53620 | g8435 | i0 | 35.9 | 0.96 | 64 | 40 | 96 | 1 | 200 | 9 | 103 | 165 | KAK2156640.1 hypothetical protein LSH36_208g02074 [Paralvinella palmiformis] | diamond | 192 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30972564 | 30972564 | PRJNA915212_P_NODE_11954_length_167_cov_0.864407_g11916_i0 | PRJNA915212 | 11954 | 167 | 0.864407 | 1.44355969 | Capitella teleta | 283909 | Annelida | Annelida | 47 | 4.21e-4 | NR | ELU13958.1 | 283909 | g11916 | i0 | 46.3 | 0.970059880239521 | 54 | 28 | 97 | 1 | 163 | 2 | 265 | 317 | ELU13958.1 hypothetical protein CAPTEDRAFT_174182 [Capitella teleta] | diamond | 162 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31327417 | 31327417 | PRJNA915212_P_NODE_15215_length_152_cov_2.388350_g15177_i0 | PRJNA915212 | 15215 | 152 | 2.38835 | 3.630292 | Metazoa | 33208 | Annelida | Annelida | 82 | 1.51e-16 | NR | XP_009011807.1 | 6412 | g15177 | i0 | 81.3 | 19.1052631578947 | 48 | 9 | 94.7 | 0 | 149 | 6 | 65 | 112 | XP_009011807.1 hypothetical protein HELRODRAFT_73062, partial [Helobdella robusta] | diamond | 2904 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32150022 | 32150022 | PRJNA915212_P_NODE_7878_length_208_cov_1.251572_g7840_i0 | PRJNA915212 | 7878 | 208 | 1.251572 | 2.60326976 | Opisthokonta | 33154 | Annelida | Annelida | 98.2 | 2.9e-23 | NR | CAH1795634.1 | 6347 | g7840 | i0 | 64.7 | 25.3701923076923 | 68 | 24 | 98.1 | 0 | 2 | 205 | 58 | 125 | CAH1795634.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 5277 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32750224 | 32750224 | PRJNA915212_P_NODE_4580_length_282_cov_1.472103_g4542_i0 | PRJNA915212 | 4580 | 282 | 1.472103 | 4.15133046 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 1.92e-28 | NR | KAK2170578.1 | 53620 | g4542 | i0 | 60.5 | 12.6170212765957 | 86 | 34 | 91.5 | 0 | 25 | 282 | 12 | 97 | KAK2170578.1 hypothetical protein LSH36_2g16020 [Paralvinella palmiformis] | diamond | 3558 | 111 | 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);;