contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3959196 | 3959196 | PRJEB66218_P_NODE_2944_length_2722_cov_37.396467_g2468_i0 | PRJEB66218 | 2944 | 2722 | 37.396467 | 1017.93183174 | Cephalobus cubaensis | 114851 | Nematoda | Nematoda | 331 | 3.24e-85 | NTclustered | gi|2678074852|gb|PP358784.1| | 114851 | g2468 | i0 | 78.625 | 16.3618662747979 | 538 | 88 | 19 | 19 | 1141 | 1662 | 1884 | 1358 | Cephalobus cubaensis isolate B3311/M641 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 44537 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Cephalobidae | Cephalobus | Cephalobus cubaensis | |
| 6511097 | 6511097 | PRJEB66218_P_NODE_249626_length_177_cov_6.491379_g247194_i0 | PRJEB66218 | 249626 | 177 | 6.491379 | 11.48974083 | Bunonema sp. VS-2014 | 1538689 | Nematoda | Nematoda | 78.7 | 2.47e-10 | NTclustered | gi|675118816|gb|KJ877287.1| | 1538689 | g247194 | i0 | 91.228 | 10.1186440677966 | 57 | 5 | 32 | 0 | 77 | 133 | 1263 | 1319 | Bunonema sp. VS-2014 strain RS9014 28S ribosomal RNA gene, partial sequence | blastn | 1791 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Bunonematidae | Bunonema | Bunonema sp. VS-2014 | |
| 9060790 | 9060790 | PRJEB66218_P_NODE_46068_length_505_cov_2.792793_g43652_i0 | PRJEB66218 | 46068 | 505 | 2.792793 | 14.10360465 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 337 | 1.22e-87 | NTclustered | gi|1376154049|ref|XM_024646386.1| | 34506 | g43652 | i0 | 80.31 | 63.2851485148515 | 452 | 84 | 89 | 5 | 43 | 490 | 1438 | 988 | Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA | blastn | 31959 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 14160879 | 14160879 | PRJEB66218_P_NODE_216152_length_207_cov_0.890411_g213722_i0 | PRJEB66218 | 216152 | 207 | 0.890411 | 1.84315077 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 76.8 | 1.07e-9 | NTclustered | gi|1376135875|ref|XM_024647987.1| | 34506 | g213722 | i0 | 80 | 0.507246376811594 | 105 | 20 | 51 | 1 | 2 | 106 | 223 | 326 | Strongyloides ratti Ribosomal protein L26/L24P, eukaryotic/archaeal family and Translation protein SH3-like domain and Ribosomal protein L2 domain 2-containing protein (SRAE_1000107700), partial mRNA | blastn | 105 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 16707772 | 16707772 | PRJEB66218_P_NODE_135054_length_256_cov_1.682051_g132625_i0 | PRJEB66218 | 135054 | 256 | 1.682051 | 4.30605056 | Plectus aquatilis | 70222 | Nematoda | Nematoda | 300 | 7.53e-77 | NTclustered | gi|148614850|gb|EF417147.1| | 70222 | g132625 | i0 | 86.822 | 11.5078125 | 258 | 30 | 99 | 2 | 2 | 256 | 574 | 318 | Plectus aquatilis large subunit ribosomal RNA gene, partial sequence | blastn | 2946 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus aquatilis | |
| 16708941 | 16708941 | PRJEB66218_P_NODE_201394_length_210_cov_1.308725_g198964_i0 | PRJEB66218 | 201394 | 210 | 1.308725 | 2.7483225 | Necator americanus | 51031 | Nematoda | Nematoda | 117 | 6.44e-22 | NTclustered | gi|2707547990|ref|XM_064180592.1| | 51031 | g198964 | i0 | 95.833 | 2.99047619047619 | 72 | 3 | 34 | 0 | 102 | 173 | 272 | 201 | Necator americanus uncharacterized protein (RB195_007128), partial mRNA | blastn | 628 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 16709032 | 16709032 | PRJEB66218_P_NODE_207334_length_209_cov_0.878378_g204904_i0 | PRJEB66218 | 207334 | 209 | 0.878378 | 1.83581002 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 180 | 8.06e-41 | NTclustered | gi|690018524|emb|LM525762.1| | 174720 | g204904 | i0 | 84.239 | 19.0095693779904 | 184 | 29 | 88 | 0 | 6 | 189 | 22898 | 22715 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000152 | blastn | 3973 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16709389 | 16709389 | PRJEB66218_P_NODE_231874_length_204_cov_0.909091_g229444_i0 | PRJEB66218 | 231874 | 204 | 0.909091 | 1.85454564 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 167 | 6.089999999999999e-37 | NTclustered | gi|687022666|emb|LM525580.1| | 174720 | g229444 | i0 | 82.723 | 90.9607843137255 | 191 | 29 | 93 | 4 | 12 | 200 | 237326 | 237138 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007 | blastn | 18556 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 19260112 | 19260112 | PRJEB66218_P_NODE_86036_length_337_cov_1.648551_g83609_i0 | PRJEB66218 | 86036 | 337 | 1.648551 | 5.55561687 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 6.84e-4 | NTclustered | gi|687022647|emb|LM525561.1| | 174720 | g83609 | i0 | 100 | 9.13946587537092 | 31 | 0 | 9 | 0 | 305 | 335 | 75339 | 75309 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000006 | blastn | 3080 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22671102 | 22671102 | PRJEB66218_P_NODE_132238_length_259_cov_1.964646_g129809_i0 | PRJEB66218 | 132238 | 259 | 1.964646 | 5.08843314 | root | 1 | Root_unresolved | Root_unresolved | 324 | 4.53e-84 | NTclustered | gi|18147016|dbj|AB047763.1| | 6304 | g129809 | i0 | 89.189 | 57.2393822393822 | 259 | 28 | 100 | 0 | 1 | 259 | 1093 | 835 | Meloidogyne arenaria DNA, polymorphic marker for virulence, isolate:MAYG-VI | blastn | 14825 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria |
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);;