contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9848963 | 9848963 | PRJNA940501_S_NODE_356588_length_156_cov_1.663717_g355770_i0 | PRJNA940501 | 356588 | 156 | 1.663717 | 2.59539852 | root | 1 | Root_unresolved | Root_unresolved | 102 | 1.34e-23 | NR | XP_009028259.1 | 6412 | g355770 | i0 | 84.3 | 27.4423076923077 | 51 | 8 | 98.1 | 0 | 3 | 155 | 291 | 341 | XP_009028259.1 hypothetical protein HELRODRAFT_103347 [Helobdella robusta] | diamond | 4281 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22598889 | 22598889 | PRJNA940501_S_NODE_71078_length_260_cov_3.741935_g70260_i0 | PRJNA940501 | 71078 | 260 | 3.741935 | 9.729031 | Capitella teleta | 283909 | Annelida | Annelida | 73.2 | 1.03e-13 | NR | ELU07708.1 | 283909 | g70260 | i0 | 74.5 | 3.18461538461538 | 47 | 12 | 54.2 | 0 | 3 | 143 | 143 | 189 | ELU07708.1 hypothetical protein CAPTEDRAFT_151035 [Capitella teleta] | diamond | 828 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27569126 | 27569126 | PRJNA940501_S_NODE_306224_length_166_cov_1.243902_g305406_i0 | PRJNA940501 | 306224 | 166 | 1.243902 | 2.06487732 | Metazoa | 33208 | Annelida | Annelida | 46.2 | 7.56e-4 | NR | XP_009026649.1 | 6412 | g305406 | i0 | 44.2 | 5.74698795180723 | 52 | 28 | 92.2 | 1 | 12 | 164 | 330 | 381 | XP_009026649.1 hypothetical protein HELRODRAFT_193600 [Helobdella robusta] | diamond | 954 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28011422 | 28011422 | PRJNA940501_S_NODE_193385_length_195_cov_1.546053_g192567_i0 | PRJNA940501 | 193385 | 195 | 1.546053 | 3.01480335 | Annelida | 6340 | Annelida | Annelida | 103 | 4.85e-24 | NR | KAK2186173.1 | 27915 | g192567 | i0 | 78.9 | 13.9692307692308 | 57 | 12 | 87.7 | 0 | 3 | 173 | 426 | 482 | KAK2186173.1 hypothetical protein NP493_212g07026 [Ridgeia piscesae] | diamond | 2724 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28611183 | 28611183 | PRJNA940501_S_NODE_65367_length_266_cov_2.107623_g64549_i0 | PRJNA940501 | 65367 | 266 | 2.107623 | 5.60627718 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67 | 1.35e-10 | NR | KAK2185879.1 | 27915 | g64549 | i0 | 57.1 | 2.58270676691729 | 49 | 21 | 55.3 | 0 | 1 | 147 | 394 | 442 | KAK2185879.1 hypothetical protein NP493_220g03039 [Ridgeia piscesae] | diamond | 687 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29368966 | 29368966 | PRJNA940501_S_NODE_397809_length_150_cov_1.317757_g396991_i0 | PRJNA940501 | 397809 | 150 | 1.317757 | 1.9766355 | root | 1 | Root_unresolved | Root_unresolved | 56.2 | 1.84e-7 | NR | CAH1783163.1 | 6347 | g396991 | i0 | 83.9 | 7.52 | 31 | 5 | 62 | 0 | 1 | 93 | 413 | 443 | CAH1783163.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1128 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30593793 | 30593793 | PRJNA940501_S_NODE_224093_length_186_cov_0.930070_g223275_i0 | PRJNA940501 | 224093 | 186 | 0.93007 | 1.7299302 | Ridgeia piscesae | 27915 | Annelida | Annelida | 41.6 | 0.0457 | NR | KAK2193290.1 | 27915 | g223275 | i0 | 52.8 | 0.580645161290323 | 36 | 15 | 58.1 | 1 | 132 | 25 | 189 | 222 | KAK2193290.1 hypothetical protein NP493_16g11006 [Ridgeia piscesae] | diamond | 108 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30973212 | 30973212 | PRJNA940501_S_NODE_351794_length_157_cov_1.631579_g350976_i0 | PRJNA940501 | 351794 | 157 | 1.631579 | 2.56157903 | Owenia fusiformis | 6347 | Annelida | Annelida | 44.3 | 0.00335 | NR | CAH1793439.1 | 6347 | g350976 | i0 | 48.6 | 0.707006369426752 | 37 | 19 | 70.7 | 0 | 124 | 14 | 207 | 243 | CAH1793439.1 unnamed protein product [Owenia fusiformis] | diamond | 111 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31517517 | 31517517 | PRJNA940501_S_NODE_361936_length_155_cov_1.741071_g361118_i0 | PRJNA940501 | 361936 | 155 | 1.741071 | 2.69866005 | Annelida | 6340 | Annelida | Annelida | 51.6 | 8.3e-6 | NR | KAK2192639.1 | 27915 | g361118 | i0 | 43.8 | 11.4967741935484 | 48 | 27 | 92.9 | 0 | 7 | 150 | 301 | 348 | KAK2192639.1 hypothetical protein NP493_27g03000 [Ridgeia piscesae] | diamond | 1782 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32459778 | 32459778 | PRJNA940501_S_NODE_377979_length_152_cov_4.311927_g377161_i0 | PRJNA940501 | 377979 | 152 | 4.311927 | 6.55412904 | Owenia fusiformis | 6347 | Annelida | Annelida | 58.2 | 3.88e-8 | NR | CAH1776626.1 | 6347 | g377161 | i0 | 62.5 | 0.947368421052632 | 48 | 18 | 94.7 | 0 | 149 | 6 | 978 | 1025 | CAH1776626.1 unnamed protein product [Owenia fusiformis] | diamond | 144 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32655550 | 32655550 | PRJNA940501_S_NODE_47500_length_288_cov_4.444898_g46682_i0 | PRJNA940501 | 47500 | 288 | 4.444898 | 12.80130624 | Opisthokonta | 33154 | Annelida | Annelida | 99 | 9.35e-24 | NR | KAK2168654.1 | 53620 | g46682 | i0 | 63.9 | 8.03125 | 83 | 30 | 86.5 | 0 | 38 | 286 | 41 | 123 | KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis] | diamond | 2313 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32743669 | 32743669 | PRJNA940501_S_NODE_32540_length_317_cov_10.521898_g31722_i0 | PRJNA940501 | 32540 | 317 | 10.521898 | 33.35441666 | Helobdella robusta | 6412 | Annelida | Annelida | 108 | 3.2499999999999998e-28 | NR | XP_009025143.1 | 6412 | g31722 | i0 | 58.9 | 0.899053627760252 | 95 | 39 | 89.9 | 0 | 299 | 15 | 7 | 101 | XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta] | diamond | 285 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32869471 | 32869471 | PRJNA940501_S_NODE_390680_length_151_cov_0.870370_g389862_i0 | PRJNA940501 | 390680 | 151 | 0.87037 | 1.3142587 | Capitella teleta | 283909 | Annelida | Annelida | 40.8 | 0.00795 | NR | ELT98715.1 | 283909 | g389862 | i0 | 45.2 | 1.2317880794702 | 31 | 17 | 61.6 | 0 | 15 | 107 | 2 | 32 | ELT98715.1 hypothetical protein CAPTEDRAFT_61794, partial [Capitella teleta] | diamond | 186 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;