contig_metadata
17 rows where bioproject = "PRJNA382357", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4902996 | 4902996 | PRJNA382357_P_NODE_26064_length_439_cov_1.208995_g25326_i0 | PRJNA382357 | 26064 | 439 | 1.208995 | 5.30748805 | Ramisyllis | 1166725 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|902816225|gb|KR604716.1| | 1166726 | g25326 | i0 | 100 | 14.501138952164 | 31 | 0 | 7 | 0 | 18 | 48 | 2008 | 1978 | Ramisyllis multicaudata 18S ribosomal RNA gene, complete sequence | blastn | 6366 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Syllidae | Ramisyllis | Ramisyllis multicaudata | |
| 5506261 | 5506261 | PRJNA382357_P_NODE_118645_length_224_cov_2.159509_g117906_i0 | PRJNA382357 | 118645 | 224 | 2.159509 | 4.83730016 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g117906 | i0 | 90.244 | 0.3125 | 41 | 4 | 18 | 0 | 119 | 159 | 7407510 | 7407470 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 70 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5506637 | 5506637 | PRJNA382357_P_NODE_142145_length_208_cov_0.884354_g141406_i0 | PRJNA382357 | 142145 | 208 | 0.884354 | 1.83945632 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.018 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g141406 | i0 | 96.774 | 0.149038461538462 | 31 | 1 | 15 | 0 | 172 | 202 | 13341893 | 13341923 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10606079 | 10606079 | PRJNA382357_P_NODE_102269_length_240_cov_1.044693_g101530_i0 | PRJNA382357 | 102269 | 240 | 1.044693 | 2.5072632 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g101530 | i0 | 100 | 0.3625 | 29 | 0 | 12 | 0 | 211 | 239 | 1702837 | 1702809 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14431236 | 14431236 | PRJNA382357_P_NODE_113292_length_229_cov_1.386905_g112553_i0 | PRJNA382357 | 113292 | 229 | 1.386905 | 3.17601245 | Metazoa | 33208 | Annelida | Annelida | 80.5 | 1.56e-15 | NR | KAK2164743.1 | 53620 | g112553 | i0 | 47.2 | 2.56768558951965 | 72 | 38 | 94.3 | 0 | 226 | 11 | 444 | 515 | KAK2164743.1 hypothetical protein LSH36_59g01037 [Paralvinella palmiformis] | diamond | 588 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 15705066 | 15705066 | PRJNA382357_P_NODE_104893_length_237_cov_1.420455_g104154_i0 | PRJNA382357 | 104893 | 237 | 1.420455 | 3.36647835 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.021 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g104154 | i0 | 96.875 | 0.135021097046413 | 32 | 0 | 13 | 1 | 195 | 225 | 8809540 | 8809509 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15705955 | 15705955 | PRJNA382357_P_NODE_162613_length_190_cov_92.286822_g161874_i0 | PRJNA382357 | 162613 | 190 | 92.286822 | 175.3449618 | Pholoe sp. YZ-2018 | 2153336 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|1376177452|gb|KY753854.1| | 2153336 | g161874 | i0 | 100 | 0.152631578947368 | 29 | 0 | 15 | 0 | 60 | 88 | 7912 | 7940 | Pholoe sp. YZ-2018 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Pholoidae | Pholoe | Pholoe sp. YZ-2018 | |
| 18256093 | 18256093 | PRJNA382357_P_NODE_87815_length_256_cov_2.087179_g87076_i0 | PRJNA382357 | 87815 | 256 | 2.087179 | 5.34317824 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g87076 | i0 | 100 | 0.11328125 | 29 | 0 | 11 | 0 | 132 | 160 | 2112452 | 2112480 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21476542 | 21476542 | PRJNA382357_P_NODE_164677_length_186_cov_3.880000_g163938_i0 | PRJNA382357 | 164677 | 186 | 3.88 | 7.2168 | Naididae | 2109251 | Annelida | Annelida | 239 | 1.14e-58 | NTclustered | gi|94467836|gb|DQ459984.1| | 66488 | g163938 | i0 | 100 | 101.865591397849 | 129 | 0 | 98 | 0 | 4 | 132 | 600 | 728 | Dero digitata 18S ribosomal RNA gene, partial sequence | blastn | 18947 | 241 | 0.991701244813278 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Dero | Dero digitata | |
| 23355580 | 23355580 | PRJNA382357_P_NODE_23839_length_456_cov_7.235443_g23102_i0 | PRJNA382357 | 23839 | 456 | 7.235443 | 32.99362008 | Orbiniidae sp. NHM 050 | 3038473 | Annelida | Annelida | 283 | 1.44e-71 | NTclustered | gi|2476402998|gb|OQ746841.1| | 3038473 | g23102 | i0 | 88.306 | 55.280701754386 | 248 | 14 | 54 | 7 | 128 | 375 | 926 | 694 | Orbiniidae sp. NHM 050 voucher NHMUK ANEA 2023.426 small subunit ribosomal RNA gene, partial sequence | blastn | 25208 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Orbiniidae | Orbiniidae sp. NHM 050 | |||
| 24629257 | 24629257 | PRJNA382357_P_NODE_141940_length_208_cov_0.884354_g141201_i0 | PRJNA382357 | 141940 | 208 | 0.884354 | 1.83945632 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|675879579|ref|XM_009027071.1| | 6412 | g141201 | i0 | 100 | 0.423076923076923 | 30 | 0 | 14 | 0 | 148 | 177 | 1749 | 1720 | Helobdella robusta hypothetical protein partial mRNA | blastn | 88 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26617210 | 26617210 | PRJNA382357_P_NODE_125721_length_218_cov_1.394904_g124982_i0 | PRJNA382357 | 125721 | 218 | 1.394904 | 3.04089072 | Metazoa | 33208 | Annelida | Annelida | 60.5 | 1.47e-8 | NR | CAH1780641.1 | 6347 | g124982 | i0 | 61.5 | 2.03669724770642 | 39 | 15 | 53.7 | 0 | 201 | 85 | 92 | 130 | CAH1780641.1 unnamed protein product [Owenia fusiformis] | diamond | 444 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26617236 | 26617236 | PRJNA382357_P_NODE_99181_length_243_cov_1.428571_g98442_i0 | PRJNA382357 | 99181 | 243 | 1.428571 | 3.47142753 | Metazoa | 33208 | Annelida | Annelida | 45.8 | 3.54e-4 | NR | KAK2147480.1 | 53620 | g98442 | i0 | 48.6 | 3.33333333333333 | 35 | 18 | 43.2 | 0 | 36 | 140 | 9 | 43 | KAK2147480.1 hypothetical protein LSH36_550g01037 [Paralvinella palmiformis] | diamond | 810 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27296320 | 27296320 | PRJNA382357_P_NODE_16243_length_539_cov_1.309623_g15517_i0 | PRJNA382357 | 16243 | 539 | 1.309623 | 7.05886797 | Owenia fusiformis | 6347 | Annelida | Annelida | 55.8 | 2.08e-5 | NR | CAH1774399.1 | 6347 | g15517 | i0 | 43.5 | 0.768089053803339 | 62 | 33 | 33.4 | 1 | 209 | 388 | 98 | 159 | CAH1774399.1 unnamed protein product [Owenia fusiformis] | diamond | 414 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28071121 | 28071121 | PRJNA382357_P_NODE_166225_length_182_cov_2.966942_g165486_i0 | PRJNA382357 | 166225 | 182 | 2.966942 | 5.39983444 | Metazoa | 33208 | Annelida | Annelida | 43.9 | 0.00291 | NR | KAK2145821.1 | 53620 | g165486 | i0 | 46.8 | 2.62087912087912 | 47 | 22 | 72.5 | 1 | 48 | 179 | 18 | 64 | KAK2145821.1 hypothetical protein LSH36_655g01078, partial [Paralvinella palmiformis] | diamond | 477 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31528950 | 31528950 | PRJNA382357_P_NODE_3896_length_973_cov_1.801535_g3324_i0 | PRJNA382357 | 3896 | 973 | 1.801535 | 17.52893555 | Capitella teleta | 283909 | Annelida | Annelida | 48.1 | 0.0135 | NR | ELT90611.1 | 283909 | g3324 | i0 | 44.4 | 0.138746145940391 | 45 | 24 | 13.6 | 1 | 11 | 142 | 96 | 140 | ELT90611.1 hypothetical protein CAPTEDRAFT_101356 [Capitella teleta] | diamond | 135 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32715657 | 32715657 | PRJNA382357_P_NODE_148600_length_205_cov_0.902778_g147861_i0 | PRJNA382357 | 148600 | 205 | 0.902778 | 1.8506949 | Metazoa | 33208 | Annelida | Annelida | 60.5 | 1.29e-8 | NR | ELU11220.1 | 283909 | g147861 | i0 | 66.7 | 2.31219512195122 | 42 | 14 | 61.5 | 0 | 151 | 26 | 1121 | 1162 | ELU11220.1 hypothetical protein CAPTEDRAFT_137412, partial [Capitella teleta] | diamond | 474 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;