contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26651954 | 26651954 | PRJNA946307_P_NODE_159801_length_162_cov_2.672566_g158927_i0 | PRJNA946307 | 159801 | 162 | 2.672566 | 4.32955692 | Metazoa | 33208 | Rotifera | other_Eukaryota | 49.3 | 6.19e-5 | NR | CAF1500307.1 | 249248 | g158927 | i0 | 63.3 | 8.81481481481481 | 30 | 11 | 55.6 | 0 | 61 | 150 | 230 | 259 | CAF1500307.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1428 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26708627 | 26708627 | PRJNA946307_P_NODE_97701_length_185_cov_2.095588_g96827_i0 | PRJNA946307 | 97701 | 185 | 2.095588 | 3.8768378 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 68.2 | 1.47e-12 | NR | CAF4291091.1 | 433720 | g96827 | i0 | 71.7 | 1.52432432432432 | 46 | 13 | 74.6 | 0 | 33 | 170 | 36 | 81 | CAF4291091.1 unnamed protein product, partial [Adineta steineri] | diamond | 282 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 26835738 | 26835738 | PRJNA946307_P_NODE_87921_length_189_cov_3.928571_g87047_i0 | PRJNA946307 | 87921 | 189 | 3.928571 | 7.42499919 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.5 | 1.52e-4 | NR | CAF4154135.1 | 433720 | g87047 | i0 | 54.5 | 1.04761904761905 | 33 | 15 | 52.4 | 0 | 187 | 89 | 224 | 256 | CAF4154135.1 unnamed protein product, partial [Adineta steineri] | diamond | 198 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27025454 | 27025454 | PRJNA946307_P_NODE_74922_length_197_cov_4.554054_g74048_i0 | PRJNA946307 | 74922 | 197 | 4.554054 | 8.97148638 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.9 | 8.98e-5 | NR | CAF4223994.1 | 433720 | g74048 | i0 | 44.9 | 2.14720812182741 | 49 | 27 | 74.6 | 0 | 15 | 161 | 148 | 196 | CAF4223994.1 unnamed protein product, partial [Adineta steineri] | diamond | 423 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28383421 | 28383421 | PRJNA946307_P_NODE_122566_length_174_cov_1.560000_g121692_i0 | PRJNA946307 | 122566 | 174 | 1.56 | 2.7144 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 43.5 | 0.00804 | NR | UJR08207.1 | 104782 | g121692 | i0 | 42.2 | 0.775862068965517 | 45 | 20 | 77.6 | 1 | 31 | 165 | 251 | 289 | UJR08207.1 hypothetical protein I4U23_012480 [Adineta vaga] | diamond | 135 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28383429 | 28383429 | PRJNA946307_P_NODE_13746_length_351_cov_3.533113_g12876_i0 | PRJNA946307 | 13746 | 351 | 3.533113 | 12.40122663 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 55.1 | 1.23e-7 | NR | CAF4402485.1 | 433720 | g12876 | i0 | 69 | 0.358974358974359 | 42 | 13 | 35.9 | 0 | 312 | 187 | 1 | 42 | CAF4402485.1 unnamed protein product, partial [Adineta steineri] | diamond | 126 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29078224 | 29078224 | PRJNA946307_P_NODE_109488_length_180_cov_1.473282_g108614_i0 | PRJNA946307 | 109488 | 180 | 1.473282 | 2.6519076 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 67.8 | 1.92e-12 | NR | CAF4291091.1 | 433720 | g108614 | i0 | 56.4 | 0.916666666666667 | 55 | 24 | 91.7 | 0 | 15 | 179 | 33 | 87 | CAF4291091.1 unnamed protein product, partial [Adineta steineri] | diamond | 165 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29173051 | 29173051 | PRJNA946307_P_NODE_58349_length_210_cov_2.440994_g57475_i0 | PRJNA946307 | 58349 | 210 | 2.440994 | 5.1260874 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 42.4 | 0.0316 | NR | CAF4239880.1 | 433720 | g57475 | i0 | 48.5 | 0.942857142857143 | 33 | 17 | 47.1 | 0 | 2 | 100 | 163 | 195 | CAF4239880.1 unnamed protein product, partial [Adineta steineri] | diamond | 198 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29520035 | 29520035 | PRJNA946307_P_NODE_117110_length_176_cov_2.921260_g116236_i0 | PRJNA946307 | 117110 | 176 | 2.92126 | 5.1414176 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 59.7 | 2.33e-9 | NR | CAF4431391.1 | 433720 | g116236 | i0 | 61.9 | 0.715909090909091 | 42 | 16 | 71.6 | 0 | 5 | 130 | 52 | 93 | CAF4431391.1 unnamed protein product, partial [Adineta steineri] | diamond | 126 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29804175 | 29804175 | PRJNA946307_P_NODE_113571_length_178_cov_1.511628_g112697_i0 | PRJNA946307 | 113571 | 178 | 1.511628 | 2.69069784 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 61.2 | 4.48e-10 | NR | CAF1092243.1 | 104777 | g112697 | i0 | 62.5 | 0.808988764044944 | 48 | 18 | 80.9 | 0 | 12 | 155 | 58 | 105 | CAF1092243.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 144 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30373342 | 30373342 | PRJNA946307_P_NODE_121372_length_174_cov_3.472000_g120498_i0 | PRJNA946307 | 121372 | 174 | 3.472 | 6.04128 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 54.3 | 6.03e-8 | NR | CAF4445048.1 | 433720 | g120498 | i0 | 51.1 | 1.58620689655172 | 45 | 22 | 77.6 | 0 | 137 | 3 | 6 | 50 | CAF4445048.1 unnamed protein product, partial [Adineta steineri] | diamond | 276 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31826889 | 31826889 | PRJNA946307_P_NODE_46417_length_210_cov_4.521739_g45543_i0 | PRJNA946307 | 46417 | 210 | 4.521739 | 9.4956519 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 58.5 | 4.29e-9 | NR | CAF1536037.1 | 433720 | g45543 | i0 | 68.8 | 0.914285714285714 | 32 | 10 | 45.7 | 0 | 207 | 112 | 47 | 78 | CAF1536037.1 unnamed protein product, partial [Adineta steineri] | diamond | 192 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32016812 | 32016812 | PRJNA946307_P_NODE_139998_length_167_cov_1.652542_g139124_i0 | PRJNA946307 | 139998 | 167 | 1.652542 | 2.75974514 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.1 | 1.66e-4 | NR | CAF4104489.1 | 433720 | g139124 | i0 | 57.6 | 0.592814371257485 | 33 | 14 | 59.3 | 0 | 99 | 1 | 486 | 518 | CAF4104489.1 unnamed protein product, partial [Adineta steineri] | diamond | 99 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32111816 | 32111816 | PRJNA946307_P_NODE_15478_length_327_cov_2.992806_g14608_i0 | PRJNA946307 | 15478 | 327 | 2.992806 | 9.78647562 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 65.9 | 3.6e-11 | NR | CAF1516412.1 | 433720 | g14608 | i0 | 43.1 | 1.98165137614679 | 72 | 40 | 65.1 | 1 | 14 | 226 | 33 | 104 | CAF1516412.1 unnamed protein product [Adineta steineri] | diamond | 648 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32435198 | 32435198 | PRJNA946307_P_NODE_142659_length_166_cov_4.598291_g141785_i0 | PRJNA946307 | 142659 | 166 | 4.598291 | 7.63316306 | root | 1 | Root_unresolved | Root_unresolved | 51.6 | 1.07e-6 | NR | CAF1528154.1 | 433720 | g141785 | i0 | 52.3 | 3.07228915662651 | 44 | 21 | 79.5 | 0 | 137 | 6 | 19 | 62 | CAF1528154.1 unnamed protein product, partial [Adineta steineri] | diamond | 510 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32680513 | 32680513 | PRJNA946307_P_NODE_165020_length_160_cov_3.315315_g164146_i0 | PRJNA946307 | 165020 | 160 | 3.315315 | 5.304504 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52.8 | 4.58e-7 | NR | CAF4129484.1 | 433720 | g164146 | i0 | 57.4 | 0.88125 | 47 | 20 | 88.1 | 0 | 19 | 159 | 47 | 93 | CAF4129484.1 unnamed protein product [Adineta steineri] | diamond | 141 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32806698 | 32806698 | PRJNA946307_P_NODE_42200_length_211_cov_5.697531_g41326_i0 | PRJNA946307 | 42200 | 211 | 5.697531 | 12.02179041 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 85.5 | 4.27e-18 | NR | CAF4225657.1 | 433720 | g41326 | i0 | 62.5 | 3.07109004739337 | 72 | 20 | 92.4 | 1 | 195 | 1 | 178 | 249 | CAF4225657.1 unnamed protein product, partial [Adineta steineri] | diamond | 648 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri |
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);;