contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8140006 | 8140006 | PRJNA515078_P_NODE_6507_length_367_cov_2.936364_g6274_i0 | PRJNA515078 | 6507 | 367 | 2.936364 | 10.77645588 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 189 | 2.55e-43 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g6274 | i0 | 84.375 | 53.1961852861035 | 192 | 30 | 52 | 0 | 36 | 227 | 312 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 19523 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9415096 | 9415096 | PRJNA515078_P_NODE_9668_length_292_cov_1.411765_g9435_i0 | PRJNA515078 | 9668 | 292 | 1.411765 | 4.1223538 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 165 | 3.3300000000000003e-36 | NTclustered | gi|470526398|ref|XM_004356698.1| | 1257118 | g9435 | i0 | 78.862 | 2.45890410958904 | 246 | 50 | 84 | 2 | 47 | 291 | 52 | 296 | Acanthamoeba castellanii str. Neff cytochrome c, putative (ACA1_175250), partial mRNA | blastn | 718 | 165 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19612914 | 19612914 | PRJNA515078_P_NODE_2636_length_599_cov_1.790036_g2423_i0 | PRJNA515078 | 2636 | 599 | 1.790036 | 10.72231564 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 440 | 1.0799999999999999e-118 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g2423 | i0 | 80.132 | 93.5058430717863 | 604 | 108 | 99 | 10 | 1 | 598 | 2314 | 1717 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 56010 | 440 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22163586 | 22163586 | PRJNA515078_P_NODE_18438_length_202_cov_1.872727_g18205_i0 | PRJNA515078 | 18438 | 202 | 1.872727 | 3.78290854 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 285 | 1.59e-72 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g18205 | i0 | 92.157 | 26.9257425742574 | 204 | 12 | 100 | 4 | 1 | 202 | 664 | 865 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 5439 | 285 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 24713037 | 24713037 | PRJNA515078_P_NODE_8600_length_312_cov_1.410909_g8367_i0 | PRJNA515078 | 8600 | 312 | 1.410909 | 4.40203608 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470423488|ref|XM_004337555.1| | 1257118 | g8367 | i0 | 94.595 | 1.31410256410256 | 37 | 1 | 12 | 1 | 183 | 219 | 78 | 43 | Acanthamoeba castellanii str. Neff ribosomal protein L23, putative (ACA1_164710), partial mRNA | blastn | 410 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;