contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6391695 | 6391695 | PRJEB10320_P_NODE_25726_length_160_cov_2.248000_g25468_i0 | PRJEB10320 | 25726 | 160 | 2.248 | 3.5968 | Cochliopodium arabianum | 1676989 | Discosea | other_Eukaryota | 291 | 2.5799999999999998e-74 | NTclustered | gi|861685103|gb|KP244685.1| | 1676989 | g25468 | i0 | 99.375 | 79.14375 | 160 | 1 | 100 | 0 | 1 | 160 | 660 | 819 | Cochliopodium arabianum voucher YT360_361 18S ribosomal RNA gene, partial sequence | blastn | 12663 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium arabianum | |||
| 7360160 | 7360160 | PRJEB10320_P_NODE_406_length_1438_cov_13.662153_g317_i0 | PRJEB10320 | 406 | 1438 | 13.662153 | 196.46176014 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 270 | 3.74e-67 | NTclustered | gi|28194618|gb|AF479562.1| | 29195 | g317 | i0 | 72.653 | 23.4297635605007 | 980 | 208 | 66 | 45 | 146 | 1088 | 1389 | 433 | Acanthamoeba griffini strain S7 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 33692 | 270 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba griffini | |||
| 8940521 | 8940521 | PRJEB10320_P_NODE_25728_length_160_cov_2.240000_g25470_i0 | PRJEB10320 | 25728 | 160 | 2.24 | 3.584 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 291 | 2.5799999999999998e-74 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g25470 | i0 | 99.375 | 11.3125 | 160 | 1 | 100 | 0 | 1 | 160 | 13 | 172 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 1810 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 17865320 | 17865320 | PRJEB10320_P_NODE_25035_length_164_cov_1.062016_g24777_i0 | PRJEB10320 | 25035 | 164 | 1.062016 | 1.74170624 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 281 | 1.6000000000000001e-71 | NTclustered | gi|659103845|gb|KJ569729.1| | 1512276 | g24777 | i0 | 97.561 | 54.9085365853659 | 164 | 4 | 100 | 0 | 1 | 164 | 399 | 562 | Cochliopodium kieliense isolate 2 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 9005 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 21690200 | 21690200 | PRJEB10320_P_NODE_7638_length_368_cov_2.834835_g7382_i0 | PRJEB10320 | 7638 | 368 | 2.834835 | 10.4321928 | Cochliopodium arabianum | 1676989 | Discosea | other_Eukaryota | 580 | 3.609999999999999e-161 | NTclustered | gi|861685103|gb|KP244685.1| | 1676989 | g7382 | i0 | 95.664 | 36.7635869565217 | 369 | 2 | 100 | 6 | 1 | 368 | 497 | 142 | Cochliopodium arabianum voucher YT360_361 18S ribosomal RNA gene, partial sequence | blastn | 13529 | 580 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium arabianum |
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);;