contig_metadata
11 rows where bioproject = "PRJNA827593", tax_phylum = "Rhodophyta" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 820751 | 820751 | PRJNA827593_P_NODE_11541_length_646_cov_10.635253_g11249_i0 | PRJNA827593 | 11541 | 646 | 10.635253 | 68.70373438 | Laurencia snackeyi | 1858662 | Rhodophyta | other_Eukaryota | 416 | 1.98e-111 | NTclustered | gi|1203234110|gb|MF093985.1| | 1858662 | g11249 | i0 | 79.867 | 81.4473684210526 | 601 | 95 | 91 | 19 | 3 | 590 | 760 | 1347 | Laurencia snackeyi isolate JFC0032 cytochrome oxidase subunit 1 (cox1) gene, complete cds; mitochondrial | blastn | 52615 | 416 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Laurencia | Laurencia snackeyi | |||
| 3372628 | 3372628 | PRJNA827593_P_NODE_8623_length_759_cov_2.252187_g8339_i0 | PRJNA827593 | 8623 | 759 | 2.252187 | 17.09409933 | Kuetzingia canaliculata | 228262 | Rhodophyta | other_Eukaryota | 359 | 4.01e-94 | NTclustered | gi|1203234108|gb|MF093984.1| | 228262 | g8339 | i0 | 80.164 | 64.5928853754941 | 489 | 90 | 64 | 6 | 2 | 488 | 889 | 1372 | Kuetzingia canaliculata isolate PD1540 cytochrome oxidase subunit 1 (cox1) gene, complete cds; mitochondrial | blastn | 49026 | 359 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Kuetzingia | Kuetzingia canaliculata | |||
| 4649460 | 4649460 | PRJNA827593_P_NODE_31224_length_369_cov_3.047297_g30925_i0 | PRJNA827593 | 31224 | 369 | 3.047297 | 11.24452593 | Palisada intermedia | 397057 | Rhodophyta | other_Eukaryota | 244 | 5.389999999999999e-60 | NTclustered | gi|2577881875|ref|NC_082323.1| | 397057 | g30925 | i0 | 79.539 | 80.6260162601626 | 347 | 67 | 93 | 4 | 1 | 345 | 13244 | 13588 | Palisada intermedia mitochondrion, complete genome | blastn | 29751 | 244 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Palisada | Palisada intermedia | |||
| 5924342 | 5924342 | PRJNA827593_P_NODE_3425_length_1253_cov_8.043220_g3213_i0 | PRJNA827593 | 3425 | 1253 | 8.04322 | 100.7815466 | Dipterosiphonia australica | 2007208 | Rhodophyta | other_Eukaryota | 145 | 2.05e-29 | NTclustered | gi|2431519370|ref|NC_070159.1| | 2007208 | g3213 | i0 | 71.891 | 17.2569832402235 | 587 | 137 | 46 | 27 | 40 | 612 | 8294 | 8866 | Dipterosiphonia australica isolate PD1107 voucher PD1107 mitochondrion, complete genome | blastn | 21623 | 145 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Dipterosiphonia | Dipterosiphonia australica | |||
| 5924691 | 5924691 | PRJNA827593_P_NODE_54645_length_268_cov_2.466667_g54346_i0 | PRJNA827593 | 54645 | 268 | 2.466667 | 6.6106675600000004 | Lemanea occidentalis | 2861711 | Rhodophyta | other_Eukaryota | 82.4 | 3.13e-11 | NTclustered | gi|2916204181|gb|PV153509.1| | 2861711 | g54346 | i0 | 85.366 | 4.58208955223881 | 82 | 9 | 30 | 2 | 106 | 185 | 25775 | 25855 | Lemanea occidentalis voucher BHO A-1233 mitochondrion, complete genome | blastn | 1228 | 82.4 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Batrachospermales | Lemaneaceae | Lemanea | Lemanea occidentalis | |||
| 11024729 | 11024729 | PRJNA827593_P_NODE_26409_length_406_cov_3.852853_g26110_i0 | PRJNA827593 | 26409 | 406 | 3.852853 | 15.64258318 | Calliblepharis sp. | 2902951 | Rhodophyta | other_Eukaryota | 257 | 7.69e-64 | NTclustered | gi|2438062301|gb|OM066866.1| | 2902951 | g26110 | i0 | 81.231 | 59.7783251231527 | 325 | 55 | 79 | 5 | 2 | 323 | 21992 | 22313 | Calliblepharis sp. isolate 64 mitochondrion, complete genome | blastn | 24270 | 257 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Cystocloniaceae | Calliblepharis | Calliblepharis sp. | |||
| 11025141 | 11025141 | PRJNA827593_P_NODE_50129_length_282_cov_4.052632_g49830_i0 | PRJNA827593 | 50129 | 282 | 4.052632 | 11.42842224 | Pterosiphonia complanata | 884089 | Rhodophyta | other_Eukaryota | 150 | 8.97e-32 | NTclustered | gi|2431519250|ref|NC_070154.1| | 884089 | g49830 | i0 | 78.059 | 2.30496453900709 | 237 | 52 | 84 | 0 | 46 | 282 | 21263 | 21499 | Pterosiphonia complanata isolate PD4865 voucher PD4865 mitochondrion, complete genome | blastn | 650 | 150 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Pterosiphonia | Pterosiphonia complanata | |||
| 12707928 | 12707928 | PRJNA827593_P_NODE_38170_length_329_cov_2.597656_g37871_i0 | PRJNA827593 | 38170 | 329 | 2.597656 | 8.54628824 | Corallinales | 31395 | Rhodophyta | other_Eukaryota | 135 | 2.99e-27 | NTclustered | gi|19919365|gb|AF419116.1| | 35170 | g37871 | i0 | 87.097 | 32.6504559270517 | 124 | 10 | 37 | 6 | 119 | 240 | 1803 | 1684 | Corallina officinalis large subunit ribosomal RNA gene, partial sequence | blastn | 10742 | 135 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Corallinales | Corallinaceae | Corallina | Corallina officinalis | |||
| 14849223 | 14849223 | PRJNA827593_P_NODE_37832_length_331_cov_1.918605_g37533_i0 | PRJNA827593 | 37832 | 331 | 1.918605 | 6.35058255 | Iridaea cordata | 29225 | Rhodophyta | other_Eukaryota | 243 | 1.72e-59 | NTclustered | gi|2587256166|gb|OP451855.1| | 29225 | g37533 | i0 | 80.428 | 88.664652567975807 | 327 | 56 | 98 | 7 | 9 | 331 | 10260 | 9938 | Iridaea cordata isolate FH110 mitochondrion, complete genome | blastn | 29348 | 243 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Gigartinaceae | Iridaea | Iridaea cordata | |||
| 19947509 | 19947509 | PRJNA827593_P_NODE_23816_length_431_cov_1.854749_g23517_i0 | PRJNA827593 | 23816 | 431 | 1.854749 | 7.99396819 | Periphykon beckeri | 2006982 | Rhodophyta | other_Eukaryota | 134 | 1.44e-26 | NTclustered | gi|2431519274|ref|NC_070155.1| | 2006982 | g23517 | i0 | 80.328 | 6.52900232018562 | 183 | 31 | 42 | 5 | 56 | 237 | 10369 | 10547 | Periphykon beckeri isolate JH1427 voucher JH1427 mitochondrion, complete genome | blastn | 2814 | 134 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Periphykon | Periphykon beckeri | |||
| 21630503 | 21630503 | PRJNA827593_P_NODE_9457_length_721_cov_3.972222_g9168_i0 | PRJNA827593 | 9457 | 721 | 3.972222 | 28.63972062 | Florideophyceae | 2806 | Rhodophyta | other_Eukaryota | 110 | 4.22e-19 | NTclustered | gi|2431519250|ref|NC_070154.1| | 884089 | g9168 | i0 | 86.139 | 0.816920943134535 | 101 | 14 | 14 | 0 | 31 | 131 | 9980 | 9880 | Pterosiphonia complanata isolate PD4865 voucher PD4865 mitochondrion, complete genome | blastn | 589 | 111 | 0.990990990990991 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Pterosiphonia | Pterosiphonia complanata |
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);;