contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655538 | 1655538 | PRJNA315314_S_NODE_17902_length_194_cov_4382.678788_g17581_i0 | PRJNA315314 | 17902 | 194 | 4382.678788 | 8502.39684872 | Chromadoropsis vivipara | 73933 | Nematoda | Nematoda | 172 | 1.23e-38 | NTclustered | gi|2063683635|gb|MZ504149.1| | 73933 | g17581 | i0 | 94.595 | 34.7577319587629 | 111 | 6 | 57 | 0 | 1 | 111 | 3702 | 3592 | Chromadoropsis vivipara isolate C-Mv internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 6743 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Chromadorida | Chromadoridae | Chromadoropsis | Chromadoropsis vivipara | |
| 1655694 | 1655694 | PRJNA315314_S_NODE_27922_length_159_cov_12.415385_g27601_i0 | PRJNA315314 | 27922 | 159 | 12.415385 | 19.74046215 | Campydora demonstrans | 211217 | Nematoda | Nematoda | 110 | 7.7e-20 | NTclustered | gi|2623950732|gb|OR852751.1| | 211217 | g27601 | i0 | 79.503 | 29.4213836477987 | 161 | 28 | 100 | 5 | 1 | 159 | 4472 | 4315 | Campydora demonstrans isolate OVN-2022 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 4678 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Enoplida | Campydoridae | Campydora | Campydora demonstrans | |
| 7443271 | 7443271 | PRJNA315314_S_NODE_5266_length_350_cov_3.190031_g4945_i0 | PRJNA315314 | 5266 | 350 | 3.190031 | 11.1651085 | Cylicocyclus | 53337 | Nematoda | Nematoda | 113 | 1.5e-20 | NTclustered | gi|2166980952|gb|MZ888509.1| | 71428 | g4945 | i0 | 88.421 | 1.08571428571429 | 95 | 10 | 27 | 1 | 80 | 173 | 7122 | 7216 | Cylicocyclus auriculatus mitochondrion, complete genome | blastn | 380 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus auriculatus | |
| 9309096 | 9309096 | PRJNA315314_S_NODE_7948_length_286_cov_7.319066_g7627_i0 | PRJNA315314 | 7948 | 286 | 7.319066 | 20.93252876 | Campydora demonstrans | 211217 | Nematoda | Nematoda | 265 | 3.12e-66 | NTclustered | gi|2623950732|gb|OR852751.1| | 211217 | g7627 | i0 | 83.86 | 2.95454545454545 | 285 | 38 | 98 | 8 | 6 | 286 | 6489 | 6209 | Campydora demonstrans isolate OVN-2022 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 845 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Enoplida | Campydoridae | Campydora | Campydora demonstrans | |
| 10584785 | 10584785 | PRJNA315314_S_NODE_30149_length_154_cov_16.216000_g29828_i0 | PRJNA315314 | 30149 | 154 | 16.216 | 24.97264 | Ascaris lumbricoides | 6252 | Nematoda | Nematoda | 76.8 | 7.5e-10 | NTclustered | gi|347983|gb|L22247.1|NEMSNUB | 6252 | g29828 | i0 | 86.301 | 23.6688311688312 | 73 | 6 | 47 | 4 | 1 | 72 | 452 | 383 | Ascaris lumbricoides snRNA U2-1 gene, snRNA U2-2 pseudogenes, and snRNA U2-1 gene, complete sequence | blastn | 3645 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ascarididae | Ascaris | Ascaris lumbricoides | |
| 13134749 | 13134749 | PRJNA315314_S_NODE_6051_length_328_cov_5.518395_g5730_i0 | PRJNA315314 | 6051 | 328 | 5.518395 | 18.1003356 | Rhigonema thysanophora | 435730 | Nematoda | Nematoda | 401 | 2.6599999999999993e-107 | NTclustered | gi|1255552292|gb|MG195996.1| | 435730 | g5730 | i0 | 88.822 | 100.835365853659 | 331 | 31 | 100 | 6 | 1 | 328 | 2002 | 1675 | Rhigonema thysanophora isolate X-3981 large subunit ribosomal RNA gene, partial sequence | blastn | 33074 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhigonematidae | Rhigonema | Rhigonema thysanophora | |
| 13818719 | 13818719 | PRJNA315314_S_NODE_24311_length_169_cov_15.407143_g23990_i0 | PRJNA315314 | 24311 | 169 | 15.407143 | 26.03807167 | Chromadorea | 119089 | Nematoda | Nematoda | 307 | 2.73e-79 | NTclustered | gi|283484471|gb|GQ892827.1| | 70222 | g23990 | i0 | 99.408 | 100 | 169 | 1 | 100 | 0 | 1 | 169 | 1096 | 928 | Plectus aquatilis 18S ribosomal RNA gene, partial sequence | blastn | 16900 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus aquatilis | |
| 14409914 | 14409914 | PRJNA315314_S_NODE_5012_length_358_cov_31.404255_g4691_i0 | PRJNA315314 | 5012 | 358 | 31.404255 | 112.4272329 | Nematoda environmental sample | 554024 | Nematoda | Nematoda | 488 | 2.1799999999999998e-133 | NTclustered | gi|460423923|gb|KC306538.1| | 554024 | g4691 | i0 | 91.365 | 94.9050279329609 | 359 | 28 | 100 | 3 | 1 | 358 | 384 | 28 | Nematoda environmental sample clone BT_Euk_C8 18S ribosomal RNA gene, partial sequence | blastn | 33976 | 488 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Nematoda environmental sample | |||||
| 15093131 | 15093131 | PRJNA315314_S_NODE_9572_length_261_cov_3128.896552_g9251_i0 | PRJNA315314 | 9572 | 261 | 3128.896552 | 8166.42000072 | Metazoa | 33208 | Nematoda | Nematoda | 405 | 1.59e-108 | NTclustered | gi|2646098909|gb|PP099678.1| | 49354 | g9251 | i0 | 99.55 | 85.1072796934866 | 222 | 1 | 85 | 0 | 35 | 256 | 588 | 809 | Plectus sp. isolate Nem.501 small subunit ribosomal RNA gene, partial sequence | blastn | 22213 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus sp. | |
| 15683600 | 15683600 | PRJNA315314_S_NODE_31833_length_151_cov_2.934426_g31512_i0 | PRJNA315314 | 31833 | 151 | 2.934426 | 4.43098326 | Mesorhabditis sp. 'Bursilla' PS1179 | 466951 | Nematoda | Nematoda | 156 | 9.13e-34 | NTclustered | gi|157787501|gb|EF990722.1| | 466951 | g31512 | i0 | 87.681 | 94.364238410596 | 138 | 12 | 91 | 2 | 4 | 141 | 1360 | 1228 | Bursilla sp. PS1179 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14249 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis sp. 'Bursilla' PS1179 | |
| 16958035 | 16958035 | PRJNA315314_S_NODE_10814_length_246_cov_5.760369_g10493_i0 | PRJNA315314 | 10814 | 246 | 5.760369 | 14.17050774 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 82.4 | 2.83e-11 | NTclustered | gi|2445393885|ref|XM_053735838.1| | 31234 | g10493 | i0 | 97.872 | 18.3780487804878 | 47 | 1 | 19 | 0 | 200 | 246 | 118 | 164 | Caenorhabditis remanei uncharacterized protein (GCK72_024337), partial mRNA | blastn | 4521 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 22742060 | 22742060 | PRJNA315314_S_NODE_12918_length_226_cov_12.573604_g12597_i0 | PRJNA315314 | 12918 | 226 | 12.573604 | 28.41634504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 1.18e-19 | NTclustered | gi|158821918|gb|EU195982.1| | 54126 | g12597 | i0 | 88.298 | 59.6946902654867 | 94 | 7 | 41 | 4 | 4 | 95 | 1960 | 1869 | Pristionchus pacificus strain 312 28S ribosomal RNA gene, partial sequence | blastn | 13491 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 24017243 | 24017243 | PRJNA315314_S_NODE_8619_length_275_cov_27.040650_g8298_i0 | PRJNA315314 | 8619 | 275 | 27.04065 | 74.3617875 | Rhabditida | 6236 | Nematoda | Nematoda | 231 | 3.0199999999999996e-56 | NTclustered | gi|159684|gb|M74585.1|NEMRGB | 6252 | g8298 | i0 | 81.949 | 27.7272727272727 | 277 | 46 | 100 | 4 | 1 | 275 | 488 | 214 | Ascaris lumbricoides 18S rRNA gene, 5' end, and 26S rRNA gene, 3' end | blastn | 7625 | 233 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ascarididae | Ascaris | Ascaris lumbricoides |
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);;