contig_metadata
11 rows where bioproject = "PRJNA1215813", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331654 | 331654 | PRJNA1215813_P_NODE_3341_length_416_cov_0.909621_g3261_i0 | PRJNA1215813 | 3341 | 416 | 0.909621 | 3.78402336 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 224 | 8.940000000000001e-70 | NR | CAH1773646.1 | 6347 | g3261 | i0 | 81.5 | 42.8725961538462 | 135 | 25 | 97.4 | 0 | 415 | 11 | 43 | 177 | CAH1773646.1 unnamed protein product [Owenia fusiformis] | diamond | 17835 | 226 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 331733 | 331733 | PRJNA1215813_P_NODE_7761_length_282_cov_1.258373_g7681_i0 | PRJNA1215813 | 7761 | 282 | 1.258373 | 3.54861186 | Metazoa | 33208 | Annelida | Annelida | 84.7 | 9.54e-17 | NR | CAH1794945.1 | 6347 | g7681 | i0 | 59.7 | 6.13829787234043 | 72 | 29 | 76.6 | 0 | 281 | 66 | 59 | 130 | CAH1794945.1 unnamed protein product [Owenia fusiformis] | diamond | 1731 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 7985166 | 7985166 | PRJNA1215813_P_NODE_3987_length_382_cov_1.449838_g3907_i0 | PRJNA1215813 | 3987 | 382 | 1.449838 | 5.53838116 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 127 | 4.929999999999999e-31 | NR | KAK2143648.1 | 53620 | g3907 | i0 | 50.4 | 6 | 131 | 59 | 99.7 | 4 | 381 | 1 | 416 | 544 | KAK2143648.1 hypothetical protein LSH36_824g03044 [Paralvinella palmiformis] | diamond | 2292 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 13085460 | 13085460 | PRJNA1215813_P_NODE_631_length_868_cov_12.495597_g573_i0 | PRJNA1215813 | 631 | 868 | 12.495597 | 108.46178196 | Metazoa | 33208 | Annelida | Annelida | 304 | 2.12e-99 | NR | KAK2146210.1 | 53620 | g573 | i0 | 69.2 | 14.9066820276498 | 208 | 64 | 71.9 | 0 | 845 | 222 | 6 | 213 | KAK2146210.1 hypothetical protein LSH36_624g01057 [Paralvinella palmiformis] | diamond | 12939 | 305 | 0.99672131147541 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 16908985 | 16908985 | PRJNA1215813_P_NODE_954_length_733_cov_2.284848_g881_i0 | PRJNA1215813 | 954 | 733 | 2.284848 | 16.74793584 | Metazoa | 33208 | Annelida | Annelida | 217 | 8.34e-65 | NR | CAH1773728.1 | 6347 | g881 | i0 | 44.1 | 21.1023192360164 | 238 | 127 | 95 | 2 | 38 | 733 | 165 | 402 | CAH1773728.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 15468 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27028249 | 27028249 | PRJNA1215813_P_NODE_2702_length_459_cov_1.505181_g2622_i0 | PRJNA1215813 | 2702 | 459 | 1.505181 | 6.90878079 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 6.51e-5 | NR | KAK2179886.1 | 27915 | g2622 | i0 | 40 | 1.80392156862745 | 65 | 30 | 36.6 | 2 | 3 | 170 | 1704 | 1768 | KAK2179886.1 hypothetical protein NP493_468g02010 [Ridgeia piscesae] | diamond | 828 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27420593 | 27420593 | PRJNA1215813_P_NODE_1963_length_531_cov_1.853712_g1883_i0 | PRJNA1215813 | 1963 | 531 | 1.853712 | 9.84321072 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 48.5 | 0.0064 | NR | KAI0212806.1 | 104711 | g1883 | i0 | 42.9 | 0.949152542372881 | 84 | 43 | 45.8 | 3 | 525 | 283 | 1088 | 1169 | KAI0212806.1 hypothetical protein LSAT2_002254 [Lamellibrachia satsuma] | diamond | 504 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 27755133 | 27755133 | PRJNA1215813_P_NODE_4544_length_360_cov_1.087108_g4464_i0 | PRJNA1215813 | 4544 | 360 | 1.087108 | 3.9135888 | Metazoa | 33208 | Annelida | Annelida | 147 | 1.17e-41 | NR | CAH1772980.1 | 6347 | g4464 | i0 | 61.5 | 11.125 | 117 | 45 | 97.5 | 0 | 351 | 1 | 33 | 149 | CAH1772980.1 unnamed protein product [Owenia fusiformis] | diamond | 4005 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31842562 | 31842562 | PRJNA1215813_P_NODE_6037_length_317_cov_1.680328_g5957_i0 | PRJNA1215813 | 6037 | 317 | 1.680328 | 5.32663976 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 110 | 1.0400000000000002e-27 | NR | KAI0209783.1 | 104711 | g5957 | i0 | 54 | 3.69085173501577 | 100 | 46 | 94.6 | 0 | 5 | 304 | 52 | 151 | KAI0209783.1 Transcription initiation factor TFIID subunit 13 [Lamellibrachia satsuma] | diamond | 1170 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32620602 | 32620602 | PRJNA1215813_P_NODE_3600_length_401_cov_0.948171_g3520_i0 | PRJNA1215813 | 3600 | 401 | 0.948171 | 3.80216571 | Metazoa | 33208 | Annelida | Annelida | 108 | 4.79e-25 | NR | CAH1791596.1 | 6347 | g3520 | i0 | 45.7 | 6.56109725685786 | 116 | 62 | 86.8 | 1 | 348 | 1 | 109 | 223 | CAH1791596.1 unnamed protein product [Owenia fusiformis] | diamond | 2631 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32809530 | 32809530 | PRJNA1215813_P_NODE_4040_length_380_cov_1.016287_g3960_i0 | PRJNA1215813 | 4040 | 380 | 1.016287 | 3.8618906 | Opisthokonta | 33154 | Annelida | Annelida | 195 | 1.5100000000000001e-59 | NR | XP_009019380.1 | 6412 | g3960 | i0 | 73.8 | 29.8421052631579 | 126 | 33 | 99.5 | 0 | 1 | 378 | 23 | 148 | XP_009019380.1 hypothetical protein HELRODRAFT_94331 [Helobdella robusta] | diamond | 11340 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;