contig_metadata
18 rows where bioproject = "PRJNA674308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3718365 | 3718365 | PRJNA674308_P_NODE_41523_length_167_cov_0.881356_g41288_i0 | PRJNA674308 | 41523 | 167 | 0.881356 | 1.47186452 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 309 | 7.53e-80 | NTclustered | gi|2537903921|gb|JX494739.2| | 104782 | g41288 | i0 | 100 | 96.1017964071856 | 167 | 0 | 100 | 0 | 1 | 167 | 19 | 185 | Adineta vaga isolate O1 18S ribosomal RNA gene, partial sequence | blastn | 16049 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22844004 | 22844004 | PRJNA674308_P_NODE_27878_length_190_cov_2.269504_g27643_i0 | PRJNA674308 | 27878 | 190 | 2.269504 | 4.3120576 | Adineta | 104781 | Rotifera | other_Eukaryota | 351 | 1.4399999999999997e-92 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g27643 | i0 | 100 | 26.1421052631579 | 190 | 0 | 100 | 0 | 1 | 190 | 1521 | 1710 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 4967 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26638557 | 26638557 | PRJNA674308_P_NODE_42921_length_166_cov_0.888889_g42686_i0 | PRJNA674308 | 42921 | 166 | 0.888889 | 1.47555574 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 73.2 | 2.35e-13 | NR | CAF0754477.1 | 104777 | g42686 | i0 | 60.8 | 0.921686746987952 | 51 | 20 | 92.2 | 0 | 164 | 12 | 332 | 382 | CAF0754477.1 unnamed protein product [Brachionus calyciflorus] | diamond | 153 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27176432 | 27176432 | PRJNA674308_P_NODE_54862_length_152_cov_2.019417_g54627_i0 | PRJNA674308 | 54862 | 152 | 2.019417 | 3.06951384 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 102 | 7.46e-24 | NR | UJR37282.1 | 104782 | g54627 | i0 | 96 | 2.96052631578947 | 50 | 2 | 98.7 | 0 | 150 | 1 | 978 | 1027 | UJR37282.1 hypothetical protein I4U23_029991 [Adineta vaga] | diamond | 450 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27271435 | 27271435 | PRJNA674308_P_NODE_35963_length_169_cov_0.866667_g35728_i0 | PRJNA674308 | 35963 | 169 | 0.866667 | 1.46466723 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 61.6 | 6.77e-10 | NR | CAF1100998.1 | 1234261 | g35728 | i0 | 56.4 | 0.976331360946746 | 55 | 24 | 97.6 | 0 | 2 | 166 | 96 | 150 | CAF1100998.1 unnamed protein product [Didymodactylos carnosus] | diamond | 165 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28072738 | 28072738 | PRJNA674308_P_NODE_7605_length_345_cov_1.040541_g7370_i0 | PRJNA674308 | 7605 | 345 | 1.040541 | 3.58986645 | Rotaria | 231623 | Rotifera | other_Eukaryota | 114 | 9.52e-27 | NR | CAF3292545.1 | 392032 | g7370 | i0 | 46.4 | 5.8695652173913 | 112 | 56 | 97.4 | 1 | 4 | 339 | 7 | 114 | CAF3292545.1 unnamed protein product [Rotaria socialis] | diamond | 2025 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28483319 | 28483319 | PRJNA674308_P_NODE_12246_length_274_cov_1.613333_g12011_i0 | PRJNA674308 | 12246 | 274 | 1.613333 | 4.42053242 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 46.2 | 0.0026 | NR | CAF1091917.1 | 433720 | g12011 | i0 | 77.3 | 0.963503649635037 | 22 | 5 | 24.1 | 0 | 273 | 208 | 210 | 231 | CAF1091917.1 unnamed protein product [Adineta steineri] | diamond | 264 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28893584 | 28893584 | PRJNA674308_P_NODE_10148_length_299_cov_1.860000_g9913_i0 | PRJNA674308 | 10148 | 299 | 1.86 | 5.5614 | Rotaria | 231623 | Rotifera | other_Eukaryota | 91.7 | 2.33e-19 | NR | CAF1372845.1 | 392030 | g9913 | i0 | 48.3 | 6.29096989966555 | 89 | 42 | 87.3 | 2 | 263 | 3 | 6 | 92 | CAF1372845.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1881 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29197746 | 29197746 | PRJNA674308_P_NODE_53369_length_162_cov_0.920354_g53134_i0 | PRJNA674308 | 53369 | 162 | 0.920354 | 1.49097348 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 92 | 3.56e-21 | NR | CAF0809184.1 | 392033 | g53134 | i0 | 77.4 | 4.90740740740741 | 53 | 12 | 98.1 | 0 | 2 | 160 | 125 | 177 | CAF0809184.1 unnamed protein product [Rotaria sordida] | diamond | 795 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29449934 | 29449934 | PRJNA674308_P_NODE_37770_length_168_cov_1.747899_g37535_i0 | PRJNA674308 | 37770 | 168 | 1.747899 | 2.93647032 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 52 | 7.5e-6 | NR | CAF0951665.1 | 1234261 | g37535 | i0 | 50 | 0.75 | 42 | 21 | 75 | 0 | 129 | 4 | 73 | 114 | CAF0951665.1 unnamed protein product [Didymodactylos carnosus] | diamond | 126 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29513157 | 29513157 | PRJNA674308_P_NODE_3410_length_522_cov_3.619450_g3178_i0 | PRJNA674308 | 3410 | 522 | 3.61945 | 18.893529 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 143 | 8.87e-38 | NR | CAF0954160.1 | 1234261 | g3178 | i0 | 42.6 | 5.18390804597701 | 183 | 95 | 99.4 | 4 | 520 | 2 | 75 | 257 | CAF0954160.1 unnamed protein product [Didymodactylos carnosus] | diamond | 2706 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29639319 | 29639319 | PRJNA674308_P_NODE_48590_length_164_cov_0.904348_g48355_i0 | PRJNA674308 | 48590 | 164 | 0.904348 | 1.48313072 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 59.7 | 1.01e-8 | NR | UJR27678.1 | 104782 | g48355 | i0 | 56.5 | 1.66463414634146 | 46 | 20 | 84.1 | 0 | 139 | 2 | 129 | 174 | UJR27678.1 hypothetical protein I4U23_008957 [Adineta vaga] | diamond | 273 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30113297 | 30113297 | PRJNA674308_P_NODE_572_length_1288_cov_2.988701_g479_i0 | PRJNA674308 | 572 | 1288 | 2.988701 | 38.49446888 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 234 | 3.61e-70 | NR | UJR26272.1 | 104782 | g479 | i0 | 47.3 | 2.02406832298137 | 279 | 135 | 62.9 | 6 | 1151 | 342 | 24 | 299 | UJR26272.1 hypothetical protein I4U23_007612 [Adineta vaga] | diamond | 2607 | 234 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31061475 | 31061475 | PRJNA674308_P_NODE_1515_length_816_cov_4.002608_g1327_i0 | PRJNA674308 | 1515 | 816 | 4.002608 | 32.66128128 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 171 | 1.3699999999999998e-48 | NR | CAF1091782.1 | 249248 | g1327 | i0 | 44.9 | 2.93382352941176 | 198 | 93 | 72.1 | 5 | 141 | 728 | 47 | 230 | CAF1091782.1 unnamed protein product [Adineta ricciae] | diamond | 2394 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32326846 | 32326846 | PRJNA674308_P_NODE_39139_length_168_cov_0.873950_g38904_i0 | PRJNA674308 | 39139 | 168 | 0.87395 | 1.468236 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 43.9 | 0.00518 | NR | CAF1553305.1 | 433720 | g38904 | i0 | 41.9 | 0.767857142857143 | 43 | 25 | 76.8 | 0 | 167 | 39 | 300 | 342 | CAF1553305.1 unnamed protein product [Adineta steineri] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32737091 | 32737091 | PRJNA674308_P_NODE_10680_length_292_cov_1.711934_g10445_i0 | PRJNA674308 | 10680 | 292 | 1.711934 | 4.99884728 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 83.6 | 3.01e-16 | NR | CAF0886665.1 | 392033 | g10445 | i0 | 44 | 2.05479452054795 | 100 | 46 | 92.5 | 1 | 272 | 3 | 997 | 1096 | CAF0886665.1 unnamed protein product [Rotaria sordida] | diamond | 600 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32799721 | 32799721 | PRJNA674308_P_NODE_32060_length_179_cov_1.200000_g31825_i0 | PRJNA674308 | 32060 | 179 | 1.2 | 2.148 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 57 | 1.45e-7 | NR | CAF4220236.1 | 433720 | g31825 | i0 | 49.2 | 6.08379888268156 | 61 | 28 | 97.2 | 1 | 176 | 3 | 357 | 417 | CAF4220236.1 unnamed protein product, partial [Adineta steineri] | diamond | 1089 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32894204 | 32894204 | PRJNA674308_P_NODE_2140_length_677_cov_2.730892_g1928_i0 | PRJNA674308 | 2140 | 677 | 2.730892 | 18.48813884 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 240 | 1.43e-76 | NR | CAF1091917.1 | 433720 | g1928 | i0 | 54 | 2.61004431314623 | 213 | 93 | 92.6 | 3 | 50 | 676 | 1 | 212 | CAF1091917.1 unnamed protein product [Adineta steineri] | diamond | 1767 | 240 | 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);;