contig_metadata
22 rows where bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559120 | 1559120 | PRJNA1136505_P_NODE_76382_length_335_cov_4.954198_g69522_i0 | PRJNA1136505 | 76382 | 335 | 4.954198 | 16.5965633 | Helobdella robusta | 6412 | Annelida | Annelida | 105 | 9.52e-27 | NR | XP_009025143.1 | 6412 | g69522 | i0 | 57.9 | 1.71044776119403 | 95 | 40 | 85.1 | 0 | 23 | 307 | 7 | 101 | XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta] | diamond | 573 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 11763143 | 11763143 | PRJNA1136505_P_NODE_37610_length_562_cov_2.969325_g30780_i0 | PRJNA1136505 | 37610 | 562 | 2.969325 | 16.6876065 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 265 | 2.19e-87 | NR | XP_009022737.1 | 6412 | g30780 | i0 | 75 | 52.4572953736655 | 180 | 43 | 96.1 | 1 | 547 | 8 | 1 | 178 | XP_009022737.1 hypothetical protein HELRODRAFT_155894 [Helobdella robusta] | diamond | 29481 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 15059673 | 15059673 | PRJNA1136505_P_NODE_154112_length_241_cov_1.488095_g147252_i0 | PRJNA1136505 | 154112 | 241 | 1.488095 | 3.58630895 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 4.66e-4 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g147252 | i0 | 90.698 | 2.45228215767635 | 43 | 4 | 18 | 0 | 141 | 183 | 9019468 | 9019426 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 591 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15587418 | 15587418 | PRJNA1136505_P_NODE_67973_length_359_cov_2.013986_g61113_i0 | PRJNA1136505 | 67973 | 359 | 2.013986 | 7.23020974 | Metazoa | 33208 | Annelida | Annelida | 122 | 3.39e-31 | NR | CAH1784700.1 | 6347 | g61113 | i0 | 56.7 | 4.05292479108635 | 120 | 43 | 99.4 | 3 | 1 | 357 | 148 | 259 | CAH1784700.1 unnamed protein product [Owenia fusiformis] | diamond | 1455 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 18136223 | 18136223 | PRJNA1136505_P_NODE_155755_length_241_cov_0.916667_g148895_i0 | PRJNA1136505 | 155755 | 241 | 0.916667 | 2.20916747 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|675871503|ref|XM_009023064.1| | 6412 | g148895 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 209 | 237 | 1969 | 1941 | Helobdella robusta hypothetical protein mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 21961286 | 21961286 | PRJNA1136505_P_NODE_40698_length_524_cov_7.090909_g33849_i0 | PRJNA1136505 | 40698 | 524 | 7.090909 | 37.15636316 | Metazoa | 33208 | Annelida | Annelida | 183 | 7.599999999999999e-56 | NR | ABW90355.1 | 6446 | g33849 | i0 | 58.9 | 17.5248091603053 | 168 | 69 | 96.2 | 0 | 514 | 11 | 1 | 168 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 9183 | 184 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 25258300 | 25258300 | PRJNA1136505_P_NODE_46880_length_465_cov_3.494898_g40021_i0 | PRJNA1136505 | 46880 | 465 | 3.494898 | 16.2512757 | Metazoa | 33208 | Annelida | Annelida | 102 | 4.42e-17 | NTclustered | gi|2444161504|gb|OQ076767.1| | 1348078 | g40021 | i0 | 78.75 | 25.2924731182796 | 160 | 28 | 34 | 5 | 1 | 157 | 3282 | 3126 | Hirudinaria manillensis voucher CSU-MG-8 mitochondrion, partial genome | blastn | 11761 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudinaria | Hirudinaria manillensis | |
| 29407103 | 29407103 | PRJNA1136505_P_NODE_121609_length_261_cov_1.228723_g114749_i0 | PRJNA1136505 | 121609 | 261 | 1.228723 | 3.20696703 | Eulalia sp. (in: segmented worms) | 2909830 | Annelida | Annelida | 98.2 | 1.4200000000000002e-21 | NR | WWC50935.1 | 2909830 | g114749 | i0 | 54.5 | 6.06896551724138 | 77 | 32 | 85.1 | 1 | 8 | 229 | 589 | 665 | WWC50935.1 peptidase M13 [Eulalia sp. (in: segmented worms)] | diamond | 1584 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Phyllodocidae | Eulalia | Eulalia sp. (in: segmented worms) | |
| 29438366 | 29438366 | PRJNA1136505_P_NODE_99490_length_289_cov_1.263889_g92630_i0 | PRJNA1136505 | 99490 | 289 | 1.263889 | 3.65263921 | Capitella teleta | 283909 | Annelida | Annelida | 117 | 1.42e-28 | NR | ELU17873.1 | 283909 | g92630 | i0 | 56.3 | 5.93771626297578 | 96 | 42 | 99.7 | 0 | 1 | 288 | 115 | 210 | ELU17873.1 hypothetical protein CAPTEDRAFT_148575 [Capitella teleta] | diamond | 1716 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29501794 | 29501794 | PRJNA1136505_P_NODE_135090_length_249_cov_0.875000_g128230_i0 | PRJNA1136505 | 135090 | 249 | 0.875 | 2.17875 | Capitella teleta | 283909 | Annelida | Annelida | 50.1 | 1.03e-4 | NR | ELU11603.1 | 283909 | g128230 | i0 | 68.8 | 0.746987951807229 | 32 | 10 | 38.6 | 0 | 12 | 107 | 519 | 550 | ELU11603.1 hypothetical protein CAPTEDRAFT_227478 [Capitella teleta] | diamond | 186 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29711615 | 29711615 | PRJNA1136505_P_NODE_116570_length_267_cov_1.376289_g109710_i0 | PRJNA1136505 | 116570 | 267 | 1.376289 | 3.67469163 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.3 | 1.05e-15 | NR | ABW23191.1 | 6344 | g109710 | i0 | 61.2 | 8.32584269662921 | 67 | 26 | 75.3 | 0 | 266 | 66 | 6 | 72 | ABW23191.1 ribosomal protein rpl36a [Arenicola marina] | diamond | 2223 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 29817477 | 29817477 | PRJNA1136505_P_NODE_126631_length_255_cov_1.120879_g119771_i0 | PRJNA1136505 | 126631 | 255 | 1.120879 | 2.85824145 | Owenia fusiformis | 6347 | Annelida | Annelida | 51.6 | 3.47e-5 | NR | CAH1788932.1 | 6347 | g119771 | i0 | 31.2 | 1.63529411764706 | 77 | 50 | 87.1 | 1 | 225 | 4 | 1764 | 1840 | CAH1788932.1 unnamed protein product [Owenia fusiformis] | diamond | 417 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29869887 | 29869887 | PRJNA1136505_P_NODE_144011_length_245_cov_1.529070_g137151_i0 | PRJNA1136505 | 144011 | 245 | 1.52907 | 3.7462215 | Metazoa | 33208 | Annelida | Annelida | 137 | 5.32e-39 | NR | KAK2192936.1 | 27915 | g137151 | i0 | 81.8 | 90.6367346938776 | 77 | 14 | 94.3 | 0 | 245 | 15 | 15 | 91 | KAK2192936.1 hypothetical protein NP493_20g08043, partial [Ridgeia piscesae] | diamond | 22206 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29881008 | 29881008 | PRJNA1136505_P_NODE_108051_length_278_cov_1.078049_g101191_i0 | PRJNA1136505 | 108051 | 278 | 1.078049 | 2.99697622 | Owenia fusiformis | 6347 | Annelida | Annelida | 87.8 | 8.13e-18 | NR | CAH1789407.1 | 6347 | g101191 | i0 | 45.6 | 0.971223021582734 | 90 | 48 | 97.1 | 1 | 3 | 272 | 462 | 550 | CAH1789407.1 unnamed protein product [Owenia fusiformis] | diamond | 270 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30544328 | 30544328 | PRJNA1136505_P_NODE_100813_length_287_cov_1.439252_g93953_i0 | PRJNA1136505 | 100813 | 287 | 1.439252 | 4.13065324 | Owenia fusiformis | 6347 | Annelida | Annelida | 145 | 3.83e-38 | NR | CAH1784821.1 | 6347 | g93953 | i0 | 67.4 | 4.85017421602787 | 92 | 30 | 96.2 | 0 | 5 | 280 | 931 | 1022 | CAH1784821.1 unnamed protein product [Owenia fusiformis] | diamond | 1392 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30627919 | 30627919 | PRJNA1136505_P_NODE_101013_length_287_cov_1.252336_g94153_i0 | PRJNA1136505 | 101013 | 287 | 1.252336 | 3.59420432 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92.8 | 6.170000000000001e-21 | NR | CAH1782702.1 | 6347 | g94153 | i0 | 46.2 | 6.86759581881533 | 93 | 50 | 97.2 | 0 | 281 | 3 | 65 | 157 | CAH1782702.1 unnamed protein product [Owenia fusiformis] | diamond | 1971 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30659713 | 30659713 | PRJNA1136505_P_NODE_121113_length_261_cov_2.079787_g114253_i0 | PRJNA1136505 | 121113 | 261 | 2.079787 | 5.42824407 | Metazoa | 33208 | Annelida | Annelida | 89.4 | 1.84e-18 | NR | XP_009019787.1 | 6412 | g114253 | i0 | 56.3 | 12.8735632183908 | 80 | 35 | 92 | 0 | 254 | 15 | 226 | 305 | XP_009019787.1 hypothetical protein HELRODRAFT_188680 [Helobdella robusta] | diamond | 3360 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30702236 | 30702236 | PRJNA1136505_P_NODE_29114_length_727_cov_1.483180_g22410_i0 | PRJNA1136505 | 29114 | 727 | 1.48318 | 10.7827186 | Owenia fusiformis | 6347 | Annelida | Annelida | 337 | 3.6399999999999997e-110 | NR | CAH1773112.1 | 6347 | g22410 | i0 | 67.4 | 32.9504814305364 | 242 | 78 | 99.4 | 1 | 725 | 3 | 91 | 332 | CAH1773112.1 unnamed protein product [Owenia fusiformis] | diamond | 23955 | 338 | 0.997041420118343 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31101940 | 31101940 | PRJNA1136505_P_NODE_145135_length_245_cov_0.895349_g138275_i0 | PRJNA1136505 | 145135 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Annelida | Annelida | 64.7 | 7.01e-10 | NR | CAH1791672.1 | 6347 | g138275 | i0 | 50.8 | 2.55918367346939 | 59 | 21 | 72.2 | 1 | 37 | 213 | 312 | 362 | CAH1791672.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 627 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32304323 | 32304323 | PRJNA1136505_P_NODE_27979_length_759_cov_1.457726_g21342_i0 | PRJNA1136505 | 27979 | 759 | 1.457726 | 11.06414034 | Metazoa | 33208 | Annelida | Annelida | 234 | 1.93e-66 | NR | XP_009030579.1 | 6412 | g21342 | i0 | 47.1 | 11.2529644268775 | 259 | 129 | 99.6 | 3 | 758 | 3 | 264 | 521 | XP_009030579.1 hypothetical protein HELRODRAFT_189807 [Helobdella robusta] | diamond | 8541 | 236 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32682991 | 32682991 | PRJNA1136505_P_NODE_128320_length_253_cov_1.077778_g121460_i0 | PRJNA1136505 | 128320 | 253 | 1.077778 | 2.72677834 | Metazoa | 33208 | Annelida | Annelida | 136 | 6.48e-38 | NR | XP_009017047.1 | 6412 | g121460 | i0 | 72.6 | 51.7944664031621 | 84 | 23 | 99.6 | 0 | 252 | 1 | 107 | 190 | XP_009017047.1 hypothetical protein HELRODRAFT_186995 [Helobdella robusta] | diamond | 13104 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32693961 | 32693961 | PRJNA1136505_P_NODE_97300_length_292_cov_1.716895_g90440_i0 | PRJNA1136505 | 97300 | 292 | 1.716895 | 5.0133334 | Owenia fusiformis | 6347 | Annelida | Annelida | 91.7 | 2.46e-19 | NR | CAH1798672.1 | 6347 | g90440 | i0 | 51 | 4.02739726027397 | 98 | 47 | 99.7 | 1 | 291 | 1 | 53 | 150 | CAH1798672.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1176 | 91.7 | 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);;