contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1489274 | 1489274 | PRJNA1111077_P_NODE_19802_length_287_cov_3.308411_g19581_i0 | PRJNA1111077 | 19802 | 287 | 3.308411 | 9.49513957 | Cochliopodium spiniferum | 313558 | Discosea | other_Eukaryota | 412 | 1.0599999999999996e-110 | NTclustered | gi|330902897|gb|JF298273.1| | 313558 | g19581 | i0 | 92.657 | 95.4216027874565 | 286 | 21 | 99 | 0 | 2 | 287 | 259 | 544 | Cochliopodium spiniferum clone 5102 actin gene, partial cds | blastn | 27386 | 412 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium spiniferum | |||
| 4041451 | 4041451 | PRJNA1111077_P_NODE_21124_length_283_cov_1.514286_g20903_i0 | PRJNA1111077 | 21124 | 283 | 1.514286 | 4.28542938 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 496 | 1e-135 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g20903 | i0 | 98.239 | 13.1095406360424 | 284 | 3 | 100 | 2 | 1 | 283 | 80 | 362 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 3710 | 496 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 7398995 | 7398995 | PRJNA1111077_P_NODE_4346_length_542_cov_1.321962_g4125_i0 | PRJNA1111077 | 4346 | 542 | 1.321962 | 7.16503404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 641 | 2.49e-179 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g4125 | i0 | 88.007 | 99.4059040590406 | 542 | 65 | 100 | 0 | 1 | 542 | 376 | 917 | Platyamoeba placida actin mRNA, partial cds | blastn | 53878 | 641 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 9142361 | 9142361 | PRJNA1111077_P_NODE_25948_length_266_cov_2.326425_g25727_i0 | PRJNA1111077 | 25948 | 266 | 2.326425 | 6.1882905 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 143 | 1.3999999999999996e-29 | NTclustered | gi|1160570380|ref|XM_020574684.1| | 670386 | g25727 | i0 | 76.604 | 0.996240601503759 | 265 | 58 | 99 | 4 | 1 | 263 | 205 | 467 | Polysphondylium pallidum PN500 vacuolar ATPase proteolipid subunit (vatP), partial mRNA | blastn | 265 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 10417962 | 10417962 | PRJNA1111077_P_NODE_17169_length_300_cov_1.911894_g16948_i0 | PRJNA1111077 | 17169 | 300 | 1.911894 | 5.735682 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 252 | 2.56e-62 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g16948 | i0 | 82.5 | 48.2233333333333 | 320 | 24 | 99 | 24 | 1 | 298 | 6953 | 6644 | Polyschismium peyerimhoffii 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 | 14467 | 252 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 11693190 | 11693190 | PRJNA1111077_P_NODE_18390_length_292_cov_5.013699_g18169_i0 | PRJNA1111077 | 18390 | 292 | 5.013699 | 14.64000108 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 375 | 1.4099999999999998e-99 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g18169 | i0 | 89.375 | 14.1917808219178 | 320 | 5 | 100 | 13 | 1 | 292 | 6142 | 6460 | Acanthamoeba castellanii 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 | 4144 | 375 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14243524 | 14243524 | PRJNA1111077_P_NODE_24492_length_272_cov_1.020101_g24271_i0 | PRJNA1111077 | 24492 | 272 | 1.020101 | 2.77467472 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 420 | 5.94e-113 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g24271 | i0 | 94.485 | 1.15441176470588 | 272 | 15 | 100 | 0 | 1 | 272 | 16 | 287 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 314 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20615750 | 20615750 | PRJNA1111077_P_NODE_20797_length_284_cov_1.706161_g20576_i0 | PRJNA1111077 | 20797 | 284 | 1.706161 | 4.84549724 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 440 | 4.789999999999998e-119 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g20576 | i0 | 94.257 | 1.04225352112676 | 296 | 4 | 100 | 4 | 1 | 284 | 5925 | 5631 | Acanthamoeba castellanii 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 | 296 | 440 | 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);;