contig_metadata
9 rows where bioproject = "PRJNA1240804", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5450994 | 5450994 | PRJNA1240804_P_NODE_146405_length_162_cov_1.707965_g146039_i0 | PRJNA1240804 | 146405 | 162 | 1.707965 | 2.7669033 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 230 | 5.799999999999999e-56 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g146039 | i0 | 95.775 | 88.9753086419753 | 142 | 6 | 88 | 0 | 7 | 148 | 2804 | 2663 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 14414 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 5452112 | 5452112 | PRJNA1240804_P_NODE_59705_length_205_cov_1.717949_g59339_i0 | PRJNA1240804 | 59705 | 205 | 1.717949 | 3.52179545 | Meloidogyne incognita | 6306 | Nematoda | Nematoda | 54.7 | 0.005 | NTclustered | gi|1988425442|gb|MW627498.1| | 6306 | g59339 | i0 | 88.636 | 0.214634146341463 | 44 | 5 | 21 | 0 | 96 | 139 | 269 | 226 | Meloidogyne incognita isolate MC01 large subunit ribosomal RNA gene, partial sequence | blastn | 44 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne incognita | |
| 7427793 | 7427793 | PRJNA1240804_P_NODE_115386_length_168_cov_0.873950_g115020_i0 | PRJNA1240804 | 115386 | 168 | 0.87395 | 1.468236 | Rhabditida | 6236 | Nematoda | Nematoda | 285 | 1.28e-72 | NTclustered | gi|158821907|gb|EU195971.1| | 473156 | g115020 | i0 | 100 | 13.7559523809524 | 154 | 0 | 92 | 0 | 15 | 168 | 426 | 579 | Oscheius dolichura strain JU460 28S ribosomal RNA gene, partial sequence | blastn | 2311 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichura | |
| 10552426 | 10552426 | PRJNA1240804_P_NODE_48609_length_221_cov_1.441860_g48243_i0 | PRJNA1240804 | 48609 | 221 | 1.44186 | 3.1865106 | Diploscapter sp. JU359 | 479134 | Nematoda | Nematoda | 370 | 4.76e-98 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g48243 | i0 | 99.51 | 71.5203619909502 | 204 | 0 | 92 | 1 | 14 | 216 | 898 | 1101 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 15806 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 20176657 | 20176657 | PRJNA1240804_P_NODE_9776_length_412_cov_1.768595_g9414_i0 | PRJNA1240804 | 9776 | 412 | 1.768595 | 7.2866114 | Metazoa | 33208 | Nematoda | Nematoda | 730 | 0 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g9414 | i0 | 99.749 | 70.4417475728155 | 398 | 1 | 97 | 0 | 15 | 412 | 1568 | 1965 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 29022 | 730 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 22026040 | 22026040 | PRJNA1240804_P_NODE_92978_length_178_cov_1.131783_g92612_i0 | PRJNA1240804 | 92978 | 178 | 1.131783 | 2.01457374 | Diploscapter sp. JU359 | 479134 | Nematoda | Nematoda | 263 | 6.39e-66 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g92612 | i0 | 95.732 | 8.90449438202247 | 164 | 6 | 92 | 1 | 1 | 164 | 3479 | 3317 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 1585 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 24574589 | 24574589 | PRJNA1240804_P_NODE_44300_length_229_cov_0.944444_g43934_i0 | PRJNA1240804 | 44300 | 229 | 0.944444 | 2.16277676 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 361 | 2.9899999999999998e-95 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g43934 | i0 | 97.183 | 93.5021834061135 | 213 | 6 | 93 | 0 | 3 | 215 | 2016 | 1804 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 21412 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 27452892 | 27452892 | PRJNA1240804_P_NODE_11723_length_384_cov_1.916418_g11358_i0 | PRJNA1240804 | 11723 | 384 | 1.916418 | 7.35904512 | Necator americanus | 51031 | Nematoda | Nematoda | 234 | 1.24e-75 | NR | ETN79591.1 | 51031 | g11358 | i0 | 86.4 | 0.9765625 | 125 | 17 | 97.7 | 0 | 1 | 375 | 28 | 152 | ETN79591.1 Replication protein [Necator americanus] | diamond | 375 | 234 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 28115645 | 28115645 | PRJNA1240804_P_NODE_2485_length_697_cov_4.027778_g2166_i0 | PRJNA1240804 | 2485 | 697 | 4.027778 | 28.07361266 | Necator americanus | 51031 | Nematoda | Nematoda | 163 | 5.959999999999999e-46 | NR | ETN79591.1 | 51031 | g2166 | i0 | 83.7 | 0.395982783357245 | 92 | 14 | 39.6 | 1 | 689 | 414 | 151 | 241 | ETN79591.1 Replication protein [Necator americanus] | diamond | 276 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus |
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);;