contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27068438 | 27068438 | PRJNA1120060_P_NODE_1717202_length_284_cov_2.426540_g1699196_i0 | PRJNA1120060 | 1717202 | 284 | 2.42654 | 6.8913736 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 42.7 | 0.0356 | NR | KAK2139064.1 | 53620 | g1699196 | i0 | 34.9 | 0.454225352112676 | 43 | 28 | 45.4 | 0 | 252 | 124 | 85 | 127 | KAK2139064.1 hypothetical protein LSH36_2071g00000 [Paralvinella palmiformis] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27163915 | 27163915 | PRJNA1120060_P_NODE_2801962_length_246_cov_1.179191_g2783876_i0 | PRJNA1120060 | 2801962 | 246 | 1.179191 | 2.90080986 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 46.6 | 0.0017 | NR | KAK2156506.1 | 53620 | g2783876 | i0 | 36.7 | 1.46341463414634 | 60 | 33 | 72 | 2 | 202 | 26 | 259 | 314 | KAK2156506.1 hypothetical protein LSH36_211g00005 [Paralvinella palmiformis] | diamond | 360 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27848710 | 27848710 | PRJNA1120060_P_NODE_2042164_length_271_cov_1.686869_g2024127_i0 | PRJNA1120060 | 2042164 | 271 | 1.686869 | 4.57141499 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.0268 | NR | XP_009018537.1 | 6412 | g2024127 | i0 | 46.8 | 2.33579335793358 | 47 | 21 | 49.8 | 2 | 48 | 182 | 157 | 201 | XP_009018537.1 hypothetical protein HELRODRAFT_112284 [Helobdella robusta] | diamond | 633 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28459220 | 28459220 | PRJNA1120060_P_NODE_3015506_length_240_cov_2.742515_g2997407_i0 | PRJNA1120060 | 3015506 | 240 | 2.742515 | 6.582036 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 43.5 | 0.0196 | NR | CAD5121145.1 | 2664684 | g2997407 | i0 | 33.3 | 0.9 | 72 | 38 | 77.5 | 1 | 16 | 201 | 496 | 567 | CAD5121145.1 DgyrCDS9680 [Dimorphilus gyrociliatus] | diamond | 216 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28922209 | 28922209 | PRJNA1120060_P_NODE_1791808_length_281_cov_2.048077_g1773796_i0 | PRJNA1120060 | 1791808 | 281 | 2.048077 | 5.75509637 | Metazoa | 33208 | Annelida | Annelida | 55.1 | 2.33e-6 | NR | KAK2155292.1 | 53620 | g1773796 | i0 | 48.6 | 8.00711743772242 | 72 | 29 | 76.9 | 2 | 281 | 66 | 40 | 103 | KAK2155292.1 hypothetical protein LSH36_243g01045 [Paralvinella palmiformis] | diamond | 2250 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29626733 | 29626733 | PRJNA1120060_P_NODE_2894730_length_244_cov_0.900585_g2876641_i0 | PRJNA1120060 | 2894730 | 244 | 0.900585 | 2.1974274 | Helobdella robusta | 6412 | Annelida | Annelida | 40.8 | 0.0331 | NR | XP_009015770.1 | 6412 | g2876641 | i0 | 40.5 | 0.516393442622951 | 42 | 25 | 51.6 | 0 | 177 | 52 | 1 | 42 | XP_009015770.1 hypothetical protein HELRODRAFT_64381, partial [Helobdella robusta] | diamond | 126 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29679852 | 29679852 | PRJNA1120060_P_NODE_2362550_length_259_cov_1.258065_g2344489_i0 | PRJNA1120060 | 2362550 | 259 | 1.258065 | 3.25838835 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.0198 | NR | KAK2180180.1 | 27915 | g2344489 | i0 | 48.8 | 2.61776061776062 | 41 | 21 | 47.5 | 0 | 64 | 186 | 165 | 205 | KAK2180180.1 hypothetical protein NP493_454g04017 [Ridgeia piscesae] | diamond | 678 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30890960 | 30890960 | PRJNA1120060_P_NODE_2890474_length_244_cov_0.912281_g2872385_i0 | PRJNA1120060 | 2890474 | 244 | 0.912281 | 2.22596564 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 42.7 | 0.0398 | NR | KAI0230970.1 | 104711 | g2872385 | i0 | 47.5 | 0.491803278688525 | 40 | 21 | 49.2 | 0 | 219 | 100 | 453 | 492 | KAI0230970.1 hypothetical protein LSAT2_018656 [Lamellibrachia satsuma] | diamond | 120 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31142624 | 31142624 | PRJNA1120060_P_NODE_201055_length_468_cov_1.197468_g184589_i0 | PRJNA1120060 | 201055 | 468 | 1.197468 | 5.60415024 | Capitella teleta | 283909 | Annelida | Annelida | 44.7 | 0.0358 | NR | ELU16938.1 | 283909 | g184589 | i0 | 35.2 | 0.455128205128205 | 71 | 35 | 42.3 | 2 | 211 | 408 | 13 | 77 | ELU16938.1 hypothetical protein CAPTEDRAFT_188816 [Capitella teleta] | diamond | 213 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32187702 | 32187702 | PRJNA1120060_P_NODE_3328818_length_224_cov_4.211921_g3310706_i0 | PRJNA1120060 | 3328818 | 224 | 4.211921 | 9.43470304 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 47 | 9.06e-4 | NR | KAI0234444.1 | 104711 | g3310706 | i0 | 43.6 | 1.39285714285714 | 55 | 29 | 71 | 1 | 162 | 4 | 169 | 223 | KAI0234444.1 hypothetical protein LSAT2_015274, partial [Lamellibrachia satsuma] | diamond | 312 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32250368 | 32250368 | PRJNA1120060_P_NODE_1890658_length_277_cov_1.946078_g1872639_i0 | PRJNA1120060 | 1890658 | 277 | 1.946078 | 5.39063606 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 43.1 | 0.0413 | NR | KAK2159829.1 | 53620 | g1872639 | i0 | 38.1 | 0.682310469314079 | 63 | 36 | 68.2 | 1 | 254 | 66 | 1188 | 1247 | KAK2159829.1 hypothetical protein LSH36_145g04079 [Paralvinella palmiformis] | diamond | 189 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;