contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2500377 | 2500377 | PRJNA812715_P_NODE_27562_length_591_cov_2.063707_g25814_i0 | PRJNA812715 | 27562 | 591 | 2.063707 | 12.19650837 | Opisthokonta | 33154 | Annelida | Annelida | 125 | 6.0399999999999995e-30 | NR | KAK2191890.1 | 27915 | g25814 | i0 | 50.4 | 6.42131979695431 | 141 | 55 | 66.5 | 2 | 159 | 551 | 317 | 452 | KAK2191890.1 hypothetical protein NP493_43g03001 [Ridgeia piscesae] | diamond | 3795 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27749545 | 27749545 | PRJNA812715_P_NODE_61264_length_334_cov_1.475096_g59465_i0 | PRJNA812715 | 61264 | 334 | 1.475096 | 4.92682064 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 105 | 1.59e-25 | NR | KAK2143286.1 | 53620 | g59465 | i0 | 53.1 | 0.727544910179641 | 81 | 38 | 72.8 | 0 | 23 | 265 | 138 | 218 | KAK2143286.1 hypothetical protein LSH36_857g00134 [Paralvinella palmiformis] | diamond | 243 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27884329 | 27884329 | PRJNA812715_P_NODE_43065_length_424_cov_1.752137_g41270_i0 | PRJNA812715 | 43065 | 424 | 1.752137 | 7.42906088 | Metazoa | 33208 | Annelida | Annelida | 170 | 1.34e-49 | NR | CAH1786460.1 | 6347 | g41270 | i0 | 61.8 | 33.5306603773585 | 144 | 50 | 99.1 | 2 | 5 | 424 | 80 | 222 | CAH1786460.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 14217 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28326230 | 28326230 | PRJNA812715_P_NODE_49086_length_387_cov_2.697452_g47289_i0 | PRJNA812715 | 49086 | 387 | 2.697452 | 10.43913924 | Metazoa | 33208 | Annelida | Annelida | 79 | 3.8e-15 | NR | ADV57678.1 | 6396 | g47289 | i0 | 37 | 2.62790697674419 | 127 | 72 | 95.3 | 3 | 386 | 18 | 13 | 135 | ADV57678.1 glutathione S-transferase [Eisenia fetida] | diamond | 1017 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 28444100 | 28444100 | PRJNA812715_P_NODE_92486_length_264_cov_3.157068_g90685_i0 | PRJNA812715 | 92486 | 264 | 3.157068 | 8.33465952 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 82 | 7.28e-16 | NR | CAD5123944.1 | 2664684 | g90685 | i0 | 52.1 | 8.48863636363636 | 71 | 34 | 80.7 | 0 | 18 | 230 | 760 | 830 | CAD5123944.1 DgyrCDS12251 [Dimorphilus gyrociliatus] | diamond | 2241 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29738213 | 29738213 | PRJNA812715_P_NODE_81990_length_281_cov_1.480769_g80190_i0 | PRJNA812715 | 81990 | 281 | 1.480769 | 4.16096089 | Owenia fusiformis | 6347 | Annelida | Annelida | 72.8 | 3.17e-13 | NR | CAH1790910.1 | 6347 | g80190 | i0 | 41.9 | 0.918149466192171 | 86 | 50 | 91.8 | 0 | 9 | 266 | 114 | 199 | CAH1790910.1 unnamed protein product [Owenia fusiformis] | diamond | 258 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31444757 | 31444757 | PRJNA812715_P_NODE_109916_length_247_cov_0.885057_g108115_i0 | PRJNA812715 | 109916 | 247 | 0.885057 | 2.18609079 | Ridgeia piscesae | 27915 | Annelida | Annelida | 43.9 | 0.0156 | NR | KAK2185544.1 | 27915 | g108115 | i0 | 32.9 | 4.73684210526316 | 70 | 42 | 85 | 2 | 17 | 226 | 380 | 444 | KAK2185544.1 hypothetical protein NP493_231g03069 [Ridgeia piscesae] | diamond | 1170 | 43.9 | 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);;