contig_metadata
16 rows where bioproject = "PRJNA888821", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7619860 | 7619860 | PRJNA888821_P_NODE_29806_length_271_cov_1.085859_g29723_i0 | PRJNA888821 | 29806 | 271 | 1.085859 | 2.94267789 | Metazoa | 33208 | Rotifera | other_Eukaryota | 457 | 4.5099999999999986e-124 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g29723 | i0 | 97.048 | 49.0369003690037 | 271 | 8 | 100 | 0 | 1 | 271 | 3036 | 2766 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 13289 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 26746474 | 26746474 | PRJNA888821_P_NODE_46041_length_217_cov_17.763889_g45958_i0 | PRJNA888821 | 46041 | 217 | 17.763889 | 38.54763913 | Rotaria | 231623 | Rotifera | other_Eukaryota | 48.5 | 2.46e-4 | NR | CAF4657051.1 | 2762511 | g45958 | i0 | 80 | 1.70046082949309 | 30 | 6 | 41.5 | 0 | 117 | 28 | 332 | 361 | CAF4657051.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 369 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27750706 | 27750706 | PRJNA888821_P_NODE_47784_length_212_cov_7.604317_g47701_i0 | PRJNA888821 | 47784 | 212 | 7.604317 | 16.12115204 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 53.9 | 2.82e-6 | NR | CAF2108603.1 | 392030 | g47701 | i0 | 39.4 | 0.933962264150943 | 66 | 38 | 92 | 2 | 199 | 5 | 81 | 145 | CAF2108603.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 198 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27845019 | 27845019 | PRJNA888821_P_NODE_49464_length_207_cov_8.052239_g49381_i0 | PRJNA888821 | 49464 | 207 | 8.052239 | 16.66813473 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 104 | 4.94e-25 | NR | CAF1559096.1 | 392033 | g49381 | i0 | 69.7 | 1.91304347826087 | 66 | 20 | 95.7 | 0 | 1 | 198 | 163 | 228 | CAF1559096.1 unnamed protein product, partial [Rotaria sordida] | diamond | 396 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28571326 | 28571326 | PRJNA888821_P_NODE_42787_length_229_cov_5.141026_g42704_i0 | PRJNA888821 | 42787 | 229 | 5.141026 | 11.77294954 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 77.4 | 1.93e-14 | NR | CAF0888219.1 | 249248 | g42704 | i0 | 94.6 | 0.48471615720524 | 37 | 2 | 48.5 | 0 | 2 | 112 | 758 | 794 | CAF0888219.1 unnamed protein product [Adineta ricciae] | diamond | 111 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29392405 | 29392405 | PRJNA888821_P_NODE_29049_length_274_cov_4.417910_g28967_i0 | PRJNA888821 | 29049 | 274 | 4.41791 | 12.1050734 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 52.4 | 1.52e-6 | NR | CAF5164037.1 | 2762511 | g28967 | i0 | 84 | 1.04014598540146 | 25 | 4 | 27.4 | 0 | 251 | 177 | 59 | 83 | CAF5164037.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 285 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29589285 | 29589285 | PRJNA888821_P_NODE_46930_length_215_cov_4.119718_g46847_i0 | PRJNA888821 | 46930 | 215 | 4.119718 | 8.8573937 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 75.5 | 7.54e-14 | NR | UJR30781.1 | 104782 | g46847 | i0 | 94.3 | 8.8046511627907 | 35 | 2 | 48.8 | 0 | 55 | 159 | 281 | 315 | UJR30781.1 hypothetical protein I4U23_018301 [Adineta vaga] | diamond | 1893 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30055336 | 30055336 | PRJNA888821_P_NODE_45311_length_220_cov_7.564626_g45228_i0 | PRJNA888821 | 45311 | 220 | 7.564626 | 16.6421772 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 44.3 | 0.00524 | NR | CAF3763794.1 | 392030 | g45228 | i0 | 55.3 | 4.2 | 38 | 17 | 51.8 | 0 | 107 | 220 | 93 | 130 | CAF3763794.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 924 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30277004 | 30277004 | PRJNA888821_P_NODE_43332_length_227_cov_7.220779_g43249_i0 | PRJNA888821 | 43332 | 227 | 7.220779 | 16.39116833 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 110 | 6.020000000000001e-27 | NR | CAF4914302.1 | 2762511 | g43249 | i0 | 68 | 2.97356828193833 | 75 | 5 | 99.1 | 1 | 1 | 225 | 132 | 187 | CAF4914302.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 675 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30790025 | 30790025 | PRJNA888821_P_NODE_51354_length_202_cov_5.178295_g51271_i0 | PRJNA888821 | 51354 | 202 | 5.178295 | 10.4601559 | Rotaria | 231623 | Rotifera | other_Eukaryota | 49.7 | 7.44e-5 | NR | CAF4286789.1 | 392032 | g51271 | i0 | 61.3 | 2.3019801980198 | 31 | 12 | 46 | 0 | 197 | 105 | 363 | 393 | CAF4286789.1 unnamed protein product [Rotaria socialis] | diamond | 465 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 31224387 | 31224387 | PRJNA888821_P_NODE_45455_length_219_cov_15.815068_g45372_i0 | PRJNA888821 | 45455 | 219 | 15.815068 | 34.63499892 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 53.1 | 5.73e-6 | NR | CAF3361161.1 | 2762512 | g45372 | i0 | 66.7 | 4.16438356164384 | 39 | 13 | 53.4 | 0 | 215 | 99 | 643 | 681 | CAF3361161.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 912 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31896585 | 31896585 | PRJNA888821_P_NODE_19277_length_310_cov_3.303797_g19195_i0 | PRJNA888821 | 19277 | 310 | 3.303797 | 10.2417707 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 58.5 | 2.34e-7 | NR | CAF0959785.1 | 249248 | g19195 | i0 | 52 | 5.32258064516129 | 50 | 24 | 48.4 | 0 | 1 | 150 | 541 | 590 | CAF0959785.1 unnamed protein product [Adineta ricciae] | diamond | 1650 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31983612 | 31983612 | PRJNA888821_P_NODE_43978_length_225_cov_6.151316_g43895_i0 | PRJNA888821 | 43978 | 225 | 6.151316 | 13.840461 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 71.6 | 1.98e-12 | NR | CAF0854622.1 | 104777 | g43895 | i0 | 80.5 | 0.546666666666667 | 41 | 8 | 54.7 | 0 | 225 | 103 | 308 | 348 | CAF0854622.1 unnamed protein product [Brachionus calyciflorus] | diamond | 123 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32268623 | 32268623 | PRJNA888821_P_NODE_37838_length_244_cov_4.754386_g37755_i0 | PRJNA888821 | 37838 | 244 | 4.754386 | 11.60070184 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 73.6 | 3.96e-13 | NR | CAF1317403.1 | 249248 | g37755 | i0 | 68 | 0.614754098360656 | 50 | 16 | 61.5 | 0 | 34 | 183 | 241 | 290 | CAF1317403.1 unnamed protein product [Adineta ricciae] | diamond | 150 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32805126 | 32805126 | PRJNA888821_P_NODE_50420_length_204_cov_12.541985_g50337_i0 | PRJNA888821 | 50420 | 204 | 12.541985 | 25.5856494 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 56.6 | 2.8e-7 | NR | CAF0835392.1 | 392033 | g50337 | i0 | 100 | 1.83823529411765 | 25 | 0 | 36.8 | 0 | 129 | 203 | 685 | 709 | CAF0835392.1 unnamed protein product [Rotaria sordida] | diamond | 375 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32812965 | 32812965 | PRJNA888821_P_NODE_36280_length_247_cov_12.534483_g36197_i0 | PRJNA888821 | 36280 | 247 | 12.534483 | 30.96017301 | Rotaria | 231623 | Rotifera | other_Eukaryota | 102 | 2e-24 | NR | CAF1540129.1 | 392033 | g36197 | i0 | 80.3 | 2.58704453441296 | 71 | 12 | 83.8 | 2 | 247 | 41 | 195 | 265 | CAF1540129.1 unnamed protein product, partial [Rotaria sordida] | diamond | 639 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida |
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);;