contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1054405 | 1054405 | PRJNA168635_P_NODE_5121_length_373_cov_54.469136_g4717_i0 | PRJNA168635 | 5121 | 373 | 54.469136 | 203.16987728 | Naididae | 2109251 | Annelida | Annelida | 592 | 1.6899999999999999e-164 | NTclustered | gi|1494622622|gb|MK076421.1| | 74742 | g4717 | i0 | 95.442 | 100.064343163539 | 373 | 14 | 99 | 1 | 4 | 373 | 2077 | 2449 | Paranais litoralis isolate PARliHBMD large subunit ribosomal RNA gene, partial sequence | blastn | 37324 | 597 | 0.991624790619765 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Paranais | Paranais litoralis | |
| 1639346 | 1639346 | PRJNA168635_P_NODE_27642_length_166_cov_2.940171_g27226_i0 | PRJNA168635 | 27642 | 166 | 2.940171 | 4.88068386 | Nais communis | 188228 | Annelida | Annelida | 294 | 2.09e-75 | NTclustered | gi|285029430|gb|GQ355448.1| | 188228 | g27226 | i0 | 98.795 | 10.0240963855422 | 166 | 1 | 100 | 1 | 1 | 166 | 380 | 544 | Nais communis 28S ribosomal RNA gene, partial sequence | blastn | 1664 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis | |
| 1639568 | 1639568 | PRJNA168635_P_NODE_8002_length_298_cov_120.148594_g7588_i0 | PRJNA168635 | 8002 | 298 | 120.148594 | 358.04281012 | Chloeia sp. r EEE-2022 | 2907852 | Annelida | Annelida | 265 | 3.2699999999999997e-66 | NTclustered | gi|2172937611|gb|OM135245.1| | 2907852 | g7588 | i0 | 82.943 | 160.137583892617 | 299 | 45 | 99 | 6 | 5 | 298 | 7004 | 6707 | 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 | 47721 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Chloeia | Chloeia sp. r EEE-2022 | |
| 2914938 | 2914938 | PRJNA168635_P_NODE_11283_length_244_cov_2.128205_g10868_i0 | PRJNA168635 | 11283 | 244 | 2.128205 | 5.1928202 | Slavina appendiculata | 188233 | Annelida | Annelida | 357 | 4.16e-94 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g10868 | i0 | 94.783 | 0.942622950819672 | 230 | 10 | 94 | 2 | 1 | 230 | 4925 | 4698 | Slavina appendiculata mitochondrion, partial genome | blastn | 230 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 5467621 | 5467621 | PRJNA168635_P_NODE_14165_length_214_cov_4.903030_g13749_i0 | PRJNA168635 | 14165 | 214 | 4.90303 | 10.4924842 | Pisione sp. YZ-2018 | 2153337 | Annelida | Annelida | 143 | 1.09e-29 | NTclustered | gi|1376177442|gb|KY753844.1| | 2153337 | g13749 | i0 | 90.09 | 52.0467289719626 | 111 | 9 | 51 | 2 | 5 | 114 | 4935 | 5044 | Pisione sp. YZ-2018 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11138 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Pisionidae | Pisione | Pisione sp. YZ-2018 | |
| 6742126 | 6742126 | PRJNA168635_P_NODE_18786_length_186_cov_6.007299_g18370_i0 | PRJNA168635 | 18786 | 186 | 6.007299 | 11.17357614 | Scalibregma inflatum | 195275 | Annelida | Annelida | 200 | 5.369999999999999e-47 | NTclustered | gi|111559325|gb|DQ790060.1| | 195275 | g18370 | i0 | 86.096 | 92.5161290322581 | 187 | 24 | 100 | 2 | 1 | 186 | 3100 | 2915 | Scalibregma inflatum 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17208 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Scalibregmatidae | Scalibregma | Scalibregma inflatum | ||
| 7432095 | 7432095 | PRJNA168635_P_NODE_1566_length_636_cov_32.085179_g1218_i0 | PRJNA168635 | 1566 | 636 | 32.085179 | 204.06173844 | Naididae | 2109251 | Annelida | Annelida | 536 | 1.4299999999999995e-147 | NTclustered | gi|1494622622|gb|MK076421.1| | 74742 | g1218 | i0 | 97.452 | 128.205974842767 | 314 | 8 | 98 | 0 | 1 | 314 | 1792 | 2105 | Paranais litoralis isolate PARliHBMD large subunit ribosomal RNA gene, partial sequence | blastn | 81539 | 536 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Paranais | Paranais litoralis | |
| 9292370 | 9292370 | PRJNA168635_P_NODE_12208_length_233_cov_5.494565_g11792_i0 | PRJNA168635 | 12208 | 233 | 5.494565 | 12.80233645 | Slavina appendiculata | 188233 | Annelida | Annelida | 381 | 2.3399999999999995e-101 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g11792 | i0 | 96.552 | 74.0944206008584 | 232 | 5 | 98 | 2 | 4 | 232 | 4599 | 4368 | Slavina appendiculata mitochondrion, partial genome | blastn | 17264 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 9292824 | 9292824 | PRJNA168635_P_NODE_7168_length_315_cov_303.954887_g6756_i0 | PRJNA168635 | 7168 | 315 | 303.954887 | 957.45789405 | Nais communis | 188228 | Annelida | Annelida | 374 | 5.539999999999998e-99 | NTclustered | gi|1494622621|gb|MK076420.1| | 188228 | g6756 | i0 | 96.46 | 143.469841269841 | 226 | 8 | 72 | 0 | 1 | 226 | 3394 | 3619 | Nais communis isolate NAIco_IUCB large subunit ribosomal RNA gene, partial sequence | blastn | 45193 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis | |
| 9982394 | 9982394 | PRJNA168635_P_NODE_33788_length_156_cov_23.102804_g33372_i0 | PRJNA168635 | 33788 | 156 | 23.102804 | 36.04037424 | Naididae | 2109251 | Annelida | Annelida | 285 | 1.16e-72 | NTclustered | gi|2889522442|gb|PP139216.1| | 41694 | g33372 | i0 | 100 | 98.7179487179487 | 154 | 0 | 99 | 0 | 3 | 156 | 403 | 556 | Stylaria lacustris voucher CE483 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 | 15400 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria lacustris | |
| 10568576 | 10568576 | PRJNA168635_P_NODE_24769_length_169_cov_18.641667_g24353_i0 | PRJNA168635 | 24769 | 169 | 18.641667 | 31.50441723 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 255 | 1e-63 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g24353 | i0 | 94.048 | 117.89349112426 | 168 | 10 | 99 | 0 | 2 | 169 | 1664211 | 1664378 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 19924 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10568602 | 10568602 | PRJNA168635_P_NODE_26449_length_168_cov_0.873950_g26033_i0 | PRJNA168635 | 26449 | 168 | 0.87395 | 1.468236 | Tubificoides heterochaetus | 449241 | Annelida | Annelida | 239 | 1.01e-58 | NTclustered | gi|306850244|gb|HM460048.1| | 449241 | g26033 | i0 | 92.857 | 96.9285714285714 | 168 | 6 | 98 | 5 | 4 | 168 | 208 | 44 | Tubificoides heterochaetus isolate CE2266 28S ribosomal RNA gene, partial sequence | blastn | 16284 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Tubificoides | Tubificoides heterochaetus | |
| 10568837 | 10568837 | PRJNA168635_P_NODE_8389_length_291_cov_33.173554_g7974_i0 | PRJNA168635 | 8389 | 291 | 33.173554 | 96.53504214 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 466 | 8.12e-127 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g7974 | i0 | 95.548 | 101.570446735395 | 292 | 12 | 100 | 1 | 1 | 291 | 4 | 295 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 29557 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 13118245 | 13118245 | PRJNA168635_P_NODE_20851_length_179_cov_4.738462_g20435_i0 | PRJNA168635 | 20851 | 179 | 4.738462 | 8.48184698 | Nais communis/variabilis complex sp. A2 | 1138461 | Annelida | Annelida | 322 | 1.05e-83 | NTclustered | gi|1228304300|gb|KY633289.1| | 1138461 | g20435 | i0 | 100 | 80.4357541899441 | 174 | 0 | 97 | 0 | 1 | 174 | 174 | 1 | Nais communis/variabilis complex sp. A2 voucher SMNH115916 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 14398 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis/variabilis complex sp. A2 | |
| 13118546 | 13118546 | PRJNA168635_P_NODE_7411_length_310_cov_119.494253_g6999_i0 | PRJNA168635 | 7411 | 310 | 119.494253 | 370.4321843 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 446 | 1.14e-120 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g6999 | i0 | 92.652 | 66.2967741935484 | 313 | 17 | 100 | 6 | 1 | 310 | 3539 | 3230 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 20552 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 13807742 | 13807742 | PRJNA168635_P_NODE_3991_length_419_cov_111.710811_g3590_i0 | PRJNA168635 | 3991 | 419 | 111.710811 | 468.06829809 | Aeolosoma | 55816 | Annelida | Annelida | 747 | 0 | NTclustered | gi|18477293|emb|AJ310500.1| | 152467 | g3590 | i0 | 99.274 | 100.064439140811 | 413 | 3 | 99 | 0 | 7 | 419 | 623 | 1035 | Aeolosoma hemprichi partial 18S rRNA gene | blastn | 41927 | 752 | 0.993351063829787 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma hemprichi | |
| 15081689 | 15081689 | PRJNA168635_P_NODE_10132_length_260_cov_4.672986_g9717_i0 | PRJNA168635 | 10132 | 260 | 4.672986 | 12.1497636 | Metazoa | 33208 | Annelida | Annelida | 171 | 6.27e-38 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g9717 | i0 | 82.439 | 63.5384615384615 | 205 | 26 | 76 | 6 | 4 | 200 | 216 | 14 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 16520 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 18216375 | 18216375 | PRJNA168635_P_NODE_35415_length_151_cov_14.098039_g34999_i0 | PRJNA168635 | 35415 | 151 | 14.098039 | 21.28803889 | Slavina appendiculata | 188233 | Annelida | Annelida | 220 | 3.19e-53 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g34999 | i0 | 93.289 | 3.25165562913907 | 149 | 10 | 99 | 0 | 1 | 149 | 5316 | 5168 | Slavina appendiculata mitochondrion, partial genome | blastn | 491 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 18905773 | 18905773 | PRJNA168635_P_NODE_33575_length_157_cov_4.259259_g33159_i0 | PRJNA168635 | 33575 | 157 | 4.259259 | 6.68703663 | Nais | 74730 | Annelida | Annelida | 281 | 1.52e-71 | NTclustered | gi|395484267|gb|JQ425011.1| | 1138461 | g33159 | i0 | 99.355 | 98.1528662420382 | 155 | 1 | 99 | 0 | 3 | 157 | 457 | 303 | Nais communis/variabilis complex sp. A2 isolate CE3787 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 15410 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis/variabilis complex sp. A2 | |
| 18905828 | 18905828 | PRJNA168635_P_NODE_7955_length_299_cov_42.340000_g7542_i0 | PRJNA168635 | 7955 | 299 | 42.34 | 126.5966 | Aeolosoma | 55816 | Annelida | Annelida | 464 | 3.0099999999999996e-126 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g7542 | i0 | 94.684 | 134.729096989967 | 301 | 12 | 100 | 4 | 1 | 299 | 2445 | 2147 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 40284 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 20180335 | 20180335 | PRJNA168635_P_NODE_27536_length_166_cov_64.282051_g27120_i0 | PRJNA168635 | 27536 | 166 | 64.282051 | 106.70820466 | Naididae | 2109251 | Annelida | Annelida | 291 | 2.7099999999999998e-74 | NTclustered | gi|285029417|gb|GQ355435.1| | 41694 | g27120 | i0 | 98.204 | 100.60843373494 | 167 | 2 | 100 | 1 | 1 | 166 | 1101 | 935 | Stylaria lacustris 18S ribosomal RNA gene, partial sequence | blastn | 16701 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria lacustris | |
| 21456207 | 21456207 | PRJNA168635_P_NODE_9177_length_276_cov_7.348018_g8762_i0 | PRJNA168635 | 9177 | 276 | 7.348018 | 20.28052968 | Nais | 74730 | Annelida | Annelida | 484 | 2.11e-132 | NTclustered | gi|395484261|gb|JQ425005.1| | 1138460 | g8762 | i0 | 98.214 | 101.416666666667 | 280 | 0 | 99 | 2 | 1 | 275 | 302 | 23 | Nais communis/variabilis complex sp. A1 isolate CE3494 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 27991 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis/variabilis complex sp. A1 | |
| 22041084 | 22041084 | PRJNA168635_P_NODE_22278_length_175_cov_6.992063_g21862_i0 | PRJNA168635 | 22278 | 175 | 6.992063 | 12.23611025 | Drawida sp. br | 1046280 | Annelida | Annelida | 87.9 | 4.04e-13 | NTclustered | gi|341833272|gb|HQ728963.1| | 1046280 | g21862 | i0 | 98 | 0.285714285714286 | 50 | 1 | 29 | 0 | 95 | 144 | 2343 | 2294 | Drawida sp. br 28S large subunit ribosomal RNA gene, partial sequence | blastn | 50 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Moniligastrida | Moniligastridae | Drawida | Drawida sp. br | |
| 23316380 | 23316380 | PRJNA168635_P_NODE_10279_length_258_cov_1.392344_g9864_i0 | PRJNA168635 | 10279 | 258 | 1.392344 | 3.59224752 | Apistobranchus typicus | 195215 | Annelida | Annelida | 154 | 6.26e-33 | NTclustered | gi|172053646|gb|EU418870.1| | 195215 | g9864 | i0 | 83.041 | 73.8565891472868 | 171 | 28 | 66 | 1 | 69 | 238 | 2977 | 3147 | Apistobranchus typicus 28S ribosomal RNA gene, partial sequence | blastn | 19055 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Spionida | Apistobranchidae | Apistobranchus | Apistobranchus typicus | |
| 24006087 | 24006087 | PRJNA168635_P_NODE_11739_length_239_cov_1.094737_g11323_i0 | PRJNA168635 | 11739 | 239 | 1.094737 | 2.61642143 | Nais | 74730 | Annelida | Annelida | 433 | 6.57e-117 | NTclustered | gi|395484364|gb|JQ599216.1| | 1138460 | g11323 | i0 | 99.163 | 9.42677824267783 | 239 | 2 | 100 | 0 | 1 | 239 | 210 | 448 | Nais communis/variabilis complex sp. A1 isolate CE4103 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 2253 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis/variabilis complex sp. A1 | |
| 25280463 | 25280463 | PRJNA168635_P_NODE_8780_length_283_cov_10.192308_g8365_i0 | PRJNA168635 | 8780 | 283 | 10.192308 | 28.84423164 | Polychaeta | 6341 | Annelida | Annelida | 80.5 | 1.2e-10 | NTclustered | gi|340763912|gb|JF509731.1| | 6431 | g8365 | i0 | 75.439 | 16.7950530035336 | 171 | 38 | 60 | 4 | 104 | 272 | 2899 | 3067 | Urechis caupo voucher AToL000328 28S ribosomal RNA gene, partial sequence | blastn | 4753 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Xenopneusta | Urechidae | Urechis | Urechis caupo |
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);;