contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11056926 | 11056926 | PRJNA876641_P_NODE_2209_length_470_cov_1.944584_g2135_i0 | PRJNA876641 | 2209 | 470 | 1.944584 | 9.1395448 | Pristionchus maupasi | 335527 | Nematoda | Nematoda | 254 | 1.17e-62 | NTclustered | gi|150981849|gb|EF634494.1| | 335527 | g2135 | i0 | 77.931 | 64.9787234042553 | 435 | 76 | 90 | 19 | 1 | 425 | 465 | 41 | Pristionchus maupasi large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds | blastn | 30540 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus maupasi | |
| 12332176 | 12332176 | PRJNA876641_P_NODE_12270_length_269_cov_1.438776_g12196_i0 | PRJNA876641 | 12270 | 269 | 1.438776 | 3.87030744 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 106 | 1.86e-18 | NTclustered | gi|268563928|ref|XM_002638925.1| | 6238 | g12196 | i0 | 76.389 | 2.89219330855019 | 216 | 39 | 78 | 10 | 50 | 259 | 202 | 411 | Caenorhabditis briggsae Protein CBR-RPL-27 (Cbr-rpl-27), partial mRNA | blastn | 778 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 12718074 | 12718074 | PRJNA876641_P_NODE_4310_length_369_cov_2.070946_g4236_i0 | PRJNA876641 | 4310 | 369 | 2.070946 | 7.64179074 | Pristionchus | 54125 | Nematoda | Nematoda | 145 | 5.62e-30 | NTclustered | gi|150984503|gb|EF634894.1| | 70414 | g4236 | i0 | 90.179 | 11.6205962059621 | 112 | 9 | 30 | 2 | 98 | 208 | 151 | 261 | Pristionchus lheritieri small subunit ribosomal protein 20 (rps-20) mRNA, complete cds | blastn | 4288 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus lheritieri | |
| 18704601 | 18704601 | PRJNA876641_P_NODE_20655_length_244_cov_2.929825_g20581_i0 | PRJNA876641 | 20655 | 244 | 2.929825 | 7.148773 | Bunonema sp. VS-2014 | 1538689 | Nematoda | Nematoda | 124 | 4.599999999999999e-24 | NTclustered | gi|675118911|gb|KJ877335.1| | 1538689 | g20581 | i0 | 81.761 | 56.8606557377049 | 159 | 19 | 63 | 9 | 87 | 240 | 301 | 148 | Bunonema sp. VS-2014 strain RS9014 large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds | blastn | 13874 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Bunonematidae | Bunonema | Bunonema sp. VS-2014 | |
| 18704708 | 18704708 | PRJNA876641_P_NODE_5555_length_339_cov_1.154135_g5481_i0 | PRJNA876641 | 5555 | 339 | 1.154135 | 3.91251765 | Necator americanus | 51031 | Nematoda | Nematoda | 76.8 | 1.9e-9 | NTclustered | gi|2707583078|ref|XM_013447403.2| | 51031 | g5481 | i0 | 94 | 3.44837758112094 | 50 | 3 | 15 | 0 | 168 | 217 | 758 | 709 | Necator americanus uncharacterized protein (RB195_001097), partial mRNA | blastn | 1169 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 19980011 | 19980011 | PRJNA876641_P_NODE_8176_length_295_cov_1.639640_g8102_i0 | PRJNA876641 | 8176 | 295 | 1.63964 | 4.836938 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 174 | 5.6e-39 | NTclustered | gi|1376144539|ref|XM_024652732.1| | 34506 | g8102 | i0 | 87.097 | 17.1796610169492 | 155 | 18 | 52 | 2 | 56 | 209 | 81 | 234 | Strongyloides ratti 40S ribosomal protein S14 (SRAE_2000174400), partial mRNA | blastn | 5068 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 21255136 | 21255136 | PRJNA876641_P_NODE_12197_length_269_cov_2.102041_g12123_i0 | PRJNA876641 | 12197 | 269 | 2.102041 | 5.65449029 | Koerneria sp. RS1982 | 358044 | Nematoda | Nematoda | 206 | 1.7899999999999998e-48 | NTclustered | gi|150984687|gb|EF635005.1| | 358044 | g12123 | i0 | 87.778 | 37.5315985130112 | 180 | 17 | 65 | 3 | 66 | 241 | 192 | 14 | Koerneria sp. RS1982 small subunit ribosomal protein 28 (rps-28) mRNA, complete cds | blastn | 10096 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Koerneria | Koerneria sp. RS1982 | |
| 21255165 | 21255165 | PRJNA876641_P_NODE_14377_length_257_cov_2.657609_g14303_i0 | PRJNA876641 | 14377 | 257 | 2.657609 | 6.83005513 | Fictor sp. 1 VS-2014 | 1538694 | Nematoda | Nematoda | 167 | 7.999999999999999e-37 | NTclustered | gi|675118977|gb|KJ877368.1| | 1538694 | g14303 | i0 | 80.717 | 5.36575875486381 | 223 | 35 | 85 | 5 | 17 | 235 | 410 | 192 | Fictor sp. 1 VS-2014 strain RS9001 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 1379 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Fictor | Fictor sp. 1 VS-2014 | |
| 21640579 | 21640579 | PRJNA876641_P_NODE_2797_length_432_cov_2.941504_g2723_i0 | PRJNA876641 | 2797 | 432 | 2.941504 | 12.70729728 | Opisthokonta | 33154 | Nematoda | Nematoda | 219 | 3.88e-52 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g2723 | i0 | 83.913 | 81.4768518518518 | 230 | 36 | 53 | 1 | 1 | 230 | 390505 | 390733 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 35198 | 220 | 0.995454545454545 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22530088 | 22530088 | PRJNA876641_P_NODE_9758_length_283_cov_2.580952_g9684_i0 | PRJNA876641 | 9758 | 283 | 2.580952 | 7.30409416 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 259 | 1.43e-64 | NTclustered | gi|2445378187|ref|XM_003100352.2| | 31234 | g9684 | i0 | 87.783 | 77.86925795053 | 221 | 27 | 78 | 0 | 63 | 283 | 1131 | 911 | Caenorhabditis remanei uncharacterized protein (GCK72_016604), partial mRNA | blastn | 22037 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 25079145 | 25079145 | PRJNA876641_P_NODE_12460_length_268_cov_1.348718_g12386_i0 | PRJNA876641 | 12460 | 268 | 1.348718 | 3.61456424 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 183 | 8.339999999999997e-42 | NTclustered | gi|374718480|gb|JF326458.1| | 174720 | g12386 | i0 | 83.938 | 55.455223880597 | 193 | 30 | 72 | 1 | 7 | 198 | 204 | 12 | Strongyloides papillosus eukaryotic translation elongation factor a alpha mRNA, complete cds | blastn | 14862 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;