contig_metadata
17 rows where bioproject = "PRJNA315314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 381085 | 381085 | PRJNA315314_S_NODE_7081_length_303_cov_20.452555_g6760_i0 | PRJNA315314 | 7081 | 303 | 20.452555 | 61.97124165 | Chloeia sp. r EEE-2022 | 2907852 | Annelida | Annelida | 224 | 5.649999999999998e-54 | NTclustered | gi|2172937611|gb|OM135245.1| | 2907852 | g6760 | i0 | 80.602 | 100.293729372937 | 299 | 50 | 97 | 7 | 6 | 299 | 6699 | 6994 | Chloeia sp. r EEE-2022 voucher UCNSCB-6857 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 30389 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Chloeia | Chloeia sp. r EEE-2022 | |
| 4208252 | 4208252 | PRJNA315314_S_NODE_6144_length_325_cov_2625.854730_g5823_i0 | PRJNA315314 | 6144 | 325 | 2625.85473 | 8534.0278725 | Chloeia sp. r EEE-2022 | 2907852 | Annelida | Annelida | 283 | 9.95e-72 | NTclustered | gi|2172937611|gb|OM135245.1| | 2907852 | g5823 | i0 | 84.536 | 143.455384615385 | 291 | 39 | 88 | 6 | 6 | 291 | 6993 | 6704 | Chloeia sp. r EEE-2022 voucher UCNSCB-6857 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 46623 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Chloeia | Chloeia sp. r EEE-2022 | |
| 7443122 | 7443122 | PRJNA315314_S_NODE_11046_length_243_cov_19.387850_g10725_i0 | PRJNA315314 | 11046 | 243 | 19.38785 | 47.1124755 | root | 1 | Root_unresolved | Root_unresolved | 183 | 7.44e-42 | NTclustered | gi|18477293|emb|AJ310500.1| | 152467 | g10725 | i0 | 100 | 45.1851851851852 | 99 | 0 | 41 | 0 | 1 | 99 | 851 | 753 | Aeolosoma hemprichi partial 18S rRNA gene | blastn | 10980 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma hemprichi | |
| 8718012 | 8718012 | PRJNA315314_S_NODE_9227_length_266_cov_76.561181_g8906_i0 | PRJNA315314 | 9227 | 266 | 76.561181 | 203.65274146 | root | 1 | Root_unresolved | Root_unresolved | 481 | 2.62e-131 | NTclustered | gi|18477293|emb|AJ310500.1| | 152467 | g8906 | i0 | 100 | 98.7368421052632 | 260 | 0 | 98 | 0 | 1 | 260 | 1012 | 753 | Aeolosoma hemprichi partial 18S rRNA gene | blastn | 26264 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma hemprichi | |
| 9308640 | 9308640 | PRJNA315314_S_NODE_10948_length_244_cov_3490.153488_g10627_i0 | PRJNA315314 | 10948 | 244 | 3490.153488 | 8515.97451072 | Oligochaeta environmental sample | 333472 | Annelida | Annelida | 363 | 8.949999999999999e-96 | NTclustered | gi|68271334|gb|DQ086515.1| | 333472 | g10627 | i0 | 97.63 | 86.7377049180328 | 211 | 5 | 86 | 0 | 1 | 211 | 1 | 211 | Uncultured Oligochaeta sp. isolate Oligoc06 large subunit ribosomal RNA gene, partial sequence | blastn | 21164 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Oligochaeta environmental sample | ||||
| 13134470 | 13134470 | PRJNA315314_S_NODE_17691_length_196_cov_1.856287_g17370_i0 | PRJNA315314 | 17691 | 196 | 1.856287 | 3.63832252 | Protodrilus ciliatus | 47111 | Annelida | Annelida | 69.4 | 1.68e-7 | NTclustered | gi|172053649|gb|EU418873.1| | 47111 | g17370 | i0 | 97.5 | 19.4336734693878 | 40 | 1 | 20 | 0 | 155 | 194 | 2021 | 2060 | Protodrilus ciliatus 28S ribosomal RNA gene, partial sequence | blastn | 3809 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Protodrilus | Protodrilus ciliatus | ||
| 13818650 | 13818650 | PRJNA315314_S_NODE_13031_length_225_cov_10.979592_g12710_i0 | PRJNA315314 | 13031 | 225 | 10.979592 | 24.704082 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 143 | 1.15e-29 | NTclustered | gi|172053649|gb|EU418873.1| | 47111 | g12710 | i0 | 91.346 | 37.1155555555556 | 104 | 9 | 46 | 0 | 119 | 222 | 2306 | 2409 | Protodrilus ciliatus 28S ribosomal RNA gene, partial sequence | blastn | 8351 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Protodrilus | Protodrilus ciliatus | ||
| 18232344 | 18232344 | PRJNA315314_S_NODE_13555_length_221_cov_31.989583_g13234_i0 | PRJNA315314 | 13555 | 221 | 31.989583 | 70.69697843 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 385 | 1.6999999999999995e-102 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g13234 | i0 | 98.624 | 99.3619909502262 | 218 | 1 | 98 | 2 | 2 | 218 | 2864 | 2648 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 21959 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 21467134 | 21467134 | PRJNA315314_S_NODE_32197_length_150_cov_20.272727_g31876_i0 | PRJNA315314 | 32197 | 150 | 20.272727 | 30.4090905 | Aeolosoma | 55816 | Annelida | Annelida | 237 | 3.14e-58 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g31876 | i0 | 95.302 | 99.92 | 149 | 7 | 99 | 0 | 2 | 150 | 1632 | 1484 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14988 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 24017148 | 24017148 | PRJNA315314_S_NODE_23039_length_173_cov_18.513889_g22718_i0 | PRJNA315314 | 23039 | 173 | 18.513889 | 32.02902797 | Aeolosoma | 55816 | Annelida | Annelida | 246 | 6.2099999999999995e-61 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g22718 | i0 | 92.529 | 135.549132947977 | 174 | 10 | 100 | 3 | 1 | 173 | 2359 | 2188 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 23450 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 24607078 | 24607078 | PRJNA315314_S_NODE_32600_length_150_cov_1.487603_g32279_i0 | PRJNA315314 | 32600 | 150 | 1.487603 | 2.2314045 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 61.2 | 2.59e-9 | NR | KAK2168368.1 | 53620 | g32279 | i0 | 58.3 | 3.86 | 48 | 20 | 96 | 0 | 2 | 145 | 60 | 107 | KAK2168368.1 hypothetical protein LSH36_17g03080 [Paralvinella palmiformis] | diamond | 579 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 25291382 | 25291382 | PRJNA315314_S_NODE_15580_length_207_cov_8.662921_g15259_i0 | PRJNA315314 | 15580 | 207 | 8.662921 | 17.93224647 | Aeolosoma | 55816 | Annelida | Annelida | 311 | 2.71e-80 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g15259 | i0 | 93.72 | 97.3623188405797 | 207 | 13 | 100 | 0 | 1 | 207 | 56 | 262 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20154 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 26965239 | 26965239 | PRJNA315314_S_NODE_21462_length_179_cov_2.460000_g21141_i0 | PRJNA315314 | 21462 | 179 | 2.46 | 4.4034 | Metazoa | 33208 | Annelida | Annelida | 47.4 | 3.72e-4 | NR | CAH1776661.1 | 6347 | g21141 | i0 | 56.3 | 1.24022346368715 | 32 | 14 | 53.6 | 0 | 152 | 57 | 163 | 194 | CAH1776661.1 unnamed protein product [Owenia fusiformis] | diamond | 222 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27439796 | 27439796 | PRJNA315314_S_NODE_24203_length_170_cov_1.879433_g23882_i0 | PRJNA315314 | 24203 | 170 | 1.879433 | 3.1950361 | Metazoa | 33208 | Annelida | Annelida | 74.7 | 7.35e-14 | NR | XP_009019147.1 | 6412 | g23882 | i0 | 63.6 | 11.9294117647059 | 55 | 20 | 97.1 | 0 | 169 | 5 | 330 | 384 | XP_009019147.1 hypothetical protein HELRODRAFT_185682 [Helobdella robusta] | diamond | 2028 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29239289 | 29239289 | PRJNA315314_S_NODE_32389_length_150_cov_2.446281_g32068_i0 | PRJNA315314 | 32389 | 150 | 2.446281 | 3.6694215 | Metazoa | 33208 | Annelida | Annelida | 48.9 | 4.1e-5 | NR | XP_009012591.1 | 6412 | g32068 | i0 | 50 | 7.64 | 48 | 24 | 96 | 0 | 149 | 6 | 42 | 89 | XP_009012591.1 hypothetical protein HELRODRAFT_156470 [Helobdella robusta] | diamond | 1146 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31988372 | 31988372 | PRJNA315314_S_NODE_13678_length_221_cov_1.380208_g13357_i0 | PRJNA315314 | 13678 | 221 | 1.380208 | 3.05025968 | Metazoa | 33208 | Annelida | Annelida | 52.8 | 7.94e-6 | NR | CAH1781821.1 | 6347 | g13357 | i0 | 32.9 | 4.39819004524887 | 85 | 44 | 97.7 | 2 | 3 | 218 | 306 | 390 | CAH1781821.1 unnamed protein product [Owenia fusiformis] | diamond | 972 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32399929 | 32399929 | PRJNA315314_S_NODE_26699_length_163_cov_1.365672_g26378_i0 | PRJNA315314 | 26699 | 163 | 1.365672 | 2.22604536 | Metazoa | 33208 | Annelida | Annelida | 48.5 | 1.16e-4 | NR | XP_009014549.1 | 6412 | g26378 | i0 | 52.2 | 2.22699386503067 | 46 | 21 | 82.8 | 1 | 2 | 136 | 294 | 339 | XP_009014549.1 hypothetical protein HELRODRAFT_170481 [Helobdella robusta] | diamond | 363 | 48.5 | 1 | 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);;