contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560210 | 560210 | PRJNA575566_P_NODE_28321_length_203_cov_0.901408_g28124_i0 | PRJNA575566 | 28321 | 203 | 0.901408 | 1.82985824 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 259 | 9.71e-65 | NTclustered | gi|470416357|ref|XM_004336829.1| | 1257118 | g28124 | i0 | 90 | 97.7783251231527 | 200 | 20 | 99 | 0 | 2 | 201 | 560 | 361 | Acanthamoeba castellanii str. Neff fumarate hydratase, class II, putative (ACA1_130590), partial mRNA | blastn | 19849 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6240436 | 6240436 | PRJNA575566_P_NODE_9565_length_338_cov_0.924188_g9368_i0 | PRJNA575566 | 9565 | 338 | 0.924188 | 3.12375544 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 4.97e-50 | NTclustered | gi|1805599632|gb|MN129744.1| | 5756 | g9368 | i0 | 78.55 | 77.6183431952663 | 331 | 63 | 97 | 7 | 2 | 328 | 229 | 555 | Acanthamoeba sp. strain PSH NADH dehydrogenase subunit 5 (ND5) gene, partial cds; mitochondrial | blastn | 26235 | 213 | 0.990610328638498 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 6938411 | 6938411 | PRJNA575566_P_NODE_9186_length_344_cov_4.890459_g8989_i0 | PRJNA575566 | 9186 | 344 | 4.890459 | 16.82317896 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 542 | 1.58e-149 | NTclustered | gi|330902845|gb|JF298249.1| | 703021 | g8989 | i0 | 95.362 | 79.4970930232558 | 345 | 8 | 100 | 5 | 1 | 344 | 816 | 1153 | Cochliopodium actinophorum clone 1202 18S ribosomal RNA gene, partial sequence | blastn | 27347 | 542 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 13314161 | 13314161 | PRJNA575566_P_NODE_2931_length_604_cov_16.416206_g2736_i0 | PRJNA575566 | 2931 | 604 | 16.416206 | 99.15388424 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 462 | 2.33e-125 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g2736 | i0 | 99.605 | 38.4834437086093 | 253 | 1 | 82 | 0 | 1 | 253 | 504 | 252 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 23244 | 462 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 18412153 | 18412153 | PRJNA575566_P_NODE_4075_length_518_cov_2.757112_g3878_i0 | PRJNA575566 | 4075 | 518 | 2.757112 | 14.28184016 | Balamuthia mandrillaris | 66527 | Discosea | other_Eukaryota | 276 | 2.7699999999999997e-69 | NTclustered | gi|918020693|ref|NC_027736.1| | 66527 | g3878 | i0 | 84.083 | 54.7683397683398 | 289 | 42 | 55 | 4 | 148 | 432 | 37325 | 37037 | Balamuthia mandrillaris strain BeN mitochondrion, complete genome | blastn | 28370 | 276 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Balamuthiidae | Balamuthia | Balamuthia mandrillaris | |||
| 22237269 | 22237269 | PRJNA575566_P_NODE_4838_length_475_cov_2.707729_g4641_i0 | PRJNA575566 | 4838 | 475 | 2.707729 | 12.86171275 | Cochliopodium marrii | 2652063 | Discosea | other_Eukaryota | 634 | 3.609999999999999e-177 | NTclustered | gi|1758131109|gb|MN389530.1| | 2652063 | g4641 | i0 | 96.134 | 61.7284210526316 | 388 | 15 | 82 | 0 | 1 | 388 | 388 | 1 | Cochliopodium marrii isolate 1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 29321 | 634 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium marrii |
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);;