contig_metadata
14 rows where bioproject = "PRJNA675042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 646015 | 646015 | PRJNA675042_P_NODE_134601_length_247_cov_0.885057_g134151_i0 | PRJNA675042 | 134601 | 247 | 0.885057 | 2.18609079 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470243907|ref|XM_004355633.1| | 261658 | g134151 | i0 | 100 | 0.477732793522267 | 30 | 0 | 12 | 0 | 43 | 72 | 38 | 9 | Cavenderia fasciculata uncharacterized protein (DFA_08189), partial mRNA | blastn | 118 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 3197934 | 3197934 | PRJNA675042_P_NODE_42483_length_338_cov_9.064151_g42033_i0 | PRJNA675042 | 42483 | 338 | 9.064151 | 30.63683038 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 494 | 4.41e-135 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g42033 | i0 | 96.939 | 42.2988165680473 | 294 | 9 | 87 | 0 | 9 | 302 | 1149 | 856 | Vannella septentrionalis 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 | 14297 | 494 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 3198305 | 3198305 | PRJNA675042_P_NODE_74023_length_288_cov_1.074419_g73573_i0 | PRJNA675042 | 74023 | 288 | 1.074419 | 3.09432672 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.4 | 5.73e-4 | NTclustered | gi|470248899|ref|XM_004357936.1| | 261658 | g73573 | i0 | 97.059 | 0.930555555555556 | 34 | 1 | 12 | 0 | 170 | 203 | 302 | 269 | Cavenderia fasciculata uncharacterized protein (DFA_00277), partial mRNA | blastn | 268 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 8300853 | 8300853 | PRJNA675042_P_NODE_85667_length_274_cov_1.149254_g85217_i0 | PRJNA675042 | 85667 | 274 | 1.149254 | 3.14895596 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|831756689|ref|XM_012893346.1| | 1410327 | g85217 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 16 | 43 | 352 | 325 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10097165 | 10097165 | PRJNA675042_P_NODE_96508_length_262_cov_0.915344_g96058_i0 | PRJNA675042 | 96508 | 262 | 0.915344 | 2.39820128 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1237201|emb|X96869.1| | 44689 | g96058 | i0 | 100 | 0.221374045801527 | 29 | 0 | 11 | 0 | 163 | 191 | 1606 | 1634 | D.discoideum dokA gene | blastn | 58 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13399842 | 13399842 | PRJNA675042_P_NODE_107111_length_251_cov_0.865169_g106661_i0 | PRJNA675042 | 107111 | 251 | 0.865169 | 2.17157419 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 60.2 | 1.36e-4 | NTclustered | gi|1160567028|ref|XM_020581139.1| | 670386 | g106661 | i0 | 94.737 | 0.151394422310757 | 38 | 2 | 15 | 0 | 88 | 125 | 1456 | 1419 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 38 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 14675768 | 14675768 | PRJNA675042_P_NODE_21792_length_404_cov_1.395770_g21342_i0 | PRJNA675042 | 21792 | 404 | 1.39577 | 5.6389108 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.039 | NTclustered | gi|66807290|ref|XM_632276.1| | 352472 | g21342 | i0 | 100 | 0.0693069306930693 | 28 | 0 | 7 | 0 | 255 | 282 | 2690 | 2663 | Dictyostelium discoideum AX4 DUF1683 family protein (DDB_G0287157) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 15948835 | 15948835 | PRJNA675042_P_NODE_137133_length_247_cov_0.885057_g136683_i0 | PRJNA675042 | 137133 | 247 | 0.885057 | 2.18609079 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1160557316|ref|XM_020575491.1| | 670386 | g136683 | i0 | 96.97 | 0.133603238866397 | 33 | 1 | 13 | 0 | 95 | 127 | 150 | 182 | Polysphondylium pallidum PN500 threonine ammonia-lyase partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 17225173 | 17225173 | PRJNA675042_P_NODE_5214_length_620_cov_2.623400_g4783_i0 | PRJNA675042 | 5214 | 620 | 2.6234 | 16.26508 | Acanthamoeba comandoni | 65659 | Discosea | other_Eukaryota | 124 | 1.2799999999999999e-23 | NTclustered | gi|28194600|gb|AF479544.1| | 65659 | g4783 | i0 | 76.23 | 11.75 | 244 | 53 | 39 | 4 | 155 | 396 | 687 | 927 | Acanthamoeba comandoni strain ATCC 30135 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 7285 | 124 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba comandoni | |||
| 19772767 | 19772767 | PRJNA675042_P_NODE_114776_length_250_cov_0.870056_g114326_i0 | PRJNA675042 | 114776 | 250 | 0.870056 | 2.17514 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|66799980|ref|XM_628914.1| | 352472 | g114326 | i0 | 96.774 | 0.124 | 31 | 1 | 12 | 0 | 49 | 79 | 462 | 432 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0293866) mRNA, complete cds | blastn | 31 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19774233 | 19774233 | PRJNA675042_P_NODE_70936_length_292_cov_1.054795_g70486_i0 | PRJNA675042 | 70936 | 292 | 1.054795 | 3.0800014 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|66805112|ref|XM_631197.1| | 352472 | g70486 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 11 | 38 | 6369 | 6396 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0289385) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19774259 | 19774259 | PRJNA675042_P_NODE_74096_length_288_cov_1.074419_g73646_i0 | PRJNA675042 | 74096 | 288 | 1.074419 | 3.09432672 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|831765947|ref|XM_012896185.1| | 1410327 | g73646 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 130 | 157 | 806 | 779 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 22323349 | 22323349 | PRJNA675042_P_NODE_124798_length_249_cov_0.875000_g124348_i0 | PRJNA675042 | 124798 | 249 | 0.875 | 2.17875 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1160563486|ref|XM_020579958.1| | 670386 | g124348 | i0 | 100 | 0.686746987951807 | 30 | 0 | 12 | 0 | 204 | 233 | 184 | 155 | Polysphondylium pallidum PN500 cyclin-like F-box containing protein partial mRNA | blastn | 171 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23599056 | 23599056 | PRJNA675042_P_NODE_148379_length_245_cov_0.895349_g147929_i0 | PRJNA675042 | 148379 | 245 | 0.895349 | 2.19360505 | Thecamoeba quadrilineata | 343530 | Discosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2386968834|ref|NC_068853.1| | 343530 | g147929 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 93 | 120 | 17255 | 17228 | Thecamoeba quadrilineata mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba quadrilineata |
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);;