contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961267 | 3961267 | PRJEB73599_P_NODE_2964_length_421_cov_5.318878_g2682_i0 | PRJEB73599 | 2964 | 421 | 5.318878 | 22.39247638 | Keratella quadrata | 204742 | Rotifera | other_Eukaryota | 396 | 1.63e-105 | NTclustered | gi|83285188|gb|DQ297735.1| | 204742 | g2682 | i0 | 83.765 | 66.855106888361 | 425 | 62 | 100 | 7 | 1 | 421 | 738 | 317 | Keratella quadrata 28S ribosomal RNA gene, partial sequence | blastn | 28146 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella quadrata | |
| 6513292 | 6513292 | PRJEB73599_P_NODE_6406_length_237_cov_3.038462_g6119_i0 | PRJEB73599 | 6406 | 237 | 3.038462 | 7.20115494 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 320 | 5.28e-83 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g6119 | i0 | 91.176 | 43.3459915611814 | 238 | 18 | 100 | 3 | 1 | 237 | 2065 | 1830 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 10273 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 10338254 | 10338254 | PRJEB73599_P_NODE_8869_length_173_cov_2.944444_g8582_i0 | PRJEB73599 | 8869 | 173 | 2.944444 | 5.09388812 | Encentrum tectipes | 360662 | Rotifera | other_Eukaryota | 176 | 8.26e-40 | NTclustered | gi|83285187|gb|DQ297734.1| | 360662 | g8582 | i0 | 85.057 | 37.2601156069364 | 174 | 24 | 99 | 2 | 2 | 173 | 1 | 174 | Encentrum tectipes 28S ribosomal RNA gene, partial sequence | blastn | 6446 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum tectipes | |
| 11198800 | 11198800 | PRJEB73599_P_NODE_2929_length_423_cov_8.449239_g2647_i0 | PRJEB73599 | 2929 | 423 | 8.449239 | 35.74028097 | Ploima | 84394 | Rotifera | other_Eukaryota | 387 | 9.83e-103 | NTclustered | gi|83285199|gb|DQ297746.1| | 360681 | g2647 | i0 | 83.333 | 67.4397163120567 | 432 | 59 | 100 | 9 | 1 | 423 | 317 | 744 | Mytilina mucronata 28S ribosomal RNA gene, partial sequence | blastn | 28527 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina mucronata | |
| 11613665 | 11613665 | PRJEB73599_P_NODE_3190_length_402_cov_3.613941_g2904_i0 | PRJEB73599 | 3190 | 402 | 3.613941 | 14.52804282 | Monommata maculata | 360679 | Rotifera | other_Eukaryota | 285 | 3.4899999999999997e-72 | NTclustered | gi|83285198|gb|DQ297745.1| | 360679 | g2904 | i0 | 82.749 | 17.4253731343284 | 342 | 38 | 83 | 16 | 71 | 402 | 410 | 740 | Monommata maculata 28S ribosomal RNA gene, partial sequence | blastn | 7005 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Monommata | Monommata maculata | |
| 12474460 | 12474460 | PRJEB73599_P_NODE_5910_length_254_cov_4.413333_g5623_i0 | PRJEB73599 | 5910 | 254 | 4.413333 | 11.20986582 | Ploima | 84394 | Rotifera | other_Eukaryota | 368 | 2.02e-97 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g5623 | i0 | 92.913 | 87.9803149606299 | 254 | 17 | 100 | 1 | 1 | 254 | 1705 | 1453 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 22347 | 370 | 0.994594594594595 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 19260766 | 19260766 | PRJEB73599_P_NODE_3336_length_392_cov_2.578512_g3050_i0 | PRJEB73599 | 3336 | 392 | 2.578512 | 10.10776704 | Ascomorpha ovalis | 360655 | Rotifera | other_Eukaryota | 303 | 9.37e-78 | NTclustered | gi|83285183|gb|DQ297730.1| | 360655 | g3050 | i0 | 80 | 16.4285714285714 | 400 | 69 | 100 | 10 | 1 | 392 | 341 | 737 | Ascomorpha ovalis 28S ribosomal RNA gene, partial sequence | blastn | 6440 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Gastropidae | Ascomorpha | Ascomorpha ovalis | |
| 21811978 | 21811978 | PRJEB73599_P_NODE_9138_length_168_cov_4.517986_g8851_i0 | PRJEB73599 | 9138 | 168 | 4.517986 | 7.59021648 | Encentrum tectipes | 360662 | Rotifera | other_Eukaryota | 237 | 3.63e-58 | NTclustered | gi|83285187|gb|DQ297734.1| | 360662 | g8851 | i0 | 92.262 | 64.6428571428571 | 168 | 11 | 100 | 2 | 1 | 168 | 908 | 743 | Encentrum tectipes 28S ribosomal RNA gene, partial sequence | blastn | 10860 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum tectipes |
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);;