contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 393442 | 393442 | PRJNA345071_P_NODE_581_length_652_cov_3.150259_g541_i0 | PRJNA345071 | 581 | 652 | 3.150259 | 20.53968868 | Asplanchna brightwellii | 2005548 | Rotifera | other_Eukaryota | 333 | 2.0700000000000002e-86 | NTclustered | gi|2906176134|gb|PV021768.1| | 2005548 | g541 | i0 | 79.276 | 3.55674846625767 | 497 | 87 | 75 | 15 | 99 | 587 | 6207 | 5719 | Asplanchna brightwellii chromosome II mitochondrion, complete sequence | blastn | 2319 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna brightwellii | |
| 4220588 | 4220588 | PRJNA345071_P_NODE_324_length_817_cov_2.764785_g287_i0 | PRJNA345071 | 324 | 817 | 2.764785 | 22.58829345 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 678 | 0 | NTclustered | gi|403082251|gb|JX463650.1| | 104777 | g287 | i0 | 82.256 | 85.265605875153 | 789 | 136 | 96 | 4 | 1 | 787 | 811 | 25 | Brachionus calyciflorus cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 69662 | 678 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 8046635 | 8046635 | PRJNA345071_P_NODE_487_length_701_cov_13.527070_g448_i0 | PRJNA345071 | 487 | 701 | 13.52707 | 94.8247607 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 486 | 1.62e-132 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g448 | i0 | 81.211 | 39.9144079885877 | 644 | 85 | 89 | 26 | 1 | 625 | 11821 | 11195 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 27980 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 10597107 | 10597107 | PRJNA345071_P_NODE_549_length_666_cov_2.458685_g509_i0 | PRJNA345071 | 549 | 666 | 2.458685 | 16.3748421 | Proales similis | 360698 | Rotifera | other_Eukaryota | 520 | 1.5099999999999999e-142 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g509 | i0 | 81.045 | 57.1801801801802 | 670 | 112 | 99 | 15 | 3 | 666 | 11803 | 12463 | Proales similis mitochondrion, complete genome | blastn | 38082 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 15695908 | 15695908 | PRJNA345071_P_NODE_133_length_1125_cov_32.077947_g116_i0 | PRJNA345071 | 133 | 1125 | 32.077947 | 360.87690375 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 433 | 3.5e-116 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g116 | i0 | 75.556 | 14.6568888888889 | 1035 | 170 | 88 | 72 | 11 | 1005 | 2406 | 1415 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 16489 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 15695920 | 15695920 | PRJNA345071_P_NODE_1913_length_407_cov_1.383234_g1873_i0 | PRJNA345071 | 1913 | 407 | 1.383234 | 5.62976238 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 558 | 1.89e-154 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g1873 | i0 | 91.443 | 65.4299754299754 | 409 | 32 | 100 | 3 | 1 | 407 | 733 | 326 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 26630 | 558 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 18244922 | 18244922 | PRJNA345071_P_NODE_4535_length_299_cov_1.672566_g4495_i0 | PRJNA345071 | 4535 | 299 | 1.672566 | 5.00097234 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 130 | 1.25e-25 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g4495 | i0 | 80.226 | 35.8929765886288 | 177 | 32 | 59 | 3 | 125 | 299 | 11252 | 11427 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 10732 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 23345199 | 23345199 | PRJNA345071_P_NODE_179_length_1043_cov_1.725773_g155_i0 | PRJNA345071 | 179 | 1043 | 1.725773 | 17.99981239 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 795 | 0 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g155 | i0 | 80.516 | 54.8350910834132 | 1047 | 194 | 99 | 10 | 1 | 1042 | 1216 | 175 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 57193 | 795 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens |
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);;