contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB7799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25528235 | 25528235 | PRJEB7799m_S_NODE_977_length_198_cov_2.453988_g972_i0 | PRJEB7799 | 977 | 198 | 2.453988 | 4.85889624 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 58.4 | 3.69e-4 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g972 | i0 | 97.059 | 2.10606060606061 | 34 | 1 | 17 | 0 | 155 | 188 | 1240 | 1207 | Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 417 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25528509 | 25528509 | PRJEB7799n_S_NODE_8545_length_173_cov_2.913043_g8508_i0 | PRJEB7799 | 8545 | 173 | 2.913043 | 5.03956439 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 309 | 7.81e-80 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g8508 | i0 | 99.412 | 44.2601156069364 | 170 | 1 | 98 | 0 | 1 | 170 | 409 | 240 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 7657 | 309 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 25616766 | 25616766 | PRJEB7799f_S_NODE_1345_length_226_cov_8.272251_g1329_i0 | PRJEB7799 | 1345 | 226 | 8.272251 | 18.69528726 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 418 | 1.7199999999999998e-112 | NTclustered | gi|909719646|gb|KT185626.1| | 5755 | g1329 | i0 | 100 | 47.9026548672566 | 226 | 0 | 100 | 0 | 1 | 226 | 3640 | 3865 | Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10826 | 418 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25617004 | 25617004 | PRJEB7799l_S_NODE_13377_length_155_cov_6.291667_g13348_i0 | PRJEB7799 | 13377 | 155 | 6.291667 | 9.75208385 | Paramoebidae | 200887 | Discosea | other_Eukaryota | 71.3 | 3.52e-8 | NTclustered | gi|30313812|gb|AY193724.1| | 227437 | g13348 | i0 | 100 | 26.541935483871 | 38 | 0 | 25 | 0 | 1 | 38 | 597 | 634 | Neoparamoeba sp. strain AFSM3 small subunit ribosomal RNA gene, complete sequence | blastn | 4114 | 71.3 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Neoparamoeba | Neoparamoeba sp. strain AFSM3 | ||
| 26025245 | 26025245 | PRJEB7799j_S_NODE_4132_length_164_cov_2.984496_g4127_i0 | PRJEB7799 | 4132 | 164 | 2.984496 | 4.89457344 | Vannellidae | 95227 | Discosea | other_Eukaryota | 134 | 4.75e-27 | NTclustered | gi|1269228442|gb|MF683567.1| | 2047823 | g4127 | i0 | 90.385 | 61.8109756097561 | 104 | 6 | 61 | 4 | 12 | 111 | 187 | 84 | Ripella tribonemae clone 70.1.1 18S ribosomal RNA gene, partial sequence | blastn | 10137 | 134 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 26071393 | 26071393 | PRJEB7799f_S_NODE_7133_length_153_cov_2.627119_g7117_i0 | PRJEB7799 | 7133 | 153 | 2.627119 | 4.01949207 | Vannella sp. LITHOV | 1215650 | Discosea | other_Eukaryota | 272 | 8.84e-69 | NTclustered | gi|399764235|gb|JQ271746.1| | 1215650 | g7117 | i0 | 98.693 | 97.1372549019608 | 153 | 2 | 100 | 0 | 1 | 153 | 394 | 242 | Vannella sp. LITHOV 18S ribosomal RNA gene, partial sequence | blastn | 14862 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. LITHOV | |||
| 26072615 | 26072615 | PRJEB7799n_S_NODE_2517_length_273_cov_3.684874_g2480_i0 | PRJEB7799 | 2517 | 273 | 3.684874 | 10.05970602 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 472 | 1.62e-128 | NTclustered | gi|330902858|gb|JF298255.1| | 1017091 | g2480 | i0 | 97.81 | 16.996336996337 | 274 | 5 | 100 | 1 | 1 | 273 | 738 | 1011 | Cochliopodium larifeili clone 904 18S ribosomal RNA gene, partial sequence | blastn | 4640 | 472 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26161418 | 26161418 | PRJEB7799k_S_NODE_445_length_249_cov_7.177570_g439_i0 | PRJEB7799 | 445 | 249 | 7.17757 | 17.8721493 | Vermistella | 354201 | Discosea | other_Eukaryota | 97.1 | 1.03e-15 | NTclustered | gi|766943132|gb|KJ874207.1| | 1628650 | g439 | i0 | 90.411 | 31.7309236947791 | 73 | 7 | 29 | 0 | 177 | 249 | 1522 | 1594 | Vermistella sp. TT-2015a strain SV198 clone 1 18S ribosomal RNA gene, partial sequence | blastn | 7901 | 97.1 | 1 | Eukaryota | Amoebozoa | Discosea | Stygamoebida | Vermistella | Vermistella arctica | ||||
| 26209373 | 26209373 | PRJEB7799p_S_NODE_1310_length_365_cov_6.142424_g1287_i0 | PRJEB7799 | 1310 | 365 | 6.142424 | 22.4198476 | uncultured Vannellidae | 544561 | Discosea | other_Eukaryota | 209 | 1.94e-49 | NTclustered | gi|724028230|gb|KP099889.1| | 544561 | g1287 | i0 | 77.929 | 37.5287671232877 | 367 | 60 | 99 | 18 | 1 | 362 | 832 | 482 | Uncultured Vannellidae clone b18 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 13698 | 209 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | uncultured Vannellidae | ||||
| 26209397 | 26209397 | PRJEB7799p_S_NODE_14526_length_178_cov_9.720280_g14503_i0 | PRJEB7799 | 14526 | 178 | 9.72028 | 17.3020984 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 298 | 1.75e-76 | NTclustered | gi|330902844|gb|JF298248.1| | 703021 | g14503 | i0 | 100 | 83.1629213483146 | 161 | 0 | 90 | 0 | 1 | 161 | 442 | 282 | Cochliopodium actinophorum clone 1206 18S ribosomal RNA gene, partial sequence | blastn | 14803 | 298 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 26297010 | 26297010 | PRJEB7799f_S_NODE_6998_length_154_cov_62.621849_g6982_i0 | PRJEB7799 | 6998 | 154 | 62.621849 | 96.43764746 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 5.639999999999999e-31 | NTclustered | gi|909719646|gb|KT185626.1| | 5755 | g6982 | i0 | 100 | 38.1168831168831 | 79 | 0 | 86 | 0 | 76 | 154 | 2997 | 2919 | Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 5870 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26345229 | 26345229 | PRJEB7799p_S_NODE_1607_length_344_cov_2.828479_g1584_i0 | PRJEB7799 | 1607 | 344 | 2.828479 | 9.72996776 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 510 | 4.469999999999998e-140 | NTclustered | gi|330902858|gb|JF298255.1| | 1017091 | g1584 | i0 | 93.696 | 14.5755813953488 | 349 | 9 | 100 | 11 | 1 | 344 | 1016 | 676 | Cochliopodium larifeili clone 904 18S ribosomal RNA gene, partial sequence | blastn | 5014 | 510 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26433240 | 26433240 | PRJEB7799j_S_NODE_191_length_280_cov_3.061224_g186_i0 | PRJEB7799 | 191 | 280 | 3.061224 | 8.5714272 | Vannellidae | 95227 | Discosea | other_Eukaryota | 329 | 1.0599999999999998e-85 | NTclustered | gi|399764216|gb|JQ271727.1| | 1215631 | g186 | i0 | 88.38 | 100.557142857143 | 284 | 20 | 100 | 7 | 1 | 280 | 560 | 286 | Vannella sp. BEN3V 18S ribosomal RNA gene, partial sequence | blastn | 28156 | 329 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. BEN3V | |||
| 26479215 | 26479215 | PRJEB7799c_S_NODE_2208_length_250_cov_4.688372_g2185_i0 | PRJEB7799 | 2208 | 250 | 4.688372 | 11.72093 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 379 | 9.139999999999998e-101 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g2185 | i0 | 97.727 | 43.128 | 220 | 5 | 88 | 0 | 31 | 250 | 1738 | 1519 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 10782 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26480950 | 26480950 | PRJEB7799n_S_NODE_1240_length_368_cov_6.621622_g1203_i0 | PRJEB7799 | 1240 | 368 | 6.621622 | 24.36756896 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 204 | 9.119999999999999e-48 | NTclustered | gi|470521486|ref|XM_004353672.1| | 1257118 | g1203 | i0 | 82.479 | 63.991847826087 | 234 | 39 | 63 | 2 | 66 | 298 | 331 | 99 | Acanthamoeba castellanii str. Neff Histone H4, putative (ACA1_376700), partial mRNA | blastn | 23549 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26481726 | 26481726 | PRJEB7799p_S_NODE_2600_length_293_cov_3.217054_g2577_i0 | PRJEB7799 | 2600 | 293 | 3.217054 | 9.42596822 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 492 | 1.35e-134 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g2577 | i0 | 96.939 | 57.9488054607509 | 294 | 7 | 100 | 2 | 1 | 293 | 133 | 425 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 16979 | 492 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili |
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);;