contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6304121 | 6304121 | PRJNA751877_P_NODE_15625_length_293_cov_1.018182_g15503_i0 | PRJNA751877 | 15625 | 293 | 1.018182 | 2.98327326 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 542 | 1.32e-149 | NTclustered | gi|2979652|gb|AF019052.1|AF019052 | 5757 | g15503 | i0 | 100 | 100.662116040956 | 293 | 0 | 100 | 0 | 1 | 293 | 719 | 1011 | Acanthamoeba polyphaga Panola Mountain 18S ribosomal RNA gene, partial sequence | blastn | 29494 | 542 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba polyphaga | |||
| 8379466 | 8379466 | PRJNA751877_P_NODE_13227_length_314_cov_1.917012_g13105_i0 | PRJNA751877 | 13227 | 314 | 1.917012 | 6.01941768 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 215 | 3.54e-51 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g13105 | i0 | 84.545 | 30.4745222929936 | 220 | 30 | 69 | 4 | 1 | 218 | 85 | 302 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 9569 | 215 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13480429 | 13480429 | PRJNA751877_P_NODE_6371_length_402_cov_1.401216_g6249_i0 | PRJNA751877 | 6371 | 402 | 1.401216 | 5.63288832 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 551 | 3.119999999999999e-152 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g6249 | i0 | 92.138 | 15.547263681592 | 407 | 7 | 97 | 15 | 1 | 388 | 5911 | 5511 | 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 | 6250 | 551 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14755435 | 14755435 | PRJNA751877_P_NODE_5272_length_428_cov_1.042254_g5150_i0 | PRJNA751877 | 5272 | 428 | 1.042254 | 4.46084712 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 259 | 2.27e-64 | NTclustered | gi|330818907|ref|XM_003291484.1| | 5786 | g5150 | i0 | 78.436 | 7.49766355140187 | 422 | 73 | 96 | 14 | 14 | 426 | 508 | 96 | Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA | blastn | 3209 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 17304204 | 17304204 | PRJNA751877_P_NODE_1134_length_712_cov_1.136150_g1017_i0 | PRJNA751877 | 1134 | 712 | 1.13615 | 8.089388 | Acramoeba dendroida | 633159 | Evosea | other_Eukaryota | 494 | 9.84e-135 | NTclustered | gi|146448853|gb|EF513194.1| | 633159 | g1017 | i0 | 79.383 | 79.6039325842697 | 713 | 137 | 99 | 9 | 5 | 712 | 711 | 4 | Acramoeba dendroida elongation factor 1A (EF1A) gene, partial cds | blastn | 56678 | 494 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Acramoebidae | Acramoeba | Acramoeba dendroida | ||
| 22877690 | 22877690 | PRJNA751877_P_NODE_19098_length_271_cov_1.166667_g18976_i0 | PRJNA751877 | 19098 | 271 | 1.166667 | 3.16166757 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 501 | 2.05e-137 | NTclustered | gi|2756360496|gb|PQ002562.1| | 5756 | g18976 | i0 | 100 | 99.9446494464945 | 271 | 0 | 100 | 0 | 1 | 271 | 606 | 876 | Acanthamoeba sp. isolate PHAS18-2 small subunit ribosomal RNA gene, partial sequence | blastn | 27085 | 501 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. |
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);;