contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA527965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1114274 | 1114274 | PRJNA527965_S_NODE_3181_length_213_cov_5.696629_g3098_i0 | PRJNA527965 | 3181 | 213 | 5.696629 | 12.13381977 | Asplanchna | 84396 | Rotifera | other_Eukaryota | 370 | 4.5599999999999996e-98 | NTclustered | gi|6456035|gb|AF092434.1|AF092434 | 84397 | g3098 | i0 | 98.122 | 99.906103286385 | 213 | 2 | 99 | 2 | 2 | 213 | 640 | 851 | Asplanchna sieboldi 18S ribosomal RNA gene, complete sequence | blastn | 21280 | 372 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 1772111 | 1772111 | PRJNA527965_S_NODE_5982_length_153_cov_1.847458_g5899_i0 | PRJNA527965 | 5982 | 153 | 1.847458 | 2.82661074 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 283 | 4.0799999999999995e-72 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g5899 | i0 | 100 | 25.4705882352941 | 153 | 0 | 100 | 0 | 1 | 153 | 1501 | 1653 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 3897 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 3665604 | 3665604 | PRJNA527965_S_NODE_6183_length_151_cov_1.543103_g6100_i0 | PRJNA527965 | 6183 | 151 | 1.543103 | 2.33008553 | Lecane | 96445 | Rotifera | other_Eukaryota | 206 | 8.94e-49 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g6100 | i0 | 91.333 | 49.1854304635762 | 150 | 13 | 99 | 0 | 2 | 151 | 1273 | 1124 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 7427 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 4323813 | 4323813 | PRJNA527965_S_NODE_3504_length_203_cov_4.970238_g3421_i0 | PRJNA527965 | 3504 | 203 | 4.970238 | 10.08958314 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 333 | 5.639999999999999e-87 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g3421 | i0 | 96.517 | 18.1034482758621 | 201 | 7 | 99 | 0 | 1 | 201 | 1528 | 1728 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 3675 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 4942564 | 4942564 | PRJNA527965_S_NODE_4104_length_187_cov_1.763158_g4021_i0 | PRJNA527965 | 4104 | 187 | 1.763158 | 3.29710546 | Metazoa | 33208 | Rotifera | other_Eukaryota | 337 | 3.95e-88 | NTclustered | gi|1399047|gb|U41281.1|PAU41281 | 44582 | g4021 | i0 | 99.459 | 98.9465240641711 | 185 | 1 | 99 | 0 | 1 | 185 | 227 | 411 | Philodina acuticornis 18S rRNA gene | blastn | 18503 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina acuticornis | |
| 19622900 | 19622900 | PRJNA527965_S_NODE_3176_length_213_cov_10.848315_g3093_i0 | PRJNA527965 | 3176 | 213 | 10.848315 | 23.10691095 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 344 | 2.76e-90 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g3093 | i0 | 95.775 | 95.6525821596244 | 213 | 9 | 100 | 0 | 1 | 213 | 2311 | 2523 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 20374 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 24722888 | 24722888 | PRJNA527965_S_NODE_1880_length_285_cov_4.204000_g1797_i0 | PRJNA527965 | 1880 | 285 | 4.204 | 11.9814 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 379 | 1.06e-100 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g1797 | i0 | 90.69 | 47.7964912280702 | 290 | 20 | 100 | 5 | 1 | 285 | 2092 | 1805 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 13622 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris |
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);;