contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 380671 | 380671 | PRJNA315314_S_NODE_12541_length_229_cov_61.230000_g12220_i0 | PRJNA315314 | 12541 | 229 | 61.23 | 140.2167 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 193 | 1.15e-44 | NTclustered | gi|37788192|gb|AY218145.1| | 104782 | g12220 | i0 | 91.034 | 59.1703056768559 | 145 | 9 | 62 | 4 | 2 | 144 | 302 | 160 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 13550 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2931594 | 2931594 | PRJNA315314_S_NODE_3183_length_446_cov_74.541966_g2863_i0 | PRJNA315314 | 3183 | 446 | 74.541966 | 332.45716836 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 793 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g2863 | i0 | 98.874 | 80.3766816143498 | 444 | 5 | 99 | 0 | 3 | 446 | 4595 | 4152 | 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 | 35848 | 793 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 6168107 | 6168107 | PRJNA315314_S_NODE_19585_length_186_cov_51.426752_g19264_i0 | PRJNA315314 | 19585 | 186 | 51.426752 | 95.65375872 | Metazoa | 33208 | Rotifera | other_Eukaryota | 344 | 2.34e-90 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g19264 | i0 | 100 | 103.327956989247 | 186 | 0 | 100 | 0 | 1 | 186 | 1373 | 1188 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 19219 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 7443156 | 7443156 | PRJNA315314_S_NODE_15406_length_208_cov_64.916201_g15085_i0 | PRJNA315314 | 15406 | 208 | 64.916201 | 135.02569808 | Metazoa | 33208 | Rotifera | other_Eukaryota | 383 | 5.69e-102 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g15085 | i0 | 100 | 98.7451923076923 | 207 | 0 | 99 | 0 | 2 | 208 | 3151 | 2945 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 20539 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 10584828 | 10584828 | PRJNA315314_S_NODE_3709_length_415_cov_61.489637_g3388_i0 | PRJNA315314 | 3709 | 415 | 61.489637 | 255.18199355 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 686 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g3388 | i0 | 98.705 | 4.58313253012048 | 386 | 5 | 93 | 0 | 1 | 386 | 10013 | 10398 | 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 | 1902 | 686 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13818704 | 13818704 | PRJNA315314_S_NODE_21311_length_179_cov_21.800000_g20990_i0 | PRJNA315314 | 21311 | 179 | 21.8 | 39.022 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 283 | 4.94e-72 | NTclustered | gi|57282209|emb|AJ487047.1| | 195509 | g20990 | i0 | 95.055 | 101.675977653631 | 182 | 5 | 100 | 4 | 1 | 179 | 684 | 864 | Floscularia decora 18S rRNA gene | blastn | 18200 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Flosculariaceae | Flosculariidae | Floscularia | Floscularia decora | |
| 15683298 | 15683298 | PRJNA315314_S_NODE_12013_length_234_cov_32.624390_g11692_i0 | PRJNA315314 | 12013 | 234 | 32.62439 | 76.3410726 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 411 | 3e-110 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g11692 | i0 | 98.291 | 27.0384615384615 | 234 | 4 | 100 | 0 | 1 | 234 | 2390 | 2623 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 6327 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 16367943 | 16367943 | PRJNA315314_S_NODE_533_length_1031_cov_81.878244_g403_i0 | PRJNA315314 | 533 | 1031 | 81.878244 | 844.16469564 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1749 | 0 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g403 | i0 | 97.3 | 35.0436469447139 | 1037 | 17 | 99 | 8 | 4 | 1031 | 2187 | 1153 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 36130 | 1764 | 0.991496598639456 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 23332873 | 23332873 | PRJNA315314_S_NODE_23979_length_170_cov_34.212766_g23658_i0 | PRJNA315314 | 23979 | 170 | 34.212766 | 58.1617022 | Lecanidae environmental sample | 662389 | Rotifera | other_Eukaryota | 257 | 2.81e-64 | NTclustered | gi|255760339|gb|GQ371121.1| | 662389 | g23658 | i0 | 94.611 | 98.3411764705882 | 167 | 8 | 98 | 1 | 1 | 167 | 191 | 26 | Lecanidae environmental sample clone Lacanidae2 18S ribosomal RNA gene, partial sequence | blastn | 16718 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecanidae environmental sample |
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);;