contig_metadata
13 rows where bioproject = "PRJNA1255065", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 360521 | 360521 | PRJNA1255065_P_NODE_77241_length_205_cov_1.993590_g75013_i0 | PRJNA1255065 | 77241 | 205 | 1.99359 | 4.0868595 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 276 | 9.76e-70 | NTclustered | gi|477541870|gb|KC603851.1| | 1199090 | g75013 | i0 | 92.67 | 56.4780487804878 | 191 | 14 | 93 | 0 | 3 | 193 | 9980 | 10170 | Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence | blastn | 11578 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 3603828 | 3603828 | PRJNA1255065_P_NODE_53323_length_273_cov_1.535714_g51096_i0 | PRJNA1255065 | 53323 | 273 | 1.535714 | 4.19249922 | Adineta | 104781 | Rotifera | other_Eukaryota | 499 | 7.45e-137 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g51096 | i0 | 99.634 | 100.025641025641 | 273 | 1 | 100 | 0 | 1 | 273 | 846 | 574 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 27307 | 499 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 9288377 | 9288377 | PRJNA1255065_P_NODE_148928_length_162_cov_0.920354_g146700_i0 | PRJNA1255065 | 148928 | 162 | 0.920354 | 1.49097348 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 60.8 | 5.18e-9 | NR | CAF0721530.1 | 104777 | g146700 | i0 | 81.3 | 0.592592592592593 | 32 | 6 | 59.3 | 0 | 96 | 1 | 356 | 387 | CAF0721530.1 unnamed protein product [Brachionus calyciflorus] | diamond | 96 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 16937886 | 16937886 | PRJNA1255065_P_NODE_79714_length_201_cov_1.361842_g77486_i0 | PRJNA1255065 | 79714 | 201 | 1.361842 | 2.73730242 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 102 | 1.23e-26 | NR | CAF0983252.1 | 104777 | g77486 | i0 | 90.4 | 0.776119402985075 | 52 | 5 | 77.6 | 0 | 199 | 44 | 50 | 101 | CAF0983252.1 unnamed protein product [Brachionus calyciflorus] | diamond | 156 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 23312058 | 23312058 | PRJNA1255065_P_NODE_115559_length_168_cov_0.865546_g113331_i0 | PRJNA1255065 | 115559 | 168 | 0.865546 | 1.45411728 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 114 | 2.35e-28 | NR | CAF1008652.1 | 104777 | g113331 | i0 | 92.7 | 1.96428571428571 | 55 | 4 | 98.2 | 0 | 165 | 1 | 251 | 305 | CAF1008652.1 unnamed protein product [Brachionus calyciflorus] | diamond | 330 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26598681 | 26598681 | PRJNA1255065_P_NODE_96381_length_178_cov_1.410853_g94153_i0 | PRJNA1255065 | 96381 | 178 | 1.410853 | 2.51131834 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 70.9 | 1.66e-12 | NR | CAF0756094.1 | 104777 | g94153 | i0 | 77.4 | 0.893258426966292 | 53 | 11 | 89.3 | 1 | 177 | 19 | 319 | 370 | CAF0756094.1 unnamed protein product [Brachionus calyciflorus] | diamond | 159 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28589853 | 28589853 | PRJNA1255065_P_NODE_116727_length_167_cov_0.881356_g114499_i0 | PRJNA1255065 | 116727 | 167 | 0.881356 | 1.47186452 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 77.4 | 7.94e-15 | NR | CAF1050440.1 | 104777 | g114499 | i0 | 73.5 | 0.880239520958084 | 49 | 9 | 88 | 1 | 148 | 2 | 1 | 45 | CAF1050440.1 unnamed protein product [Brachionus calyciflorus] | diamond | 147 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30073663 | 30073663 | PRJNA1255065_P_NODE_111612_length_168_cov_0.873950_g109384_i0 | PRJNA1255065 | 111612 | 168 | 0.87395 | 1.468236 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 63.5 | 6.08e-10 | NR | CAF0727616.1 | 104777 | g109384 | i0 | 93.9 | 1.17857142857143 | 33 | 2 | 58.9 | 0 | 2 | 100 | 1079 | 1111 | CAF0727616.1 unnamed protein product [Brachionus calyciflorus] | diamond | 198 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30705606 | 30705606 | PRJNA1255065_P_NODE_142314_length_163_cov_0.912281_g140086_i0 | PRJNA1255065 | 142314 | 163 | 0.912281 | 1.48701803 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 57.4 | 8.55e-8 | NR | CAF1091672.1 | 104777 | g140086 | i0 | 51.9 | 3.82822085889571 | 52 | 25 | 95.7 | 0 | 160 | 5 | 323 | 374 | CAF1091672.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 624 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30832066 | 30832066 | PRJNA1255065_P_NODE_150954_length_162_cov_0.920354_g148726_i0 | PRJNA1255065 | 150954 | 162 | 0.920354 | 1.49097348 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 58.2 | 4.3e-8 | NR | CAF1360961.1 | 433720 | g148726 | i0 | 82.8 | 2.14814814814815 | 29 | 5 | 53.7 | 0 | 158 | 72 | 340 | 368 | CAF1360961.1 unnamed protein product [Adineta steineri] | diamond | 348 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31432607 | 31432607 | PRJNA1255065_P_NODE_11376_length_855_cov_3.090571_g9699_i0 | PRJNA1255065 | 11376 | 855 | 3.090571 | 26.42438205 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 107 | 4.92e-24 | NR | CAF0950857.1 | 104777 | g9699 | i0 | 33 | 0.670175438596491 | 191 | 111 | 62.5 | 5 | 788 | 255 | 4 | 190 | CAF0950857.1 unnamed protein product [Brachionus calyciflorus] | diamond | 573 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31545598 | 31545598 | PRJNA1255065_P_NODE_119296_length_167_cov_0.881356_g117068_i0 | PRJNA1255065 | 119296 | 167 | 0.881356 | 1.47186452 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0013 | NR | UJR20269.1 | 104782 | g117068 | i0 | 36.4 | 8.80239520958084 | 55 | 35 | 98.8 | 0 | 1 | 165 | 10 | 64 | UJR20269.1 hypothetical protein I4U23_023400 [Adineta vaga] | diamond | 1470 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32854824 | 32854824 | PRJNA1255065_P_NODE_153460_length_162_cov_0.911504_g151232_i0 | PRJNA1255065 | 153460 | 162 | 0.911504 | 1.47663648 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 110 | 2.31e-26 | NR | RNA09346.1 | 10195 | g151232 | i0 | 92.6 | 1 | 54 | 4 | 100 | 0 | 1 | 162 | 504 | 557 | RNA09346.1 Serine threonine- kinase PLK1 [Brachionus plicatilis] | diamond | 162 | 110 | 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);;