contig_metadata
12 rows where bioproject = "PRJEB81463", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3966602 | 3966602 | PRJEB81463_P_NODE_23204_length_249_cov_0.886364_g22932_i0 | PRJEB81463 | 23204 | 249 | 0.886364 | 2.20704636 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 3.74e-5 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g22932 | i0 | 94.872 | 0.815261044176707 | 39 | 2 | 16 | 0 | 152 | 190 | 1675013 | 1674975 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 203 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6518790 | 6518790 | PRJEB81463_P_NODE_28586_length_240_cov_3.209581_g28314_i0 | PRJEB81463 | 28586 | 240 | 3.209581 | 7.7029944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 1.04e-33 | NR | XP_009015247.1 | 6412 | g28314 | i0 | 78.9 | 32.0375 | 76 | 16 | 95 | 0 | 11 | 238 | 574 | 649 | XP_009015247.1 hypothetical protein HELRODRAFT_105890 [Helobdella robusta] | diamond | 7689 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13750817 | 13750817 | PRJEB81463_P_NODE_6371_length_397_cov_1.444444_g6099_i0 | PRJEB81463 | 6371 | 397 | 1.444444 | 5.73444268 | Metazoa | 33208 | Annelida | Annelida | 130 | 1.88e-35 | NR | CAH1775043.1 | 6347 | g6099 | i0 | 51.2 | 6.28715365239295 | 121 | 48 | 86.9 | 3 | 392 | 48 | 33 | 148 | CAH1775043.1 unnamed protein product [Owenia fusiformis] | diamond | 2496 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 16717434 | 16717434 | PRJEB81463_P_NODE_794_length_1106_cov_42.225557_g620_i0 | PRJEB81463 | 794 | 1106 | 42.225557 | 467.01466042 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 57.8 | 3.35e-5 | NR | KAK2156517.1 | 53620 | g620 | i0 | 49.1 | 0.154611211573237 | 57 | 25 | 15.2 | 3 | 556 | 723 | 220 | 273 | KAK2156517.1 hypothetical protein LSH36_211g02023 [Paralvinella palmiformis] | diamond | 171 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 16717450 | 16717450 | PRJEB81463_P_NODE_9034_length_335_cov_1.190840_g8762_i0 | PRJEB81463 | 9034 | 335 | 1.19084 | 3.989314 | Metazoa | 33208 | Annelida | Annelida | 147 | 1.8799999999999998e-38 | NR | KAK2174015.1 | 27915 | g8762 | i0 | 64 | 33.734328358209 | 111 | 39 | 99.4 | 1 | 2 | 334 | 390 | 499 | KAK2174015.1 hypothetical protein NP493_835g00021 [Ridgeia piscesae] | diamond | 11301 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 17992254 | 17992254 | PRJEB81463_P_NODE_9115_length_333_cov_2.242308_g8843_i0 | PRJEB81463 | 9115 | 333 | 2.242308 | 7.46688564 | Annelida | 6340 | Annelida | Annelida | 140 | 1.6399999999999999e-40 | NR | ABW90363.1 | 6446 | g8843 | i0 | 67.3 | 23.981981981982 | 101 | 33 | 91 | 0 | 26 | 328 | 5 | 105 | ABW90363.1 putative ribosomal protein L31 [Sipunculus nudus] | diamond | 7986 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 24366327 | 24366327 | PRJEB81463_P_NODE_24960_length_246_cov_1.236994_g24688_i0 | PRJEB81463 | 24960 | 246 | 1.236994 | 3.04300524 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 67.6 | 7.94e-7 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g24688 | i0 | 91.667 | 18.1626016260163 | 48 | 4 | 20 | 0 | 68 | 115 | 7512832 | 7512785 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 4468 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27318906 | 27318906 | PRJEB81463_P_NODE_20863_length_252_cov_0.871508_g20591_i0 | PRJEB81463 | 20863 | 252 | 0.871508 | 2.19620016 | Spirobranchus lamarcki | 2082999 | Annelida | Annelida | 93.6 | 5.4e-21 | NR | ADB11399.1 | 2082999 | g20591 | i0 | 59.4 | 0.821428571428571 | 69 | 28 | 82.1 | 0 | 46 | 252 | 9 | 77 | ADB11399.1 bacterial endonuclease I-like protein, partial [Spirobranchus lamarcki] | diamond | 207 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Spirobranchus | Spirobranchus lamarcki | |
| 28543131 | 28543131 | PRJEB81463_P_NODE_17947_length_262_cov_3.010582_g17675_i0 | PRJEB81463 | 17947 | 262 | 3.010582 | 7.88772484 | Metazoa | 33208 | Annelida | Annelida | 54.3 | 1.28e-6 | NR | ABW90355.1 | 6446 | g17675 | i0 | 62.8 | 4.33969465648855 | 43 | 16 | 49.2 | 0 | 129 | 1 | 38 | 80 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 1137 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 29300711 | 29300711 | PRJEB81463_P_NODE_26289_length_244_cov_1.824561_g26017_i0 | PRJEB81463 | 26289 | 244 | 1.824561 | 4.45192884 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 2.18e-26 | NR | ELT93316.1 | 283909 | g26017 | i0 | 69.3 | 2.80327868852459 | 75 | 22 | 92.2 | 1 | 238 | 14 | 38 | 111 | ELT93316.1 hypothetical protein CAPTEDRAFT_125179 [Capitella teleta] | diamond | 684 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29332279 | 29332279 | PRJEB81463_P_NODE_7029_length_378_cov_1.655738_g6757_i0 | PRJEB81463 | 7029 | 378 | 1.655738 | 6.25868964 | Opisthokonta | 33154 | Annelida | Annelida | 92.4 | 2.95e-21 | NR | CAH1781962.1 | 6347 | g6757 | i0 | 37.4 | 3.93650793650794 | 123 | 76 | 96.8 | 1 | 3 | 368 | 3 | 125 | CAH1781962.1 unnamed protein product [Owenia fusiformis] | diamond | 1488 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31670396 | 31670396 | PRJEB81463_P_NODE_10317_length_314_cov_2.012448_g10045_i0 | PRJEB81463 | 10317 | 314 | 2.012448 | 6.31908672 | Metazoa | 33208 | Annelida | Annelida | 143 | 3.4299999999999995e-37 | NR | XP_009027051.1 | 6412 | g10045 | i0 | 66.3 | 11.6178343949045 | 98 | 32 | 93.6 | 1 | 298 | 5 | 268 | 364 | XP_009027051.1 hypothetical protein HELRODRAFT_102919 [Helobdella robusta] | diamond | 3648 | 144 | 0.993055555555556 | 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);;