contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1130581 | 1130581 | PRJNA560932_P_NODE_36821_length_299_cov_4.619469_g36465_i0 | PRJNA560932 | 36821 | 299 | 4.619469 | 13.81221231 | Adineta | 104781 | Rotifera | other_Eukaryota | 532 | 8.139999999999998e-147 | NTclustered | gi|1005055512|gb|KU860655.1| | 1813164 | g36465 | i0 | 98.671 | 26.5585284280936 | 301 | 2 | 100 | 1 | 1 | 299 | 1737 | 1437 | Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence | blastn | 7941 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. A JFF-2016 | |
| 1130588 | 1130588 | PRJNA560932_P_NODE_41721_length_282_cov_5.066986_g41365_i0 | PRJNA560932 | 41721 | 282 | 5.066986 | 14.28890052 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 505 | 1.6599999999999995e-138 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g41365 | i0 | 98.936 | 94.0106382978723 | 282 | 3 | 100 | 0 | 1 | 282 | 502 | 783 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 26511 | 510 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 1820188 | 1820188 | PRJNA560932_P_NODE_16962_length_427_cov_1.166667_g16606_i0 | PRJNA560932 | 16962 | 427 | 1.166667 | 4.98166809 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 440 | 7.519999999999997e-119 | NTclustered | gi|402761725|gb|JX183994.1| | 104786 | g16606 | i0 | 85.315 | 1.97658079625293 | 429 | 59 | 100 | 4 | 1 | 427 | 569 | 143 | Habrotrocha constricta ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 844 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 8197529 | 8197529 | PRJNA560932_P_NODE_27907_length_339_cov_10.932331_g27551_i0 | PRJNA560932 | 27907 | 339 | 10.932331 | 37.06060209 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 595 | 1.1799999999999996e-165 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g27551 | i0 | 100 | 76.2949852507375 | 322 | 0 | 95 | 0 | 18 | 339 | 5 | 326 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 25864 | 595 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 8783505 | 8783505 | PRJNA560932_P_NODE_8987_length_580_cov_5.763314_g8634_i0 | PRJNA560932 | 8987 | 580 | 5.763314 | 33.4272212 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 592 | 2.729999999999999e-164 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g8634 | i0 | 85.915 | 27.4224137931034 | 568 | 65 | 97 | 14 | 20 | 579 | 1843 | 2403 | Rotaria rotatoria mitochondrion, complete genome | blastn | 15905 | 592 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 9473115 | 9473115 | PRJNA560932_P_NODE_19828_length_395_cov_3.055901_g19472_i0 | PRJNA560932 | 19828 | 395 | 3.055901 | 12.07080895 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 547 | 3.9499999999999996e-151 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g19472 | i0 | 93.085 | 44.2658227848101 | 376 | 22 | 95 | 3 | 22 | 395 | 1831 | 2204 | Philodina citrina complete mitochondrial genome | blastn | 17485 | 547 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 10059089 | 10059089 | PRJNA560932_P_NODE_28808_length_335_cov_1.122137_g28452_i0 | PRJNA560932 | 28808 | 335 | 1.122137 | 3.7591589500000002 | Brachionus | 10194 | Rotifera | other_Eukaryota | 150 | 1.09e-31 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g28452 | i0 | 81.383 | 1.12238805970149 | 188 | 31 | 56 | 4 | 17 | 202 | 8446 | 8631 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 376 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 15847753 | 15847753 | PRJNA560932_P_NODE_7113_length_648_cov_2.215652_g6761_i0 | PRJNA560932 | 7113 | 648 | 2.215652 | 14.35742496 | Lepadellidae sp. SHQC150123a | 1804024 | Rotifera | other_Eukaryota | 649 | 0 | NTclustered | gi|1009658444|gb|KU720095.1| | 1804024 | g6761 | i0 | 86.409 | 92.2746913580247 | 596 | 78 | 92 | 3 | 55 | 648 | 1 | 595 | Lepadellidae sp. SHQC150123a cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 59794 | 649 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadellidae sp. SHQC150123a | ||
| 17122341 | 17122341 | PRJNA560932_P_NODE_32694_length_317_cov_1.241803_g32338_i0 | PRJNA560932 | 32694 | 317 | 1.241803 | 3.93651551 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 577 | 3.9599999999999985e-160 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g32338 | i0 | 99.683 | 96.4637223974763 | 315 | 1 | 99 | 0 | 1 | 315 | 376 | 690 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 30579 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 19671071 | 19671071 | PRJNA560932_P_NODE_25676_length_352_cov_1.358423_g25320_i0 | PRJNA560932 | 25676 | 352 | 1.358423 | 4.78164896 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 628 | 1.2099999999999999e-175 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g25320 | i0 | 98.864 | 68.0085227272727 | 352 | 4 | 100 | 0 | 1 | 352 | 2807 | 2456 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 23939 | 628 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22221647 | 22221647 | PRJNA560932_P_NODE_23818_length_364_cov_1.058419_g23462_i0 | PRJNA560932 | 23818 | 364 | 1.058419 | 3.85264516 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 231 | 4.1299999999999995e-56 | NTclustered | gi|1066800230|gb|KX364937.1| | 96890 | g23462 | i0 | 80.872 | 50.4697802197802 | 298 | 53 | 81 | 4 | 68 | 363 | 1439 | 1144 | Brachionus rotundiformis chromosome II mitochondrion, complete sequence | blastn | 18371 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 22221780 | 22221780 | PRJNA560932_P_NODE_40078_length_287_cov_4.214953_g39722_i0 | PRJNA560932 | 40078 | 287 | 4.214953 | 12.09691511 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 529 | 1.01e-145 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g39722 | i0 | 100 | 55.2299651567944 | 286 | 0 | 99 | 0 | 1 | 286 | 1519 | 1804 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 15851 | 529 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 23497129 | 23497129 | PRJNA560932_P_NODE_5039_length_761_cov_9.764535_g4710_i0 | PRJNA560932 | 5039 | 761 | 9.764535 | 74.30811135 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 390 | 1.42e-103 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g4710 | i0 | 77.341 | 26.8672798948752 | 737 | 117 | 94 | 43 | 5 | 722 | 11143 | 10438 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 20446 | 390 | 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);;