contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 240198 | 240198 | PRJNA1120060_P_NODE_1600141_length_289_cov_1.879630_g1582148_i0 | PRJNA1120060 | 1600141 | 289 | 1.87963 | 5.4321307 | Coeloseira compressa | 1852973 | Rhodophyta | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1037241293|ref|NC_030338.1| | 1852973 | g1582148 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 73 | 100 | 55357 | 55384 | Coeloseira compressa plastid, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Rhodymeniales | Champiaceae | Coeloseira | Coeloseira compressa | |||
| 246220 | 246220 | PRJNA1120060_P_NODE_2039761_length_271_cov_1.969697_g2021724_i0 | PRJNA1120060 | 2039761 | 271 | 1.969697 | 5.33787887 | Asparagopsis taxiformis | 260499 | Rhodophyta | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1070108057|ref|NC_031148.1| | 260499 | g2021724 | i0 | 96.97 | 0.121771217712177 | 33 | 0 | 12 | 1 | 231 | 262 | 31579 | 31547 | Asparagopsis taxiformis plastid, complete genome | blastn | 33 | 54.7 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Bonnemaisoniales | Bonnemaisoniaceae | Asparagopsis | Asparagopsis taxiformis | |||
| 1526277 | 1526277 | PRJNA1120060_P_NODE_2440502_length_256_cov_1.595628_g2422433_i0 | PRJNA1120060 | 2440502 | 256 | 1.595628 | 4.08480768 | Pyropia kuniedae | 683349 | Rhodophyta | other_Eukaryota | 60.2 | 1.39e-4 | NTclustered | gi|378786326|dbj|AB525396.1| | 683349 | g2422433 | i0 | 97.222 | 0.140625 | 36 | 0 | 14 | 1 | 91 | 125 | 167 | 202 | Porphyra kuniedae mitochondrial trnC(gca), rps11, sdh3, trnG(gcc), trnN(guu), trnP(ugg), rns genes for tRNA-Cys, ribosomal protein S11, succinate:cytochrome c oxidoreductase subunit 3, tRNA-Gly, tRNA-Asn, tRNA-Pro, small subunit ribosomal RNA, partial and complete cds, partial and complete sequence | blastn | 36 | 60.2 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia kuniedae | |||
| 2806216 | 2806216 | PRJNA1120060_P_NODE_2778003_length_246_cov_3.988439_g2759917_i0 | PRJNA1120060 | 2778003 | 246 | 3.988439 | 9.81155994 | Rhodella violacea | 2801 | Rhodophyta | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2222300232|ref|NC_062301.1| | 2801 | g2759917 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 152 | 179 | 354073 | 354046 | Rhodella violacea strain SAG 115.79 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Rhodellophyceae | Rhodellales | Rhodellaceae | Rhodella | Rhodella violacea | |||
| 6637445 | 6637445 | PRJNA1120060_P_NODE_3121906_length_235_cov_2.512346_g3103804_i0 | PRJNA1120060 | 3121906 | 235 | 2.512346 | 5.9040131 | Gracilariopsis heteroclada | 172978 | Rhodophyta | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1436051580|ref|NC_038100.1| | 172978 | g3103804 | i0 | 100 | 0.127659574468085 | 30 | 0 | 13 | 0 | 70 | 99 | 127951 | 127922 | Gracilariopsis heteroclada chloroplast, complete genome | blastn | 30 | 56.5 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilariopsis | Gracilariopsis heteroclada | |||
| 10437302 | 10437302 | PRJNA1120060_P_NODE_1163809_length_311_cov_1.823529_g1145874_i0 | PRJNA1120060 | 1163809 | 311 | 1.823529 | 5.67117519 | Bostrychia tenuissima | 196631 | Rhodophyta | other_Eukaryota | 62.1 | 4.83e-5 | NTclustered | gi|2666692823|ref|NC_085549.1| | 196631 | g1145874 | i0 | 95 | 6.27331189710611 | 40 | 0 | 13 | 2 | 254 | 293 | 16980 | 17017 | Bostrychia tenuissima strain MABIK-LAS-00000110 mitochondrion, complete genome | blastn | 1951 | 62.1 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Bostrychia | Bostrychia tenuissima | |||
| 10437411 | 10437411 | PRJNA1120060_P_NODE_1170269_length_310_cov_6.257384_g1152329_i0 | PRJNA1120060 | 1170269 | 310 | 6.257384 | 19.3978904 | Compsopogon caeruleus | 31354 | Rhodophyta | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1215848283|ref|NC_035350.1| | 31354 | g1152329 | i0 | 96.97 | 0.106451612903226 | 33 | 0 | 11 | 1 | 230 | 262 | 152689 | 152658 | Compsopogon caeruleus chloroplast, complete genome | blastn | 33 | 54.7 | 1 | Eukaryota | Rhodophyta | Compsopogonophyceae | Compsopogonales | Compsopogonaceae | Compsopogon | Compsopogon caeruleus | |||
| 10475630 | 10475630 | PRJNA1120060_P_NODE_845069_length_315_cov_1.987603_g827152_i0 | PRJNA1120060 | 845069 | 315 | 1.987603 | 6.26094945 | Choreocolax polysiphoniae | 282351 | Rhodophyta | other_Eukaryota | 60.2 | 1.76e-4 | NTclustered | gi|788512200|ref|NC_026522.1| | 282351 | g827152 | i0 | 91.304 | 0.146031746031746 | 46 | 1 | 14 | 2 | 1 | 43 | 69522 | 69477 | Choreocolax polysiphoniae plastid, complete genome | blastn | 46 | 60.2 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Choreocolacaceae | Choreocolax | Choreocolax polysiphoniae | |||
| 11720200 | 11720200 | PRJNA1120060_P_NODE_1698630_length_285_cov_1.735849_g1680626_i0 | PRJNA1120060 | 1698630 | 285 | 1.735849 | 4.94716965 | Echinothamnion hookeri | 2008680 | Rhodophyta | other_Eukaryota | 60.2 | 1.57e-4 | NTclustered | gi|2519762028|ref|NC_079646.1| | 2008680 | g1680626 | i0 | 100 | 0.221052631578947 | 32 | 0 | 11 | 0 | 11 | 42 | 147687 | 147718 | Echinothamnion hookeri voucher PD3303 chloroplast, complete genome | blastn | 63 | 60.2 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Echinothamnion | Echinothamnion hookeri | |||
| 12504560 | 12504560 | PRJNA1120060_P_NODE_1739770_length_283_cov_2.680952_g1721762_i0 | PRJNA1120060 | 1739770 | 283 | 2.680952 | 7.58709416 | Gracilaria | 2774 | Rhodophyta | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2127868550|ref|NC_058675.1| | 172960 | g1721762 | i0 | 96.875 | 0.339222614840989 | 32 | 0 | 11 | 1 | 67 | 98 | 6493 | 6463 | Gracilaria cervicornis voucher ALCB65155 mitochondrion, complete genome | blastn | 96 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilaria | Gracilaria cervicornis | |||
| 12505968 | 12505968 | PRJNA1120060_P_NODE_596810_length_349_cov_2.561594_g579084_i0 | PRJNA1120060 | 596810 | 349 | 2.561594 | 8.93996306 | Corallina | 35169 | Rhodophyta | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1835927919|gb|MT211885.1| | 35170 | g579084 | i0 | 100 | 0.515759312320917 | 30 | 0 | 9 | 0 | 50 | 79 | 163876 | 163847 | Corallina officinalis chloroplast, complete genome | blastn | 180 | 56.5 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Corallinales | Corallinaceae | Corallina | Corallina officinalis | |||
| 15557754 | 15557754 | PRJNA1120060_P_NODE_2722553_length_248_cov_0.891429_g2704470_i0 | PRJNA1120060 | 2722553 | 248 | 0.891429 | 2.21074392 | Choreocolax polysiphoniae | 282351 | Rhodophyta | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|788512200|ref|NC_026522.1| | 282351 | g2704470 | i0 | 90.476 | 0.169354838709677 | 42 | 1 | 17 | 2 | 184 | 225 | 50713 | 50751 | Choreocolax polysiphoniae plastid, complete genome | blastn | 42 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Choreocolacaceae | Choreocolax | Choreocolax polysiphoniae | |||
| 16814584 | 16814584 | PRJNA1120060_P_NODE_1407734_length_297_cov_4.433036_g1389752_i0 | PRJNA1120060 | 1407734 | 297 | 4.433036 | 13.16611692 | Bangia atropurpurea | 31347 | Rhodophyta | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2222305355|ref|NC_062392.1| | 31347 | g1389752 | i0 | 100 | 0.0942760942760943 | 28 | 0 | 9 | 0 | 190 | 217 | 164380 | 164407 | Bangia atropurpurea strain SAG 1351-1 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Bangia | Bangia atropurpurea | |||
| 18092250 | 18092250 | PRJNA1120060_P_NODE_1627995_length_288_cov_1.493023_g1609998_i0 | PRJNA1120060 | 1627995 | 288 | 1.493023 | 4.29990624 | Lemanea occidentalis | 2861711 | Rhodophyta | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2916204181|gb|PV153509.1| | 2861711 | g1609998 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 121 | 148 | 17922 | 17895 | Lemanea occidentalis voucher BHO A-1233 mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Batrachospermales | Lemaneaceae | Lemanea | Lemanea occidentalis | |||
| 19378309 | 19378309 | PRJNA1120060_P_NODE_2499436_length_254_cov_1.353591_g2481365_i0 | PRJNA1120060 | 2499436 | 254 | 1.353591 | 3.43812114 | Gracilaria ornata | 172946 | Rhodophyta | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2127868732|ref|NC_058682.1| | 172946 | g2481365 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 150 | 177 | 5586 | 5613 | Gracilaria ornata voucher ALCB99680 mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilaria | Gracilaria ornata | |||
| 19399143 | 19399143 | PRJNA1120060_P_NODE_927716_length_312_cov_3.564854_g909787_i0 | PRJNA1120060 | 927716 | 312 | 3.564854 | 11.12234448 | Cyanidium caldarium | 2771 | Rhodophyta | other_Eukaryota | 58.4 | 6.27e-4 | NTclustered | gi|7799050|emb|AJ277169.1| | 2771 | g909787 | i0 | 75.862 | 0.532051282051282 | 116 | 27 | 37 | 1 | 162 | 276 | 387 | 502 | Galdieria sulphuraria mRNA for ubiquitin, subunits I and II (polyubiquitin gene) | blastn | 166 | 58.4 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Cyanidiales | Cyanidiaceae | Cyanidium | Cyanidium caldarium | |||
| 20675354 | 20675354 | PRJNA1120060_P_NODE_970397_length_312_cov_2.891213_g952468_i0 | PRJNA1120060 | 970397 | 312 | 2.891213 | 9.02058456 | Galdieria sulphuraria | 130081 | Rhodophyta | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|545708272|ref|XM_005706392.1| | 130081 | g952468 | i0 | 100 | 0.092948717948718 | 29 | 0 | 9 | 0 | 167 | 195 | 2164 | 2192 | Galdieria sulphuraria 5' nucleotidase family protein (Gasu_27140), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Galdieriales | Galdieriaceae | Galdieria | Galdieria sulphuraria | |||
| 21908936 | 21908936 | PRJNA1120060_P_NODE_1049038_length_311_cov_4.525210_g1031103_i0 | PRJNA1120060 | 1049038 | 311 | 4.52521 | 14.0734031 | Chroothece richteriana | 101928 | Root_unresolved | Root_unresolved | 52.8 | 0.029 | NTclustered | gi|2222323044|ref|NC_062379.1| | 101928 | g1031103 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 106 | 133 | 194809 | 194782 | Chroothece richteriana strain SAG 104.79 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Stylonematophyceae | Stylonematales | Stylonemataceae | Chroothece | Chroothece richteriana | |||
| 21917711 | 21917711 | PRJNA1120060_P_NODE_1645658_length_287_cov_2.336449_g1627660_i0 | PRJNA1120060 | 1645658 | 287 | 2.336449 | 6.70560863 | Compsopogon caeruleus | 31354 | Rhodophyta | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1215848283|ref|NC_035350.1| | 31354 | g1627660 | i0 | 96.97 | 0.114982578397213 | 33 | 0 | 11 | 1 | 204 | 236 | 152689 | 152658 | Compsopogon caeruleus chloroplast, complete genome | blastn | 33 | 54.7 | 1 | Eukaryota | Rhodophyta | Compsopogonophyceae | Compsopogonales | Compsopogonaceae | Compsopogon | Compsopogon caeruleus | |||
| 21928933 | 21928933 | PRJNA1120060_P_NODE_2485618_length_254_cov_2.850829_g2467547_i0 | PRJNA1120060 | 2485618 | 254 | 2.850829 | 7.24110566 | Grateloupia asiatica | 151735 | Rhodophyta | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1824615466|dbj|AP018129.2| | 151735 | g2467547 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 181 | 208 | 184433 | 184406 | Grateloupia asiatica chloroplast DNA, nearly complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Halymeniales | Halymeniaceae | Grateloupia | Grateloupia asiatica | |||
| 23188279 | 23188279 | PRJNA1120060_P_NODE_1308839_length_306_cov_1.600858_g1290887_i0 | PRJNA1120060 | 1308839 | 306 | 1.600858 | 4.89862548 | Ceramothamnion japonicum | 218448 | Rhodophyta | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1070110402|ref|NC_031174.1| | 218448 | g1290887 | i0 | 100 | 0.0915032679738562 | 28 | 0 | 9 | 0 | 209 | 236 | 122637 | 122664 | Ceramium japonicum plastid, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Ceramiaceae | Ceramothamnion | Ceramothamnion japonicum | |||
| 23197048 | 23197048 | PRJNA1120060_P_NODE_1926099_length_275_cov_8.099010_g1908075_i0 | PRJNA1120060 | 1926099 | 275 | 8.09901 | 22.2722775 | Gelidium vagum | 35171 | Rhodophyta | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|1016880742|ref|NC_029859.1| | 35171 | g1908075 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 0 | 68 | 95 | 109534 | 109561 | Gelidium vagum plastid, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gelidiales | Gelidiaceae | Gelidium | Gelidium vagum | |||
| 23200061 | 23200061 | PRJNA1120060_P_NODE_2146739_length_267_cov_1.515464_g2128693_i0 | PRJNA1120060 | 2146739 | 267 | 1.515464 | 4.04628888 | Peyssonnelia rubra | 389204 | Rhodophyta | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1358962767|gb|MG030787.1| | 389204 | g2128693 | i0 | 94.444 | 3.02621722846442 | 36 | 0 | 13 | 2 | 87 | 120 | 234 | 269 | Peyssonnelia rubra voucher RM0052 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 808 | 54.7 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Peyssonneliales | Peyssonneliaceae | Peyssonnelia | Peyssonnelia rubra |
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);;