contig_metadata
12 rows where bioproject = "PRJNA781196", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27211333 | 27211333 | PRJNA781196_P_NODE_33502_length_305_cov_1.801724_g33125_i0 | PRJNA781196 | 33502 | 305 | 1.801724 | 5.4952582 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 157 | 1.5e-46 | NR | KAI3387873.1 | 104778 | g33125 | i0 | 72.3 | 3.92459016393443 | 101 | 28 | 99.3 | 0 | 303 | 1 | 32 | 132 | KAI3387873.1 hypothetical protein SNEBB_008664 [Seison nebaliae] | diamond | 1197 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 27369890 | 27369890 | PRJNA781196_P_NODE_39903_length_283_cov_1.485714_g39526_i0 | PRJNA781196 | 39903 | 283 | 1.485714 | 4.20457062 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 56.2 | 6.17e-7 | NR | CAF3315123.1 | 392032 | g39526 | i0 | 60.6 | 0.69964664310954106 | 33 | 13 | 35 | 0 | 4 | 102 | 2 | 34 | CAF3315123.1 unnamed protein product [Rotaria socialis] | diamond | 198 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 27496000 | 27496000 | PRJNA781196_P_NODE_64223_length_244_cov_0.912281_g63846_i0 | PRJNA781196 | 64223 | 244 | 0.912281 | 2.22596564 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 50.1 | 9.4e-5 | NR | CAF3652806.1 | 433720 | g63846 | i0 | 48 | 1.22950819672131 | 50 | 26 | 61.5 | 0 | 90 | 239 | 320 | 369 | CAF3652806.1 unnamed protein product [Adineta steineri] | diamond | 300 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28199694 | 28199694 | PRJNA781196_P_NODE_11946_length_469_cov_3.189394_g11570_i0 | PRJNA781196 | 11946 | 469 | 3.189394 | 14.95825786 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 1.4999999999999998e-24 | NR | RMZ98034.1 | 10195 | g11570 | i0 | 57.4 | 2.85287846481876 | 108 | 35 | 64 | 2 | 163 | 462 | 65 | 169 | RMZ98034.1 Nascent polypeptide-associated complex subunit alpha [Brachionus plicatilis] | diamond | 1338 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28253633 | 28253633 | PRJNA781196_P_NODE_64346_length_244_cov_0.883041_g63969_i0 | PRJNA781196 | 64346 | 244 | 0.883041 | 2.15462004 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 51.6 | 2.87e-5 | NR | CAF3824335.1 | 2762511 | g63969 | i0 | 39.7 | 3.02459016393443 | 63 | 38 | 77.5 | 0 | 241 | 53 | 316 | 378 | CAF3824335.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 738 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28736668 | 28736668 | PRJNA781196_P_NODE_62247_length_245_cov_0.906977_g61870_i0 | PRJNA781196 | 62247 | 245 | 0.906977 | 2.22209365 | Rotaria | 231623 | Rotifera | other_Eukaryota | 50.8 | 1.2e-5 | NR | CAF3336628.1 | 392032 | g61870 | i0 | 56.1 | 2.03265306122449 | 41 | 16 | 47.8 | 1 | 117 | 1 | 5 | 45 | CAF3336628.1 unnamed protein product [Rotaria socialis] | diamond | 498 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 29138045 | 29138045 | PRJNA781196_P_NODE_68089_length_228_cov_2.012903_g67712_i0 | PRJNA781196 | 68089 | 228 | 2.012903 | 4.5894188400000004 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 55.8 | 7.56e-7 | NR | CAF3489518.1 | 2762511 | g67712 | i0 | 43.1 | 3.78947368421053 | 72 | 40 | 94.7 | 1 | 219 | 4 | 549 | 619 | CAF3489518.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 864 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29390453 | 29390453 | PRJNA781196_P_NODE_24489_length_347_cov_4.189781_g24112_i0 | PRJNA781196 | 24489 | 347 | 4.189781 | 14.53854007 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 107 | 3.4900000000000006e-27 | NR | CAF0711365.1 | 104777 | g24112 | i0 | 53.8 | 1.63400576368876 | 93 | 43 | 80.4 | 0 | 331 | 53 | 1 | 93 | CAF0711365.1 unnamed protein product [Brachionus calyciflorus] | diamond | 567 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30979339 | 30979339 | PRJNA781196_P_NODE_63494_length_244_cov_0.912281_g63117_i0 | PRJNA781196 | 63494 | 244 | 0.912281 | 2.22596564 | Adineta | 104781 | Rotifera | other_Eukaryota | 59.3 | 5.53e-8 | NR | CAF1539677.1 | 249248 | g63117 | i0 | 58.1 | 3.72540983606557 | 43 | 18 | 52.9 | 0 | 243 | 115 | 272 | 314 | CAF1539677.1 unnamed protein product [Adineta ricciae] | diamond | 909 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30979340 | 30979340 | PRJNA781196_P_NODE_66874_length_242_cov_0.923077_g66497_i0 | PRJNA781196 | 66874 | 242 | 0.923077 | 2.23384634 | Metazoa | 33208 | Rotifera | other_Eukaryota | 134 | 2.3299999999999997e-37 | NR | RNA23418.1 | 10195 | g66497 | i0 | 73.4 | 22.5247933884298 | 79 | 21 | 97.9 | 0 | 3 | 239 | 72 | 150 | RNA23418.1 parkin coregulated protein [Brachionus plicatilis] | diamond | 5451 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31317440 | 31317440 | PRJNA781196_P_NODE_58115_length_248_cov_0.891429_g57738_i0 | PRJNA781196 | 58115 | 248 | 0.891429 | 2.21074392 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 43.9 | 0.0145 | NR | CAF1126420.1 | 1234261 | g57738 | i0 | 31.9 | 2.39516129032258 | 72 | 48 | 87.1 | 1 | 236 | 21 | 2 | 72 | CAF1126420.1 unnamed protein product [Didymodactylos carnosus] | diamond | 594 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32645457 | 32645457 | PRJNA781196_P_NODE_22040_length_363_cov_1.468966_g21663_i0 | PRJNA781196 | 22040 | 363 | 1.468966 | 5.33234658 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 85.5 | 1.11e-16 | NR | CAF0956249.1 | 104777 | g21663 | i0 | 43.8 | 0.925619834710744 | 112 | 56 | 89.3 | 3 | 326 | 3 | 5 | 113 | CAF0956249.1 unnamed protein product [Brachionus calyciflorus] | diamond | 336 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;