contig_metadata
12 rows where bioproject = "PRJNA1174207", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590493 | 1590493 | PRJNA1174207_P_NODE_38462_length_245_cov_0.895349_g37933_i0 | PRJNA1174207 | 38462 | 245 | 0.895349 | 2.19360505 | Adineta | 104781 | Rotifera | other_Eukaryota | 123 | 4.24e-33 | NR | CAF1066595.1 | 249248 | g37933 | i0 | 71.6 | 6.94285714285714 | 81 | 23 | 99.2 | 0 | 2 | 244 | 116 | 196 | CAF1066595.1 unnamed protein product [Adineta ricciae] | diamond | 1701 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 13068890 | 13068890 | PRJNA1174207_P_NODE_10211_length_477_cov_2.769802_g9685_i0 | PRJNA1174207 | 10211 | 477 | 2.769802 | 13.21195554 | Asplanchna brightwellii | 2005548 | Rotifera | other_Eukaryota | 340 | 8.849999999999999e-89 | NTclustered | gi|2899343712|gb|PQ788833.1| | 2005548 | g9685 | i0 | 80.206 | 32.7211740041929 | 485 | 70 | 99 | 19 | 2 | 475 | 2401 | 1932 | Asplanchna brightwellii chromosome I mitochondrion, complete sequence | blastn | 15608 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna brightwellii | |
| 19441728 | 19441728 | PRJNA1174207_P_NODE_32696_length_253_cov_1.711111_g32167_i0 | PRJNA1174207 | 32696 | 253 | 1.711111 | 4.32911083 | Mytilina mucronata | 360681 | Rotifera | other_Eukaryota | 381 | 2.5799999999999995e-101 | NTclustered | gi|83285199|gb|DQ297746.1| | 360681 | g32167 | i0 | 94.048 | 85.0158102766798 | 252 | 14 | 99 | 1 | 3 | 253 | 266 | 15 | Mytilina mucronata 28S ribosomal RNA gene, partial sequence | blastn | 21509 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina mucronata | |
| 26945460 | 26945460 | PRJNA1174207_P_NODE_37742_length_246_cov_0.890173_g37213_i0 | PRJNA1174207 | 37742 | 246 | 0.890173 | 2.18982558 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 75.9 | 8.02e-14 | NR | CAF0938170.1 | 433720 | g37213 | i0 | 47.1 | 4.14634146341463 | 85 | 38 | 95.1 | 1 | 246 | 13 | 319 | 403 | CAF0938170.1 unnamed protein product [Adineta steineri] | diamond | 1020 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27735848 | 27735848 | PRJNA1174207_P_NODE_42364_length_235_cov_2.376543_g41835_i0 | PRJNA1174207 | 42364 | 235 | 2.376543 | 5.58487605 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 74.7 | 1.74e-15 | NR | CAF1041951.1 | 2762511 | g41835 | i0 | 55.4 | 4.85106382978723 | 65 | 29 | 83 | 0 | 233 | 39 | 19 | 83 | CAF1041951.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1140 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28196613 | 28196613 | PRJNA1174207_P_NODE_32506_length_254_cov_1.696133_g31977_i0 | PRJNA1174207 | 32506 | 254 | 1.696133 | 4.30817782 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 103 | 1.2499999999999999e-23 | NR | CAF0739562.1 | 433720 | g31977 | i0 | 61.9 | 8.92913385826772 | 84 | 31 | 98 | 1 | 250 | 2 | 628 | 711 | CAF0739562.1 unnamed protein product [Adineta steineri] | diamond | 2268 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28272078 | 28272078 | PRJNA1174207_P_NODE_36986_length_247_cov_0.885057_g36457_i0 | PRJNA1174207 | 36986 | 247 | 0.885057 | 2.18609079 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 49.3 | 1.97e-4 | NR | CAF0739950.1 | 249248 | g36457 | i0 | 34.2 | 2.76923076923077 | 76 | 50 | 92.3 | 0 | 234 | 7 | 621 | 696 | CAF0739950.1 unnamed protein product [Adineta ricciae] | diamond | 684 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28745883 | 28745883 | PRJNA1174207_P_NODE_37007_length_247_cov_0.867816_g36478_i0 | PRJNA1174207 | 37007 | 247 | 0.867816 | 2.14350552 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 61.6 | 4.86e-9 | NR | CAF2866870.1 | 2762512 | g36478 | i0 | 42.2 | 3.69230769230769 | 83 | 40 | 99.6 | 3 | 1 | 246 | 71 | 146 | CAF2866870.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 912 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31608346 | 31608346 | PRJNA1174207_P_NODE_11996_length_429_cov_1.893258_g11469_i0 | PRJNA1174207 | 11996 | 429 | 1.893258 | 8.12207682 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 209 | 7.97e-66 | NR | CAF1066595.1 | 249248 | g11469 | i0 | 69.7 | 53.6083916083916 | 142 | 43 | 99.3 | 0 | 429 | 4 | 65 | 206 | CAF1066595.1 unnamed protein product [Adineta ricciae] | diamond | 22998 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32000346 | 32000346 | PRJNA1174207_P_NODE_31718_length_257_cov_2.173913_g31189_i0 | PRJNA1174207 | 31718 | 257 | 2.173913 | 5.58695641 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 52 | 2.34e-5 | NR | CAF0927075.1 | 1234261 | g31189 | i0 | 54.1 | 0.863813229571984 | 37 | 17 | 43.2 | 0 | 238 | 128 | 358 | 394 | CAF0927075.1 unnamed protein product [Didymodactylos carnosus] | diamond | 222 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32317068 | 32317068 | PRJNA1174207_P_NODE_11179_length_449_cov_2.452128_g10653_i0 | PRJNA1174207 | 11179 | 449 | 2.452128 | 11.01005472 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 89.7 | 9.28e-18 | NR | CAF1239628.1 | 1234261 | g10653 | i0 | 37.8 | 0.955456570155902 | 143 | 85 | 92.9 | 3 | 421 | 5 | 186 | 328 | CAF1239628.1 unnamed protein product [Didymodactylos carnosus] | diamond | 429 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32664163 | 32664163 | PRJNA1174207_P_NODE_31140_length_260_cov_1.427807_g30611_i0 | PRJNA1174207 | 31140 | 260 | 1.427807 | 3.7122982 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 87.8 | 3.5e-18 | NR | CAF0861238.1 | 392033 | g30611 | i0 | 62.3 | 2.18076923076923 | 61 | 21 | 68.1 | 1 | 84 | 260 | 24 | 84 | CAF0861238.1 unnamed protein product [Rotaria sordida] | diamond | 567 | 87.8 | 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);;