contig_metadata
18 rows where bioproject = "PRJNA807685", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3774546 | 3774546 | PRJNA807685_P_NODE_24563_length_269_cov_8.504310_g23490_i0 | PRJNA807685 | 24563 | 269 | 8.50431 | 22.8765939 | Caenorhabditis | 6237 | Nematoda | Nematoda | 353 | 6.03e-93 | NTclustered | gi|413006566|emb|Z92784.2| | 6239 | g23490 | i0 | 100 | 68.7360594795539 | 191 | 0 | 71 | 0 | 44 | 234 | 28933 | 28743 | Caenorhabditis elegans Cosmid F31C3, complete sequence | blastn | 18490 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6326757 | 6326757 | PRJNA807685_P_NODE_31425_length_226_cov_10.407407_g30352_i0 | PRJNA807685 | 31425 | 226 | 10.407407 | 23.52073982 | Chromadorea | 119089 | Nematoda | Nematoda | 342 | 1.07e-89 | NTclustered | gi|25167357|ref|NR_000053.1| | 6239 | g30352 | i0 | 100 | 82.0442477876106 | 185 | 0 | 82 | 0 | 25 | 209 | 1589 | 1405 | Caenorhabditis elegans 18S ribosomal RNA (rrn-1.1), rRNA | blastn | 18542 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6326832 | 6326832 | PRJNA807685_P_NODE_51805_length_169_cov_4.303030_g50732_i0 | PRJNA807685 | 51805 | 169 | 4.30303 | 7.2721207 | Caenorhabditis | 6237 | Nematoda | Nematoda | 307 | 2.73e-79 | NTclustered | gi|356605872|gb|JN636061.1| | 6238 | g50732 | i0 | 100 | 89.8757396449704 | 166 | 0 | 98 | 0 | 1 | 166 | 6075 | 6240 | Caenorhabditis briggsae 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 15189 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 7184780 | 7184780 | PRJNA807685_P_NODE_28506_length_242_cov_62.765854_g27433_i0 | PRJNA807685 | 28506 | 242 | 62.765854 | 151.89336668 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 285 | 1.97e-72 | NTclustered | gi|1279388955|gb|MG551716.1| | 6239 | g27433 | i0 | 100 | 64.3884297520661 | 154 | 0 | 64 | 0 | 34 | 187 | 498 | 651 | Caenorhabditis elegans isolate C.eleg_S1A small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 15582 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16108963 | 16108963 | PRJNA807685_P_NODE_32333_length_222_cov_2.951351_g31260_i0 | PRJNA807685 | 32333 | 222 | 2.951351 | 6.55199922 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 370 | 4.79e-98 | NTclustered | gi|413006566|emb|Z92784.2| | 6239 | g31260 | i0 | 99.507 | 89.2072072072072 | 203 | 1 | 91 | 0 | 20 | 222 | 26580 | 26782 | Caenorhabditis elegans Cosmid F31C3, complete sequence | blastn | 19804 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19933102 | 19933102 | PRJNA807685_P_NODE_17696_length_345_cov_1.857143_g16624_i0 | PRJNA807685 | 17696 | 345 | 1.857143 | 6.40714335 | Trichuris suis | 68888 | Nematoda | Nematoda | 103 | 2.4299999999999994e-24 | NR | KFD60198.1 | 68888 | g16624 | i0 | 51.4 | 1.77391304347826 | 105 | 49 | 89.6 | 2 | 310 | 2 | 67 | 171 | KFD60198.1 hypothetical protein M514_09835 [Trichuris suis] | diamond | 612 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 22483246 | 22483246 | PRJNA807685_P_NODE_11498_length_477_cov_42.984091_g10442_i0 | PRJNA807685 | 11498 | 477 | 42.984091 | 205.03411407 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 811 | 0 | NTclustered | gi|25167357|ref|NR_000053.1| | 6239 | g10442 | i0 | 99.774 | 83.1174004192872 | 442 | 1 | 93 | 0 | 1 | 442 | 443 | 2 | Caenorhabditis elegans 18S ribosomal RNA (rrn-1.1), rRNA | blastn | 39647 | 811 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23759289 | 23759289 | PRJNA807685_P_NODE_56079_length_163_cov_1.849206_g55006_i0 | PRJNA807685 | 56079 | 163 | 1.849206 | 3.01420578 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 69.4 | 1.35e-7 | NTclustered | gi|687866226|emb|LK928152.1| | 6239 | g55006 | i0 | 95.349 | 1.05521472392638 | 43 | 2 | 42 | 0 | 29 | 71 | 9140 | 9098 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000504 | blastn | 172 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26800927 | 26800927 | PRJNA807685_P_NODE_46521_length_179_cov_1.373239_g45448_i0 | PRJNA807685 | 46521 | 179 | 1.373239 | 2.45809781 | Trichuris suis | 68888 | Nematoda | Nematoda | 68.6 | 1.23e-11 | NR | KFD64092.1 | 68888 | g45448 | i0 | 55.7 | 17.3966480446927 | 61 | 24 | 98.9 | 2 | 3 | 179 | 374 | 433 | KFD64092.1 hypothetical protein M514_23802 [Trichuris suis] | diamond | 3114 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 26864635 | 26864635 | PRJNA807685_P_NODE_53661_length_167_cov_1.061538_g52588_i0 | PRJNA807685 | 53661 | 167 | 1.061538 | 1.77276846 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 47.8 | 2.23e-4 | NR | CAJ0580575.1 | 96644 | g52588 | i0 | 54.8 | 2.26347305389222 | 42 | 18 | 75.4 | 1 | 39 | 164 | 185 | 225 | CAJ0580575.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 378 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27189364 | 27189364 | PRJNA807685_P_NODE_59682_length_159_cov_1.073770_g58609_i0 | PRJNA807685 | 59682 | 159 | 1.07377 | 1.7072943 | Metazoa | 33208 | Nematoda | Nematoda | 44.3 | 0.00334 | NR | VDP01474.1 | 241478 | g58609 | i0 | 64.3 | 5.62264150943396 | 28 | 10 | 52.8 | 0 | 2 | 85 | 105 | 132 | VDP01474.1 unnamed protein product [Soboliphyme baturini] | diamond | 894 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 27789710 | 27789710 | PRJNA807685_P_NODE_64664_length_153_cov_1.612069_g63591_i0 | PRJNA807685 | 64664 | 153 | 1.612069 | 2.46646557 | Metazoa | 33208 | Nematoda | Nematoda | 45.4 | 0.00119 | NR | KAK5980047.1 | 6319 | g63591 | i0 | 46 | 2.94117647058824 | 50 | 26 | 98 | 1 | 3 | 152 | 79 | 127 | KAK5980047.1 hypothetical protein GCK32_000148 [Trichostrongylus colubriformis] | diamond | 450 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis | |
| 28980737 | 28980737 | PRJNA807685_P_NODE_16668_length_361_cov_2.222222_g15598_i0 | PRJNA807685 | 16668 | 361 | 2.222222 | 8.02222142 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 44.3 | 0.0356 | NR | CAD2201923.1 | 390850 | g15598 | i0 | 32.8 | 0.556786703601108 | 67 | 34 | 50.7 | 2 | 102 | 284 | 108 | 169 | CAD2201923.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 201 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29264526 | 29264526 | PRJNA807685_P_NODE_45609_length_181_cov_1.361111_g44536_i0 | PRJNA807685 | 45609 | 181 | 1.361111 | 2.46361091 | Trichinella papuae | 268474 | Nematoda | Nematoda | 57.4 | 3.36e-8 | NR | KRZ77646.1 | 268474 | g44536 | i0 | 45.6 | 0.94475138121547 | 57 | 31 | 94.5 | 0 | 10 | 180 | 91 | 147 | KRZ77646.1 Tigger transposable element-derived protein 4 [Trichinella papuae] | diamond | 171 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella papuae | |
| 30307447 | 30307447 | PRJNA807685_P_NODE_36592_length_205_cov_1.571429_g35519_i0 | PRJNA807685 | 36592 | 205 | 1.571429 | 3.22142945 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 82.8 | 1.77e-16 | NR | VDO93362.1 | 241478 | g35519 | i0 | 64.2 | 0.980487804878049 | 67 | 24 | 98 | 0 | 1 | 201 | 775 | 841 | VDO93362.1 unnamed protein product [Soboliphyme baturini] | diamond | 201 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 30442315 | 30442315 | PRJNA807685_P_NODE_37213_length_203_cov_1.355422_g36140_i0 | PRJNA807685 | 37213 | 203 | 1.355422 | 2.75150666 | Metazoa | 33208 | Nematoda | Nematoda | 61.6 | 4.88e-9 | NR | KRZ55879.1 | 6335 | g36140 | i0 | 47.6 | 17.6748768472906 | 63 | 32 | 91.6 | 1 | 14 | 199 | 398 | 460 | KRZ55879.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94, partial [Trichinella nativa] | diamond | 3588 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa | |
| 30726472 | 30726472 | PRJNA807685_P_NODE_54934_length_165_cov_1.195312_g53861_i0 | PRJNA807685 | 54934 | 165 | 1.195312 | 1.9722648 | Caenorhabditis | 6237 | Nematoda | Nematoda | 49.3 | 6.18e-5 | NR | XP_045093902.1 | 6238 | g53861 | i0 | 58.5 | 2.98181818181818 | 41 | 16 | 72.7 | 1 | 124 | 5 | 150 | 190 | XP_045093902.1 Protein CBR-ZMP-1 [Caenorhabditis briggsae] | diamond | 492 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 31887397 | 31887397 | PRJNA807685_P_NODE_58777_length_160_cov_1.243902_g57704_i0 | PRJNA807685 | 58777 | 160 | 1.243902 | 1.9902432 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 47.4 | 2.74e-4 | NR | CAJ0959873.1 | 2138241 | g57704 | i0 | 47.5 | 0.75 | 40 | 21 | 75 | 0 | 30 | 149 | 355 | 394 | CAJ0959873.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 120 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari |
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);;