contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA229468" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4884540 | 4884540 | PRJNA229468_S_NODE_144_length_403_cov_3.576271_g131_i0 | PRJNA229468 | 144 | 403 | 3.576271 | 14.41237213 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 499 | 1.15e-136 | NTclustered | gi|330841829|ref|XM_003292845.1| | 5786 | g131 | i0 | 89.421 | 97.8957816377171 | 397 | 40 | 98 | 2 | 8 | 403 | 550 | 945 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA | blastn | 39452 | 499 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 9295359 | 9295359 | PRJNA229468_S_NODE_248_length_316_cov_1.681648_g235_i0 | PRJNA229468 | 248 | 316 | 1.681648 | 5.31400768 | Ripella sp. | 1973050 | Discosea | other_Eukaryota | 477 | 4.119999999999998e-130 | NTclustered | gi|2666517889|gb|PP259000.1| | 1973050 | g235 | i0 | 96.552 | 88.2088607594937 | 290 | 6 | 91 | 4 | 1 | 289 | 994 | 708 | Ripella sp. strain CHIESE83/2 small subunit ribosomal RNA gene, partial sequence | blastn | 27874 | 477 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. | |||
| 13809991 | 13809991 | PRJNA229468_S_NODE_1111_length_165_cov_2.965517_g1098_i0 | PRJNA229468 | 1111 | 165 | 2.965517 | 4.89310305 | Ripella | 1217112 | Discosea | other_Eukaryota | 263 | 5.86e-66 | NTclustered | gi|1269228383|gb|MF683508.1| | 2047821 | g1098 | i0 | 99.315 | 84.3878787878788 | 146 | 0 | 88 | 1 | 20 | 165 | 209 | 353 | Ripella platypodia clone 26.10.47 18S ribosomal RNA gene, partial sequence | blastn | 13924 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 14396337 | 14396337 | PRJNA229468_S_NODE_412_length_244_cov_2.041026_g399_i0 | PRJNA229468 | 412 | 244 | 2.041026 | 4.98010344 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 254 | 5.62e-63 | NTclustered | gi|2306687673|gb|MZ234286.1| | 1115720 | g399 | i0 | 85.597 | 73.0409836065574 | 243 | 33 | 99 | 2 | 3 | 244 | 161 | 402 | Lamproderma scintillans voucher LE297459 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 17822 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 15670096 | 15670096 | PRJNA229468_S_NODE_953_length_173_cov_2.733871_g940_i0 | PRJNA229468 | 953 | 173 | 2.733871 | 4.72959683 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 303 | 3.63e-78 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g940 | i0 | 98.266 | 97.4624277456647 | 173 | 3 | 100 | 0 | 1 | 173 | 188 | 16 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 16861 | 303 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 24008528 | 24008528 | PRJNA229468_S_NODE_779_length_187_cov_2.615942_g766_i0 | PRJNA229468 | 779 | 187 | 2.615942 | 4.89181154 | Vannella | 95228 | Discosea | other_Eukaryota | 318 | 1.43e-82 | NTclustered | gi|399764213|gb|JQ271724.1| | 1215628 | g766 | i0 | 97.326 | 81.4010695187166 | 187 | 5 | 100 | 0 | 1 | 187 | 163 | 349 | Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence | blastn | 15222 | 318 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ACN1 |
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);;