contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA902848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3432725 | 3432725 | PRJNA902848_P_NODE_2623_length_471_cov_1.007538_g2573_i0 | PRJNA902848 | 2623 | 471 | 1.007538 | 4.74550398 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 499 | 1.3599999999999999e-136 | NTclustered | gi|402761759|gb|JX184011.1| | 104788 | g2573 | i0 | 85.775 | 30.9808917197452 | 471 | 67 | 100 | 0 | 1 | 471 | 579 | 109 | Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 14592 | 499 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 5985476 | 5985476 | PRJNA902848_P_NODE_705_length_766_cov_11.473304_g662_i0 | PRJNA902848 | 705 | 766 | 11.473304 | 87.88550864 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 1310 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g662 | i0 | 97.523 | 92.1971279373368 | 767 | 18 | 100 | 1 | 1 | 766 | 376 | 1142 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 70623 | 1310 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 9809933 | 9809933 | PRJNA902848_P_NODE_20568_length_229_cov_6.730769_g20518_i0 | PRJNA902848 | 20568 | 229 | 6.730769 | 15.41346101 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 385 | 1.77e-102 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g20518 | i0 | 96.943 | 83.5982532751092 | 229 | 7 | 100 | 0 | 1 | 229 | 57 | 285 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 19144 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 13635877 | 13635877 | PRJNA902848_P_NODE_7411_length_321_cov_1.649194_g7361_i0 | PRJNA902848 | 7411 | 321 | 1.649194 | 5.29391274 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 267 | 9.88e-67 | NTclustered | gi|402761729|gb|JX183996.1| | 104788 | g7361 | i0 | 81.734 | 2.42679127725857 | 323 | 55 | 100 | 3 | 1 | 321 | 456 | 136 | Macrotrachela quadricornifera isolate CR ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 779 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 13635891 | 13635891 | PRJNA902848_P_NODE_791_length_732_cov_11.738998_g747_i0 | PRJNA902848 | 791 | 732 | 11.738998 | 85.92946536 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 723 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g747 | i0 | 84.885 | 21.3087431693989 | 741 | 85 | 99 | 22 | 2 | 732 | 2392 | 1669 | Philodina citrina complete mitochondrial genome | blastn | 15598 | 723 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 17824644 | 17824644 | PRJNA902848_P_NODE_8694_length_302_cov_1.218341_g8644_i0 | PRJNA902848 | 8694 | 302 | 1.218341 | 3.67938982 | Ploima | 84394 | Rotifera | other_Eukaryota | 287 | 7.08e-73 | NTclustered | gi|1189131121|dbj|LC215601.1| | 1957054 | g8644 | i0 | 83.946 | 98.6523178807947 | 299 | 48 | 99 | 0 | 1 | 299 | 323 | 621 | Trichocerca sp. WM-2017a mitochondrial COI gene for cytochrome c oxidase subunit I, partial cds, isolate: Tricho_012 | blastn | 29793 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Trichocercidae | Trichocerca | Trichocerca sp. WM-2017a | |
| 22924580 | 22924580 | PRJNA902848_P_NODE_11998_length_262_cov_6.137566_g11948_i0 | PRJNA902848 | 11998 | 262 | 6.137566 | 16.08042292 | Metazoa | 33208 | Rotifera | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g11948 | i0 | 100 | 99.9160305343512 | 262 | 0 | 100 | 0 | 1 | 262 | 1451 | 1190 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 26178 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;