contig_metadata
22 rows where bioproject = "PRJNA976345", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16250532 | 16250532 | PRJNA976345_P_NODE_111513_length_182_cov_2.870748_g109905_i0 | PRJNA976345 | 111513 | 182 | 2.870748 | 5.22476136 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 183 | 5.259999999999998e-42 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g109905 | i0 | 85.795 | 22.2747252747253 | 176 | 22 | 96 | 3 | 1 | 174 | 9870 | 10044 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 4054 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 26836311 | 26836311 | PRJNA976345_P_NODE_116701_length_179_cov_3.583333_g115093_i0 | PRJNA976345 | 116701 | 179 | 3.583333 | 6.41416607 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 43.5 | 0.00861 | NR | CAF4050641.1 | 433720 | g115093 | i0 | 65.4 | 0.871508379888268 | 26 | 9 | 43.6 | 0 | 20 | 97 | 335 | 360 | CAF4050641.1 unnamed protein product [Adineta steineri] | diamond | 156 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27531596 | 27531596 | PRJNA976345_P_NODE_3923_length_1004_cov_5.325077_g2811_i0 | PRJNA976345 | 3923 | 1004 | 5.325077 | 53.46377308 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 139 | 1.7e-32 | NR | CAF1925056.1 | 392030 | g2811 | i0 | 37.1 | 5.36653386454183 | 210 | 130 | 62.7 | 2 | 630 | 1 | 258 | 465 | CAF1925056.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 5388 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27784385 | 27784385 | PRJNA976345_P_NODE_112784_length_182_cov_1.231293_g111176_i0 | PRJNA976345 | 112784 | 182 | 1.231293 | 2.24095326 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 43.1 | 0.0121 | NR | CAF3785542.1 | 392030 | g111176 | i0 | 42 | 0.824175824175824 | 50 | 29 | 82.4 | 0 | 6 | 155 | 456 | 505 | CAF3785542.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 150 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27973625 | 27973625 | PRJNA976345_P_NODE_107145_length_185_cov_1.840000_g105537_i0 | PRJNA976345 | 107145 | 185 | 1.84 | 3.404 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 77.4 | 1.03e-14 | NR | CAF1084049.1 | 1234261 | g105537 | i0 | 55.7 | 2.96756756756757 | 61 | 27 | 98.9 | 0 | 3 | 185 | 154 | 214 | CAF1084049.1 unnamed protein product [Didymodactylos carnosus] | diamond | 549 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27973658 | 27973658 | PRJNA976345_P_NODE_32125_length_299_cov_1.897727_g30519_i0 | PRJNA976345 | 32125 | 299 | 1.897727 | 5.67420373 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 101 | 1.61e-22 | NR | CAF1408492.1 | 392033 | g30519 | i0 | 52.5 | 1.9866220735786 | 99 | 46 | 99.3 | 1 | 2 | 298 | 57 | 154 | CAF1408492.1 unnamed protein product [Rotaria sordida] | diamond | 594 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28200649 | 28200649 | PRJNA976345_P_NODE_104746_length_186_cov_5.947020_g103138_i0 | PRJNA976345 | 104746 | 186 | 5.94702 | 11.0614572 | Metazoa | 33208 | Rotifera | other_Eukaryota | 43.5 | 0.00926 | NR | CAF0708023.1 | 104777 | g103138 | i0 | 39.1 | 10.4838709677419 | 46 | 28 | 74.2 | 0 | 45 | 182 | 219 | 264 | CAF0708023.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1950 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28232153 | 28232153 | PRJNA976345_P_NODE_13366_length_467_cov_3.298611_g11794_i0 | PRJNA976345 | 13366 | 467 | 3.298611 | 15.40451337 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 57.4 | 1.57e-6 | NR | CAF0891462.1 | 104777 | g11794 | i0 | 29.1 | 1.17558886509636 | 86 | 61 | 55.2 | 0 | 194 | 451 | 42 | 127 | CAF0891462.1 unnamed protein product [Brachionus calyciflorus] | diamond | 549 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28794396 | 28794396 | PRJNA976345_P_NODE_44687_length_259_cov_2.937500_g43079_i0 | PRJNA976345 | 44687 | 259 | 2.9375 | 7.608125 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 51.6 | 3.37e-5 | NR | CAF4549710.1 | 392032 | g43079 | i0 | 30.9 | 2.53667953667954 | 81 | 50 | 90.3 | 2 | 245 | 12 | 148 | 225 | CAF4549710.1 unnamed protein product, partial [Rotaria socialis] | diamond | 657 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 29110401 | 29110401 | PRJNA976345_P_NODE_140168_length_170_cov_4.651852_g138560_i0 | PRJNA976345 | 140168 | 170 | 4.651852 | 7.9081484 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 40.4 | 0.0435 | NR | CAF4638611.1 | 1234261 | g138560 | i0 | 41.8 | 0.970588235294118 | 55 | 28 | 97.1 | 1 | 167 | 3 | 4 | 54 | CAF4638611.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 165 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29457306 | 29457306 | PRJNA976345_P_NODE_38890_length_275_cov_2.400000_g37283_i0 | PRJNA976345 | 38890 | 275 | 2.4 | 6.6 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 46.2 | 0.00134 | NR | UJR38222.1 | 104782 | g37283 | i0 | 55.6 | 1.58181818181818 | 36 | 16 | 39.3 | 0 | 168 | 275 | 76 | 111 | UJR38222.1 hypothetical protein I4U23_030895 [Adineta vaga] | diamond | 435 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29646646 | 29646646 | PRJNA976345_P_NODE_179130_length_156_cov_1.289256_g177522_i0 | PRJNA976345 | 179130 | 156 | 1.289256 | 2.01123936 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 49.3 | 5.36e-6 | NR | CAF3963697.1 | 2762511 | g177522 | i0 | 52.6 | 0.730769230769231 | 38 | 18 | 73.1 | 0 | 2 | 115 | 36 | 73 | CAF3963697.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 114 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29836460 | 29836460 | PRJNA976345_P_NODE_4951_length_850_cov_4.132515_g3714_i0 | PRJNA976345 | 4951 | 850 | 4.132515 | 35.1263775 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 126 | 1.26e-28 | NR | CAF3564276.1 | 2762511 | g3714 | i0 | 30.1 | 4.05882352941176 | 289 | 185 | 98.8 | 9 | 2 | 841 | 661 | 941 | CAF3564276.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 3450 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30120687 | 30120687 | PRJNA976345_P_NODE_17352_length_405_cov_3.675676_g15761_i0 | PRJNA976345 | 17352 | 405 | 3.675676 | 14.8864878 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 45.8 | 0.0174 | NR | CAF1571111.1 | 392030 | g15761 | i0 | 23.8 | 1.80740740740741 | 122 | 90 | 89.6 | 2 | 392 | 30 | 70 | 189 | CAF1571111.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 732 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30253719 | 30253719 | PRJNA976345_P_NODE_30832_length_304_cov_3.680297_g29226_i0 | PRJNA976345 | 30832 | 304 | 3.680297 | 11.18810288 | Rotaria | 231623 | Rotifera | other_Eukaryota | 97.1 | 2.32e-21 | NR | CAF5185416.1 | 392030 | g29226 | i0 | 43.2 | 12.1875 | 95 | 54 | 93.8 | 0 | 285 | 1 | 123 | 217 | CAF5185416.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 3705 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30443133 | 30443133 | PRJNA976345_P_NODE_13273_length_469_cov_3.023041_g11702_i0 | PRJNA976345 | 13273 | 469 | 3.023041 | 14.17806229 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 2.0299999999999993e-34 | NR | RMZ93013.1 | 10195 | g11702 | i0 | 48.6 | 11.8144989339019 | 138 | 70 | 87.6 | 1 | 468 | 58 | 45 | 182 | RMZ93013.1 U2 small nuclear ribonucleo A [Brachionus plicatilis] | diamond | 5541 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31100175 | 31100175 | PRJNA976345_P_NODE_85415_length_201_cov_1.644578_g83807_i0 | PRJNA976345 | 85415 | 201 | 1.644578 | 3.30560178 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 56.6 | 2.66e-7 | NR | CAF1488038.1 | 1234261 | g83807 | i0 | 55.3 | 1.1044776119403 | 38 | 17 | 56.7 | 0 | 65 | 178 | 343 | 380 | CAF1488038.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 222 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31770577 | 31770577 | PRJNA976345_P_NODE_66977_length_220_cov_1.886486_g65369_i0 | PRJNA976345 | 66977 | 220 | 1.886486 | 4.1502692 | Metazoa | 33208 | Rotifera | other_Eukaryota | 77.8 | 1.12e-14 | NR | RNA36410.1 | 10195 | g65369 | i0 | 47.9 | 6.6 | 71 | 36 | 95.5 | 1 | 218 | 9 | 53 | 123 | RNA36410.1 fibronectin type-III domain-containing [Brachionus plicatilis] | diamond | 1452 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31890942 | 31890942 | PRJNA976345_P_NODE_54697_length_238_cov_2.497537_g53089_i0 | PRJNA976345 | 54697 | 238 | 2.497537 | 5.94413806 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 48.5 | 2.61e-4 | NR | CAF0891462.1 | 104777 | g53089 | i0 | 27.3 | 1.94117647058824 | 77 | 56 | 97.1 | 0 | 238 | 8 | 46 | 122 | CAF0891462.1 unnamed protein product [Brachionus calyciflorus] | diamond | 462 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32112501 | 32112501 | PRJNA976345_P_NODE_28498_length_316_cov_1.985765_g26894_i0 | PRJNA976345 | 28498 | 316 | 1.985765 | 6.2750174 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 101 | 1.9e-22 | NR | CAF1521526.1 | 249248 | g26894 | i0 | 49 | 0.987341772151899 | 104 | 53 | 98.7 | 0 | 2 | 313 | 882 | 985 | CAF1521526.1 unnamed protein product [Adineta ricciae] | diamond | 312 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32340334 | 32340334 | PRJNA976345_P_NODE_197199_length_150_cov_2.765217_g195591_i0 | PRJNA976345 | 197199 | 150 | 2.765217 | 4.1478255 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 80.9 | 3.68e-16 | NR | CAF1021035.1 | 433720 | g195591 | i0 | 70.4 | 7.68 | 54 | 9 | 94 | 1 | 143 | 3 | 217 | 270 | CAF1021035.1 unnamed protein product [Adineta steineri] | diamond | 1152 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32901640 | 32901640 | PRJNA976345_P_NODE_140600_length_170_cov_2.459259_g138992_i0 | PRJNA976345 | 140600 | 170 | 2.459259 | 4.1807403 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 61.6 | 3.01e-9 | NR | CAF1604450.1 | 392030 | g138992 | i0 | 44.6 | 11.7705882352941 | 56 | 31 | 98.8 | 0 | 170 | 3 | 244 | 299 | CAF1604450.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 2001 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;