contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA883229" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 859983 | 859983 | PRJNA883229_P_NODE_1681_length_480_cov_1.847666_g1635_i0 | PRJNA883229 | 1681 | 480 | 1.847666 | 8.8687968 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 357 | 8.849999999999997e-94 | NTclustered | gi|62362203|gb|AY942841.1| | 317012 | g1635 | i0 | 81.465 | 5.01666666666667 | 437 | 79 | 91 | 2 | 45 | 480 | 71 | 506 | Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds | blastn | 2408 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 3410721 | 3410721 | PRJNA883229_P_NODE_2743_length_387_cov_1.987261_g2697_i0 | PRJNA883229 | 2743 | 387 | 1.987261 | 7.69070007 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 329 | 1.52e-85 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g2697 | i0 | 84.273 | 48.9483204134367 | 337 | 53 | 87 | 0 | 4 | 340 | 26374 | 26038 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 18943 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 5963270 | 5963270 | PRJNA883229_P_NODE_4205_length_328_cov_3.054902_g4159_i0 | PRJNA883229 | 4205 | 328 | 3.054902 | 10.02007856 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 573 | 5.329999999999998e-159 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g4159 | i0 | 98.171 | 4.46036585365854 | 328 | 6 | 100 | 0 | 1 | 328 | 10057 | 10384 | 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 | 1463 | 573 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 5963284 | 5963284 | PRJNA883229_P_NODE_4985_length_308_cov_2.365957_g4939_i0 | PRJNA883229 | 4985 | 308 | 2.365957 | 7.28714756 | Adineta vaga complex sp. C JFF-2016 | 1813166 | Rotifera | other_Eukaryota | 326 | 1.53e-84 | NTclustered | gi|1005061344|gb|KU861166.1| | 1813166 | g4939 | i0 | 88.476 | 70.0876623376623 | 269 | 31 | 87 | 0 | 14 | 282 | 462 | 194 | Adineta vaga complex sp. C JFF-2016 isolate H4-28a 82 kDa heat shock protein gene, partial cds | blastn | 21587 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. C JFF-2016 | |
| 9787905 | 9787905 | PRJNA883229_P_NODE_2528_length_400_cov_3.984709_g2482_i0 | PRJNA883229 | 2528 | 400 | 3.984709 | 15.938836 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 717 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g2482 | i0 | 99 | 59.1275 | 400 | 4 | 100 | 0 | 1 | 400 | 2398 | 2797 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 23651 | 717 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 11063634 | 11063634 | PRJNA883229_P_NODE_9189_length_252_cov_1.307263_g9143_i0 | PRJNA883229 | 9189 | 252 | 1.307263 | 3.29430276 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 274 | 4.48e-69 | NTclustered | gi|402761789|gb|JX184026.1| | 104786 | g9143 | i0 | 86.454 | 33.3928571428571 | 251 | 33 | 99 | 1 | 2 | 252 | 467 | 218 | Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 8415 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 12339111 | 12339111 | PRJNA883229_P_NODE_610_length_762_cov_6.082729_g570_i0 | PRJNA883229 | 610 | 762 | 6.082729 | 46.35039498 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 811 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g570 | i0 | 86.28 | 22.0866141732283 | 758 | 90 | 99 | 13 | 1 | 752 | 1659 | 2408 | Philodina citrina complete mitochondrial genome | blastn | 16830 | 811 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 14887969 | 14887969 | PRJNA883229_P_NODE_192_length_1247_cov_3.880750_g169_i0 | PRJNA883229 | 192 | 1247 | 3.88075 | 48.3929525 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 1585 | 0 | NTclustered | gi|402761731|gb|JX183997.1| | 104788 | g169 | i0 | 89.647 | 56.4266238973537 | 1246 | 127 | 99 | 2 | 1 | 1245 | 15 | 1259 | Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 70364 | 1585 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 14888063 | 14888063 | PRJNA883229_P_NODE_852_length_660_cov_1.524702_g809_i0 | PRJNA883229 | 852 | 660 | 1.524702 | 10.0630332 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 396 | 2.63e-105 | NTclustered | gi|187233667|gb|EU643500.1| | 104782 | g809 | i0 | 79.852 | 68.6484848484849 | 541 | 109 | 82 | 0 | 5 | 545 | 614 | 74 | Adineta vaga ribosomal protein L11 mRNA, partial cds | blastn | 45308 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 15269008 | 15269008 | PRJNA883229_P_NODE_3012_length_373_cov_7.770000_g2966_i0 | PRJNA883229 | 3012 | 373 | 7.77 | 28.9821 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 689 | 0 | NTclustered | gi|2537903788|gb|KM043253.2| | 104782 | g2966 | i0 | 100 | 99.7479892761394 | 373 | 0 | 100 | 0 | 1 | 373 | 548 | 920 | Adineta vaga voucher AD006 18S ribosomal RNA gene, partial sequence | blastn | 37206 | 689 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 16162707 | 16162707 | PRJNA883229_P_NODE_4733_length_314_cov_2.149378_g4687_i0 | PRJNA883229 | 4733 | 314 | 2.149378 | 6.74904692 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 287 | 7.399999999999999e-73 | NTclustered | gi|187233665|gb|EU643499.1| | 104782 | g4687 | i0 | 85.455 | 1.15286624203822 | 275 | 40 | 88 | 0 | 13 | 287 | 1 | 275 | Adineta vaga ribosomal protein L26 mRNA, partial cds | blastn | 362 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 17818670 | 17818670 | PRJNA883229_P_NODE_934_length_631_cov_2.885305_g891_i0 | PRJNA883229 | 934 | 631 | 2.885305 | 18.20627455 | Adineta | 104781 | Rotifera | other_Eukaryota | 1120 | 0 | NTclustered | gi|1005055512|gb|KU860655.1| | 1813164 | g891 | i0 | 98.732 | 41.7527733755943 | 631 | 7 | 100 | 1 | 1 | 631 | 2027 | 1398 | Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence | blastn | 26346 | 1120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. A JFF-2016 | |
| 20367454 | 20367454 | PRJNA883229_P_NODE_5596_length_295_cov_1.954955_g5550_i0 | PRJNA883229 | 5596 | 295 | 1.954955 | 5.76711725 | Adineta | 104781 | Rotifera | other_Eukaryota | 534 | 2.23e-147 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g5550 | i0 | 99.322 | 92.1661016949153 | 295 | 2 | 100 | 0 | 1 | 295 | 796 | 502 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 27189 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 21643286 | 21643286 | PRJNA883229_P_NODE_3997_length_335_cov_3.465649_g3951_i0 | PRJNA883229 | 3997 | 335 | 3.465649 | 11.60992415 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 603 | 6.9499999999999975e-168 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g3951 | i0 | 99.104 | 76.9432835820895 | 335 | 3 | 100 | 0 | 1 | 335 | 6986 | 6652 | 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 | 25776 | 603 | 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);;