contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13573 | 13573 | PRJEB10320_P_NODE_5741_length_439_cov_3.264851_g5490_i0 | PRJEB10320 | 5741 | 439 | 3.264851 | 14.33269589 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 364 | 4.7999999999999996e-96 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g5490 | i0 | 81.777 | 83.4874715261959 | 439 | 76 | 99 | 4 | 1 | 437 | 1070 | 634 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 36651 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 1287857 | 1287857 | PRJEB10320_P_NODE_762_length_1133_cov_15.763206_g653_i0 | PRJEB10320 | 762 | 1133 | 15.763206 | 178.59712398 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 409 | 5.939999999999999e-109 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g653 | i0 | 76.854 | 13.297440423654 | 782 | 146 | 68 | 30 | 357 | 1121 | 11079 | 11842 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 15066 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 2563382 | 2563382 | PRJEB10320_P_NODE_13503_length_254_cov_1.593607_g13245_i0 | PRJEB10320 | 13503 | 254 | 1.593607 | 4.04776178 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 143 | 1.33e-29 | NTclustered | gi|477541861|gb|KC603850.1| | 1199090 | g13245 | i0 | 78.151 | 29.3149606299213 | 238 | 42 | 92 | 10 | 22 | 254 | 6775 | 7007 | Brachionus sp. 'koreanus' chromosome II mitochondrion, complete sequence | blastn | 7446 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 2563454 | 2563454 | PRJEB10320_P_NODE_4563_length_499_cov_3.010776_g4326_i0 | PRJEB10320 | 4563 | 499 | 3.010776 | 15.02377224 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 285 | 4.42e-72 | NTclustered | gi|218117260|emb|AM980958.1| | 10195 | g4326 | i0 | 82.371 | 1.70140280561122 | 329 | 56 | 66 | 2 | 47 | 374 | 401 | 74 | Brachionus plicatilis partial mRNA for 40S ribosomal protein S11, (RPS11 gene) | blastn | 849 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 5115891 | 5115891 | PRJEB10320_P_NODE_18085_length_206_cov_9.619883_g17827_i0 | PRJEB10320 | 18085 | 206 | 9.619883 | 19.81695898 | Cephalodella gibba | 231616 | Rotifera | other_Eukaryota | 311 | 2.69e-80 | NTclustered | gi|37788188|gb|AY218141.1| | 231616 | g17827 | i0 | 93.78 | 102.529126213592 | 209 | 9 | 99 | 3 | 2 | 206 | 213 | 5 | Cephalodella gibba 28S ribosomal RNA gene, partial sequence | blastn | 21121 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Cephalodella | Cephalodella gibba | |
| 8635575 | 8635575 | PRJEB10320_P_NODE_4227_length_520_cov_4.243299_g3992_i0 | PRJEB10320 | 4227 | 520 | 4.243299 | 22.0651548 | Ploima | 84394 | Rotifera | other_Eukaryota | 399 | 1.5799999999999998e-106 | NTclustered | gi|1896828520|gb|MT211653.1| | 1708513 | g3992 | i0 | 81.933 | 83.2557692307692 | 476 | 82 | 91 | 4 | 41 | 514 | 476 | 3 | Asplanchna intermedia voucher BUZOODST-P-Aim cytochrome c oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 43293 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna intermedia | |
| 12461554 | 12461554 | PRJEB10320_P_NODE_13190_length_258_cov_1.762332_g12932_i0 | PRJEB10320 | 13190 | 258 | 1.762332 | 4.54681656 | Ploima | 84394 | Rotifera | other_Eukaryota | 377 | 3.41e-100 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g12932 | i0 | 93.676 | 97.7364341085271 | 253 | 15 | 98 | 1 | 6 | 258 | 1694 | 1443 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 25216 | 379 | 0.994722955145119 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 14041669 | 14041669 | PRJEB10320_P_NODE_6852_length_395_cov_1.463889_g6597_i0 | PRJEB10320 | 6852 | 395 | 1.463889 | 5.78236155 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 272 | 2.6699999999999993e-68 | NTclustered | gi|567315823|dbj|AB775784.1| | 10195 | g6597 | i0 | 81.306 | 6.35443037974684 | 337 | 61 | 85 | 2 | 60 | 395 | 1903 | 1568 | Brachionus plicatilis hsp70-1 mRNA for heat shock 70 kDa protein 1, complete cds | blastn | 2510 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 15315713 | 15315713 | PRJEB10320_P_NODE_12033_length_274_cov_3.112971_g11775_i0 | PRJEB10320 | 12033 | 274 | 3.112971 | 8.52954054 | Cephalodella forficula | 360656 | Rotifera | other_Eukaryota | 473 | 4.53e-129 | NTclustered | gi|83285081|gb|DQ297693.1| | 360656 | g11775 | i0 | 97.81 | 100 | 274 | 6 | 100 | 0 | 1 | 274 | 613 | 886 | Cephalodella forficula 18S ribosomal RNA gene, partial sequence | blastn | 27400 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Cephalodella | Cephalodella forficula | |
| 22965443 | 22965443 | PRJEB10320_P_NODE_5419_length_454_cov_6.988067_g5170_i0 | PRJEB10320 | 5419 | 454 | 6.988067 | 31.72582418 | Mytilina ventralis | 360682 | Rotifera | other_Eukaryota | 520 | 9.999999999999999e-143 | NTclustered | gi|83285200|gb|DQ297747.1| | 360682 | g5170 | i0 | 87.309 | 79.068281938326 | 457 | 54 | 100 | 4 | 1 | 454 | 271 | 726 | Mytilina ventralis 28S ribosomal RNA gene, partial sequence | blastn | 35897 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina ventralis |
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);;