contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2056609 | 2056609 | PRJNA796753_P_NODE_30702_length_277_cov_8.200980_g30390_i0 | PRJNA796753 | 30702 | 277 | 8.20098 | 22.7167146 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 78.7 | 4.2e-10 | NTclustered | gi|2445352248|ref|XM_053723719.1| | 31234 | g30390 | i0 | 94.118 | 0.646209386281588 | 51 | 3 | 18 | 0 | 208 | 258 | 282 | 232 | Caenorhabditis remanei uncharacterized protein (GCK72_002963), partial mRNA | blastn | 179 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 2492120 | 2492120 | PRJNA796753_P_NODE_34042_length_267_cov_1.190722_g33730_i0 | PRJNA796753 | 34042 | 267 | 1.190722 | 3.17922774 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.024 | NTclustered | gi|687865587|emb|LK927641.1| | 6239 | g33730 | i0 | 100 | 2.2247191011236 | 28 | 0 | 10 | 0 | 207 | 234 | 57673 | 57700 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000013 | blastn | 594 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6320693 | 6320693 | PRJNA796753_P_NODE_26265_length_293_cov_1.563636_g25953_i0 | PRJNA796753 | 26265 | 293 | 1.563636 | 4.58145348 | Opisthokonta | 33154 | Nematoda | Nematoda | 222 | 1.96e-53 | NTclustered | gi|268571800|ref|XM_002641106.1| | 6238 | g25953 | i0 | 82.609 | 56.5529010238908 | 253 | 42 | 86 | 2 | 38 | 289 | 309 | 58 | Caenorhabditis briggsae Protein CBR-ARF-1.2 (Cbr-arf-1.2), partial mRNA | blastn | 16570 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 9708828 | 9708828 | PRJNA796753_P_NODE_15148_length_366_cov_3.058020_g14836_i0 | PRJNA796753 | 15148 | 366 | 3.05802 | 11.1923532 | Brugia malayi | 6279 | Nematoda | Nematoda | 350 | 1.1e-91 | NTclustered | gi|2082298039|ref|XM_043075942.1| | 6279 | g14836 | i0 | 87.879 | 29.5792349726776 | 297 | 36 | 81 | 0 | 65 | 361 | 1 | 297 | Brugia malayi Uncharacterized protein (Bma-tbb-4), partial mRNA | blastn | 10826 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 9708901 | 9708901 | PRJNA796753_P_NODE_28088_length_286_cov_1.727700_g27776_i0 | PRJNA796753 | 28088 | 286 | 1.7277 | 4.941222 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 191 | 5.37e-44 | NTclustered | gi|2158424922|ref|XM_045237347.1| | 6238 | g27776 | i0 | 79.371 | 49.6083916083916 | 286 | 47 | 98 | 9 | 3 | 282 | 2249 | 1970 | Caenorhabditis briggsae Protein CBR-EFT-2 (Cbr-eft-2), partial mRNA | blastn | 14188 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 9708905 | 9708905 | PRJNA796753_P_NODE_28828_length_284_cov_1.298578_g28516_i0 | PRJNA796753 | 28828 | 284 | 1.298578 | 3.68796152 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 130 | 1.18e-25 | NTclustered | gi|2158425779|ref|XM_045244164.1| | 6238 | g28516 | i0 | 80.952 | 9.60915492957746 | 168 | 28 | 58 | 4 | 112 | 277 | 1665 | 1830 | Caenorhabditis briggsae Protein CBR-PGP-2 (Cbr-pgp-2), partial mRNA | blastn | 2729 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 10984852 | 10984852 | PRJNA796753_P_NODE_8869_length_462_cov_1.557841_g8558_i0 | PRJNA796753 | 8869 | 462 | 1.557841 | 7.19722542 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 285 | 4.0599999999999995e-72 | NTclustered | gi|687865574|emb|LK927573.1| | 6239 | g8558 | i0 | 82.371 | 67.1926406926407 | 329 | 56 | 71 | 2 | 14 | 341 | 82954 | 83281 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000040 | blastn | 31043 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 12696283 | 12696283 | PRJNA796753_P_NODE_17570_length_346_cov_1.029304_g17258_i0 | PRJNA796753 | 17570 | 346 | 1.029304 | 3.56139184 | Metazoa | 33208 | Nematoda | Nematoda | 56.5 | 0.003 | NTclustered | gi|339264662|ref|XM_003366495.1| | 6334 | g17258 | i0 | 100 | 0.34393063583815 | 30 | 0 | 9 | 0 | 115 | 144 | 1397 | 1368 | Trichinella spiralis zinc finger protein (Tsp_13826) mRNA, complete cds | blastn | 119 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 13534349 | 13534349 | PRJNA796753_P_NODE_2931_length_772_cov_2.419170_g2656_i0 | PRJNA796753 | 2931 | 772 | 2.41917 | 18.6759924 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 444 | 1.0899999999999994e-119 | NTclustered | gi|1376147725|ref|XM_024654528.1| | 34506 | g2656 | i0 | 83.974 | 51.3121761658031 | 468 | 69 | 60 | 6 | 1 | 465 | 923 | 1387 | Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA | blastn | 39613 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22457773 | 22457773 | PRJNA796753_P_NODE_19238_length_334_cov_2.137931_g18926_i0 | PRJNA796753 | 19238 | 334 | 2.137931 | 7.14068954 | Myctolaimus sp. RS5442 | 669110 | Nematoda | Nematoda | 198 | 3.82e-46 | NTclustered | gi|256709120|gb|GQ422212.1| | 669110 | g18926 | i0 | 77.812 | 11.7814371257485 | 329 | 67 | 98 | 6 | 9 | 334 | 272 | 597 | Myctolaimus sp. RS5442 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 3935 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Cylindrocorporidae | Myctolaimus | Myctolaimus sp. RS5442 | |
| 22457810 | 22457810 | PRJNA796753_P_NODE_24758_length_301_cov_4.807018_g24446_i0 | PRJNA796753 | 24758 | 301 | 4.807018 | 14.46912418 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 315 | 3.239999999999999e-81 | NTclustered | gi|1376147859|ref|XM_024654603.1| | 34506 | g24446 | i0 | 86.054 | 209.249169435216 | 294 | 39 | 97 | 2 | 1 | 293 | 683 | 391 | Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA | blastn | 62984 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22457876 | 22457876 | PRJNA796753_P_NODE_38858_length_251_cov_0.865169_g38546_i0 | PRJNA796753 | 38858 | 251 | 0.865169 | 2.17157419 | Oigolaimella sp. VS-2014 | 1538701 | Nematoda | Nematoda | 132 | 2.84e-26 | NTclustered | gi|675119001|gb|KJ877380.1| | 1538701 | g38546 | i0 | 88.182 | 0.924302788844621 | 110 | 13 | 44 | 0 | 1 | 110 | 287 | 396 | Oigolaimella sp. VS-2014 strain RS9010 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 232 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella sp. VS-2014 | |
| 22457952 | 22457952 | PRJNA796753_P_NODE_48478_length_245_cov_0.895349_g48166_i0 | PRJNA796753 | 48478 | 245 | 0.895349 | 2.19360505 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 241 | 4.400000000000001e-59 | NTclustered | gi|339244268|ref|XM_003378012.1| | 6334 | g48166 | i0 | 84.426 | 96.3918367346939 | 244 | 38 | 99 | 0 | 2 | 245 | 463 | 220 | Trichinella spiralis histone H3 (Tsp_02260) mRNA, complete cds | blastn | 23616 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 22894277 | 22894277 | PRJNA796753_P_NODE_17438_length_347_cov_1.124088_g17126_i0 | PRJNA796753 | 17438 | 347 | 1.124088 | 3.90058536 | Metazoa | 33208 | Nematoda | Nematoda | 158 | 6.77e-34 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g17126 | i0 | 79.464 | 61.0374639769452 | 224 | 44 | 64 | 2 | 124 | 346 | 868 | 646 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 21180 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 25007020 | 25007020 | PRJNA796753_P_NODE_14860_length_369_cov_4.834459_g14548_i0 | PRJNA796753 | 14860 | 369 | 4.834459 | 17.83915371 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 176 | 1.99e-39 | NTclustered | gi|2445378119|ref|XM_003100380.2| | 31234 | g14548 | i0 | 85.294 | 30.5094850948509 | 170 | 25 | 46 | 0 | 116 | 285 | 194 | 25 | Caenorhabditis remanei uncharacterized protein (GCK72_016568), partial mRNA | blastn | 11258 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei |
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);;