contig_metadata
15 rows where bioproject = "PRJNA814235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3778554 | 3778554 | PRJNA814235_P_NODE_21243_length_415_cov_1.500000_g19881_i0 | PRJNA814235 | 21243 | 415 | 1.5 | 6.225 | Poikilolaimus | 96658 | Nematoda | Nematoda | 758 | 0 | NTclustered | gi|70609419|gb|DQ059057.1| | 96660 | g19881 | i0 | 99.758 | 14.3301204819277 | 413 | 1 | 99 | 0 | 3 | 415 | 542 | 130 | Poikilolaimus regenfussi strain SB199 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5947 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi | |
| 4645649 | 4645649 | PRJNA814235_P_NODE_202344_length_150_cov_1.681416_g200949_i0 | PRJNA814235 | 202344 | 150 | 1.681416 | 2.522124 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 261 | 1.86e-65 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g200949 | i0 | 98 | 100.66 | 150 | 3 | 100 | 0 | 1 | 150 | 2020 | 1871 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 15099 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 4647007 | 4647007 | PRJNA814235_P_NODE_81264_length_211_cov_1.528736_g79869_i0 | PRJNA814235 | 81264 | 211 | 1.528736 | 3.22563296 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 357 | 3.5099999999999996e-94 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g79869 | i0 | 97.156 | 100.943127962085 | 211 | 6 | 100 | 0 | 1 | 211 | 2583 | 2793 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 21299 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 16120259 | 16120259 | PRJNA814235_P_NODE_40513_length_300_cov_2.775665_g39122_i0 | PRJNA814235 | 40513 | 300 | 2.775665 | 8.326995 | Rotylenchulus reniformis | 239373 | Nematoda | Nematoda | 187 | 7.33e-43 | NTclustered | gi|264664697|gb|FJ905984.1| | 239373 | g39122 | i0 | 93.651 | 1.41 | 126 | 7 | 42 | 1 | 1 | 125 | 60 | 185 | Rotylenchulus reniformis clone 190 microsatellite sequence | blastn | 423 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Hoplolaimidae | Rotylenchulus | Rotylenchulus reniformis | |
| 16528640 | 16528640 | PRJNA814235_P_NODE_145053_length_179_cov_1.922535_g143658_i0 | PRJNA814235 | 145053 | 179 | 1.922535 | 3.44133765 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 127 | 2.19e-32 | NR | KJH40125.1 | 29172 | g143658 | i0 | 98.3 | 0.988826815642458 | 59 | 1 | 98.9 | 0 | 179 | 3 | 130 | 188 | KJH40125.1 homeobox domain protein [Dictyocaulus viviparus] | diamond | 177 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 21218841 | 21218841 | PRJNA814235_P_NODE_181317_length_152_cov_2.078261_g179922_i0 | PRJNA814235 | 181317 | 152 | 2.078261 | 3.15895672 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 246 | 5.31e-61 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g179922 | i0 | 96.622 | 3.03947368421053 | 148 | 5 | 97 | 0 | 5 | 152 | 1718 | 1865 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 462 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 21219640 | 21219640 | PRJNA814235_P_NODE_38317_length_309_cov_1.911765_g36927_i0 | PRJNA814235 | 38317 | 309 | 1.911765 | 5.90735385 | Poikilolaimus regenfussi | 96660 | Nematoda | Nematoda | 571 | 1.7899999999999995e-158 | NTclustered | gi|8515061|gb|AF083022.1| | 96660 | g36927 | i0 | 100 | 94.8349514563107 | 309 | 0 | 100 | 0 | 1 | 309 | 331 | 23 | Poikilolaimus regenfussi strain SB199 18S ribosomal RNA gene, partial sequence | blastn | 29304 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi | |
| 25043582 | 25043582 | PRJNA814235_P_NODE_22580_length_402_cov_2.523288_g21216_i0 | PRJNA814235 | 22580 | 402 | 2.523288 | 10.14361776 | Poikilolaimus regenfussi | 96660 | Nematoda | Nematoda | 586 | 8.539999999999997e-163 | NTclustered | gi|1252285341|gb|MG051252.1| | 2042950 | g21216 | i0 | 99.688 | 93.9900497512438 | 320 | 1 | 80 | 0 | 83 | 402 | 1 | 320 | Poikilolaimus regenfussi KW-1C-12 large subunit ribosomal RNA gene, partial sequence | blastn | 37784 | 586 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi | |
| 29706543 | 29706543 | PRJNA814235_P_NODE_196750_length_150_cov_4.486726_g195355_i0 | PRJNA814235 | 196750 | 150 | 4.486726 | 6.730089 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 43.9 | 0.00337 | NR | XP_003375610.1 | 6334 | g195355 | i0 | 59.3 | 1.1 | 27 | 11 | 54 | 0 | 148 | 68 | 17 | 43 | XP_003375610.1 zinc finger protein [Trichinella spiralis] | diamond | 165 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 29801637 | 29801637 | PRJNA814235_P_NODE_97351_length_203_cov_2.590361_g95956_i0 | PRJNA814235 | 97351 | 203 | 2.590361 | 5.25843283 | Necator americanus | 51031 | Nematoda | Nematoda | 50.8 | 2.57e-5 | NR | ETN71555.1 | 51031 | g95956 | i0 | 95.8 | 0.354679802955665 | 24 | 1 | 35.5 | 0 | 74 | 3 | 61 | 84 | ETN71555.1 Replication protein [Necator americanus] | diamond | 72 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 30622928 | 30622928 | PRJNA814235_P_NODE_125913_length_200_cov_1.815951_g124518_i0 | PRJNA814235 | 125913 | 200 | 1.815951 | 3.631902 | Necator americanus | 51031 | Nematoda | Nematoda | 122 | 1.1e-32 | NR | ETN79591.1 | 51031 | g124518 | i0 | 87.9 | 2.97 | 66 | 8 | 99 | 0 | 200 | 3 | 56 | 121 | ETN79591.1 Replication protein [Necator americanus] | diamond | 594 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 31002394 | 31002394 | PRJNA814235_P_NODE_92534_length_203_cov_3.000000_g91139_i0 | PRJNA814235 | 92534 | 203 | 3 | 6.09 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 46.6 | 9.4e-4 | NR | KAH7717977.1 | 70226 | g91139 | i0 | 70.8 | 1.064039408867 | 24 | 7 | 35.5 | 0 | 203 | 132 | 135 | 158 | KAH7717977.1 Protein OAC-37 [Aphelenchoides avenae] | diamond | 216 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 31928010 | 31928010 | PRJNA814235_P_NODE_29697_length_351_cov_2.732484_g28314_i0 | PRJNA814235 | 29697 | 351 | 2.732484 | 9.59101884 | root | 1 | Root_unresolved | Root_unresolved | 154 | 2.85e-44 | NR | VDO17378.1 | 42155 | g28314 | i0 | 97.5 | 1.38461538461538 | 81 | 2 | 69.2 | 0 | 109 | 351 | 1 | 81 | VDO17378.1 unnamed protein product, partial [Brugia timori] | diamond | 486 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori | |
| 32077522 | 32077522 | PRJNA814235_P_NODE_187198_length_151_cov_3.438596_g185803_i0 | PRJNA814235 | 187198 | 151 | 3.438596 | 5.19227996 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 59.7 | 1.11e-8 | NR | KAE9556064.1 | 2598192 | g185803 | i0 | 52.4 | 1.25165562913907 | 63 | 9 | 83.4 | 1 | 26 | 151 | 190 | 252 | KAE9556064.1 hypothetical protein FO519_000698 [Halicephalobus sp. NKZ332] | diamond | 189 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 32212883 | 32212883 | PRJNA814235_P_NODE_153778_length_171_cov_2.477612_g152383_i0 | PRJNA814235 | 153778 | 171 | 2.477612 | 4.23671652 | Metazoa | 33208 | Nematoda | Nematoda | 45.4 | 0.00156 | NR | KAK6018137.1 | 6317 | g152383 | i0 | 56.7 | 1.07017543859649 | 30 | 13 | 52.6 | 0 | 3 | 92 | 396 | 425 | KAK6018137.1 hypothetical protein OSTOST_16290 [Ostertagia ostertagi] | diamond | 183 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi |
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);;