contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA606583" and tax_phylum = "Placozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3697741 | 3697741 | PRJNA606583_P_NODE_14423_length_337_cov_42.456667_g13995_i0 | PRJNA606583 | 14423 | 337 | 42.456667 | 143.07896779 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 617 | 2.4999999999999997e-172 | NTclustered | gi|56417895|gb|AY603697.1| | 10228 | g13995 | i0 | 99.704 | 23.0504451038576 | 338 | 0 | 100 | 1 | 1 | 337 | 322 | 659 | Trichoplax adhaerens 28S ribosomal RNA gene, partial sequence | blastn | 7768 | 619 | 0.996768982229402 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 4974546 | 4974546 | PRJNA606583_P_NODE_31664_length_186_cov_1.308725_g31235_i0 | PRJNA606583 | 31664 | 186 | 1.308725 | 2.4342285 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 344 | 2.34e-90 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g31235 | i0 | 100 | 67.1989247311828 | 186 | 0 | 100 | 0 | 1 | 186 | 27786 | 27601 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 12499 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 6961946 | 6961946 | PRJNA606583_P_NODE_39626_length_158_cov_1.280992_g39197_i0 | PRJNA606583 | 39626 | 158 | 1.280992 | 2.02396736 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 287 | 3.29e-73 | NTclustered | gi|33468433|emb|AJ549225.1| | 10228 | g39197 | i0 | 99.367 | 18.4177215189873 | 158 | 1 | 100 | 0 | 1 | 158 | 734 | 891 | Trichoplax adhaerens mRNA for elongation factor 1 alpha (ef1a gene) | blastn | 2910 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 7524351 | 7524351 | PRJNA606583_P_NODE_39786_length_157_cov_2.516667_g39357_i0 | PRJNA606583 | 39786 | 157 | 2.516667 | 3.95116719 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 291 | 2.52e-74 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g39357 | i0 | 100 | 66.9235668789809 | 157 | 0 | 100 | 0 | 1 | 157 | 31898 | 31742 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 10507 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 8236796 | 8236796 | PRJNA606583_P_NODE_5867_length_560_cov_2.258126_g5464_i0 | PRJNA606583 | 5867 | 560 | 2.258126 | 12.6455056 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 1035 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g5464 | i0 | 100 | 45.4767857142857 | 560 | 0 | 100 | 0 | 1 | 560 | 27028 | 27587 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 25467 | 1035 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 12625168 | 12625168 | PRJNA606583_P_NODE_12630_length_368_cov_28.577039_g12202_i0 | PRJNA606583 | 12630 | 368 | 28.577039 | 105.16350352 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 669 | 0 | NTclustered | gi|34495333|gb|AY303975.1| | 10228 | g12202 | i0 | 99.457 | 101.103260869565 | 368 | 2 | 100 | 0 | 1 | 368 | 1511 | 1878 | Trichoplax adhaerens 28S ribosomal RNA gene, partial sequence | blastn | 37206 | 675 | 0.991111111111111 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 13337810 | 13337810 | PRJNA606583_P_NODE_7911_length_481_cov_2.283784_g7491_i0 | PRJNA606583 | 7911 | 481 | 2.283784 | 10.98500104 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 819 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g7491 | i0 | 99.555 | 32.2494802494802 | 449 | 2 | 100 | 0 | 1 | 449 | 31089 | 31537 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 15512 | 819 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 13900439 | 13900439 | PRJNA606583_P_NODE_3611_length_690_cov_2.218989_g3264_i0 | PRJNA606583 | 3611 | 690 | 2.218989 | 15.3110241 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 675 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g3264 | i0 | 100 | 47.668115942029 | 365 | 0 | 100 | 0 | 1 | 365 | 27873 | 28237 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 32891 | 675 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 17724029 | 17724029 | PRJNA606583_P_NODE_10754_length_406_cov_1.371274_g10329_i0 | PRJNA606583 | 10754 | 406 | 1.371274 | 5.56737244 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 745 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g10329 | i0 | 99.754 | 9.95320197044335 | 406 | 1 | 100 | 0 | 1 | 406 | 31081 | 30676 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 4041 | 745 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 17724039 | 17724039 | PRJNA606583_P_NODE_11354_length_393_cov_2.974719_g10929_i0 | PRJNA606583 | 11354 | 393 | 2.974719 | 11.69064567 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 725 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g10929 | i0 | 100 | 9.1501272264631 | 392 | 0 | 99 | 0 | 1 | 392 | 30137 | 30528 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 3596 | 725 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 22260749 | 22260749 | PRJNA606583_P_NODE_36898_length_166_cov_1.162791_g36469_i0 | PRJNA606583 | 36898 | 166 | 1.162791 | 1.93023306 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 303 | 3.48e-78 | NTclustered | gi|196011480|ref|XM_002115568.1| | 10228 | g36469 | i0 | 100 | 0.987951807228916 | 164 | 0 | 99 | 0 | 3 | 166 | 359 | 196 | Trichoplax adhaerens expressed hypothetical protein (TRIADDRAFT_63128), mRNA | blastn | 164 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 22823625 | 22823625 | PRJNA606583_P_NODE_24098_length_230_cov_17.896373_g23669_i0 | PRJNA606583 | 24098 | 230 | 17.896373 | 41.1616579 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 425 | 1.05e-114 | NTclustered | gi|56417895|gb|AY603697.1| | 10228 | g23669 | i0 | 100 | 58.1695652173913 | 230 | 0 | 100 | 0 | 1 | 230 | 36 | 265 | Trichoplax adhaerens 28S ribosomal RNA gene, partial sequence | blastn | 13379 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 22823718 | 22823718 | PRJNA606583_P_NODE_30458_length_191_cov_1.954545_g30029_i0 | PRJNA606583 | 30458 | 191 | 1.954545 | 3.73318095 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 353 | 4.02e-93 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g30029 | i0 | 100 | 10.0104712041885 | 191 | 0 | 100 | 0 | 1 | 191 | 9145 | 8955 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 1912 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 24098493 | 24098493 | PRJNA606583_P_NODE_9159_length_445_cov_2.583333_g8736_i0 | PRJNA606583 | 9159 | 445 | 2.583333 | 11.49583185 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 815 | 0 | NTclustered | gi|1252414032|ref|NC_008151.3| | 10228 | g8736 | i0 | 99.775 | 3.75056179775281 | 445 | 0 | 100 | 1 | 1 | 445 | 26570 | 27013 | Trichoplax adhaerens isolate Grell Red Sea mitochondrion, complete genome | blastn | 1669 | 815 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens |
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);;