contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1821116 | 1821116 | PRJNA561212_P_NODE_23582_length_246_cov_1.670520_g23371_i0 | PRJNA561212 | 23582 | 246 | 1.67052 | 4.1094792 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 206 | 1.61e-48 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g23371 | i0 | 83.544 | 3.18292682926829 | 237 | 22 | 93 | 14 | 10 | 238 | 1993 | 1766 | Philodina citrina complete mitochondrial genome | blastn | 783 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 1821139 | 1821139 | PRJNA561212_P_NODE_25702_length_242_cov_1.378698_g25491_i0 | PRJNA561212 | 25702 | 242 | 1.378698 | 3.33644916 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 261 | 3.33e-65 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g25491 | i0 | 87.892 | 5.09917355371901 | 223 | 25 | 92 | 2 | 7 | 228 | 2389 | 2168 | Philodina citrina complete mitochondrial genome | blastn | 1234 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 3096239 | 3096239 | PRJNA561212_P_NODE_13463_length_305_cov_0.961207_g13252_i0 | PRJNA561212 | 13463 | 305 | 0.961207 | 2.93168135 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 324 | 5.4599999999999995e-84 | NTclustered | gi|1800242915|gb|MN983090.1| | 96446 | g13252 | i0 | 86.441 | 96.6885245901639 | 295 | 40 | 97 | 0 | 1 | 295 | 168 | 462 | Lecane bulla isolate LbullaMAG306 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 29490 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 3682007 | 3682007 | PRJNA561212_P_NODE_18903_length_261_cov_8.808511_g18692_i0 | PRJNA561212 | 18903 | 261 | 8.808511 | 22.99021371 | Lecane | 96445 | Rotifera | other_Eukaryota | 446 | 9.339999999999999e-121 | NTclustered | gi|1845957832|gb|MT522656.1| | 1213210 | g18692 | i0 | 99.59 | 93.4521072796935 | 244 | 1 | 93 | 0 | 9 | 252 | 612 | 855 | Lecane ludwigii isolate JH_005J07 small subunit ribosomal RNA gene, partial sequence | blastn | 24391 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane ludwigii | |
| 4373005 | 4373005 | PRJNA561212_P_NODE_7644_length_397_cov_1.283951_g7433_i0 | PRJNA561212 | 7644 | 397 | 1.283951 | 5.09728547 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 387 | 9.17e-103 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g7433 | i0 | 86.571 | 80.6272040302267 | 350 | 47 | 88 | 0 | 9 | 358 | 1359 | 1010 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 32009 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 4958815 | 4958815 | PRJNA561212_P_NODE_2804_length_658_cov_3.006838_g2599_i0 | PRJNA561212 | 2804 | 658 | 3.006838 | 19.78499404 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1096 | 0 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g2599 | i0 | 97.368 | 41.2370820668693 | 646 | 13 | 98 | 3 | 8 | 649 | 1534 | 2179 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 27134 | 1107 | 0.990063233965673 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 15848126 | 15848126 | PRJNA561212_P_NODE_12913_length_310_cov_1.628692_g12702_i0 | PRJNA561212 | 12913 | 310 | 1.628692 | 5.0489452 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 366 | 9.11e-97 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g12702 | i0 | 90.391 | 54.0064516129032 | 281 | 23 | 90 | 4 | 10 | 288 | 2153 | 1875 | Philodina citrina complete mitochondrial genome | blastn | 16742 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 17122936 | 17122936 | PRJNA561212_P_NODE_11134_length_332_cov_1.212355_g10923_i0 | PRJNA561212 | 11134 | 332 | 1.212355 | 4.0250186 | Notommata allantois | 360683 | Rotifera | other_Eukaryota | 374 | 5.879999999999999e-99 | NTclustered | gi|1845941366|gb|MT521622.1| | 360683 | g10923 | i0 | 88.254 | 93.2259036144578 | 315 | 34 | 94 | 3 | 10 | 322 | 48 | 361 | Notommata allantois voucher AZF8_NA2 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 30951 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Notommata | Notommata allantois | |
| 17708641 | 17708641 | PRJNA561212_P_NODE_13554_length_303_cov_4.056522_g13343_i0 | PRJNA561212 | 13554 | 303 | 4.056522 | 12.29126166 | Metazoa | 33208 | Rotifera | other_Eukaryota | 520 | 6.439999999999999e-143 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g13343 | i0 | 99.649 | 52.016501650165 | 285 | 0 | 94 | 1 | 10 | 294 | 1813 | 1530 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 15761 | 521 | 0.998080614203455 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 18397361 | 18397361 | PRJNA561212_P_NODE_25015_length_244_cov_0.906433_g24804_i0 | PRJNA561212 | 25015 | 244 | 0.906433 | 2.21169652 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 204 | 5.74e-48 | NTclustered | gi|402761847|gb|JX184055.1| | 104788 | g24804 | i0 | 83.408 | 4.54508196721311 | 223 | 34 | 91 | 3 | 11 | 231 | 342 | 563 | Macrotrachela quadricornifera isolate LH NADH dehydrogenase subunit 4 (ND4) gene, partial cds; mitochondrial | blastn | 1109 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 24771786 | 24771786 | PRJNA561212_P_NODE_6280_length_440_cov_0.929155_g6069_i0 | PRJNA561212 | 6280 | 440 | 0.929155 | 4.088282 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 715 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g6069 | i0 | 97.826 | 4.64772727272727 | 414 | 9 | 94 | 0 | 10 | 423 | 9985 | 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 | 2045 | 715 | 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);;