contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2719588 | 2719588 | PRJNA1035005_P_NODE_83083_length_243_cov_0.917647_g82677_i0 | PRJNA1035005 | 83083 | 243 | 0.917647 | 2.22988221 | Fictor sp. 2 VS-2014 | 1538695 | Nematoda | Nematoda | 104 | 5.96e-18 | NTclustered | gi|675118819|gb|KJ877289.1| | 1538695 | g82677 | i0 | 79.861 | 4.88477366255144 | 144 | 28 | 59 | 1 | 32 | 174 | 198 | 55 | Fictor sp. 2 VS-2014 strain RS9002 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 1187 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Fictor | Fictor sp. 2 VS-2014 | |
| 6546952 | 6546952 | PRJNA1035005_P_NODE_4606_length_496_cov_2.014184_g4206_i0 | PRJNA1035005 | 4606 | 496 | 2.014184 | 9.99035264 | Oscheius tipulae | 141969 | Nematoda | Nematoda | 911 | 0 | NTclustered | gi|158821905|gb|EU195969.1| | 141969 | g4206 | i0 | 99.798 | 100.618951612903 | 496 | 1 | 100 | 0 | 1 | 496 | 1895 | 1400 | Oscheius tipulae strain CEW1 28S ribosomal RNA gene, partial sequence | blastn | 49907 | 911 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius tipulae | |
| 7821479 | 7821479 | PRJNA1035005_P_NODE_4527_length_501_cov_1.406542_g4128_i0 | PRJNA1035005 | 4527 | 501 | 1.406542 | 7.04677542 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 58.4 | 0.001 | NTclustered | gi|413002270|emb|Z50005.2| | 6239 | g4128 | i0 | 100 | 0.12375249500998 | 31 | 0 | 6 | 0 | 139 | 169 | 6337 | 6307 | Caenorhabditis elegans Cosmid F16H9, complete sequence | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 7821660 | 7821660 | PRJNA1035005_P_NODE_69167_length_247_cov_2.902299_g68761_i0 | PRJNA1035005 | 69167 | 247 | 2.902299 | 7.16867853 | Parastrongyloides trichosuri | 131310 | Nematoda | Nematoda | 134 | 7.750000000000001e-27 | NTclustered | gi|9438175|gb|AF278536.1| | 131310 | g68761 | i0 | 76.829 | 1.51012145748988 | 246 | 52 | 98 | 4 | 3 | 244 | 2699 | 2943 | Parastrongyloides trichosuri heat shock 70 protein gene, complete cds | blastn | 373 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Parastrongyloides | Parastrongyloides trichosuri | |
| 11211286 | 11211286 | PRJNA1035005_P_NODE_8609_length_382_cov_1.003236_g8207_i0 | PRJNA1035005 | 8609 | 382 | 1.003236 | 3.83236152 | Metazoa | 33208 | Nematoda | Nematoda | 228 | 5.639999999999998e-55 | NTclustered | gi|255098668|gb|FJ555023.1| | 6325 | g8207 | i0 | 78.655 | 80.8821989528796 | 342 | 73 | 90 | 0 | 25 | 366 | 958 | 617 | Bursaphelenchus mucronatus heat shock protein 70 (hsp70) mRNA, complete cds | blastn | 30897 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus mucronatus | |
| 19294497 | 19294497 | PRJNA1035005_P_NODE_21776_length_294_cov_1.411765_g21370_i0 | PRJNA1035005 | 21776 | 294 | 1.411765 | 4.1505891 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 226 | 1.52e-54 | NTclustered | gi|1376136021|ref|XM_024648069.1| | 34506 | g21370 | i0 | 81.034 | 27.9421768707483 | 290 | 50 | 97 | 5 | 9 | 294 | 299 | 11 | Strongyloides ratti Histone H3 (SRAE_1000114900), partial mRNA | blastn | 8215 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 20569886 | 20569886 | PRJNA1035005_P_NODE_22697_length_292_cov_1.401826_g22291_i0 | PRJNA1035005 | 22697 | 292 | 1.401826 | 4.09333192 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 252 | 2.4899999999999998e-62 | NTclustered | gi|687865697|emb|LK927572.1| | 6239 | g22291 | i0 | 84.17 | 132.325342465753 | 259 | 41 | 95 | 0 | 1 | 259 | 119839 | 120097 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039 | blastn | 38639 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;