contig_metadata
22 rows where bioproject = "PRJNA1240805", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16352952 | 16352952 | PRJNA1240805_P_NODE_4153_length_225_cov_5.448864_g4104_i0 | PRJNA1240805 | 4153 | 225 | 5.448864 | 12.259944 | Brachionidae | 10193 | Rotifera | other_Eukaryota | 342 | 1.0599999999999999e-89 | NTclustered | gi|2177087|gb|U49911.1|BPU49911 | 10195 | g4104 | i0 | 97.044 | 90.2044444444444 | 203 | 6 | 90 | 0 | 1 | 203 | 1640 | 1438 | Brachionus plicatilis 18S rRNA gene, complete sequence | blastn | 20296 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 16352953 | 16352953 | PRJNA1240805_P_NODE_4173_length_224_cov_14.291429_g4124_i0 | PRJNA1240805 | 4173 | 224 | 14.291429 | 32.01280096 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 76.3 | 4.47e-14 | NR | CAF1338083.1 | 249248 | g4124 | i0 | 82.9 | 10.9821428571429 | 41 | 7 | 54.9 | 0 | 190 | 68 | 18 | 58 | CAF1338083.1 unnamed protein product, partial [Adineta ricciae] | diamond | 2460 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 19475462 | 19475462 | PRJNA1240805_P_NODE_2276_length_315_cov_17.575188_g2227_i0 | PRJNA1240805 | 2276 | 315 | 17.575188 | 55.3618422 | Platyias quadricornis | 360688 | Rotifera | other_Eukaryota | 309 | 1.58e-79 | NTclustered | gi|308156994|gb|GQ890459.1| | 360688 | g2227 | i0 | 86.254 | 41.4793650793651 | 291 | 33 | 92 | 3 | 1 | 291 | 633 | 350 | Platyias quadricornis isolate DNA197 large subunit ribosomal RNA gene, partial sequence | blastn | 13066 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Platyias | Platyias quadricornis | |
| 19475487 | 19475487 | PRJNA1240805_P_NODE_4176_length_224_cov_8.657143_g4127_i0 | PRJNA1240805 | 4176 | 224 | 8.657143 | 19.39200032 | Proales similis | 360698 | Rotifera | other_Eukaryota | 189 | 1.4499999999999999e-43 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g4127 | i0 | 94.309 | 6.07142857142857 | 123 | 7 | 55 | 0 | 47 | 169 | 12362 | 12484 | Proales similis mitochondrion, complete genome | blastn | 1360 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 20176675 | 20176675 | PRJNA1240805_P_NODE_2076_length_334_cov_34.764912_g2027_i0 | PRJNA1240805 | 2076 | 334 | 34.764912 | 116.11480608 | Lecane | 96445 | Rotifera | other_Eukaryota | 420 | 7.49e-113 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g2027 | i0 | 91.586 | 53.9311377245509 | 309 | 18 | 91 | 6 | 11 | 313 | 2091 | 1785 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 18013 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 24575779 | 24575779 | PRJNA1240805_P_NODE_5560_length_193_cov_6.312500_g5511_i0 | PRJNA1240805 | 5560 | 193 | 6.3125 | 12.183125 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 147 | 7.419999999999999e-31 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g5511 | i0 | 82.738 | 35.6735751295337 | 168 | 25 | 87 | 3 | 22 | 189 | 11235 | 11398 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 6885 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 26724954 | 26724954 | PRJNA1240805_P_NODE_3161_length_262_cov_4.004695_g3112_i0 | PRJNA1240805 | 3161 | 262 | 4.004695 | 10.4923009 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 85.9 | 1.93e-18 | NR | CAF0897745.1 | 104777 | g3112 | i0 | 83.3 | 0.618320610687023 | 54 | 9 | 61.8 | 0 | 23 | 184 | 155 | 208 | CAF0897745.1 unnamed protein product [Brachionus calyciflorus] | diamond | 162 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27484360 | 27484360 | PRJNA1240805_P_NODE_4563_length_214_cov_8.490909_g4514_i0 | PRJNA1240805 | 4563 | 214 | 8.490909 | 18.17054526 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 83.6 | 9.79e-17 | NR | CAF1125919.1 | 1234261 | g4514 | i0 | 68.4 | 7.09345794392523 | 57 | 18 | 79.9 | 0 | 41 | 211 | 38 | 94 | CAF1125919.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 1518 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27547497 | 27547497 | PRJNA1240805_P_NODE_1824_length_359_cov_4.209677_g1775_i0 | PRJNA1240805 | 1824 | 359 | 4.209677 | 15.11274043 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 55.5 | 1.14e-7 | NR | RNA00457.1 | 10195 | g1775 | i0 | 75 | 0.902506963788301 | 36 | 9 | 30.1 | 0 | 22 | 129 | 15 | 50 | RNA00457.1 NAD(P)H:quinone type IV, partial [Brachionus plicatilis] | diamond | 324 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27579033 | 27579033 | PRJNA1240805_P_NODE_3124_length_264_cov_5.920930_g3075_i0 | PRJNA1240805 | 3124 | 264 | 5.92093 | 15.6312552 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 116 | 2.75e-31 | NR | RNA29896.1 | 10195 | g3075 | i0 | 82.3 | 0.704545454545455 | 62 | 11 | 70.5 | 0 | 24 | 209 | 76 | 137 | RNA29896.1 40S ribosomal S12 [Brachionus plicatilis] | diamond | 186 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27894723 | 27894723 | PRJNA1240805_P_NODE_6505_length_179_cov_11.761538_g6456_i0 | PRJNA1240805 | 6505 | 179 | 11.761538 | 21.05315302 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 84.7 | 2.41e-17 | NR | CAF0763792.1 | 104777 | g6456 | i0 | 76 | 0.837988826815642 | 50 | 12 | 83.8 | 0 | 24 | 173 | 399 | 448 | CAF0763792.1 unnamed protein product [Brachionus calyciflorus] | diamond | 150 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27989628 | 27989628 | PRJNA1240805_P_NODE_6045_length_186_cov_2.233577_g5996_i0 | PRJNA1240805 | 6045 | 186 | 2.233577 | 4.15445322 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 72.4 | 5.48e-15 | NR | RNA40478.1 | 10195 | g5996 | i0 | 92.3 | 0.629032258064516 | 39 | 3 | 62.9 | 0 | 2 | 118 | 36 | 74 | RNA40478.1 60S ribosomal L38 [Brachionus plicatilis] | diamond | 117 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28178739 | 28178739 | PRJNA1240805_P_NODE_6666_length_177_cov_5.312500_g6617_i0 | PRJNA1240805 | 6666 | 177 | 5.3125 | 9.403125 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 81.3 | 4.01e-16 | NR | CAF0825505.1 | 104777 | g6617 | i0 | 72.5 | 0.864406779661017 | 51 | 14 | 86.4 | 0 | 24 | 176 | 877 | 927 | CAF0825505.1 unnamed protein product [Brachionus calyciflorus] | diamond | 153 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28652644 | 28652644 | PRJNA1240805_P_NODE_4607_length_213_cov_6.402439_g4558_i0 | PRJNA1240805 | 4607 | 213 | 6.402439 | 13.63719507 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 72.4 | 8.75e-13 | NR | CAF0734485.1 | 104777 | g4558 | i0 | 48.3 | 0.845070422535211 | 60 | 31 | 84.5 | 0 | 191 | 12 | 424 | 483 | CAF0734485.1 unnamed protein product [Brachionus calyciflorus] | diamond | 180 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30439405 | 30439405 | PRJNA1240805_P_NODE_6733_length_176_cov_9.921260_g6684_i0 | PRJNA1240805 | 6733 | 176 | 9.92126 | 17.4614176 | Brachionus | 10194 | Rotifera | other_Eukaryota | 77 | 8.17e-15 | NR | RNA02595.1 | 10195 | g6684 | i0 | 69.2 | 1.75568181818182 | 52 | 16 | 88.6 | 0 | 157 | 2 | 65 | 116 | RNA02595.1 elongation factor 1-gamma, partial [Brachionus plicatilis] | diamond | 309 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30452966 | 30452966 | PRJNA1240805_P_NODE_4453_length_217_cov_2.386905_g4404_i0 | PRJNA1240805 | 4453 | 217 | 2.386905 | 5.17958385 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 71.6 | 2.9e-13 | NR | CAF0870909.1 | 104777 | g4404 | i0 | 88.6 | 0.483870967741935 | 35 | 4 | 48.4 | 0 | 197 | 93 | 169 | 203 | CAF0870909.1 unnamed protein product [Brachionus calyciflorus] | diamond | 105 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30610534 | 30610534 | PRJNA1240805_P_NODE_3173_length_262_cov_2.253521_g3124_i0 | PRJNA1240805 | 3173 | 262 | 2.253521 | 5.90422502 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 100 | 1.15e-24 | NR | CAF0865306.1 | 104777 | g3124 | i0 | 73.5 | 1.55725190839695 | 68 | 18 | 77.9 | 0 | 7 | 210 | 77 | 144 | CAF0865306.1 unnamed protein product [Brachionus calyciflorus] | diamond | 408 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30926853 | 30926853 | PRJNA1240805_P_NODE_5694_length_191_cov_5.676056_g5645_i0 | PRJNA1240805 | 5694 | 191 | 5.676056 | 10.84126696 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 63.5 | 5.25e-10 | NR | RMZ93438.1 | 10195 | g5645 | i0 | 50.9 | 0.832460732984293 | 53 | 26 | 83.2 | 0 | 179 | 21 | 28 | 80 | RMZ93438.1 hypothetical protein BpHYR1_011371 [Brachionus plicatilis] | diamond | 159 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31021476 | 31021476 | PRJNA1240805_P_NODE_6755_length_176_cov_3.976378_g6706_i0 | PRJNA1240805 | 6755 | 176 | 3.976378 | 6.99842528 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 89.7 | 1.41e-20 | NR | RMZ95576.1 | 10195 | g6706 | i0 | 76.9 | 8.59090909090909 | 52 | 12 | 88.6 | 0 | 166 | 11 | 142 | 193 | RMZ95576.1 40S ribosomal S7 [Brachionus plicatilis] | diamond | 1512 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31337395 | 31337395 | PRJNA1240805_P_NODE_3736_length_239_cov_4.389474_g3687_i0 | PRJNA1240805 | 3736 | 239 | 4.389474 | 10.49084286 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 58.5 | 5e-8 | NR | CAF0785067.1 | 104777 | g3687 | i0 | 90 | 0.376569037656904 | 30 | 3 | 37.7 | 0 | 202 | 113 | 199 | 228 | CAF0785067.1 unnamed protein product [Brachionus calyciflorus] | diamond | 90 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31432362 | 31432362 | PRJNA1240805_P_NODE_2876_length_278_cov_2.921397_g2827_i0 | PRJNA1240805 | 2876 | 278 | 2.921397 | 8.12148366 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 67.8 | 8.7e-11 | NR | CAF0745072.1 | 104777 | g2827 | i0 | 50 | 0.690647482014389 | 64 | 32 | 69.1 | 0 | 274 | 83 | 528 | 591 | CAF0745072.1 unnamed protein product [Brachionus calyciflorus] | diamond | 192 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32001780 | 32001780 | PRJNA1240805_P_NODE_4718_length_210_cov_10.919255_g4669_i0 | PRJNA1240805 | 4718 | 210 | 10.919255 | 22.9304355 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 85.1 | 2.82e-17 | NR | CAF0899337.1 | 104777 | g4669 | i0 | 68.6 | 1.91428571428571 | 70 | 20 | 97.1 | 1 | 206 | 3 | 22 | 91 | CAF0899337.1 unnamed protein product [Brachionus calyciflorus] | diamond | 402 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;