contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA431371" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1702973 | 1702973 | PRJNA431371_P_NODE_18282_length_300_cov_0.995595_g18209_i0 | PRJNA431371 | 18282 | 300 | 0.995595 | 2.986785 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|470525710|ref|XM_004356591.1| | 1257118 | g18209 | i0 | 90.244 | 0.136666666666667 | 41 | 2 | 13 | 2 | 223 | 261 | 3262 | 3222 | Acanthamoeba castellanii str. Neff Ankyrin repeatcontaining protein (ACA1_174020), partial mRNA | blastn | 41 | 52.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1703328 | 1703328 | PRJNA431371_P_NODE_3602_length_604_cov_1.775895_g3529_i0 | PRJNA431371 | 3602 | 604 | 1.775895 | 10.7264058 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 634 | 4.669999999999999e-177 | NTclustered | gi|470385745|ref|XM_004334098.1| | 1257118 | g3529 | i0 | 85.596 | 97.3692052980132 | 604 | 87 | 100 | 0 | 1 | 604 | 2261 | 1658 | Acanthamoeba castellanii str. Neff helicase conserved Cterminal domain containing protein (ACA1_140170), partial mRNA | blastn | 58811 | 634 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6806314 | 6806314 | PRJNA431371_P_NODE_8946_length_415_cov_2.207602_g8873_i0 | PRJNA431371 | 8946 | 415 | 2.207602 | 9.1615483 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 494 | 5.52e-135 | NTclustered | gi|167859711|gb|EU273435.1| | 1346289 | g8873 | i0 | 88.509 | 97.4650602409639 | 409 | 45 | 98 | 2 | 8 | 415 | 791 | 384 | Telaepolella tubasferens clone 1 actin gene, partial cds | blastn | 40448 | 494 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 9356168 | 9356168 | PRJNA431371_P_NODE_14148_length_338_cov_1.743396_g14075_i0 | PRJNA431371 | 14148 | 338 | 1.743396 | 5.89267848 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 268 | 2.9099999999999994e-67 | NTclustered | gi|1160570376|ref|XM_020574682.1| | 670386 | g14075 | i0 | 82.637 | 84.8520710059172 | 311 | 47 | 91 | 5 | 1 | 306 | 425 | 117 | Polysphondylium pallidum PN500 histone H3 partial mRNA | blastn | 28680 | 268 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 9356189 | 9356189 | PRJNA431371_P_NODE_148_length_1686_cov_16.721017_g117_i0 | PRJNA431371 | 148 | 1686 | 16.721017 | 281.91634662 | Balamuthia mandrillaris | 66527 | Discosea | other_Eukaryota | 145 | 2.78e-29 | NTclustered | gi|2241228763|gb|OM994889.1| | 66527 | g117 | i0 | 78.059 | 6.49525504151839 | 237 | 47 | 14 | 5 | 20 | 255 | 36754 | 36522 | Balamuthia mandrillaris strain KM-20 mitochondrion, complete genome | blastn | 10951 | 145 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Balamuthiidae | Balamuthia | Balamuthia mandrillaris | |||
| 11291158 | 11291158 | PRJNA431371_P_NODE_16869_length_312_cov_2.707113_g16796_i0 | PRJNA431371 | 16869 | 312 | 2.707113 | 8.44619256 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 6.27e-4 | NTclustered | gi|330791506|ref|XM_003283786.1| | 5786 | g16796 | i0 | 92.5 | 1.58653846153846 | 40 | 3 | 13 | 0 | 31 | 70 | 6327 | 6288 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA | blastn | 495 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11906899 | 11906899 | PRJNA431371_P_NODE_20670_length_281_cov_1.110577_g20597_i0 | PRJNA431371 | 20670 | 281 | 1.110577 | 3.12072137 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|470439653|ref|XM_004339166.1| | 1257118 | g20597 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 1 | 28 | 909 | 882 | Acanthamoeba castellanii str. Neff leucine rich repeat domain containing protein (ACA1_058570), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 15730909 | 15730909 | PRJNA431371_P_NODE_27853_length_248_cov_2.965714_g27780_i0 | PRJNA431371 | 27853 | 248 | 2.965714 | 7.35497072 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 87.9 | 6.15e-13 | NTclustered | gi|470236159|ref|XM_004349983.1| | 261658 | g27780 | i0 | 91.935 | 0.25 | 62 | 5 | 25 | 0 | 1 | 62 | 62 | 1 | Cavenderia fasciculata uncharacterized protein (DFA_11090), partial mRNA | blastn | 62 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 17005277 | 17005277 | PRJNA431371_P_NODE_14094_length_339_cov_1.157895_g14021_i0 | PRJNA431371 | 14094 | 339 | 1.157895 | 3.92526405 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 119 | 3.11e-22 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g14021 | i0 | 77.13 | 1.48672566371681 | 223 | 40 | 64 | 8 | 98 | 315 | 32113 | 31897 | Paravannella minima mitochondrion, complete genome | blastn | 504 | 119 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 18279482 | 18279482 | PRJNA431371_P_NODE_10975_length_378_cov_1.514754_g10902_i0 | PRJNA431371 | 10975 | 378 | 1.514754 | 5.72577012 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 182 | 4.4e-41 | NTclustered | gi|470530395|ref|XM_004368186.1| | 1257118 | g10902 | i0 | 79.389 | 0.992063492063492 | 262 | 50 | 69 | 4 | 47 | 306 | 456 | 197 | Acanthamoeba castellanii str. Neff ureidopropionase, beta, putative (ACA1_295740), partial mRNA | blastn | 375 | 182 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20829857 | 20829857 | PRJNA431371_P_NODE_22937_length_264_cov_1.612565_g22864_i0 | PRJNA431371 | 22937 | 264 | 1.612565 | 4.2571716 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 233 | 8.02e-57 | NTclustered | gi|330842539|ref|XM_003293186.1| | 5786 | g22864 | i0 | 82.707 | 53.9015151515151 | 266 | 42 | 100 | 4 | 1 | 264 | 182 | 445 | Dictyostelium purpureum calmodulin (DICPUDRAFT_93011), mRNA | blastn | 14230 | 233 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23380438 | 23380438 | PRJNA431371_P_NODE_2799_length_662_cov_1.359932_g2726_i0 | PRJNA431371 | 2799 | 662 | 1.359932 | 9.00274984 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 966 | 0 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g2726 | i0 | 93.373 | 58.0181268882175 | 664 | 27 | 98 | 11 | 16 | 662 | 1373 | 2036 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 38408 | 966 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense |
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);;