contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145247 | 145247 | PRJNA1000943_P_NODE_8841_length_279_cov_1.854369_g8703_i0 | PRJNA1000943 | 8841 | 279 | 1.854369 | 5.17368951 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 398 | 2.8599999999999996e-106 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g8703 | i0 | 92.226 | 58.8996415770609 | 283 | 18 | 100 | 2 | 1 | 279 | 1777 | 2059 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 16433 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 5247991 | 5247991 | PRJNA1000943_P_NODE_7965_length_292_cov_1.977169_g7827_i0 | PRJNA1000943 | 7965 | 292 | 1.977169 | 5.77333348 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 183 | 9.2e-42 | NTclustered | gi|477541861|gb|KC603850.1| | 1199090 | g7827 | i0 | 78.305 | 5.83904109589041 | 295 | 57 | 100 | 7 | 1 | 292 | 6314 | 6024 | Brachionus sp. 'koreanus' chromosome II mitochondrion, complete sequence | blastn | 1705 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 6523464 | 6523464 | PRJNA1000943_P_NODE_16026_length_227_cov_2.025974_g15888_i0 | PRJNA1000943 | 16026 | 227 | 2.025974 | 4.59896098 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 235 | 1.87e-57 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g15888 | i0 | 86.73 | 85.8590308370044 | 211 | 28 | 93 | 0 | 15 | 225 | 57 | 267 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 19490 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 9927270 | 9927270 | PRJNA1000943_P_NODE_9808_length_266_cov_4.808290_g9670_i0 | PRJNA1000943 | 9808 | 266 | 4.80829 | 12.7900514 | Ploima | 84394 | Rotifera | other_Eukaryota | 379 | 9.819999999999998e-101 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g9670 | i0 | 92.481 | 102.026315789474 | 266 | 19 | 100 | 1 | 1 | 266 | 1705 | 1441 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 27139 | 381 | 0.994750656167979 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 10348224 | 10348224 | PRJNA1000943_P_NODE_13609_length_246_cov_1.635838_g13471_i0 | PRJNA1000943 | 13609 | 246 | 1.635838 | 4.02416148 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 327 | 3.3e-85 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g13471 | i0 | 93.243 | 86.5975609756098 | 222 | 15 | 90 | 0 | 25 | 246 | 1 | 222 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 21303 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 11623739 | 11623739 | PRJNA1000943_P_NODE_370_length_1120_cov_105.308500_g305_i0 | PRJNA1000943 | 370 | 1120 | 105.3085 | 1179.4552 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 472 | 7.389999999999998e-128 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g305 | i0 | 82.531 | 25.3785714285714 | 561 | 75 | 49 | 18 | 53 | 602 | 11801 | 11253 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 28424 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 12898869 | 12898869 | PRJNA1000943_P_NODE_611_length_913_cov_7.727381_g514_i0 | PRJNA1000943 | 611 | 913 | 7.727381 | 70.55098853 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 682 | 0 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g514 | i0 | 81.851 | 72.3953997809419 | 821 | 139 | 90 | 7 | 95 | 913 | 1459 | 647 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 66097 | 682 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 16721994 | 16721994 | PRJNA1000943_P_NODE_154_length_1522_cov_8.467219_g124_i0 | PRJNA1000943 | 154 | 1522 | 8.467219 | 128.87107318 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 1251 | 0 | NTclustered | gi|2778092484|gb|PP988072.1| | 3231738 | g124 | i0 | 82.317 | 50.0216819973719 | 1459 | 242 | 95 | 13 | 8 | 1455 | 16 | 1469 | Asplanchna sp. chromosome II mitochondrion, complete sequence | blastn | 76133 | 1251 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 19270723 | 19270723 | PRJNA1000943_P_NODE_4136_length_386_cov_1.744409_g3999_i0 | PRJNA1000943 | 4136 | 386 | 1.744409 | 6.73341874 | Synchaeta pectinata | 525906 | Rotifera | other_Eukaryota | 451 | 3.11e-122 | NTclustered | gi|403492659|gb|JX193068.1| | 525906 | g3999 | i0 | 87.792 | 98.880829015544 | 385 | 47 | 99 | 0 | 1 | 385 | 213 | 597 | Synchaeta pectinata isolate A458.2 alpha tubulin gene, partial cds | blastn | 38168 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Synchaeta | Synchaeta pectinata | |
| 21822002 | 21822002 | PRJNA1000943_P_NODE_398_length_1087_cov_9.743590_g330_i0 | PRJNA1000943 | 398 | 1087 | 9.74359 | 105.9128233 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 719 | 0 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g330 | i0 | 82.009 | 18.3247470101196 | 856 | 144 | 78 | 10 | 237 | 1087 | 870 | 20 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 19919 | 719 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 24371022 | 24371022 | PRJNA1000943_P_NODE_2520_length_481_cov_3.686275_g2383_i0 | PRJNA1000943 | 2520 | 481 | 3.686275 | 17.73098275 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 287 | 1.18e-72 | NTclustered | gi|218117260|emb|AM980958.1| | 10195 | g2383 | i0 | 79.419 | 3.06652806652807 | 413 | 79 | 85 | 6 | 15 | 424 | 410 | 1 | Brachionus plicatilis partial mRNA for 40S ribosomal protein S11, (RPS11 gene) | blastn | 1475 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;