contig_metadata
9 rows where bioproject = "PRJNA922890", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9825623 | 9825623 | PRJNA922890_P_NODE_32248_length_337_cov_1.507463_g31838_i0 | PRJNA922890 | 32248 | 337 | 1.507463 | 5.08015031 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 453 | 7.46e-123 | NTclustered | gi|239584293|gb|FJ426408.1| | 104788 | g31838 | i0 | 91.071 | 99.6261127596439 | 336 | 29 | 99 | 1 | 1 | 335 | 512 | 177 | Macrotrachela quadricornifera isolate M.quad.TU.1.1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 33574 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 10180490 | 10180490 | PRJNA922890_P_NODE_10668_length_587_cov_15.718147_g10265_i0 | PRJNA922890 | 10668 | 587 | 15.718147 | 92.26552289 | Brachionus | 10194 | Rotifera | other_Eukaryota | 460 | 8.129999999999998e-125 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g10265 | i0 | 82.569 | 54.0408858603066 | 545 | 73 | 91 | 19 | 33 | 566 | 11791 | 11258 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 31722 | 462 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 23849711 | 23849711 | PRJNA922890_P_NODE_10319_length_598_cov_8.533081_g9916_i0 | PRJNA922890 | 10319 | 598 | 8.533081 | 51.02782438 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 401 | 5.099999999999999e-107 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g9916 | i0 | 80.389 | 65.8595317725753 | 566 | 79 | 93 | 29 | 5 | 559 | 10044 | 9500 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 39384 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 27568989 | 27568989 | PRJNA922890_P_NODE_71244_length_234_cov_0.884848_g70834_i0 | PRJNA922890 | 71244 | 234 | 0.884848 | 2.07054432 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 123 | 3.06e-33 | NR | CAF1032429.1 | 249248 | g70834 | i0 | 93 | 6.42307692307692 | 71 | 5 | 91 | 0 | 20 | 232 | 1 | 71 | CAF1032429.1 unnamed protein product [Adineta ricciae] | diamond | 1503 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27632282 | 27632282 | PRJNA922890_P_NODE_82384_length_228_cov_1.823899_g81974_i0 | PRJNA922890 | 82384 | 228 | 1.823899 | 4.15848972 | Adineta | 104781 | Rotifera | other_Eukaryota | 126 | 3.65e-33 | NR | CAF0947129.1 | 249248 | g81974 | i0 | 86.2 | 3.42105263157895 | 65 | 9 | 85.5 | 0 | 197 | 3 | 142 | 206 | CAF0947129.1 unnamed protein product [Adineta ricciae] | diamond | 780 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27720141 | 27720141 | PRJNA922890_P_NODE_84204_length_228_cov_0.905660_g83794_i0 | PRJNA922890 | 84204 | 228 | 0.90566 | 2.0649048 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 103 | 6.819999999999999e-24 | NR | UJR18211.1 | 104782 | g83794 | i0 | 58.7 | 1.94736842105263 | 75 | 30 | 97.4 | 1 | 1 | 222 | 211 | 285 | UJR18211.1 hypothetical protein I4U23_005112 [Adineta vaga] | diamond | 444 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28990190 | 28990190 | PRJNA922890_P_NODE_82788_length_228_cov_0.918239_g82378_i0 | PRJNA922890 | 82788 | 228 | 0.918239 | 2.09358492 | Rotaria | 231623 | Rotifera | other_Eukaryota | 81.3 | 8.25e-16 | NR | CAF4108630.1 | 392030 | g82378 | i0 | 71.4 | 4.14473684210526 | 63 | 18 | 82.9 | 0 | 39 | 227 | 575 | 637 | CAF4108630.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 945 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30877727 | 30877727 | PRJNA922890_P_NODE_75354_length_232_cov_0.895706_g74944_i0 | PRJNA922890 | 75354 | 232 | 0.895706 | 2.07803792 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 50.4 | 1.11e-5 | NR | CAF1330988.1 | 249248 | g74944 | i0 | 88 | 0.646551724137931 | 25 | 3 | 32.3 | 0 | 231 | 157 | 92 | 116 | CAF1330988.1 unnamed protein product [Adineta ricciae] | diamond | 150 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32907612 | 32907612 | PRJNA922890_P_NODE_81160_length_229_cov_0.912500_g80750_i0 | PRJNA922890 | 81160 | 229 | 0.9125 | 2.089625 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 112 | 5.05e-30 | NR | UJR08324.1 | 104782 | g80750 | i0 | 68.4 | 6.96943231441048 | 76 | 23 | 99.6 | 1 | 1 | 228 | 27 | 101 | UJR08324.1 hypothetical protein I4U23_012595 [Adineta vaga] | diamond | 1596 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;