contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746799 | 746799 | PRJNA770826_P_NODE_1081_length_810_cov_4.078844_g952_i0 | PRJNA770826 | 1081 | 810 | 4.078844 | 33.0386364 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 549 | 2.3699999999999993e-151 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g952 | i0 | 84.146 | 41.8753086419753 | 574 | 83 | 70 | 7 | 4 | 572 | 300 | 870 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 33919 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 2022958 | 2022958 | PRJNA770826_P_NODE_522_length_1098_cov_30.746425_g438_i0 | PRJNA770826 | 522 | 1098 | 30.746425 | 337.5957465 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 497 | 1.19e-135 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g438 | i0 | 81.385 | 25.7167577413479 | 650 | 86 | 58 | 25 | 464 | 1095 | 11195 | 11827 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 28237 | 497 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 5850359 | 5850359 | PRJNA770826_P_NODE_14405_length_212_cov_1.650307_g14234_i0 | PRJNA770826 | 14405 | 212 | 1.650307 | 3.49865084 | Anuraeopsis fissa | 885374 | Rotifera | other_Eukaryota | 115 | 2.3400000000000003e-21 | NTclustered | gi|308156986|gb|GQ890451.1| | 885374 | g14234 | i0 | 81.56 | 0.665094339622642 | 141 | 25 | 67 | 1 | 15 | 155 | 294 | 155 | Anuraeopsis fissa isolate DNA97 large subunit ribosomal RNA gene, partial sequence | blastn | 141 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Anuraeopsis | Anuraeopsis fissa | |
| 7125689 | 7125689 | PRJNA770826_P_NODE_5486_length_361_cov_3.201923_g5315_i0 | PRJNA770826 | 5486 | 361 | 3.201923 | 11.55894203 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 599 | 9.749999999999995e-167 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g5315 | i0 | 96.438 | 86.983379501385 | 365 | 9 | 100 | 3 | 1 | 361 | 1721 | 1357 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 31401 | 599 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 12226644 | 12226644 | PRJNA770826_P_NODE_4050_length_428_cov_3.063325_g3879_i0 | PRJNA770826 | 4050 | 428 | 3.063325 | 13.111031 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 405 | 2.75e-108 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g3879 | i0 | 84.101 | 69.9883177570093 | 434 | 54 | 100 | 8 | 1 | 428 | 733 | 309 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 29955 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 12226677 | 12226677 | PRJNA770826_P_NODE_6790_length_318_cov_2.821561_g6619_i0 | PRJNA770826 | 6790 | 318 | 2.821561 | 8.97256398 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 270 | 7.56e-68 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g6619 | i0 | 86.056 | 75.9025157232704 | 251 | 35 | 79 | 0 | 66 | 316 | 57 | 307 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 24137 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 13500694 | 13500694 | PRJNA770826_P_NODE_4091_length_426_cov_2.246684_g3920_i0 | PRJNA770826 | 4091 | 426 | 2.246684 | 9.57087384 | Synchaeta pectinata | 525906 | Rotifera | other_Eukaryota | 503 | 9.43e-138 | NTclustered | gi|403492659|gb|JX193068.1| | 525906 | g3920 | i0 | 87.559 | 100.173708920188 | 426 | 53 | 100 | 0 | 1 | 426 | 423 | 848 | Synchaeta pectinata isolate A458.2 alpha tubulin gene, partial cds | blastn | 42674 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Synchaeta | Synchaeta pectinata | |
| 16509653 | 16509653 | PRJNA770826_P_NODE_7953_length_289_cov_2.237500_g7782_i0 | PRJNA770826 | 7953 | 289 | 2.2375 | 6.466375 | Ploima | 84394 | Rotifera | other_Eukaryota | 394 | 3.86e-105 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g7782 | i0 | 91.349 | 101.311418685121 | 289 | 24 | 100 | 1 | 1 | 289 | 1437 | 1724 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 29279 | 396 | 0.994949494949495 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 18598666 | 18598666 | PRJNA770826_P_NODE_29755_length_167_cov_0.881356_g29584_i0 | PRJNA770826 | 29755 | 167 | 0.881356 | 1.47186452 | Lepadella triba | 497826 | Rotifera | other_Eukaryota | 303 | 3.5e-78 | NTclustered | gi|166014122|gb|EU252111.1| | 497826 | g29584 | i0 | 99.401 | 1.39520958083832 | 167 | 1 | 100 | 0 | 1 | 167 | 189 | 23 | Lepadella triba internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 233 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella triba | |
| 18598670 | 18598670 | PRJNA770826_P_NODE_30855_length_166_cov_1.341880_g30684_i0 | PRJNA770826 | 30855 | 166 | 1.34188 | 2.2275208 | Lecane hamata | 1213208 | Rotifera | other_Eukaryota | 183 | 4.729999999999999e-42 | NTclustered | gi|1199302037|gb|KY749533.1| | 1213208 | g30684 | i0 | 86.667 | 99.5361445783133 | 165 | 22 | 99 | 0 | 1 | 165 | 413 | 577 | Lecane hamata isolate TIN39AR cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 16523 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane hamata | |
| 19873744 | 19873744 | PRJNA770826_P_NODE_5916_length_346_cov_1.037037_g5745_i0 | PRJNA770826 | 5916 | 346 | 1.037037 | 3.58814802 | Lepadella rhomboides | 360666 | Rotifera | other_Eukaryota | 270 | 8.31e-68 | NTclustered | gi|83321185|gb|DQ297806.1| | 360666 | g5745 | i0 | 85.441 | 80.8208092485549 | 261 | 37 | 75 | 1 | 1 | 261 | 263 | 4 | Lepadella rhomboides histone H3 gene, partial cds | blastn | 27964 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella rhomboides | |
| 20333127 | 20333127 | PRJNA770826_P_NODE_18676_length_187_cov_1.869565_g18505_i0 | PRJNA770826 | 18676 | 187 | 1.869565 | 3.49608655 | Ploima | 84394 | Rotifera | other_Eukaryota | 335 | 1.4199999999999996e-87 | NTclustered | gi|1957252648|gb|MW484998.1| | 1213212 | g18505 | i0 | 98.93 | 100.085561497326 | 187 | 2 | 100 | 0 | 1 | 187 | 1388 | 1574 | Lecane monostyla voucher NNIBRIV50294 small subunit ribosomal RNA gene, partial sequence | blastn | 18716 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane monostyla | |
| 23699792 | 23699792 | PRJNA770826_P_NODE_1419_length_714_cov_2.645113_g1279_i0 | PRJNA770826 | 1419 | 714 | 2.645113 | 18.88610682 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 665 | 0 | NTclustered | gi|2057213576|gb|MZ438220.1| | 204736 | g1279 | i0 | 84.15 | 92.296918767507 | 694 | 102 | 97 | 8 | 19 | 708 | 1 | 690 | Brachionus urceolaris isolate Burc_SB cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 65900 | 665 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 24973516 | 24973516 | PRJNA770826_P_NODE_2560_length_543_cov_2.809717_g2392_i0 | PRJNA770826 | 2560 | 543 | 2.809717 | 15.25676331 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 292 | 2.89e-74 | NTclustered | gi|218117260|emb|AM980958.1| | 10195 | g2392 | i0 | 79.661 | 3.35174953959484 | 413 | 78 | 76 | 6 | 80 | 489 | 410 | 1 | Brachionus plicatilis partial mRNA for 40S ribosomal protein S11, (RPS11 gene) | blastn | 1820 | 292 | 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);;