contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452471 | 452471 | PRJNA492406_P_NODE_19121_length_287_cov_2.261682_g18822_i0 | PRJNA492406 | 19121 | 287 | 2.261682 | 6.49102734 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 525 | 1.2999999999999995e-144 | NTclustered | gi|687867634|emb|LK929784.1| | 6239 | g18822 | i0 | 99.652 | 6.07317073170732 | 287 | 1 | 100 | 0 | 1 | 287 | 1408 | 1694 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0001286 | blastn | 1743 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6829928 | 6829928 | PRJNA492406_P_NODE_17606_length_297_cov_3.482143_g17307_i0 | PRJNA492406 | 17606 | 297 | 3.482143 | 10.34196471 | Pristionchus maxplancki | 1317128 | Nematoda | Nematoda | 167 | 9.44e-37 | NTclustered | gi|478487019|gb|KC491689.1| | 1317128 | g17307 | i0 | 77.7 | 61.016835016835 | 287 | 52 | 94 | 7 | 20 | 297 | 317 | 34 | Pristionchus maxplancki strain RS5594 large subunit ribosomal protein 27a (rpl27a) gene, partial cds | blastn | 18122 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus maxplancki | |
| 6830138 | 6830138 | PRJNA492406_P_NODE_26846_length_251_cov_0.865169_g26547_i0 | PRJNA492406 | 26846 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.1499999999999996e-124 | NTclustered | gi|413004756|emb|Z81495.2| | 6239 | g26547 | i0 | 99.602 | 92.9601593625498 | 251 | 1 | 100 | 0 | 1 | 251 | 1298 | 1548 | Caenorhabditis elegans Cosmid F08G2, complete sequence | blastn | 23333 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9380394 | 9380394 | PRJNA492406_P_NODE_25088_length_258_cov_1.443243_g24789_i0 | PRJNA492406 | 25088 | 258 | 1.443243 | 3.72356694 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 477 | 3.2699999999999985e-130 | NTclustered | gi|6919|emb|X03044.1| | 6239 | g24789 | i0 | 100 | 10.9457364341085 | 258 | 0 | 100 | 0 | 1 | 258 | 1838 | 2095 | Caenorhabditis elegans vit-5 gene for vitellogenin | blastn | 2824 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10655932 | 10655932 | PRJNA492406_P_NODE_11709_length_363_cov_2.789655_g11410_i0 | PRJNA492406 | 11709 | 363 | 2.789655 | 10.12644765 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 268 | 3.1399999999999996e-67 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g11410 | i0 | 81.571 | 7.23415977961433 | 331 | 55 | 90 | 6 | 1 | 328 | 364 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2626 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 11931014 | 11931014 | PRJNA492406_P_NODE_19110_length_287_cov_3.154206_g18811_i0 | PRJNA492406 | 19110 | 287 | 3.154206 | 9.05257122 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 531 | 2.799999999999999e-146 | NTclustered | gi|1279388950|gb|MG551689.1| | 6239 | g18811 | i0 | 100 | 98.595818815331 | 287 | 0 | 100 | 0 | 1 | 287 | 319 | 33 | Caenorhabditis elegans isolate C.eleg_AM151 small subunit ribosomal RNA gene, partial sequence | blastn | 28297 | 531 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11931055 | 11931055 | PRJNA492406_P_NODE_20790_length_279_cov_2.766990_g20491_i0 | PRJNA492406 | 20790 | 279 | 2.76699 | 7.7199021 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 505 | 1.6399999999999995e-138 | NTclustered | gi|28396069|gb|AY204194.1| | 6239 | g20491 | i0 | 99.283 | 98.5878136200717 | 279 | 2 | 100 | 0 | 1 | 279 | 922 | 644 | Caenorhabditis elegans clone yk805b2 nuclear receptor (NHR-108) pseudogene mRNA, complete sequence | blastn | 27506 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11931177 | 11931177 | PRJNA492406_P_NODE_26610_length_251_cov_0.865169_g26311_i0 | PRJNA492406 | 26610 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 464 | 2.47e-126 | NTclustered | gi|1972231355|ref|NM_059927.7| | 6239 | g26311 | i0 | 100 | 3.0199203187251 | 251 | 0 | 100 | 0 | 1 | 251 | 660 | 910 | Caenorhabditis elegans DFDF domain-containing protein (edc-3), mRNA | blastn | 758 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16401827 | 16401827 | PRJNA492406_P_NODE_22973_length_268_cov_4.230769_g22674_i0 | PRJNA492406 | 22973 | 268 | 4.230769 | 11.33846092 | Caenorhabditis | 6237 | Nematoda | Nematoda | 496 | 9.429999999999999e-136 | NTclustered | gi|1279388950|gb|MG551689.1| | 6239 | g22674 | i0 | 100 | 101 | 268 | 0 | 100 | 0 | 1 | 268 | 542 | 809 | Caenorhabditis elegans isolate C.eleg_AM151 small subunit ribosomal RNA gene, partial sequence | blastn | 27068 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18304217 | 18304217 | PRJNA492406_P_NODE_27655_length_249_cov_0.875000_g27356_i0 | PRJNA492406 | 27655 | 249 | 0.875 | 2.17875 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 222 | 1.62e-53 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g27356 | i0 | 82.869 | 43.6305220883534 | 251 | 39 | 100 | 4 | 1 | 249 | 232324 | 232572 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 10864 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 20854352 | 20854352 | PRJNA492406_P_NODE_32977_length_200_cov_5.031496_g32678_i0 | PRJNA492406 | 32977 | 200 | 5.031496 | 10.062992 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 370 | 4.22e-98 | NTclustered | gi|413006566|emb|Z92784.2| | 6239 | g32678 | i0 | 100 | 36.885 | 200 | 0 | 100 | 0 | 1 | 200 | 28609 | 28808 | Caenorhabditis elegans Cosmid F31C3, complete sequence | blastn | 7377 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22129261 | 22129261 | PRJNA492406_P_NODE_9158_length_404_cov_10.770393_g8859_i0 | PRJNA492406 | 9158 | 404 | 10.770393 | 43.51238772 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 736 | 0 | NTclustered | gi|413006566|emb|Z92784.2| | 6239 | g8859 | i0 | 100 | 98.7821782178218 | 398 | 0 | 99 | 0 | 1 | 398 | 28117 | 28514 | Caenorhabditis elegans Cosmid F31C3, complete sequence | blastn | 39908 | 736 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24678644 | 24678644 | PRJNA492406_P_NODE_28680_length_247_cov_0.885057_g28381_i0 | PRJNA492406 | 28680 | 247 | 0.885057 | 2.18609079 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 451 | 1.88e-122 | NTclustered | gi|1972262238|ref|NM_065355.6| | 6239 | g28381 | i0 | 99.595 | 3.0080971659919 | 247 | 1 | 100 | 0 | 1 | 247 | 1303 | 1549 | Caenorhabditis elegans Cell division control protein 45 homolog (evl-18), partial mRNA | blastn | 743 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25325403 | 25325403 | PRJNA492406_P_NODE_18000_length_293_cov_8.913636_g17701_i0 | PRJNA492406 | 18000 | 293 | 8.913636 | 26.11695348 | Caenorhabditis | 6237 | Nematoda | Nematoda | 540 | 4.76e-149 | NTclustered | gi|256561710|gb|FJ589010.1| | 6239 | g17701 | i0 | 100 | 71.3447098976109 | 292 | 0 | 99 | 0 | 1 | 292 | 18 | 309 | Caenorhabditis elegans isolate X5005 large subunit ribosomal RNA gene, partial sequence | blastn | 20904 | 540 | 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);;