contig_metadata
8 rows where bioproject = "PRJNA1198392", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11803299 | 11803299 | PRJNA1198392_P_NODE_650_length_938_cov_7.885549_g540_i0 | PRJNA1198392 | 650 | 938 | 7.885549 | 73.96644962 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 472 | 6.14e-128 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g540 | i0 | 82.531 | 30.3027718550107 | 561 | 75 | 59 | 18 | 339 | 888 | 11253 | 11801 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 28424 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 14353547 | 14353547 | PRJNA1198392_P_NODE_16692_length_249_cov_2.335227_g16551_i0 | PRJNA1198392 | 16692 | 249 | 2.335227 | 5.81471523 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 119 | 1.72e-30 | NR | CAF1040579.1 | 1234261 | g16551 | i0 | 67.9 | 7.07228915662651 | 84 | 26 | 100 | 1 | 249 | 1 | 172 | 255 | CAF1040579.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1761 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 15071459 | 15071459 | PRJNA1198392_P_NODE_15132_length_254_cov_2.502762_g14991_i0 | PRJNA1198392 | 15132 | 254 | 2.502762 | 6.35701548 | Asplanchna | 84396 | Rotifera | other_Eukaryota | 219 | 2.1499999999999998e-52 | NTclustered | gi|2899343712|gb|PQ788833.1| | 2005548 | g14991 | i0 | 83.402 | 14.6850393700787 | 241 | 35 | 94 | 5 | 16 | 254 | 2124 | 2361 | Asplanchna brightwellii chromosome I mitochondrion, complete sequence | blastn | 3730 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna brightwellii | |
| 26851240 | 26851240 | PRJNA1198392_P_NODE_5641_length_338_cov_1.267925_g5500_i0 | PRJNA1198392 | 5641 | 338 | 1.267925 | 4.2855865 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 51.2 | 1.05e-4 | NR | CAF1506221.1 | 249248 | g5500 | i0 | 33 | 4.4112426035503 | 97 | 53 | 82.5 | 4 | 296 | 18 | 183 | 271 | CAF1506221.1 unnamed protein product [Adineta ricciae] | diamond | 1491 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27262276 | 27262276 | PRJNA1198392_P_NODE_8103_length_291_cov_1.866972_g7962_i0 | PRJNA1198392 | 8103 | 291 | 1.866972 | 5.43288852 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 71.6 | 1.6e-12 | NR | CAF5177193.1 | 392030 | g7962 | i0 | 37.5 | 3.65979381443299 | 96 | 59 | 99 | 1 | 1 | 288 | 145 | 239 | CAF5177193.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1065 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29396660 | 29396660 | PRJNA1198392_P_NODE_11429_length_275_cov_1.524752_g11288_i0 | PRJNA1198392 | 11429 | 275 | 1.524752 | 4.193068 | Brachionus | 10194 | Rotifera | other_Eukaryota | 120 | 9.18e-30 | NR | YP_001739869.1 | 10195 | g11288 | i0 | 67 | 4.96363636363636 | 91 | 30 | 99.3 | 0 | 2 | 274 | 313 | 403 | YP_001739869.1 NADH dehydrogenase subunit 5 [Brachionus plicatilis] | diamond | 1365 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30325839 | 30325839 | PRJNA1198392_P_NODE_18432_length_246_cov_1.462428_g18291_i0 | PRJNA1198392 | 18432 | 246 | 1.462428 | 3.59757288 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 52.8 | 1.15e-5 | NR | AOP18530.1 | 96890 | g18291 | i0 | 40.3 | 0.939024390243902 | 77 | 46 | 93.9 | 0 | 10 | 240 | 424 | 500 | AOP18530.1 NADH dehydrogenase subunit 5 [Brachionus rotundiformis] | diamond | 231 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 31829683 | 31829683 | PRJNA1198392_P_NODE_9157_length_286_cov_1.446009_g9016_i0 | PRJNA1198392 | 9157 | 286 | 1.446009 | 4.13558574 | Brachionus | 10194 | Rotifera | other_Eukaryota | 185 | 1.77e-52 | NR | RNA30477.1 | 10195 | g9016 | i0 | 91.6 | 1.99300699300699 | 95 | 8 | 99.7 | 0 | 2 | 286 | 542 | 636 | RNA30477.1 dolichyl-diphosphooligosaccharide-- glycosyltransferase subunit STT3B [Brachionus plicatilis] | diamond | 570 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;