contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10055560 | 10055560 | PRJNA556992_P_NODE_668468_length_253_cov_3.133333_g666279_i0 | PRJNA556992 | 668468 | 253 | 3.133333 | 7.92733249 | root | 1 | Root_unresolved | Root_unresolved | 166 | 2.57e-50 | NR | XP_009012174.1 | 6412 | g666279 | i0 | 97.6 | 27.8893280632411 | 84 | 2 | 99.6 | 0 | 252 | 1 | 60 | 143 | XP_009012174.1 hypothetical protein HELRODRAFT_92894, partial [Helobdella robusta] | diamond | 7056 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22206038 | 22206038 | PRJNA556992_P_NODE_455178_length_271_cov_2.191919_g452989_i0 | PRJNA556992 | 455178 | 271 | 2.191919 | 5.94010049 | Ridgeia piscesae | 27915 | Annelida | Annelida | 157 | 2.81e-43 | NR | KAK2159764.1 | 27915 | g452989 | i0 | 78.9 | 11.9557195571956 | 90 | 19 | 99.6 | 0 | 271 | 2 | 95 | 184 | KAK2159764.1 hypothetical protein NP493_1689g00002 [Ridgeia piscesae] | diamond | 3240 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27836491 | 27836491 | PRJNA556992_P_NODE_407104_length_276_cov_1.379310_g404915_i0 | PRJNA556992 | 407104 | 276 | 1.37931 | 3.8068956 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 46.6 | 0.00249 | NR | CAD5111750.1 | 2664684 | g404915 | i0 | 34.9 | 1.8695652173913 | 63 | 40 | 68.5 | 1 | 66 | 254 | 515 | 576 | CAD5111750.1 DgyrCDS1029 [Dimorphilus gyrociliatus] | diamond | 516 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27836777 | 27836777 | PRJNA556992_P_NODE_954984_length_235_cov_3.061728_g952794_i0 | PRJNA556992 | 954984 | 235 | 3.061728 | 7.1950608 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 47.4 | 8.03e-4 | NR | KAK2145522.1 | 53620 | g952794 | i0 | 42 | 0.880851063829787 | 69 | 34 | 80.4 | 3 | 41 | 229 | 270 | 338 | KAK2145522.1 hypothetical protein LSH36_676g00014 [Paralvinella palmiformis] | diamond | 207 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28956303 | 28956303 | PRJNA556992_P_NODE_523088_length_265_cov_2.276042_g520899_i0 | PRJNA556992 | 523088 | 265 | 2.276042 | 6.0315113 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 3.83e-4 | NR | XP_009025746.1 | 6412 | g520899 | i0 | 69 | 10.6528301886792 | 29 | 9 | 32.8 | 0 | 177 | 263 | 1 | 29 | XP_009025746.1 hypothetical protein HELRODRAFT_185092 [Helobdella robusta] | diamond | 2823 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29415290 | 29415290 | PRJNA556992_P_NODE_600329_length_259_cov_1.408602_g598140_i0 | PRJNA556992 | 600329 | 259 | 1.408602 | 3.64827918 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 67.8 | 7.21e-11 | NR | CAD5126586.1 | 2664684 | g598140 | i0 | 45.2 | 0.845559845559846 | 73 | 38 | 84.6 | 1 | 258 | 40 | 1479 | 1549 | CAD5126586.1 DgyrCDS14676 [Dimorphilus gyrociliatus] | diamond | 219 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29998241 | 29998241 | PRJNA556992_P_NODE_471231_length_270_cov_1.233503_g469042_i0 | PRJNA556992 | 471231 | 270 | 1.233503 | 3.3304581 | Metazoa | 33208 | Annelida | Annelida | 85.5 | 6.09e-18 | NR | KAK2185374.1 | 27915 | g469042 | i0 | 45 | 7.05555555555556 | 80 | 44 | 88.9 | 0 | 24 | 263 | 37 | 116 | KAK2185374.1 hypothetical protein NP493_239g09004 [Ridgeia piscesae] | diamond | 1905 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30110355 | 30110355 | PRJNA556992_P_NODE_965312_length_234_cov_2.850932_g963122_i0 | PRJNA556992 | 965312 | 234 | 2.850932 | 6.67118088 | Owenia fusiformis | 6347 | Annelida | Annelida | 54.3 | 2.72e-6 | NR | CAH1790518.1 | 6347 | g963122 | i0 | 41.4 | 0.897435897435897 | 70 | 34 | 89.7 | 2 | 23 | 232 | 12 | 74 | CAH1790518.1 unnamed protein product [Owenia fusiformis] | diamond | 210 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30300391 | 30300391 | PRJNA556992_P_NODE_943692_length_236_cov_3.613497_g941502_i0 | PRJNA556992 | 943692 | 236 | 3.613497 | 8.52785292 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 97.4 | 4.77e-22 | NR | KAK2143312.1 | 53620 | g941502 | i0 | 58.4 | 0.978813559322034 | 77 | 32 | 97.9 | 0 | 232 | 2 | 118 | 194 | KAK2143312.1 hypothetical protein LSH36_855g01173 [Paralvinella palmiformis] | diamond | 231 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30314544 | 30314544 | PRJNA556992_P_NODE_283092_length_292_cov_2.063927_g280903_i0 | PRJNA556992 | 283092 | 292 | 2.063927 | 6.02666684 | Annelida | 6340 | Annelida | Annelida | 44.3 | 0.019 | NR | XBW67467.1 | 208440 | g280903 | i0 | 94.1 | 1.15068493150685 | 17 | 1 | 17.5 | 0 | 208 | 258 | 6 | 22 | XBW67467.1 Vasa1, partial [Enchytraeus coronatus] | diamond | 336 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus coronatus | |
| 30963315 | 30963315 | PRJNA556992_P_NODE_453434_length_271_cov_2.777778_g451245_i0 | PRJNA556992 | 453434 | 271 | 2.777778 | 7.52777838 | Helobdella robusta | 6412 | Annelida | Annelida | 48.5 | 3.64e-4 | NR | XP_009021949.1 | 6412 | g451245 | i0 | 47.5 | 1.7380073800738 | 40 | 21 | 44.3 | 0 | 120 | 1 | 156 | 195 | XP_009021949.1 hypothetical protein HELRODRAFT_185780 [Helobdella robusta] | diamond | 471 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31247552 | 31247552 | PRJNA556992_P_NODE_422395_length_274_cov_2.587065_g420206_i0 | PRJNA556992 | 422395 | 274 | 2.587065 | 7.0885581 | Ridgeia piscesae | 27915 | Annelida | Annelida | 47 | 0.0016 | NR | KAK2182365.1 | 27915 | g420206 | i0 | 50 | 2.71532846715328 | 46 | 22 | 50.4 | 1 | 138 | 1 | 127 | 171 | KAK2182365.1 hypothetical protein NP493_357g04049 [Ridgeia piscesae] | diamond | 744 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31989385 | 31989385 | PRJNA556992_P_NODE_1100158_length_212_cov_11.251799_g1097967_i0 | PRJNA556992 | 1100158 | 212 | 11.251799 | 23.85381388 | Metazoa | 33208 | Annelida | Annelida | 60.1 | 1.9e-8 | NR | KAK2166678.1 | 27915 | g1097967 | i0 | 44.4 | 4.61320754716981 | 63 | 34 | 87.7 | 1 | 3 | 188 | 262 | 324 | KAK2166678.1 hypothetical protein NP493_1310g00031 [Ridgeia piscesae] | diamond | 978 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32211071 | 32211071 | PRJNA556992_P_NODE_884058_length_241_cov_4.380952_g881868_i0 | PRJNA556992 | 884058 | 241 | 4.380952 | 10.55809432 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 4.11e-6 | NR | KAK2175535.1 | 27915 | g881868 | i0 | 38.9 | 2.68879668049793 | 54 | 33 | 67.2 | 0 | 16 | 177 | 323 | 376 | KAK2175535.1 hypothetical protein NP493_723g00003 [Ridgeia piscesae] | diamond | 648 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32576482 | 32576482 | PRJNA556992_P_NODE_566419_length_261_cov_4.265957_g564230_i0 | PRJNA556992 | 566419 | 261 | 4.265957 | 11.13414777 | Capitella teleta | 283909 | Annelida | Annelida | 48.9 | 2.78e-4 | NR | ELU03225.1 | 283909 | g564230 | i0 | 62.5 | 0.367816091954023 | 32 | 12 | 36.8 | 0 | 157 | 62 | 4 | 35 | ELU03225.1 hypothetical protein CAPTEDRAFT_162057 [Capitella teleta] | diamond | 96 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32622024 | 32622024 | PRJNA556992_P_NODE_730760_length_249_cov_3.937500_g728571_i0 | PRJNA556992 | 730760 | 249 | 3.9375 | 9.804375 | Metazoa | 33208 | Annelida | Annelida | 70.1 | 7.25e-12 | NR | KAK2156536.1 | 27915 | g728571 | i0 | 50.9 | 6.31325301204819 | 57 | 28 | 68.7 | 0 | 77 | 247 | 261 | 317 | KAK2156536.1 hypothetical protein NP493_1944g00015 [Ridgeia piscesae] | diamond | 1572 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;