contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3332470 | 3332470 | PRJNA797475_P_NODE_23303_length_249_cov_0.875000_g23204_i0 | PRJNA797475 | 23303 | 249 | 0.875 | 2.17875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 460 | 3.16e-125 | NTclustered | gi|687865928|emb|LK927994.1| | 6239 | g23204 | i0 | 100 | 3 | 249 | 0 | 100 | 0 | 1 | 249 | 59271 | 59023 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000393 | blastn | 747 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8434544 | 8434544 | PRJNA797475_P_NODE_23327_length_249_cov_0.875000_g23228_i0 | PRJNA797475 | 23327 | 249 | 0.875 | 2.17875 | Sudhausia aristotokia | 1357959 | Nematoda | Nematoda | 122 | 1.69e-23 | NTclustered | gi|675118807|gb|KJ877278.1| | 1357959 | g23228 | i0 | 79.255 | 52.0120481927711 | 188 | 30 | 73 | 9 | 38 | 220 | 1421 | 1604 | Sudhausia aristotokia strain RS9011 28S ribosomal RNA gene, partial sequence | blastn | 12951 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Sudhausia | Sudhausia aristotokia | |
| 14809930 | 14809930 | PRJNA797475_P_NODE_21672_length_251_cov_0.865169_g21573_i0 | PRJNA797475 | 21672 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.1499999999999996e-124 | NTclustered | gi|351060592|emb|FO080992.1| | 6239 | g21573 | i0 | 99.602 | 3 | 251 | 1 | 100 | 0 | 1 | 251 | 10369 | 10619 | Caenorhabditis elegans YAC Y119C1B, complete sequence | blastn | 753 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16083952 | 16083952 | PRJNA797475_P_NODE_22733_length_250_cov_0.870056_g22634_i0 | PRJNA797475 | 22733 | 250 | 0.870056 | 2.17514 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 462 | 8.83e-126 | NTclustered | gi|687865721|emb|LK927708.1| | 6239 | g22634 | i0 | 100 | 47.104 | 250 | 0 | 100 | 0 | 1 | 250 | 369 | 120 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000155 | blastn | 11776 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16083976 | 16083976 | PRJNA797475_P_NODE_24533_length_248_cov_0.880000_g24434_i0 | PRJNA797475 | 24533 | 248 | 0.88 | 2.1824 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|1972262700|ref|NM_065509.9| | 6239 | g24434 | i0 | 100 | 6.62096774193548 | 248 | 0 | 100 | 0 | 1 | 248 | 514 | 761 | Caenorhabditis elegans Small ribosomal subunit protein eS1 (rps-3A), mRNA | blastn | 1642 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19908176 | 19908176 | PRJNA797475_P_NODE_19276_length_261_cov_2.632979_g19177_i0 | PRJNA797475 | 19276 | 261 | 2.632979 | 6.87207519 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 475 | 1.1899999999999999e-129 | NTclustered | gi|1972230171|ref|NM_001392490.1| | 6239 | g19177 | i0 | 99.615 | 3.04980842911877 | 260 | 1 | 99 | 0 | 1 | 260 | 261 | 2 | Caenorhabditis elegans Small integral membrane protein 15 (C48B6.10), mRNA | blastn | 796 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19908239 | 19908239 | PRJNA797475_P_NODE_23916_length_248_cov_1.320000_g23817_i0 | PRJNA797475 | 23916 | 248 | 1.32 | 3.2736 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|1734338622|ref|NM_076012.6| | 6239 | g23817 | i0 | 100 | 96.5564516129032 | 248 | 0 | 100 | 0 | 1 | 248 | 371 | 124 | Caenorhabditis elegans Large ribosomal subunit protein uL5B (rpl-11.2), mRNA | blastn | 23946 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22458546 | 22458546 | PRJNA797475_P_NODE_23258_length_249_cov_0.875000_g23159_i0 | PRJNA797475 | 23258 | 249 | 0.875 | 2.17875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 460 | 3.16e-125 | NTclustered | gi|1734326521|ref|NM_066550.4| | 6239 | g23159 | i0 | 100 | 2.97991967871486 | 249 | 0 | 100 | 0 | 1 | 249 | 697 | 449 | Caenorhabditis elegans Malectin domain-containing protein (F44E2.10), partial mRNA | blastn | 742 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23734237 | 23734237 | PRJNA797475_P_NODE_25439_length_247_cov_0.885057_g25340_i0 | PRJNA797475 | 25439 | 247 | 0.885057 | 2.18609079 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 457 | 4.05e-124 | NTclustered | gi|687865583|emb|LK927625.1| | 6239 | g25340 | i0 | 100 | 4 | 247 | 0 | 100 | 0 | 1 | 247 | 87779 | 88025 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000086 | blastn | 988 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25007781 | 25007781 | PRJNA797475_P_NODE_20880_length_253_cov_1.422222_g20781_i0 | PRJNA797475 | 20880 | 253 | 1.422222 | 3.59822166 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 462 | 8.95e-126 | NTclustered | gi|1972236089|ref|NM_001383766.2| | 6239 | g20781 | i0 | 99.605 | 8.09090909090909 | 253 | 1 | 100 | 0 | 1 | 253 | 288 | 36 | Caenorhabditis elegans Small ribosomal subunit protein eS26 (rps-26), mRNA | blastn | 2047 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;