contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1205037 | 1205037 | PRJNA763243_P_NODE_17961_length_369_cov_16.466216_g17616_i0 | PRJNA763243 | 17961 | 369 | 16.466216 | 60.76033704 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 673 | 0 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g17616 | i0 | 99.728 | 99.2845528455285 | 367 | 1 | 99 | 0 | 1 | 367 | 902 | 536 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 36636 | 673 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 1205103 | 1205103 | PRJNA763243_P_NODE_32401_length_299_cov_8.991150_g32055_i0 | PRJNA763243 | 32401 | 299 | 8.99115 | 26.8835385 | Ploima | 84394 | Rotifera | other_Eukaryota | 466 | 8.38e-127 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g32055 | i0 | 95.254 | 95.9966555183946 | 295 | 13 | 99 | 1 | 4 | 298 | 1423 | 1716 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 28703 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 3756903 | 3756903 | PRJNA763243_P_NODE_24583_length_325_cov_14.234127_g24237_i0 | PRJNA763243 | 24583 | 325 | 14.234127 | 46.26091275 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 555 | 1.9099999999999995e-153 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g24237 | i0 | 98.113 | 79.3138461538462 | 318 | 6 | 98 | 0 | 5 | 322 | 7005 | 6688 | 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 | 25777 | 560 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4571446 | 4571446 | PRJNA763243_P_NODE_32184_length_300_cov_4.493392_g31838_i0 | PRJNA763243 | 32184 | 300 | 4.493392 | 13.480176 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 396 | 1.12e-105 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g31838 | i0 | 94.574 | 88.9766666666667 | 258 | 10 | 85 | 4 | 45 | 300 | 1 | 256 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 26693 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 7583290 | 7583290 | PRJNA763243_P_NODE_48466_length_257_cov_4.255435_g48120_i0 | PRJNA763243 | 48466 | 257 | 4.255435 | 10.93646795 | Adineta | 104781 | Rotifera | other_Eukaryota | 403 | 5.599999999999998e-108 | NTclustered | gi|1005055598|gb|KU860741.1| | 1813167 | g48120 | i0 | 95.294 | 84.5214007782101 | 255 | 10 | 99 | 2 | 1 | 254 | 383 | 130 | Adineta vaga complex sp. D JFF-2016 isolate H3-14b 28S ribosomal RNA gene, partial sequence | blastn | 21722 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. D JFF-2016 | |
| 10948113 | 10948113 | PRJNA763243_P_NODE_70229_length_219_cov_7.205479_g69883_i0 | PRJNA763243 | 70229 | 219 | 7.205479 | 15.77999901 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 272 | 1.37e-68 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g69883 | i0 | 99.333 | 2.72146118721461 | 150 | 1 | 100 | 0 | 70 | 219 | 10370 | 10221 | 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 | 596 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 11409079 | 11409079 | PRJNA763243_P_NODE_5389_length_610_cov_7.376164_g5066_i0 | PRJNA763243 | 5389 | 610 | 7.376164 | 44.9946004 | Adineta | 104781 | Rotifera | other_Eukaryota | 1101 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g5066 | i0 | 99.504 | 42.4885245901639 | 605 | 3 | 99 | 0 | 3 | 607 | 2105 | 1501 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 25918 | 1101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13959374 | 13959374 | PRJNA763243_P_NODE_74691_length_199_cov_9.595238_g74345_i0 | PRJNA763243 | 74691 | 199 | 9.595238 | 19.09452362 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 363 | 7.019999999999998e-96 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g74345 | i0 | 100 | 96.1758793969849 | 196 | 0 | 98 | 0 | 4 | 199 | 691 | 496 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 19139 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22883040 | 22883040 | PRJNA763243_P_NODE_67998_length_228_cov_6.406452_g67652_i0 | PRJNA763243 | 67998 | 228 | 6.406452 | 14.60671056 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 353 | 4.98e-93 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g67652 | i0 | 95.111 | 93.2719298245614 | 225 | 10 | 99 | 1 | 4 | 228 | 7019 | 7242 | 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 | 21266 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24969251 | 24969251 | PRJNA763243_P_NODE_12980_length_423_cov_4.185714_g12635_i0 | PRJNA763243 | 12980 | 423 | 4.185714 | 17.70557022 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 760 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g12635 | i0 | 99.286 | 58.1678486997636 | 420 | 3 | 99 | 0 | 1 | 420 | 2806 | 2387 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 24605 | 760 | 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);;