contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183453 | 183453 | PRJNA1068830_P_NODE_68581_length_260_cov_93.080214_g67878_i0 | PRJNA1068830 | 68581 | 260 | 93.080214 | 242.0085564 | Paranais litoralis | 74742 | Annelida | Annelida | 348 | 2.7e-91 | NTclustered | gi|1494622622|gb|MK076421.1| | 74742 | g67878 | i0 | 95.045 | 138.938461538462 | 222 | 9 | 85 | 1 | 41 | 260 | 3616 | 3395 | Paranais litoralis isolate PARliHBMD large subunit ribosomal RNA gene, partial sequence | blastn | 36124 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Paranais | Paranais litoralis | |
| 1457229 | 1457229 | PRJNA1068830_P_NODE_33822_length_389_cov_0.987342_g33119_i0 | PRJNA1068830 | 33822 | 389 | 0.987342 | 3.84076038 | Eisenia andrei | 168636 | Annelida | Annelida | 719 | 0 | NTclustered | gi|2281547178|ref|NC_065212.1| | 168636 | g33119 | i0 | 100 | 87.7249357326478 | 389 | 0 | 100 | 0 | 1 | 389 | 405 | 17 | Eisenia andrei mitochondrion, complete genome | blastn | 34125 | 719 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia andrei | |
| 1457943 | 1457943 | PRJNA1068830_P_NODE_65022_length_269_cov_1.311224_g64319_i0 | PRJNA1068830 | 65022 | 269 | 1.311224 | 3.52719256 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g64319 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 0 | 126 | 153 | 1944360 | 1944387 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2289283 | 2289283 | PRJNA1068830_P_NODE_16842_length_590_cov_16.829787_g16154_i0 | PRJNA1068830 | 16842 | 590 | 16.829787 | 99.2957433 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.016 | NTclustered | gi|675863313|ref|XM_009018969.1| | 6412 | g16154 | i0 | 100 | 0.0983050847457627 | 29 | 0 | 5 | 0 | 289 | 317 | 1100 | 1072 | Helobdella robusta hypothetical protein partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2733741 | 2733741 | PRJNA1068830_P_NODE_60163_length_280_cov_2.236715_g59460_i0 | PRJNA1068830 | 60163 | 280 | 2.236715 | 6.262802 | Nais elinguis | 74736 | Annelida | Annelida | 263 | 1.09e-65 | NTclustered | gi|38154516|gb|AY364858.1| | 74736 | g59460 | i0 | 96.815 | 64.1214285714286 | 157 | 5 | 56 | 0 | 124 | 280 | 473 | 317 | Nais elinguis cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 17954 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais elinguis | |
| 4010446 | 4010446 | PRJNA1068830_P_NODE_89924_length_234_cov_2.037267_g89221_i0 | PRJNA1068830 | 89924 | 234 | 2.037267 | 4.76720478 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 327 | 3.11e-85 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g89221 | i0 | 91.915 | 44.8418803418803 | 235 | 17 | 100 | 2 | 1 | 234 | 3309 | 3542 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 10493 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 5285427 | 5285427 | PRJNA1068830_P_NODE_36185_length_373_cov_1.560000_g35482_i0 | PRJNA1068830 | 36185 | 373 | 1.56 | 5.8188 | Eisenia andrei | 168636 | Annelida | Annelida | 689 | 0 | NTclustered | gi|2281547178|ref|NC_065212.1| | 168636 | g35482 | i0 | 100 | 43.9061662198391 | 373 | 0 | 100 | 0 | 1 | 373 | 4348 | 3976 | Eisenia andrei mitochondrion, complete genome | blastn | 16377 | 689 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia andrei | |
| 6117356 | 6117356 | PRJNA1068830_P_NODE_46285_length_323_cov_2.276000_g45582_i0 | PRJNA1068830 | 46285 | 323 | 2.276 | 7.35148 | Naididae | 2109251 | Annelida | Annelida | 436 | 7.169999999999999e-118 | NTclustered | gi|285029438|gb|GQ355456.1| | 150440 | g45582 | i0 | 91.049 | 98.687306501548 | 324 | 28 | 100 | 1 | 1 | 323 | 650 | 327 | Pristina leidyi 28S ribosomal RNA gene, partial sequence | blastn | 31876 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina leidyi | |
| 6560751 | 6560751 | PRJNA1068830_P_NODE_44786_length_330_cov_0.964981_g44083_i0 | PRJNA1068830 | 44786 | 330 | 0.964981 | 3.1844373 | Pristina aequiseta complex sp. CEB | 3386435 | Annelida | Annelida | 65.8 | 3.99e-6 | NTclustered | gi|2889117295|gb|PP138016.1| | 3386435 | g44083 | i0 | 100 | 0.106060606060606 | 35 | 0 | 11 | 0 | 1 | 35 | 35 | 1 | Pristina aequiseta complex sp. CEB voucher CE33209 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 35 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta complex sp. CEB | |
| 9109826 | 9109826 | PRJNA1068830_P_NODE_20968_length_519_cov_7.206278_g20267_i0 | PRJNA1068830 | 20968 | 519 | 7.206278 | 37.40058282 | Slavina appendiculata | 188233 | Annelida | Annelida | 708 | 0 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g20267 | i0 | 91.379 | 70.8863198458574 | 522 | 37 | 99 | 8 | 2 | 519 | 4022 | 4539 | Slavina appendiculata mitochondrion, partial genome | blastn | 36790 | 708 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 9110095 | 9110095 | PRJNA1068830_P_NODE_33528_length_390_cov_5.596215_g32825_i0 | PRJNA1068830 | 33528 | 390 | 5.596215 | 21.8252385 | Slavina appendiculata | 188233 | Annelida | Annelida | 381 | 4.189999999999999e-101 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g32825 | i0 | 85.445 | 2.91538461538462 | 371 | 49 | 95 | 5 | 1 | 370 | 5065 | 4699 | Slavina appendiculata mitochondrion, partial genome | blastn | 1137 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 9110911 | 9110911 | PRJNA1068830_P_NODE_65708_length_267_cov_1.706186_g65005_i0 | PRJNA1068830 | 65708 | 267 | 1.706186 | 4.55551662 | Enchytraeus albidus | 6390 | Annelida | Annelida | 191 | 4.96e-44 | NTclustered | gi|1068288851|gb|KU728857.1| | 6390 | g65005 | i0 | 80.233 | 85.5805243445693 | 258 | 47 | 96 | 3 | 2 | 257 | 419 | 164 | Enchytraeus albidus cytochrome c oxidase subunit 2 (Cox2) gene, partial cds; mitochondrial | blastn | 22850 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus albidus | |
| 9111162 | 9111162 | PRJNA1068830_P_NODE_75608_length_251_cov_0.876404_g74905_i0 | PRJNA1068830 | 75608 | 251 | 0.876404 | 2.19977404 | Dero obtusa | 212255 | Annelida | Annelida | 442 | 1.1599999999999995e-119 | NTclustered | gi|33330107|gb|AF534838.1| | 212255 | g74905 | i0 | 98.406 | 90.5298804780876 | 251 | 4 | 100 | 0 | 1 | 251 | 470 | 720 | Dero obtusa isolate DERobfd cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial gene for mitochondrial product | blastn | 22723 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Dero | Dero obtusa | |
| 10387252 | 10387252 | PRJNA1068830_P_NODE_90489_length_228_cov_19.251613_g89786_i0 | PRJNA1068830 | 90489 | 228 | 19.251613 | 43.89367764 | Nais communis | 188228 | Annelida | Annelida | 311 | 3.0400000000000003e-80 | NTclustered | gi|1494622621|gb|MK076420.1| | 188228 | g89786 | i0 | 95.833 | 131.938596491228 | 192 | 8 | 84 | 0 | 37 | 228 | 3619 | 3428 | Nais communis isolate NAIco_IUCB large subunit ribosomal RNA gene, partial sequence | blastn | 30082 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis | |
| 16316620 | 16316620 | PRJNA1068830_P_NODE_39853_length_352_cov_25.053763_g39150_i0 | PRJNA1068830 | 39853 | 352 | 25.053763 | 88.18924576 | Naididae | 2109251 | Annelida | Annelida | 645 | 1.2e-180 | NTclustered | gi|19550402|gb|AF411875.1| | 188231 | g39150 | i0 | 99.716 | 99.8721590909091 | 352 | 1 | 100 | 0 | 1 | 352 | 8 | 359 | Pristina longiseta 18S ribosomal RNA gene, partial sequence | blastn | 35155 | 651 | 0.990783410138249 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 16759981 | 16759981 | PRJNA1068830_P_NODE_55794_length_291_cov_2.050459_g55091_i0 | PRJNA1068830 | 55794 | 291 | 2.050459 | 5.96683569 | Eisenia andrei | 168636 | Annelida | Annelida | 538 | 1.6999999999999994e-148 | NTclustered | gi|2281547178|ref|NC_065212.1| | 168636 | g55091 | i0 | 100 | 2.90721649484536 | 291 | 0 | 100 | 0 | 1 | 291 | 10558 | 10268 | Eisenia andrei mitochondrion, complete genome | blastn | 846 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia andrei | |
| 18034042 | 18034042 | PRJNA1068830_P_NODE_21815_length_507_cov_1.900922_g21114_i0 | PRJNA1068830 | 21815 | 507 | 1.900922 | 9.63767454 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g21114 | i0 | 97.059 | 1.93491124260355 | 34 | 1 | 7 | 0 | 101 | 134 | 1799138 | 1799105 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 981 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19308821 | 19308821 | PRJNA1068830_P_NODE_62136_length_276_cov_1.152709_g61433_i0 | PRJNA1068830 | 62136 | 276 | 1.152709 | 3.18147684 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 198 | 3.08e-46 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g61433 | i0 | 86.932 | 0.63768115942029 | 176 | 23 | 64 | 0 | 22 | 197 | 9265093 | 9264918 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 176 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20584360 | 20584360 | PRJNA1068830_P_NODE_63457_length_272_cov_2.281407_g62754_i0 | PRJNA1068830 | 63457 | 272 | 2.281407 | 6.20542704 | Eisenia andrei | 168636 | Annelida | Annelida | 503 | 5.729999999999998e-138 | NTclustered | gi|2281547178|ref|NC_065212.1| | 168636 | g62754 | i0 | 100 | 10.1654411764706 | 272 | 0 | 100 | 0 | 1 | 272 | 3346 | 3075 | Eisenia andrei mitochondrion, complete genome | blastn | 2765 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia andrei | |
| 21859348 | 21859348 | PRJNA1068830_P_NODE_32898_length_395_cov_1.453416_g32195_i0 | PRJNA1068830 | 32898 | 395 | 1.453416 | 5.7409932 | Phragmatopoma lapidosa | 341668 | Annelida | Annelida | 270 | 9.59e-68 | NTclustered | gi|700589089|gb|KM267680.1| | 341668 | g32195 | i0 | 79.74 | 34.4708860759494 | 385 | 69 | 96 | 9 | 13 | 393 | 1 | 380 | Phragmatopoma lapidosa clone 116 40S ribosomal protein mRNA, complete cds | blastn | 13616 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Phragmatopoma | Phragmatopoma lapidosa | |
| 23966580 | 23966580 | PRJNA1068830_P_NODE_47559_length_318_cov_2.453061_g46856_i0 | PRJNA1068830 | 47559 | 318 | 2.453061 | 7.80073398 | Naididae | 2109251 | Annelida | Annelida | 379 | 1.1999999999999999e-100 | NTclustered | gi|285029438|gb|GQ355456.1| | 150440 | g46856 | i0 | 88.162 | 100.990566037736 | 321 | 34 | 100 | 4 | 1 | 318 | 650 | 331 | Pristina leidyi 28S ribosomal RNA gene, partial sequence | blastn | 32115 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina leidyi |
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);;