contig_metadata
12 rows where bioproject = "PRJEB8827", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530260 | 25530260 | PRJEB8827g_S_NODE_5441_length_174_cov_5.474820_g5420_i0 | PRJEB8827 | 5441 | 174 | 5.47482 | 9.5261868 | Ripella sp. 8 | 1973050 | Discosea | other_Eukaryota | 189 | 1.0699999999999999e-43 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g5420 | i0 | 100 | 62.0287356321839 | 102 | 0 | 59 | 0 | 51 | 152 | 682 | 581 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 10793 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 25530338 | 25530338 | PRJEB8827h_S_NODE_30497_length_175_cov_11.950000_g30478_i0 | PRJEB8827 | 30497 | 175 | 11.95 | 20.9125 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 296 | 6.17e-76 | NTclustered | gi|330902844|gb|JF298248.1| | 703021 | g30478 | i0 | 100 | 84.56 | 160 | 0 | 91 | 0 | 1 | 160 | 442 | 283 | Cochliopodium actinophorum clone 1206 18S ribosomal RNA gene, partial sequence | blastn | 14798 | 296 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 25802484 | 25802484 | PRJEB8827h_S_NODE_45467_length_156_cov_11.371901_g45448_i0 | PRJEB8827 | 45467 | 156 | 11.371901 | 17.74016556 | Ripella sp. 8 | 1973050 | Discosea | other_Eukaryota | 250 | 4.25e-62 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g45448 | i0 | 95.541 | 101.596153846154 | 157 | 6 | 100 | 1 | 1 | 156 | 554 | 398 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 15849 | 250 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 25802539 | 25802539 | PRJEB8827j_S_NODE_2827_length_174_cov_4.956835_g2823_i0 | PRJEB8827 | 2827 | 174 | 4.956835 | 8.6248929 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 311 | 2.19e-80 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g2823 | i0 | 98.851 | 46.367816091954 | 174 | 2 | 100 | 0 | 1 | 174 | 417 | 244 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 8068 | 311 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 26074557 | 26074557 | PRJEB8827g_S_NODE_157_length_607_cov_707.398601_g143_i0 | PRJEB8827 | 157 | 607 | 707.398601 | 4293.90950807 | Ripella sp. 8 | 1973050 | Discosea | other_Eukaryota | 883 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g143 | i0 | 95.365 | 92.7660626029654 | 561 | 17 | 92 | 8 | 49 | 607 | 1 | 554 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 56309 | 883 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 26074662 | 26074662 | PRJEB8827h_S_NODE_2845_length_216_cov_6.049724_g2826_i0 | PRJEB8827 | 2845 | 216 | 6.049724 | 13.06740384 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 346 | 7.810000000000001e-91 | NTclustered | gi|1269228400|gb|MF683525.1| | 2047822 | g2826 | i0 | 95.833 | 86.462962962963 | 216 | 6 | 100 | 3 | 1 | 216 | 392 | 180 | Ripella decalvata clone 23.3.9 18S ribosomal RNA gene, partial sequence | blastn | 18676 | 346 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 26074736 | 26074736 | PRJEB8827j_S_NODE_669_length_222_cov_1.475936_g665_i0 | PRJEB8827 | 669 | 222 | 1.475936 | 3.27657792 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 327 | 2.92e-85 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g665 | i0 | 93.274 | 11 | 223 | 14 | 100 | 1 | 1 | 222 | 791 | 569 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 2442 | 327 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26210946 | 26210946 | PRJEB8827h_S_NODE_830_length_313_cov_7.496403_g811_i0 | PRJEB8827 | 830 | 313 | 7.496403 | 23.46374139 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 385 | 2.54e-102 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g811 | i0 | 98.19 | 65.1182108626198 | 221 | 3 | 71 | 1 | 66 | 286 | 222 | 3 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 20382 | 385 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 26346714 | 26346714 | PRJEB8827h_S_NODE_1703_length_246_cov_2.345972_g1684_i0 | PRJEB8827 | 1703 | 246 | 2.345972 | 5.77109112 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 117 | 7.77e-22 | NTclustered | gi|470434524|ref|XM_004338640.1| | 1257118 | g1684 | i0 | 78.977 | 13.5 | 176 | 34 | 71 | 3 | 66 | 239 | 202 | 28 | Acanthamoeba castellanii str. Neff protein translocase SEC61 complex gamma subunit, archaeal and eukaryotic, putative (ACA1_089230), partial mRNA | blastn | 3321 | 117 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26346770 | 26346770 | PRJEB8827h_S_NODE_4727_length_203_cov_1.416667_g4708_i0 | PRJEB8827 | 4727 | 203 | 1.416667 | 2.87583401 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 281 | 2.07e-71 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g4708 | i0 | 91.667 | 10.8965517241379 | 204 | 16 | 100 | 1 | 1 | 203 | 606 | 809 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 2212 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26483043 | 26483043 | PRJEB8827j_S_NODE_232_length_307_cov_5.772059_g228_i0 | PRJEB8827 | 232 | 307 | 5.772059 | 17.72022113 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 363 | 1.17e-95 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g228 | i0 | 91.698 | 23.1107491856678 | 265 | 17 | 85 | 5 | 1 | 262 | 617 | 879 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 7095 | 363 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 26570044 | 26570044 | PRJEB8827h_S_NODE_43240_length_159_cov_5.508065_g43221_i0 | PRJEB8827 | 43240 | 159 | 5.508065 | 8.75782335 | Ripella | 1217112 | Discosea | other_Eukaryota | 220 | 3.4099999999999998e-53 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g43221 | i0 | 100 | 76.6037735849057 | 119 | 0 | 75 | 0 | 41 | 159 | 682 | 564 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 12180 | 220 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 |
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);;