contig_metadata
12 rows where bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26484 | 26484 | PRJEB29441_P_NODE_28981_length_194_cov_4.206897_g28540_i0 | PRJEB29441 | 28981 | 194 | 4.206897 | 8.16138018 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 348 | 1.91e-91 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g28540 | i0 | 98.974 | 99.639175257732 | 195 | 1 | 100 | 1 | 1 | 194 | 1627 | 1433 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 19330 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 2576522 | 2576522 | PRJEB29441_P_NODE_35543_length_175_cov_1.603175_g35102_i0 | PRJEB29441 | 35543 | 175 | 1.603175 | 2.80555625 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 109 | 3.92e-26 | NR | CAF0708291.1 | 104777 | g35102 | i0 | 85.7 | 0.96 | 56 | 8 | 96 | 0 | 2 | 169 | 299 | 354 | CAF0708291.1 unnamed protein product [Brachionus calyciflorus] | diamond | 168 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 7678523 | 7678523 | PRJEB29441_P_NODE_15287_length_278_cov_4.938865_g14846_i0 | PRJEB29441 | 15287 | 278 | 4.938865 | 13.7300447 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 497 | 2.73e-136 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g14846 | i0 | 98.921 | 26.3525179856115 | 278 | 3 | 100 | 0 | 1 | 278 | 1717 | 1440 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 7326 | 497 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 11191743 | 11191743 | PRJEB29441_P_NODE_5809_length_492_cov_4.672686_g5376_i0 | PRJEB29441 | 5809 | 492 | 4.672686 | 22.98961512 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 505 | 3.069999999999999e-138 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g5376 | i0 | 85.404 | 92.6483739837398 | 507 | 51 | 100 | 17 | 1 | 492 | 829 | 331 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 45583 | 510 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 14054844 | 14054844 | PRJEB29441_P_NODE_38012_length_168_cov_4.966387_g37571_i0 | PRJEB29441 | 38012 | 168 | 4.966387 | 8.34353016 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 294 | 2.12e-75 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g37571 | i0 | 98.214 | 33.6488095238095 | 168 | 3 | 100 | 0 | 1 | 168 | 1851 | 2018 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 5653 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 19151858 | 19151858 | PRJEB29441_P_NODE_18216_length_251_cov_4.450495_g17775_i0 | PRJEB29441 | 18216 | 251 | 4.450495 | 11.17074245 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 327 | 3.37e-85 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g17775 | i0 | 90.947 | 2.83665338645418 | 243 | 22 | 97 | 0 | 9 | 251 | 10398 | 10156 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 712 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22665063 | 22665063 | PRJEB29441_P_NODE_18218_length_251_cov_3.841584_g17777_i0 | PRJEB29441 | 18218 | 251 | 3.841584 | 9.64237584 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 442 | 1.1599999999999995e-119 | NTclustered | gi|2537903785|gb|KM043250.2| | 758807 | g17777 | i0 | 98.406 | 93.4541832669323 | 251 | 4 | 100 | 0 | 1 | 251 | 292 | 42 | Abrochtha sonneborni voucher Bird_3_2 18S ribosomal RNA gene, partial sequence | blastn | 23457 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinavida | Philodinavidae | Abrochtha | Abrochtha sonneborni | |
| 22978180 | 22978180 | PRJEB29441_P_NODE_10079_length_356_cov_9.736156_g9638_i0 | PRJEB29441 | 10079 | 356 | 9.736156 | 34.66071536 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 553 | 7.579999999999998e-153 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g9638 | i0 | 94.663 | 77.0842696629213 | 356 | 19 | 100 | 0 | 1 | 356 | 6650 | 7005 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 27442 | 553 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22978700 | 22978700 | PRJEB29441_P_NODE_41139_length_165_cov_1.758621_g40698_i0 | PRJEB29441 | 41139 | 165 | 1.758621 | 2.90172465 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 283 | 4.4899999999999995e-72 | NTclustered | gi|83285189|gb|DQ297736.1| | 96446 | g40698 | i0 | 97.576 | 18.6363636363636 | 165 | 4 | 100 | 0 | 1 | 165 | 192 | 28 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 3075 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 22978887 | 22978887 | PRJEB29441_P_NODE_9099_length_378_cov_7.680851_g8658_i0 | PRJEB29441 | 9099 | 378 | 7.680851 | 29.03361678 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 516 | 1.06e-141 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g8658 | i0 | 91.27 | 34.4656084656085 | 378 | 33 | 100 | 0 | 1 | 378 | 417 | 40 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 13028 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 26589787 | 26589787 | PRJEB29441_P_NODE_42881_length_164_cov_0.886957_g42440_i0 | PRJEB29441 | 42881 | 164 | 0.886957 | 1.45460948 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 72.8 | 3.23e-13 | NR | CAF1123067.1 | 392033 | g42440 | i0 | 57.4 | 3.95121951219512 | 54 | 23 | 98.8 | 0 | 2 | 163 | 544 | 597 | CAF1123067.1 unnamed protein product [Rotaria sordida] | diamond | 648 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 26780160 | 26780160 | PRJEB29441_P_NODE_31061_length_188_cov_1.194245_g30620_i0 | PRJEB29441 | 31061 | 188 | 1.194245 | 2.2451806 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 67.8 | 2.72e-12 | NR | UJR27921.1 | 104782 | g30620 | i0 | 56.4 | 3.28723404255319 | 55 | 24 | 87.8 | 0 | 24 | 188 | 1 | 55 | UJR27921.1 hypothetical protein I4U23_009181 [Adineta vaga] | diamond | 618 | 67.8 | 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);;