contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_phylum = "Rhodophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1049679 | 1049679 | PRJNA1237347_P_NODE_88941_length_734_cov_180.673222_g82706_i0 | PRJNA1237347 | 88941 | 734 | 180.673222 | 1326.14144948 | Metazoa | 33208 | Rhodophyta | other_Eukaryota | 119 | 7.1400000000000005e-22 | NTclustered | gi|1839347089|gb|MT325691.1| | 48978 | g82706 | i0 | 89.474 | 13.6376021798365 | 95 | 9 | 13 | 1 | 638 | 731 | 538 | 632 | Jania rubens voucher VPF00439 28S ribosomal RNA gene, partial sequence | blastn | 10010 | 119 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Corallinales | Corallinaceae | Jania | Jania rubens | |||
| 1612506 | 1612506 | PRJNA1237347_P_NODE_173422_length_476_cov_7.074442_g166851_i0 | PRJNA1237347 | 173422 | 476 | 7.074442 | 33.67434392 | Bangia fuscopurpurea | 101920 | Rhodophyta | other_Eukaryota | 67.6 | 1.65e-6 | NTclustered | gi|998751923|gb|KR010938.1| | 101920 | g166851 | i0 | 93.333 | 0.945378151260504 | 45 | 3 | 9 | 0 | 1 | 45 | 5252 | 5208 | Bangia fuscopurpurea isolate XLS large subunit ribosomal RNA gene, partial sequence | blastn | 450 | 67.6 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Bangia | Bangia fuscopurpurea | |||
| 1616684 | 1616684 | PRJNA1237347_P_NODE_380762_length_288_cov_1.130233_g374189_i0 | PRJNA1237347 | 380762 | 288 | 1.130233 | 3.25507104 | Webervanbossea splachnoides | 81619 | Rhodophyta | other_Eukaryota | 141 | 5.53e-29 | NTclustered | gi|116266797|gb|DQ873288.1| | 81619 | g374189 | i0 | 88.136 | 6.02430555555556 | 118 | 14 | 41 | 0 | 170 | 287 | 672 | 789 | Webervanbossea splachnoides voucher GWS002435 large subunit ribosomal RNA gene, partial sequence | blastn | 1735 | 141 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Rhodymeniales | Faucheaceae | Webervanbossea | Webervanbossea splachnoides | |||
| 2890435 | 2890435 | PRJNA1237347_P_NODE_251403_length_373_cov_2.006667_g244830_i0 | PRJNA1237347 | 251403 | 373 | 2.006667 | 7.48486791 | Plocamium cartilagineum | 31452 | Rhodophyta | other_Eukaryota | 174 | 7.26e-39 | NTclustered | gi|612407963|gb|KJ398160.1| | 31452 | g244830 | i0 | 81.517 | 53.9008042895442 | 211 | 39 | 57 | 0 | 148 | 358 | 12289 | 12079 | Plocamium cartilagineum mitochondrion, partial genome | blastn | 20105 | 174 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Plocamiales | Plocamiaceae | Plocamium | Plocamium cartilagineum | |||
| 6714874 | 6714874 | PRJNA1237347_P_NODE_140926_length_545_cov_4.239407_g134387_i0 | PRJNA1237347 | 140926 | 545 | 4.239407 | 23.10476815 | Gracilariophila oryzoides | 42480 | Rhodophyta | other_Eukaryota | 119 | 5.21e-22 | NTclustered | gi|1102131068|gb|KX687879.1| | 42480 | g134387 | i0 | 77.103 | 0.981651376146789 | 214 | 43 | 39 | 5 | 160 | 370 | 12137 | 11927 | Gracilariophila oryzoides mitochondrion, complete genome | blastn | 535 | 119 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilariophila | Gracilariophila oryzoides | |||
| 7426129 | 7426129 | PRJNA1237347_P_NODE_303686_length_331_cov_2.337209_g297113_i0 | PRJNA1237347 | 303686 | 331 | 2.337209 | 7.73616179 | Bangiaceae | 31345 | Rhodophyta | other_Eukaryota | 71.3 | 8.61e-8 | NTclustered | gi|645928506|gb|KJ708766.1| | 182771 | g297113 | i0 | 88.136 | 4.33836858006042 | 59 | 7 | 32 | 0 | 205 | 263 | 10676 | 10618 | Pyropia perforata voucher PB-A 684 mitochondrion, complete genome | blastn | 1436 | 71.3 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia perforata | |||
| 9265588 | 9265588 | PRJNA1237347_P_NODE_156368_length_509_cov_46.467890_g149810_i0 | PRJNA1237347 | 156368 | 509 | 46.46789 | 236.5215601 | Pyropia haitanensis | 1262161 | Rhodophyta | other_Eukaryota | 379 | 2.01e-100 | NTclustered | gi|1026716609|gb|KU179277.1| | 1262161 | g149810 | i0 | 82.103 | 87.127701375245607 | 447 | 76 | 87 | 3 | 36 | 480 | 488 | 44 | Pyropia haitanensis calmodulin 1 mRNA, complete cds | blastn | 44348 | 379 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia haitanensis | |||
| 10542310 | 10542310 | PRJNA1237347_P_NODE_193909_length_442_cov_3.579946_g187337_i0 | PRJNA1237347 | 193909 | 442 | 3.579946 | 15.82336132 | Laurencia snackeyi | 1858662 | Rhodophyta | other_Eukaryota | 375 | 2.2299999999999998e-99 | NTclustered | gi|1203234110|gb|MF093985.1| | 1858662 | g187337 | i0 | 82.127 | 100.151583710407 | 442 | 75 | 99 | 4 | 1 | 440 | 862 | 1301 | Laurencia snackeyi isolate JFC0032 cytochrome oxidase subunit 1 (cox1) gene, complete cds; mitochondrial | blastn | 44267 | 375 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Laurencia | Laurencia snackeyi | |||
| 10550368 | 10550368 | PRJNA1237347_P_NODE_86189_length_749_cov_2.600592_g79987_i0 | PRJNA1237347 | 86189 | 749 | 2.600592 | 19.47843408 | Pyropia seriata | 79731 | Rhodophyta | other_Eukaryota | 1162 | 0 | NTclustered | gi|922081034|gb|KP241942.1| | 79731 | g79987 | i0 | 94.66 | 99.2202937249666 | 749 | 40 | 100 | 0 | 1 | 749 | 696 | 1444 | Pyropia seriata heat shock protein 70c (HSP70c) mRNA, complete cds | blastn | 74316 | 1162 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia seriata | |||
| 11817183 | 11817183 | PRJNA1237347_P_NODE_199210_length_434_cov_846.002770_g192638_i0 | PRJNA1237347 | 199210 | 434 | 846.00277 | 3671.6520218 | Compsopogon caeruleus | 31354 | Rhodophyta | other_Eukaryota | 165 | 5.16e-36 | NTclustered | gi|1812772006|gb|MT117933.1| | 31354 | g192638 | i0 | 90.476 | 27.8847926267281 | 126 | 10 | 29 | 2 | 1 | 126 | 4117 | 4240 | Compsopogon caeruleus strain SAG36.94 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 | 12102 | 165 | 1 | Eukaryota | Rhodophyta | Compsopogonophyceae | Compsopogonales | Compsopogonaceae | Compsopogon | Compsopogon caeruleus | |||
| 14370690 | 14370690 | PRJNA1237347_P_NODE_356852_length_299_cov_2.876106_g350279_i0 | PRJNA1237347 | 356852 | 299 | 2.876106 | 8.59955694 | Antithamnionella miharai | 536589 | Rhodophyta | other_Eukaryota | 99 | 3.52e-16 | NTclustered | gi|2666692773|ref|NC_085547.1| | 536589 | g350279 | i0 | 75.362 | 3.33779264214047 | 207 | 49 | 69 | 2 | 73 | 278 | 22609 | 22814 | Antithamnionella miharai strain MABIK-LAS-00000332 mitochondrion, complete genome | blastn | 998 | 99 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Ceramiaceae | Antithamnionella | Antithamnionella miharai | |||
| 15641244 | 15641244 | PRJNA1237347_P_NODE_191013_length_447_cov_1.374332_g184441_i0 | PRJNA1237347 | 191013 | 447 | 1.374332 | 6.14326404 | Centroceras gasparrinii | 371099 | Rhodophyta | other_Eukaryota | 52.8 | 0.043 | NTclustered | gi|2666692877|ref|NC_085551.1| | 371099 | g184441 | i0 | 96.774 | 0.0693512304250559 | 31 | 1 | 7 | 0 | 411 | 441 | 2889 | 2919 | Centroceras gasparrinii strain MABIK-LAS-00000294 mitochondrion, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Ceramiaceae | Centroceras | Centroceras gasparrinii | |||
| 15641798 | 15641798 | PRJNA1237347_P_NODE_215813_length_412_cov_2.805310_g209241_i0 | PRJNA1237347 | 215813 | 412 | 2.80531 | 11.5578772 | Pyropia seriata | 79731 | Rhodophyta | other_Eukaryota | 326 | 2.11e-84 | NTclustered | gi|922081034|gb|KP241942.1| | 79731 | g209241 | i0 | 88.806 | 14.2621359223301 | 268 | 26 | 65 | 3 | 146 | 411 | 118 | 383 | Pyropia seriata heat shock protein 70c (HSP70c) mRNA, complete cds | blastn | 5876 | 326 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia seriata | |||
| 16351600 | 16351600 | PRJNA1237347_P_NODE_467533_length_252_cov_1.955307_g460960_i0 | PRJNA1237347 | 467533 | 252 | 1.955307 | 4.92737364 | Rhodophyta | 2763 | Rhodophyta | other_Eukaryota | 154 | 6.09e-33 | NTclustered | gi|746001632|ref|NC_026056.1| | 2822 | g460960 | i0 | 83.14 | 9.37301587301587 | 172 | 26 | 67 | 3 | 9 | 178 | 20525 | 20355 | Palmaria palmata mitochondrion, complete genome | blastn | 2362 | 154 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Palmariales | Palmariaceae | Palmaria | Palmaria palmata | |||
| 16917400 | 16917400 | PRJNA1237347_P_NODE_288654_length_342_cov_1.438662_g282081_i0 | PRJNA1237347 | 288654 | 342 | 1.438662 | 4.92022404 | Heterosiphonia pulchra | 189631 | Rhodophyta | other_Eukaryota | 213 | 1.4e-50 | NTclustered | gi|2666692949|ref|NC_085554.1| | 189631 | g282081 | i0 | 79.31 | 18.5906432748538 | 319 | 54 | 92 | 9 | 19 | 331 | 18180 | 17868 | Heterosiphonia pulchra strain MABIK-LAS-00000388 mitochondrion, complete genome | blastn | 6358 | 213 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Dasyaceae | Heterosiphonia | Heterosiphonia pulchra | |||
| 17625097 | 17625097 | PRJNA1237347_P_NODE_136894_length_555_cov_72.068465_g130360_i0 | PRJNA1237347 | 136894 | 555 | 72.068465 | 399.97998075 | Cyanidiales | 265318 | Rhodophyta | other_Eukaryota | 169 | 5.2000000000000004e-37 | NTclustered | gi|133755338|ref|NC_000887.3| | 45157 | g130360 | i0 | 80.087 | 5.47027027027027 | 231 | 43 | 41 | 3 | 280 | 509 | 24602 | 24830 | Cyanidioschyzon merolae mitochondrion, complete genome | blastn | 3036 | 169 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Cyanidiales | Cyanidiaceae | Cyanidioschyzon | Cyanidioschyzon merolae | |||
| 20738656 | 20738656 | PRJNA1237347_P_NODE_141377_length_544_cov_3.059448_g134838_i0 | PRJNA1237347 | 141377 | 544 | 3.059448 | 16.64339712 | Gelidiella acerosa | 28867 | Rhodophyta | other_Eukaryota | 69.4 | 5.31e-7 | NTclustered | gi|1980524013|ref|NC_052712.1| | 28867 | g134838 | i0 | 79.808 | 0.696691176470588 | 104 | 14 | 19 | 6 | 33 | 133 | 1462 | 1363 | Gelidiella acerosa voucher CNU026920 mitochondrion, complete genome | blastn | 379 | 69.4 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gelidiales | Gelidiellaceae | Gelidiella | Gelidiella acerosa | |||
| 20740079 | 20740079 | PRJNA1237347_P_NODE_205837_length_425_cov_2.389205_g199265_i0 | PRJNA1237347 | 205837 | 425 | 2.389205 | 10.15412125 | Pyropia seriata | 79731 | Rhodophyta | other_Eukaryota | 440 | 7.479999999999997e-119 | NTclustered | gi|922081034|gb|KP241942.1| | 79731 | g199265 | i0 | 89.205 | 0.894117647058824 | 352 | 38 | 83 | 0 | 74 | 425 | 2021 | 1670 | Pyropia seriata heat shock protein 70c (HSP70c) mRNA, complete cds | blastn | 380 | 440 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia seriata |
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);;