contig_metadata
14 rows where bioproject = "PRJEB8827", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15026837 | 15026837 | PRJEB8827_P_NODE_492_length_270_cov_110210.049793_g470_i0 | PRJEB8827 | 492 | 270 | 110210.049793 | 297567.1344411 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 5.32e-4 | NTclustered | gi|690021421|emb|LM529123.1| | 174720 | g470 | i0 | 100 | 12.1074074074074 | 31 | 0 | 11 | 0 | 179 | 209 | 1684 | 1714 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003434 | blastn | 3269 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25617808 | 25617808 | PRJEB8827h_S_NODE_1009_length_293_cov_4.813953_g990_i0 | PRJEB8827 | 1009 | 293 | 4.813953 | 14.10488229 | Metazoa | 33208 | Nematoda | Nematoda | 60.2 | 1.62e-4 | NTclustered | gi|1523906|emb|Z79754.1| | 6239 | g990 | i0 | 85.965 | 1.09215017064846 | 57 | 7 | 19 | 1 | 143 | 199 | 35013 | 34958 | Caenorhabditis elegans Cosmid F25H2, complete sequence | blastn | 320 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25754042 | 25754042 | PRJEB8827h_S_NODE_1074_length_286_cov_4.175299_g1055_i0 | PRJEB8827 | 1074 | 286 | 4.175299 | 11.94135514 | Metazoa | 33208 | Nematoda | Nematoda | 117 | 9.24e-22 | NTclustered | gi|158821894|gb|EU195958.1| | 473172 | g1055 | i0 | 92.593 | 27.9475524475524 | 81 | 6 | 28 | 0 | 206 | 286 | 1892 | 1972 | Protorhabditis sp. JB122 28S ribosomal RNA gene, partial sequence | blastn | 7993 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Protorhabditis | Protorhabditis sp. JB122 | |
| 25938173 | 25938173 | PRJEB8827f_S_NODE_10980_length_179_cov_1.541667_g10960_i0 | PRJEB8827 | 10980 | 179 | 1.541667 | 2.75958393 | Pristionchus sp. 14 RS523 | 3077109 | Nematoda | Nematoda | 104 | 4.13e-18 | NTclustered | gi|150984645|gb|EF634984.1| | 452808 | g10960 | i0 | 80.741 | 1.37430167597765 | 135 | 24 | 75 | 2 | 9 | 142 | 106 | 239 | Pristionchus sp. 14 RS5230 small subunit ribosomal protein 27 (rps-27) mRNA, complete cds | blastn | 246 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 14 RS5230 | |
| 26162252 | 26162252 | PRJEB8827h_S_NODE_42325_length_161_cov_1016.817460_g42306_i0 | PRJEB8827 | 42325 | 161 | 1016.81746 | 1637.0761106 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|2675986210|gb|PP343069.1| | 6293 | g42306 | i0 | 100 | 8.22981366459627 | 30 | 0 | 19 | 0 | 99 | 128 | 933 | 904 | Wuchereria bancrofti isolate Colombia small subunit ribosomal RNA gene, partial sequence | blastn | 1325 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 26297945 | 26297945 | PRJEB8827f_S_NODE_366_length_487_cov_35.289823_g347_i0 | PRJEB8827 | 366 | 487 | 35.289823 | 171.86143801 | Pristionchus | 54125 | Nematoda | Nematoda | 117 | 1.66e-21 | NTclustered | gi|150982243|gb|EF634710.1| | 358043 | g347 | i0 | 83.74 | 3.54004106776181 | 123 | 20 | 25 | 0 | 365 | 487 | 303 | 181 | Pristionchus sp. 6 RS5101 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 1724 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 6 RS5101 | |
| 26345897 | 26345897 | PRJEB8827b_S_NODE_2439_length_231_cov_297.698980_g2387_i0 | PRJEB8827 | 2439 | 231 | 297.69898 | 687.6846438 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 4.44e-4 | NTclustered | gi|690021421|emb|LM529123.1| | 174720 | g2387 | i0 | 100 | 1.11255411255411 | 31 | 0 | 13 | 0 | 11 | 41 | 1712 | 1682 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003434 | blastn | 257 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26433920 | 26433920 | PRJEB8827e_S_NODE_3823_length_231_cov_3.382653_g3795_i0 | PRJEB8827 | 3823 | 231 | 3.382653 | 7.81392843 | root | 1 | Root_unresolved | Root_unresolved | 65.8 | 2.65e-6 | NTclustered | gi|690021421|emb|LM529123.1| | 174720 | g3795 | i0 | 86.667 | 15.4458874458874 | 60 | 6 | 25 | 2 | 1 | 58 | 1716 | 1657 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003434 | blastn | 3568 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26569823 | 26569823 | PRJEB8827e_S_NODE_11816_length_189_cov_25.071429_g11788_i0 | PRJEB8827 | 11816 | 189 | 25.071429 | 47.38500081 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 2.69e-5 | NTclustered | gi|690021421|emb|LM529123.1| | 174720 | g11788 | i0 | 100 | 18.4497354497354 | 33 | 0 | 17 | 0 | 1 | 33 | 1716 | 1684 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003434 | blastn | 3487 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26570034 | 26570034 | PRJEB8827h_S_NODE_30504_length_175_cov_5.714286_g30485_i0 | PRJEB8827 | 30504 | 175 | 5.714286 | 10.0000005 | Metazoa | 33208 | Nematoda | Nematoda | 108 | 3.1e-19 | NTclustered | gi|158821897|gb|EU195961.1| | 479135 | g30485 | i0 | 78.313 | 79.5657142857143 | 166 | 36 | 95 | 0 | 10 | 175 | 2624 | 2789 | Cephaloboides cf. armata SB363 28S ribosomal RNA gene, partial sequence | blastn | 13924 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Cephaloboides | Cephaloboides cf. armata SB363 | |
| 32923284 | 32923284 | PRJEB8827h_S_NODE_27849_length_177_cov_1.408451_g27830_i0 | PRJEB8827 | 27849 | 177 | 1.408451 | 2.49295827 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 2.16e-13 | NR | KAK6028982.1 | 6317 | g27830 | i0 | 75 | 8.25423728813559 | 44 | 11 | 74.6 | 0 | 174 | 43 | 116 | 159 | KAK6028982.1 ribosomal protein L15 [Ostertagia ostertagi] | diamond | 1461 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 32982459 | 32982459 | PRJEB8827b_S_NODE_5379_length_207_cov_1085.662791_g5327_i0 | PRJEB8827 | 5379 | 207 | 1085.662791 | 2247.32197737 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 70.9 | 2.94e-12 | NR | KRX92917.1 | 6337 | g5327 | i0 | 72.7 | 0.63768115942029 | 44 | 12 | 63.8 | 0 | 204 | 73 | 152 | 195 | KRX92917.1 Ubiquitin-60S ribosomal protein L40 [Trichinella pseudospiralis] | diamond | 132 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 33084987 | 33084987 | PRJEB8827h_S_NODE_21718_length_181_cov_3.952055_g21699_i0 | PRJEB8827 | 21718 | 181 | 3.952055 | 7.15321955 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 46.6 | 1.79e-4 | NR | KRZ34780.1 | 6337 | g21699 | i0 | 60 | 1.25966850828729 | 40 | 16 | 66.3 | 0 | 179 | 60 | 75 | 114 | KRZ34780.1 40S ribosomal protein S25 [Trichinella pseudospiralis] | diamond | 228 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 33084992 | 33084992 | PRJEB8827h_S_NODE_6438_length_198_cov_4.834356_g6419_i0 | PRJEB8827 | 6438 | 198 | 4.834356 | 9.57202488 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 53.5 | 3.11e-7 | NR | GMT14341.1 | 1538716 | g6419 | i0 | 69.2 | 3.10606060606061 | 39 | 12 | 59.1 | 0 | 179 | 63 | 60 | 98 | GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus] | diamond | 615 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus |
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);;