contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 948214 | 948214 | PRJNA976345_P_NODE_198501_length_150_cov_1.739130_g196893_i0 | PRJNA976345 | 198501 | 150 | 1.73913 | 2.608695 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.012 | NTclustered | gi|351062981|emb|FO081360.1| | 6239 | g196893 | i0 | 100 | 0.373333333333333 | 28 | 0 | 19 | 0 | 10 | 37 | 9058 | 9031 | Caenorhabditis elegans Cosmid F54D11, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 2223287 | 2223287 | PRJNA976345_P_NODE_15462_length_431_cov_14.040404_g13877_i0 | PRJNA976345 | 15462 | 431 | 14.040404 | 60.51414124 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 58.4 | 8.94e-4 | NTclustered | gi|687866312|emb|LK928592.1| | 6239 | g13877 | i0 | 100 | 0.273781902552204 | 31 | 0 | 7 | 0 | 391 | 421 | 14295 | 14265 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000765 | blastn | 118 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 2223916 | 2223916 | PRJNA976345_P_NODE_5102_length_832_cov_28.065245_g3852_i0 | PRJNA976345 | 5102 | 832 | 28.065245 | 233.5028384 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 58.4 | 0.002 | NTclustered | gi|687866312|emb|LK928592.1| | 6239 | g3852 | i0 | 100 | 0.0745192307692308 | 31 | 0 | 4 | 0 | 792 | 822 | 14295 | 14265 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000765 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3498654 | 3498654 | PRJNA976345_P_NODE_167003_length_160_cov_1.264000_g165395_i0 | PRJNA976345 | 167003 | 160 | 1.264 | 2.0224 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 52.8 | 0.013 | NTclustered | gi|11095119|gb|AC084673.1|CBRG47I15 | 6238 | g165395 | i0 | 100 | 0.175 | 28 | 0 | 18 | 0 | 88 | 115 | 18027 | 18000 | Caenorhabditis briggsae cosmid G47I15, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 4777048 | 4777048 | PRJNA976345_P_NODE_73644_length_212_cov_2.248588_g72036_i0 | PRJNA976345 | 73644 | 212 | 2.248588 | 4.76700656 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.005 | NTclustered | gi|7140414|gb|AC024851.1|AC024851 | 6239 | g72036 | i0 | 96.97 | 0.466981132075472 | 33 | 0 | 15 | 1 | 85 | 116 | 64787 | 64755 | Caenorhabditis elegans clone Y71F9AL, complete sequence | blastn | 99 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6051186 | 6051186 | PRJNA976345_P_NODE_161945_length_161_cov_4.841270_g160337_i0 | PRJNA976345 | 161945 | 161 | 4.84127 | 7.7944447 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|412976035|emb|FO080131.2| | 6239 | g160337 | i0 | 100 | 0.360248447204969 | 29 | 0 | 18 | 0 | 17 | 45 | 12704 | 12732 | Caenorhabditis elegans Cosmid C06A8, complete sequence | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6051354 | 6051354 | PRJNA976345_P_NODE_188365_length_153_cov_1.483051_g186757_i0 | PRJNA976345 | 188365 | 153 | 1.483051 | 2.26906803 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 89.8 | 9.55e-14 | NTclustered | gi|413002462|emb|Z35663.2| | 6239 | g186757 | i0 | 88.158 | 1.49019607843137 | 76 | 8 | 49 | 1 | 26 | 100 | 25137 | 25062 | Caenorhabditis elegans Cosmid T04A8, complete sequence | blastn | 228 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 7326293 | 7326293 | PRJNA976345_P_NODE_35766_length_285_cov_3.076000_g34159_i0 | PRJNA976345 | 35766 | 285 | 3.076 | 8.7666 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|687022658|emb|LM525572.1| | 174720 | g34159 | i0 | 100 | 0.105263157894737 | 30 | 0 | 11 | 0 | 26 | 55 | 141482 | 141511 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000013 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 11151863 | 11151863 | PRJNA976345_P_NODE_2689_length_1370_cov_18.085393_g1776_i0 | PRJNA976345 | 2689 | 1370 | 18.085393 | 247.7698841 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 58.4 | 0.003 | NTclustered | gi|687866312|emb|LK928592.1| | 6239 | g1776 | i0 | 100 | 0.0452554744525547 | 31 | 0 | 2 | 0 | 1330 | 1360 | 14295 | 14265 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000765 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 12427385 | 12427385 | PRJNA976345_P_NODE_190410_length_152_cov_2.316239_g188802_i0 | PRJNA976345 | 190410 | 152 | 2.316239 | 3.52068328 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|687866576|emb|LK928554.1| | 6239 | g188802 | i0 | 97.059 | 0.447368421052632 | 34 | 0 | 22 | 1 | 47 | 79 | 5068 | 5101 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000278 | blastn | 68 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 14976732 | 14976732 | PRJNA976345_P_NODE_78372_length_207_cov_2.488372_g76764_i0 | PRJNA976345 | 78372 | 207 | 2.488372 | 5.15093004 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 126 | 1.05e-24 | NTclustered | gi|268536275|ref|XM_002633227.1| | 6238 | g76764 | i0 | 84.8 | 12.9130434782609 | 125 | 19 | 60 | 0 | 21 | 145 | 125 | 1 | Caenorhabditis briggsae Protein CBR-LET-70 (Cbr-let-70), partial mRNA | blastn | 2673 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 18800750 | 18800750 | PRJNA976345_P_NODE_96755_length_192_cov_1.796178_g95147_i0 | PRJNA976345 | 96755 | 192 | 1.796178 | 3.44866176 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|412976748|emb|AL033514.2| | 6239 | g95147 | i0 | 100 | 0.291666666666667 | 28 | 0 | 15 | 0 | 124 | 151 | 202938 | 202911 | Caenorhabditis elegans YAC Y75B8A, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25173858 | 25173858 | PRJNA976345_P_NODE_128560_length_176_cov_1.801418_g126952_i0 | PRJNA976345 | 128560 | 176 | 1.801418 | 3.17049568 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|687022780|emb|LM525892.1| | 174720 | g126952 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 107 | 134 | 16427 | 16400 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000266 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;