contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3400437 | 3400437 | PRJNA870096_S_NODE_13403_length_501_cov_14.157205_g11773_i0 | PRJNA870096 | 13403 | 501 | 14.157205 | 70.92759705 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 335 | 4.339999999999999e-87 | NTclustered | gi|1066800230|gb|KX364937.1| | 96890 | g11773 | i0 | 79.339 | 54.5329341317365 | 484 | 94 | 96 | 5 | 19 | 499 | 1552 | 1072 | Brachionus rotundiformis chromosome II mitochondrion, complete sequence | blastn | 27321 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 3400947 | 3400947 | PRJNA870096_S_NODE_48383_length_253_cov_7.961905_g46719_i0 | PRJNA870096 | 48383 | 253 | 7.961905 | 20.14361965 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 407 | 4.2500000000000005e-109 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g46719 | i0 | 98.69 | 32.2252964426877 | 229 | 3 | 91 | 0 | 1 | 229 | 2028 | 1800 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 8153 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 4678280 | 4678280 | PRJNA870096_S_NODE_20684_length_398_cov_14.047887_g19026_i0 | PRJNA870096 | 20684 | 398 | 14.047887 | 55.91059026 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 222 | 2.75e-53 | NTclustered | gi|1999716433|gb|MT875425.1| | 396692 | g19026 | i0 | 79.747 | 4.28643216080402 | 316 | 57 | 78 | 6 | 42 | 352 | 8626 | 8313 | Brachionus angularis chromosome I mitochondrion, complete sequence | blastn | 1706 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 7228382 | 7228382 | PRJNA870096_S_NODE_50446_length_248_cov_1.570732_g48782_i0 | PRJNA870096 | 50446 | 248 | 1.570732 | 3.89541536 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 182 | 2.74e-41 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g48782 | i0 | 80.242 | 4.05241935483871 | 248 | 44 | 99 | 5 | 1 | 246 | 656 | 412 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 1005 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 11054264 | 11054264 | PRJNA870096_S_NODE_8129_length_652_cov_25.981938_g6672_i0 | PRJNA870096 | 8129 | 652 | 25.981938 | 169.40223576 | Brachionus manjavacas | 667381 | Rotifera | other_Eukaryota | 545 | 2.44e-150 | NTclustered | gi|2006240385|gb|MW559988.1| | 667381 | g6672 | i0 | 84.103 | 55.2622699386503 | 585 | 71 | 88 | 16 | 61 | 637 | 9935 | 10505 | Brachionus manjavacas isolate DE chromosome I mitochondrion, complete sequence | blastn | 36031 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus manjavacas | |
| 12329690 | 12329690 | PRJNA870096_S_NODE_80730_length_195_cov_1.894737_g79066_i0 | PRJNA870096 | 80730 | 195 | 1.894737 | 3.69473715 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 272 | 1.19e-68 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g79066 | i0 | 91.795 | 73.8461538461538 | 195 | 16 | 100 | 0 | 1 | 195 | 7 | 201 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 14400 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 14878298 | 14878298 | PRJNA870096_S_NODE_59712_length_227_cov_1.565217_g58048_i0 | PRJNA870096 | 59712 | 227 | 1.565217 | 3.55304259 | Lecane sp. bulla5 | 1225232 | Rotifera | other_Eukaryota | 195 | 3.17e-45 | NTclustered | gi|401880185|gb|JX216660.1| | 1225232 | g58048 | i0 | 82.018 | 72.2114537444934 | 228 | 40 | 100 | 1 | 1 | 227 | 340 | 567 | Lecane sp. bulla5 voucher ECOCHZ-AG0858 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 16392 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane sp. bulla5 | |
| 23801493 | 23801493 | PRJNA870096_S_NODE_104559_length_173_cov_1.476923_g102895_i0 | PRJNA870096 | 104559 | 173 | 1.476923 | 2.55507679 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 122 | 1.0899999999999999e-23 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g102895 | i0 | 80 | 0.982658959537572 | 170 | 30 | 97 | 3 | 1 | 167 | 5806 | 5974 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 170 | 122 | 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);;