contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 311960 | 311960 | PRJNA1164198_P_NODE_17181_length_298_cov_1.448889_g16912_i0 | PRJNA1164198 | 17181 | 298 | 1.448889 | 4.31768922 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 285 | 2.51e-72 | NTclustered | gi|1914009695|gb|MT975597.1| | 313997 | g16912 | i0 | 84 | 96.6375838926175 | 300 | 44 | 100 | 4 | 1 | 298 | 44 | 341 | Cochliopodium minus clone 2 actin gene, partial cds | blastn | 28798 | 285 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 6689872 | 6689872 | PRJNA1164198_P_NODE_1606_length_963_cov_5.931461_g1438_i0 | PRJNA1164198 | 1606 | 963 | 5.931461 | 57.11996943 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 119 | 9.48e-22 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g1438 | i0 | 79.429 | 1.9460020768432 | 175 | 30 | 18 | 5 | 412 | 583 | 2858 | 2687 | Paravannella minima mitochondrion, complete genome | blastn | 1874 | 119 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 10515586 | 10515586 | PRJNA1164198_P_NODE_18169_length_290_cov_2.271889_g17900_i0 | PRJNA1164198 | 18169 | 290 | 2.271889 | 6.5884781 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 137 | 7.2099999999999985e-28 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g17900 | i0 | 79.512 | 42.9 | 205 | 33 | 69 | 9 | 30 | 229 | 2929 | 3129 | Paravannella minima mitochondrion, complete genome | blastn | 12441 | 137 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 11790627 | 11790627 | PRJNA1164198_P_NODE_7730_length_450_cov_2.291777_g7468_i0 | PRJNA1164198 | 7730 | 450 | 2.291777 | 10.3129965 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 344 | 6.419999999999999e-90 | NTclustered | gi|1269228420|gb|MF683545.1| | 2047822 | g7468 | i0 | 81.264 | 101.173333333333 | 459 | 56 | 99 | 18 | 5 | 450 | 1576 | 1135 | Ripella decalvata clone 26.1.57 18S ribosomal RNA gene, partial sequence | blastn | 45528 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 15614805 | 15614805 | PRJNA1164198_P_NODE_27913_length_247_cov_0.896552_g27644_i0 | PRJNA1164198 | 27913 | 247 | 0.896552 | 2.21448344 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 339 | 1.5299999999999998e-88 | NTclustered | gi|470492676|ref|XM_004345989.1| | 1257118 | g27644 | i0 | 99.462 | 14.5384615384615 | 186 | 1 | 75 | 0 | 62 | 247 | 1674 | 1489 | Acanthamoeba castellanii str. Neff cathepsin Llike proteinase (ACA1_184420), partial mRNA | blastn | 3591 | 339 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18163527 | 18163527 | PRJNA1164198_P_NODE_12255_length_355_cov_0.840426_g11987_i0 | PRJNA1164198 | 12255 | 355 | 0.840426 | 2.9835123 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 579 | 1.2499999999999997e-160 | NTclustered | gi|1269228411|gb|MF683536.1| | 2047822 | g11987 | i0 | 96.078 | 101.36338028169 | 357 | 10 | 100 | 4 | 1 | 355 | 1130 | 1484 | Ripella decalvata clone 26.1.47 18S ribosomal RNA gene, partial sequence | blastn | 35984 | 579 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 18163634 | 18163634 | PRJNA1164198_P_NODE_6435_length_496_cov_5.458629_g6177_i0 | PRJNA1164198 | 6435 | 496 | 5.458629 | 27.07479984 | Vannella miroides | 218656 | Discosea | other_Eukaryota | 793 | 0 | NTclustered | gi|27803574|gb|AY183888.1| | 218656 | g6177 | i0 | 95.565 | 97.8286290322581 | 496 | 20 | 100 | 2 | 1 | 496 | 1436 | 1929 | Vannella miroides small subunit ribosomal RNA gene, complete sequence | blastn | 48523 | 793 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella miroides | |||
| 19437976 | 19437976 | PRJNA1164198_P_NODE_3076_length_716_cov_6.841369_g2852_i0 | PRJNA1164198 | 3076 | 716 | 6.841369 | 48.98420204 | Vannella croatica | 1778588 | Discosea | other_Eukaryota | 1116 | 0 | NTclustered | gi|973761167|gb|KT345693.1| | 1778588 | g2852 | i0 | 94.832 | 82.3659217877095 | 716 | 36 | 100 | 1 | 1 | 716 | 1235 | 521 | Vannella croatica isolate KRKA 29.9.7.6.1 small subunit ribosomal RNA gene, partial sequence | blastn | 58974 | 1116 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella croatica | |||
| 20713275 | 20713275 | PRJNA1164198_P_NODE_13957_length_331_cov_1.810078_g13688_i0 | PRJNA1164198 | 13957 | 331 | 1.810078 | 5.99135818 | Vexillifera multispinosa | 1105342 | Discosea | other_Eukaryota | 529 | 1.1799999999999999e-145 | NTclustered | gi|354720322|gb|HQ687481.1| | 1105342 | g13688 | i0 | 95.522 | 67.3897280966767 | 335 | 8 | 100 | 4 | 1 | 331 | 1200 | 869 | Vexillifera multispinosa strain P124 small subunit ribosomal RNA gene, partial sequence | blastn | 22306 | 529 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera multispinosa | ||
| 20713344 | 20713344 | PRJNA1164198_P_NODE_28577_length_246_cov_0.901734_g28308_i0 | PRJNA1164198 | 28577 | 246 | 0.901734 | 2.21826564 | Thecamoeba sp. JRG-2011 | 1078868 | Discosea | other_Eukaryota | 279 | 9.36e-71 | NTclustered | gi|345452613|gb|JF694325.1| | 1078868 | g28308 | i0 | 86.992 | 100.934959349593 | 246 | 32 | 100 | 0 | 1 | 246 | 538 | 293 | Thecamoeba sp. JRG-2011 strain ATCC 50185 clone 3 actin gene, partial cds | blastn | 24830 | 279 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba sp. JRG-2011 | |||
| 23264253 | 23264253 | PRJNA1164198_P_NODE_6599_length_489_cov_2.810096_g6340_i0 | PRJNA1164198 | 6599 | 489 | 2.810096 | 13.74136944 | Ripella sp. | 1973050 | Discosea | other_Eukaryota | 375 | 2.4899999999999997e-99 | NTclustered | gi|2666517890|gb|PP259001.1| | 1973050 | g6340 | i0 | 86.188 | 78.4683026584867 | 362 | 32 | 73 | 14 | 57 | 412 | 110 | 459 | Ripella sp. strain CHIESE60 small subunit ribosomal RNA gene, partial sequence | blastn | 38371 | 375 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. | |||
| 25265821 | 25265821 | PRJNA1164198_P_NODE_9220_length_410_cov_2.459941_g8955_i0 | PRJNA1164198 | 9220 | 410 | 2.459941 | 10.0857581 | Ripella | 1217112 | Discosea | other_Eukaryota | 612 | 1.4399999999999996e-170 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g8955 | i0 | 93.917 | 91.5170731707317 | 411 | 15 | 99 | 7 | 4 | 410 | 1073 | 669 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 37522 | 616 | 0.993506493506494 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 |
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);;