contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 424180 | 424180 | PRJNA421571_P_NODE_84241_length_267_cov_1.582474_g81692_i0 | PRJNA421571 | 84241 | 267 | 1.582474 | 4.22520558 | Arenicola marina | 6344 | Annelida | Annelida | 157 | 1.5699999999999998e-47 | NR | ABW23182.1 | 6344 | g81692 | i0 | 79.3 | 0.97752808988764 | 87 | 18 | 97.8 | 0 | 265 | 5 | 13 | 99 | ABW23182.1 ribosomal protein rpl27a, partial [Arenicola marina] | diamond | 261 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 11900658 | 11900658 | PRJNA421571_P_NODE_101390_length_244_cov_2.228070_g98841_i0 | PRJNA421571 | 101390 | 244 | 2.22807 | 5.4364908 | Platynereis dumerilii | 6359 | Annelida | Annelida | 108 | 3.68e-26 | NR | AIZ77501.1 | 6359 | g98841 | i0 | 65.9 | 1.04508196721311 | 85 | 24 | 98.4 | 1 | 4 | 243 | 174 | 258 | AIZ77501.1 subtilisin-2 [Platynereis dumerilii] | diamond | 255 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 11901609 | 11901609 | PRJNA421571_P_NODE_35110_length_519_cov_1.724215_g32569_i0 | PRJNA421571 | 35110 | 519 | 1.724215 | 8.94867585 | Metazoa | 33208 | Annelida | Annelida | 243 | 8.66e-74 | NR | CAH1774925.1 | 6347 | g32569 | i0 | 68.1 | 52.6705202312139 | 166 | 53 | 96 | 0 | 500 | 3 | 1 | 166 | CAH1774925.1 unnamed protein product [Owenia fusiformis] | diamond | 27336 | 245 | 0.991836734693878 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 22762504 | 22762504 | PRJNA421571_P_NODE_22518_length_734_cov_3.653555_g20129_i0 | PRJNA421571 | 22518 | 734 | 3.653555 | 26.8170937 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 175 | 3.69e-50 | NR | KAI0231247.1 | 104711 | g20129 | i0 | 55.3 | 5.33378746594005 | 179 | 77 | 73.2 | 2 | 537 | 1 | 17 | 192 | KAI0231247.1 60S ribosomal protein L7a [Lamellibrachia satsuma] | diamond | 3915 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 26807472 | 26807472 | PRJNA421571_P_NODE_48681_length_399_cov_0.788344_g46133_i0 | PRJNA421571 | 48681 | 399 | 0.788344 | 3.14549256 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 160 | 2.41e-47 | NR | KAK2168654.1 | 53620 | g46133 | i0 | 65.4 | 20.390977443609 | 127 | 44 | 95.5 | 0 | 19 | 399 | 41 | 167 | KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis] | diamond | 8136 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27360264 | 27360264 | PRJNA421571_P_NODE_107063_length_241_cov_0.916667_g104514_i0 | PRJNA421571 | 107063 | 241 | 0.916667 | 2.20916747 | Owenia fusiformis | 6347 | Annelida | Annelida | 55.1 | 1.62e-6 | NR | CAH1800156.1 | 6347 | g104514 | i0 | 56.6 | 1.92946058091286 | 53 | 23 | 66 | 0 | 241 | 83 | 293 | 345 | CAH1800156.1 unnamed protein product [Owenia fusiformis] | diamond | 465 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27455072 | 27455072 | PRJNA421571_P_NODE_28783_length_608_cov_3.652336_g26270_i0 | PRJNA421571 | 28783 | 608 | 3.652336 | 22.20620288 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 80.9 | 9.37e-16 | NR | KAI0218681.1 | 104711 | g26270 | i0 | 35.7 | 1.91447368421053 | 129 | 76 | 63.2 | 2 | 571 | 188 | 3 | 125 | KAI0218681.1 Profilin [Lamellibrachia satsuma] | diamond | 1164 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28780811 | 28780811 | PRJNA421571_P_NODE_19107_length_823_cov_1.638667_g16891_i0 | PRJNA421571 | 19107 | 823 | 1.638667 | 13.48622941 | Owenia fusiformis | 6347 | Annelida | Annelida | 325 | 1.64e-103 | NR | CAH1789021.1 | 6347 | g16891 | i0 | 61.3 | 1.84447144592953 | 253 | 96 | 91.9 | 2 | 795 | 40 | 424 | 675 | CAH1789021.1 unnamed protein product [Owenia fusiformis] | diamond | 1518 | 325 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29223198 | 29223198 | PRJNA421571_P_NODE_105889_length_241_cov_1.773810_g103340_i0 | PRJNA421571 | 105889 | 241 | 1.77381 | 4.2748821 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 95.5 | 8.71e-22 | NR | KAK2159225.1 | 53620 | g103340 | i0 | 72.1 | 0.846473029045643 | 68 | 19 | 84.6 | 0 | 240 | 37 | 197 | 264 | KAK2159225.1 hypothetical protein LSH36_156g08009 [Paralvinella palmiformis] | diamond | 204 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29807815 | 29807815 | PRJNA421571_P_NODE_107731_length_233_cov_2.237500_g105182_i0 | PRJNA421571 | 107731 | 233 | 2.2375 | 5.213375 | Metazoa | 33208 | Annelida | Annelida | 116 | 1.51e-28 | NR | XP_009009765.1 | 6412 | g105182 | i0 | 67.5 | 3.9656652360515 | 77 | 25 | 99.1 | 0 | 2 | 232 | 366 | 442 | XP_009009765.1 hypothetical protein HELRODRAFT_153989 [Helobdella robusta] | diamond | 924 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30376991 | 30376991 | PRJNA421571_P_NODE_75132_length_289_cov_1.162037_g72583_i0 | PRJNA421571 | 75132 | 289 | 1.162037 | 3.35828693 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 176 | 1.4899999999999999e-53 | NR | CAH1780222.1 | 6347 | g72583 | i0 | 84.4 | 145.453287197232 | 96 | 15 | 99.7 | 0 | 2 | 289 | 86 | 181 | CAH1780222.1 unnamed protein product [Owenia fusiformis] | diamond | 42036 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31149466 | 31149466 | PRJNA421571_P_NODE_56735_length_353_cov_2.364286_g54186_i0 | PRJNA421571 | 56735 | 353 | 2.364286 | 8.34592958 | Phragmatopoma lapidosa | 341668 | Annelida | Annelida | 81.6 | 4.86e-17 | NR | AIU94829.1 | 341668 | g54186 | i0 | 41.6 | 1.75920679886686 | 101 | 54 | 84.1 | 2 | 316 | 20 | 3 | 100 | AIU94829.1 60S ribosomal protein [Phragmatopoma lapidosa] | diamond | 621 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Phragmatopoma | Phragmatopoma lapidosa | |
| 31830445 | 31830445 | PRJNA421571_P_NODE_64417_length_323_cov_1.204000_g61868_i0 | PRJNA421571 | 64417 | 323 | 1.204 | 3.88892 | Opisthokonta | 33154 | Annelida | Annelida | 51.6 | 1.71e-5 | NR | CAH1785131.1 | 6347 | g61868 | i0 | 44.8 | 4.92260061919505 | 67 | 34 | 60.4 | 2 | 321 | 127 | 72 | 137 | CAH1785131.1 unnamed protein product [Owenia fusiformis] | diamond | 1590 | 51.6 | 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);;