contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1082072" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26678876 | 26678876 | PRJNA1082072_P_NODE_2981_length_240_cov_3.227545_g2974_i0 | PRJNA1082072 | 2981 | 240 | 3.227545 | 7.746108 | Brachionus | 10194 | Rotifera | other_Eukaryota | 113 | 3.2000000000000003e-27 | NR | QHR79579.1 | 392764 | g2974 | i0 | 78.2 | 1.8875 | 78 | 17 | 97.5 | 0 | 5 | 238 | 177 | 254 | QHR79579.1 NADH dehydrogenase subunit 5 [Brachionus rubens] | diamond | 453 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 27257120 | 27257120 | PRJNA1082072_P_NODE_543_length_425_cov_0.980114_g536_i0 | PRJNA1082072 | 543 | 425 | 0.980114 | 4.1654845 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 67 | 1.82e-10 | NR | RNA14707.1 | 10195 | g536 | i0 | 41.1 | 0.515294117647059 | 73 | 42 | 51.5 | 1 | 417 | 199 | 75 | 146 | RNA14707.1 hypothetical protein BpHYR1_030445 [Brachionus plicatilis] | diamond | 219 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27288722 | 27288722 | PRJNA1082072_P_NODE_2283_length_249_cov_0.875000_g2276_i0 | PRJNA1082072 | 2283 | 249 | 0.875 | 2.17875 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 57.4 | 2.81e-7 | NR | RNA23314.1 | 10195 | g2276 | i0 | 63.6 | 0.530120481927711 | 44 | 16 | 53 | 0 | 9 | 140 | 1814 | 1857 | RNA23314.1 nuclear pore complex Nup98-Nup96 isoform X1 [Brachionus plicatilis] | diamond | 132 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27352204 | 27352204 | PRJNA1082072_P_NODE_1603_length_280_cov_1.487923_g1596_i0 | PRJNA1082072 | 1603 | 280 | 1.487923 | 4.1661844 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 42.7 | 0.0465 | NR | CAF0906093.1 | 104777 | g1596 | i0 | 34.8 | 0.707142857142857 | 66 | 41 | 70.7 | 2 | 202 | 5 | 151 | 214 | CAF0906093.1 unnamed protein product [Brachionus calyciflorus] | diamond | 198 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27731186 | 27731186 | PRJNA1082072_P_NODE_1404_length_291_cov_1.903670_g1397_i0 | PRJNA1082072 | 1404 | 291 | 1.90367 | 5.5396797 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 118 | 1.51e-28 | NR | CAF0783313.1 | 104777 | g1397 | i0 | 56.3 | 1.22680412371134 | 119 | 26 | 99 | 2 | 2 | 289 | 578 | 693 | CAF0783313.1 unnamed protein product [Brachionus calyciflorus] | diamond | 357 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28520342 | 28520342 | PRJNA1082072_P_NODE_2467_length_247_cov_0.885057_g2460_i0 | PRJNA1082072 | 2467 | 247 | 0.885057 | 2.18609079 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 95.9 | 7.99e-21 | NR | CAF1477448.1 | 249248 | g2460 | i0 | 88.5 | 0.631578947368421 | 52 | 6 | 63.2 | 0 | 1 | 156 | 210 | 261 | CAF1477448.1 unnamed protein product [Adineta ricciae] | diamond | 156 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28962505 | 28962505 | PRJNA1082072_P_NODE_1688_length_276_cov_1.211823_g1681_i0 | PRJNA1082072 | 1688 | 276 | 1.211823 | 3.34463148 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 77.4 | 3.01e-14 | NR | CAF0714608.1 | 104777 | g1681 | i0 | 47.8 | 0.978260869565217 | 90 | 42 | 97.8 | 1 | 3 | 272 | 77 | 161 | CAF0714608.1 unnamed protein product [Brachionus calyciflorus] | diamond | 270 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29215101 | 29215101 | PRJNA1082072_P_NODE_2749_length_244_cov_0.900585_g2742_i0 | PRJNA1082072 | 2749 | 244 | 0.900585 | 2.1974274 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 140 | 8.13e-39 | NR | CAF1670151.1 | 249248 | g2742 | i0 | 91.1 | 0.971311475409836 | 79 | 7 | 97.1 | 0 | 239 | 3 | 17 | 95 | CAF1670151.1 unnamed protein product, partial [Adineta ricciae] | diamond | 237 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30636019 | 30636019 | PRJNA1082072_P_NODE_2693_length_244_cov_0.900585_g2686_i0 | PRJNA1082072 | 2693 | 244 | 0.900585 | 2.1974274 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 114 | 2.53e-27 | NR | CAF1419028.1 | 249248 | g2686 | i0 | 71.6 | 3.98360655737705 | 81 | 23 | 99.6 | 0 | 243 | 1 | 1465 | 1545 | CAF1419028.1 unnamed protein product [Adineta ricciae] | diamond | 972 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31204485 | 31204485 | PRJNA1082072_P_NODE_2475_length_247_cov_0.885057_g2468_i0 | PRJNA1082072 | 2475 | 247 | 0.885057 | 2.18609079 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 45.1 | 0.00603 | NR | CAF0959555.1 | 104777 | g2468 | i0 | 44.2 | 0.935222672064777 | 77 | 39 | 91.1 | 3 | 228 | 4 | 512 | 586 | CAF0959555.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 231 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31236428 | 31236428 | PRJNA1082072_P_NODE_1735_length_273_cov_1.355000_g1728_i0 | PRJNA1082072 | 1735 | 273 | 1.355 | 3.69915 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 176 | 4.21e-49 | NR | CAF1647536.1 | 249248 | g1728 | i0 | 91.1 | 0.989010989010989 | 90 | 8 | 98.9 | 0 | 3 | 272 | 669 | 758 | CAF1647536.1 unnamed protein product [Adineta ricciae] | diamond | 270 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31576023 | 31576023 | PRJNA1082072_P_NODE_2136_length_251_cov_0.865169_g2129_i0 | PRJNA1082072 | 2136 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.8 | 1.11e-8 | NR | CAF1669311.1 | 249248 | g2129 | i0 | 41 | 1.99601593625498 | 83 | 47 | 98 | 2 | 251 | 6 | 21 | 102 | CAF1669311.1 unnamed protein product, partial [Adineta ricciae] | diamond | 501 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31733870 | 31733870 | PRJNA1082072_P_NODE_2197_length_250_cov_0.870056_g2190_i0 | PRJNA1082072 | 2197 | 250 | 0.870056 | 2.17514 | Rotaria | 231623 | Rotifera | other_Eukaryota | 51.2 | 4.41e-5 | NR | CAF1191014.1 | 392033 | g2190 | i0 | 47.5 | 5.964 | 61 | 26 | 73.2 | 1 | 202 | 20 | 8219 | 8273 | CAF1191014.1 unnamed protein product [Rotaria sordida] | diamond | 1491 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31987013 | 31987013 | PRJNA1082072_P_NODE_258_length_595_cov_1.459770_g251_i0 | PRJNA1082072 | 258 | 595 | 1.45977 | 8.6856315 | Adineta | 104781 | Rotifera | other_Eukaryota | 60.1 | 2.4e-8 | NR | CAF0989334.1 | 249248 | g251 | i0 | 45.6 | 0.882352941176471 | 57 | 27 | 27.2 | 2 | 552 | 391 | 21 | 76 | CAF0989334.1 unnamed protein product [Adineta ricciae] | diamond | 525 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32375528 | 32375528 | PRJNA1082072_P_NODE_2379_length_248_cov_0.880000_g2372_i0 | PRJNA1082072 | 2379 | 248 | 0.88 | 2.1824 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 144 | 1.0599999999999998e-37 | NR | CAF1058956.1 | 249248 | g2372 | i0 | 98.6 | 1.76612903225806 | 73 | 1 | 88.3 | 0 | 221 | 3 | 1031 | 1103 | CAF1058956.1 unnamed protein product [Adineta ricciae] | diamond | 438 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32682476 | 32682476 | PRJNA1082072_P_NODE_2820_length_242_cov_1.461538_g2813_i0 | PRJNA1082072 | 2820 | 242 | 1.461538 | 3.53692196 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.3 | 9.78e-19 | NR | CAF0802296.1 | 1234261 | g2813 | i0 | 51.4 | 2.81404958677686 | 74 | 35 | 90.5 | 1 | 4 | 222 | 118 | 191 | CAF0802296.1 unnamed protein product [Didymodactylos carnosus] | diamond | 681 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;