contig_metadata
21 rows where bioproject = "PRJNA928559", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1253232 | 1253232 | PRJNA928559_P_NODE_92001_length_371_cov_2.828859_g90432_i0 | PRJNA928559 | 92001 | 371 | 2.828859 | 10.49506689 | Metazoa | 33208 | Annelida | Annelida | 57 | 1.65e-6 | NR | XP_009021212.1 | 6412 | g90432 | i0 | 28.4 | 4.8355795148248 | 109 | 78 | 88.1 | 0 | 329 | 3 | 521 | 629 | XP_009021212.1 hypothetical protein HELRODRAFT_82872, partial [Helobdella robusta] | diamond | 1794 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2178206 | 2178206 | PRJNA928559_P_NODE_169162_length_269_cov_1.193878_g167593_i0 | PRJNA928559 | 169162 | 269 | 1.193878 | 3.21153182 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.14e-5 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g167593 | i0 | 100 | 9.50557620817844 | 34 | 0 | 13 | 0 | 236 | 269 | 2635944 | 2635911 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 2557 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4732745 | 4732745 | PRJNA928559_P_NODE_64604_length_435_cov_3.185083_g63035_i0 | PRJNA928559 | 64604 | 435 | 3.185083 | 13.85511105 | Helobdella robusta | 6412 | Annelida | Annelida | 723 | 0 | NTclustered | gi|675870283|ref|XM_009022454.1| | 6412 | g63035 | i0 | 96.767 | 14.9402298850575 | 433 | 14 | 99 | 0 | 3 | 435 | 917 | 485 | Helobdella robusta hypothetical protein partial mRNA | blastn | 6499 | 723 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 10181855 | 10181855 | PRJNA928559_P_NODE_86208_length_383_cov_1.548387_g84639_i0 | PRJNA928559 | 86208 | 383 | 1.548387 | 5.93032221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 4.66e-11 | NTclustered | gi|38350384|gb|AY366513.1| | 36124 | g84639 | i0 | 97.872 | 13.8616187989556 | 47 | 1 | 12 | 0 | 120 | 166 | 1467 | 1513 | Ophelia rathkei 28S ribosomal RNA gene, partial sequence | blastn | 5309 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Opheliidae | Ophelia | Ophelia rathkei | ||
| 22579384 | 22579384 | PRJNA928559_P_NODE_124698_length_318_cov_3.114286_g123129_i0 | PRJNA928559 | 124698 | 318 | 3.114286 | 9.90342948 | Pristina aequiseta | 212339 | Annelida | Annelida | 414 | 3.2999999999999995e-111 | NTclustered | gi|285029437|gb|GQ355455.1| | 212339 | g123129 | i0 | 90.312 | 94.0471698113208 | 320 | 25 | 100 | 5 | 1 | 318 | 320 | 635 | Pristina aequiseta 28S ribosomal RNA gene, partial sequence | blastn | 29907 | 414 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta | |
| 26961276 | 26961276 | PRJNA928559_P_NODE_101142_length_355_cov_1.067376_g99573_i0 | PRJNA928559 | 101142 | 355 | 1.067376 | 3.7891848 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 72.4 | 5.63e-12 | NR | KAK2144442.1 | 53620 | g99573 | i0 | 42.4 | 1.63943661971831 | 99 | 51 | 82.8 | 2 | 1 | 294 | 707 | 800 | KAK2144442.1 hypothetical protein LSH36_756g00059 [Paralvinella palmiformis] | diamond | 582 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27182607 | 27182607 | PRJNA928559_P_NODE_142682_length_296_cov_1.327354_g141113_i0 | PRJNA928559 | 142682 | 296 | 1.327354 | 3.92896784 | Helobdella robusta | 6412 | Annelida | Annelida | 81.3 | 2.03e-15 | NR | XP_009020262.1 | 6412 | g141113 | i0 | 42.1 | 0.962837837837838 | 95 | 53 | 96.3 | 1 | 3 | 287 | 470 | 562 | XP_009020262.1 hypothetical protein HELRODRAFT_100479 [Helobdella robusta] | diamond | 285 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27435873 | 27435873 | PRJNA928559_P_NODE_167763_length_270_cov_1.583756_g166194_i0 | PRJNA928559 | 167763 | 270 | 1.583756 | 4.2761412 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 95.1 | 2.01e-20 | NR | CAD5112606.1 | 2664684 | g166194 | i0 | 56.2 | 6.87777777777778 | 89 | 38 | 98.9 | 1 | 268 | 2 | 674 | 761 | CAD5112606.1 DgyrCDS1819 [Dimorphilus gyrociliatus] | diamond | 1857 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27537586 | 27537586 | PRJNA928559_P_NODE_25843_length_635_cov_2.738434_g24336_i0 | PRJNA928559 | 25843 | 635 | 2.738434 | 17.3890559 | Metazoa | 33208 | Annelida | Annelida | 217 | 7.33e-63 | NR | CAH1789021.1 | 6347 | g24336 | i0 | 58.1 | 9.35433070866142 | 179 | 70 | 83.6 | 3 | 2 | 532 | 497 | 672 | CAH1789021.1 unnamed protein product [Owenia fusiformis] | diamond | 5940 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27972412 | 27972412 | PRJNA928559_P_NODE_194965_length_250_cov_0.881356_g193396_i0 | PRJNA928559 | 194965 | 250 | 0.881356 | 2.20339 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 47.8 | 7.17e-4 | NR | KAK2163937.1 | 53620 | g193396 | i0 | 38.3 | 1.944 | 81 | 35 | 97.2 | 3 | 247 | 5 | 564 | 629 | KAK2163937.1 hypothetical protein LSH36_72g08045 [Paralvinella palmiformis] | diamond | 486 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28730250 | 28730250 | PRJNA928559_P_NODE_220767_length_232_cov_2.955975_g219198_i0 | PRJNA928559 | 220767 | 232 | 2.955975 | 6.857862 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 139 | 3.56e-36 | NR | CAD5123301.1 | 2664684 | g219198 | i0 | 79.2 | 6.9698275862069 | 77 | 16 | 99.6 | 0 | 2 | 232 | 443 | 519 | CAD5123301.1 DgyrCDS11658 [Dimorphilus gyrociliatus] | diamond | 1617 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29242549 | 29242549 | PRJNA928559_P_NODE_149009_length_289_cov_1.083333_g147440_i0 | PRJNA928559 | 149009 | 289 | 1.083333 | 3.13083237 | Metazoa | 33208 | Annelida | Annelida | 154 | 1.0899999999999999e-43 | NR | CAH1801346.1 | 6347 | g147440 | i0 | 71.6 | 11.8339100346021 | 95 | 27 | 98.6 | 0 | 1 | 285 | 189 | 283 | CAH1801346.1 unnamed protein product [Owenia fusiformis] | diamond | 3420 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30214251 | 30214251 | PRJNA928559_P_NODE_175052_length_263_cov_2.347368_g173483_i0 | PRJNA928559 | 175052 | 263 | 2.347368 | 6.17357784 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 52 | 2.72e-5 | NR | CAD5112216.1 | 2664684 | g173483 | i0 | 51.5 | 0.752851711026616 | 66 | 28 | 75.3 | 2 | 64 | 261 | 1861 | 1922 | CAD5112216.1 DgyrCDS1449 [Dimorphilus gyrociliatus] | diamond | 198 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30568805 | 30568805 | PRJNA928559_P_NODE_201633_length_247_cov_1.471264_g200064_i0 | PRJNA928559 | 201633 | 247 | 1.471264 | 3.63402208 | Opisthokonta | 33154 | Annelida | Annelida | 47 | 0.00126 | NR | CAH1775353.1 | 6347 | g200064 | i0 | 50 | 1.90688259109312 | 44 | 22 | 53.4 | 0 | 226 | 95 | 184 | 227 | CAH1775353.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 471 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30632115 | 30632115 | PRJNA928559_P_NODE_226273_length_209_cov_4.375000_g224704_i0 | PRJNA928559 | 226273 | 209 | 4.375 | 9.14375 | Metazoa | 33208 | Annelida | Annelida | 60.8 | 9.61e-9 | NR | CAH1794275.1 | 6347 | g224704 | i0 | 49.1 | 6.30143540669856 | 55 | 28 | 78.9 | 0 | 3 | 167 | 63 | 117 | CAH1794275.1 unnamed protein product [Owenia fusiformis] | diamond | 1317 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31098869 | 31098869 | PRJNA928559_P_NODE_116055_length_331_cov_1.224806_g114486_i0 | PRJNA928559 | 116055 | 331 | 1.224806 | 4.05410786 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 61.6 | 2.45e-8 | NR | CAD5126419.1 | 2664684 | g114486 | i0 | 34.9 | 0.960725075528701 | 106 | 62 | 93.4 | 5 | 319 | 11 | 15 | 116 | CAD5126419.1 DgyrCDS14553 [Dimorphilus gyrociliatus] | diamond | 318 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 31390925 | 31390925 | PRJNA928559_P_NODE_95216_length_365_cov_2.356164_g93647_i0 | PRJNA928559 | 95216 | 365 | 2.356164 | 8.5999986 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 186 | 6.249999999999999e-55 | NR | XP_009012062.1 | 6412 | g93647 | i0 | 71.1 | 14.9178082191781 | 121 | 35 | 99.5 | 0 | 1 | 363 | 68 | 188 | XP_009012062.1 hypothetical protein HELRODRAFT_122321, partial [Helobdella robusta] | diamond | 5445 | 187 | 0.994652406417112 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31731435 | 31731435 | PRJNA928559_P_NODE_203817_length_246_cov_1.722543_g202248_i0 | PRJNA928559 | 203817 | 246 | 1.722543 | 4.23745578 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 70.1 | 3.32e-13 | NR | KAI0231037.1 | 104711 | g202248 | i0 | 69.2 | 0.475609756097561 | 39 | 12 | 47.6 | 0 | 3 | 119 | 13 | 51 | KAI0231037.1 hypothetical protein LSAT2_018592 [Lamellibrachia satsuma] | diamond | 117 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31858017 | 31858017 | PRJNA928559_P_NODE_54337_length_468_cov_1.878481_g52771_i0 | PRJNA928559 | 54337 | 468 | 1.878481 | 8.79129108 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 61.2 | 1.44e-7 | NR | CAD5126731.1 | 2664684 | g52771 | i0 | 33.3 | 3.17307692307692 | 165 | 87 | 95.5 | 9 | 463 | 17 | 523 | 680 | CAD5126731.1 DgyrCDS14787 [Dimorphilus gyrociliatus] | diamond | 1485 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 32238009 | 32238009 | PRJNA928559_P_NODE_116518_length_330_cov_1.968872_g114949_i0 | PRJNA928559 | 116518 | 330 | 1.968872 | 6.4972776 | Ridgeia piscesae | 27915 | Annelida | Annelida | 48.1 | 0.00123 | NR | KAK2167443.1 | 27915 | g114949 | i0 | 29.7 | 0.827272727272727 | 91 | 56 | 75.5 | 2 | 3 | 251 | 257 | 347 | KAK2167443.1 hypothetical protein NP493_1277g00003 [Ridgeia piscesae] | diamond | 273 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32561585 | 32561585 | PRJNA928559_P_NODE_192659_length_251_cov_0.876404_g191090_i0 | PRJNA928559 | 192659 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.2 | 7.3e-20 | NR | CAH1790122.1 | 6347 | g191090 | i0 | 48.2 | 3.9681274900398402 | 83 | 42 | 99.2 | 1 | 1 | 249 | 582 | 663 | CAH1790122.1 unnamed protein product [Owenia fusiformis] | diamond | 996 | 93.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);;