contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA438687" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 435284 | 435284 | PRJNA438687_S_NODE_2601_length_276_cov_18.394191_g2511_i0 | PRJNA438687 | 2601 | 276 | 18.394191 | 50.76796716 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 464 | 2.75e-126 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g2511 | i0 | 97.778 | 57.0724637681159 | 270 | 5 | 97 | 1 | 8 | 276 | 1448 | 1179 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 15752 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 2985956 | 2985956 | PRJNA438687_S_NODE_2363_length_288_cov_7.845850_g2273_i0 | PRJNA438687 | 2363 | 288 | 7.84585 | 22.596048 | Encentrum astridae | 360661 | Rotifera | other_Eukaryota | 484 | 2.2199999999999994e-132 | NTclustered | gi|124388846|gb|EF151006.1| | 360661 | g2273 | i0 | 97.203 | 99.9722222222222 | 286 | 8 | 99 | 0 | 3 | 288 | 2028 | 1743 | Encentrum astridae 28S ribosomal RNA gene, partial sequence | blastn | 28792 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum astridae | |
| 5539012 | 5539012 | PRJNA438687_S_NODE_4285_length_214_cov_14.379888_g4195_i0 | PRJNA438687 | 4285 | 214 | 14.379888 | 30.77296032 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 355 | 1.28e-93 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g4195 | i0 | 96.714 | 97.6168224299065 | 213 | 7 | 99 | 0 | 2 | 214 | 2524 | 2312 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 20890 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 9363369 | 9363369 | PRJNA438687_S_NODE_6268_length_175_cov_3.478571_g6178_i0 | PRJNA438687 | 6268 | 175 | 3.478571 | 6.08749925 | Bryceella stylata | 2739610 | Rotifera | other_Eukaryota | 254 | 3.77e-63 | NTclustered | gi|1845957807|gb|MT522631.1| | 2739610 | g6178 | i0 | 99.286 | 80.0342857142857 | 140 | 1 | 80 | 0 | 1 | 140 | 953 | 1092 | Bryceella stylata isolate JH_006A06 small subunit ribosomal RNA gene, partial sequence | blastn | 14006 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Bryceella | Bryceella stylata | |
| 15737988 | 15737988 | PRJNA438687_S_NODE_4973_length_199_cov_8.896341_g4883_i0 | PRJNA438687 | 4973 | 199 | 8.896341 | 17.70371859 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 276 | 9.41e-70 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g4883 | i0 | 91.626 | 47.21608040201 | 203 | 11 | 100 | 4 | 1 | 199 | 2051 | 1851 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 9396 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 17012588 | 17012588 | PRJNA438687_S_NODE_2074_length_302_cov_3.925094_g1984_i0 | PRJNA438687 | 2074 | 302 | 3.925094 | 11.85378388 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 542 | 1.37e-149 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g1984 | i0 | 99.007 | 26.2615894039735 | 302 | 3 | 100 | 0 | 1 | 302 | 1503 | 1804 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 7931 | 542 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria |
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);;