contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1249133 | 1249133 | PRJNA908278_P_NODE_7401_length_434_cov_3.822715_g7298_i0 | PRJNA908278 | 7401 | 434 | 3.822715 | 16.5905831 | Ripella | 1217112 | Discosea | other_Eukaryota | 682 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g7298 | i0 | 95.392 | 100.709677419355 | 434 | 10 | 100 | 4 | 1 | 434 | 617 | 1040 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 43708 | 688 | 0.991279069767442 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 4718638 | 4718638 | PRJNA908278_P_NODE_10864_length_370_cov_1.296296_g10761_i0 | PRJNA908278 | 10864 | 370 | 1.296296 | 4.7962952 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 60.2 | 2.1e-4 | NTclustered | gi|470421359|ref|XM_004337333.1| | 1257118 | g10761 | i0 | 100 | 0.856756756756757 | 32 | 0 | 9 | 0 | 251 | 282 | 98 | 67 | Acanthamoeba castellanii str. Neff ENTH domain containing protein (ACA1_275420), partial mRNA | blastn | 317 | 60.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11094080 | 11094080 | PRJNA908278_P_NODE_8769_length_404_cov_1.474320_g8666_i0 | PRJNA908278 | 8769 | 404 | 1.47432 | 5.9562528 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 309 | 2.08e-79 | NTclustered | gi|470504494|ref|XM_004348424.1| | 1257118 | g8666 | i0 | 82.402 | 44.4158415841584 | 358 | 59 | 88 | 3 | 48 | 403 | 1 | 356 | Acanthamoeba castellanii str. Neff Ras family protein (ACA1_157480), partial mRNA | blastn | 17944 | 309 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14918264 | 14918264 | PRJNA908278_P_NODE_23052_length_270_cov_1.563452_g22949_i0 | PRJNA908278 | 23052 | 270 | 1.563452 | 4.2213204 | Vannella sp. GERL14 | 1002217 | Discosea | other_Eukaryota | 392 | 1.28e-104 | NTclustered | gi|327391632|gb|HM363630.1| | 1002217 | g22949 | i0 | 92.754 | 98.9592592592593 | 276 | 12 | 100 | 3 | 1 | 270 | 285 | 12 | Vannella sp. GERL14 small subunit ribosomal RNA gene, partial sequence | blastn | 26719 | 392 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERL14 | |||
| 15277032 | 15277032 | PRJNA908278_P_NODE_4352_length_552_cov_2.774530_g4249_i0 | PRJNA908278 | 4352 | 552 | 2.77453 | 15.3154056 | Ripella | 1217112 | Discosea | other_Eukaryota | 815 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g4249 | i0 | 93.784 | 99.1938405797101 | 547 | 26 | 99 | 8 | 8 | 552 | 1 | 541 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54755 | 815 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 19100532 | 19100532 | PRJNA908278_P_NODE_2255_length_743_cov_4.526866_g2157_i0 | PRJNA908278 | 2255 | 743 | 4.526866 | 33.63461438 | Vannella | 95228 | Discosea | other_Eukaryota | 1186 | 0 | NTclustered | gi|861554667|gb|KP719197.1| | 197532 | g2157 | i0 | 95.296 | 74.9892328398385 | 744 | 34 | 100 | 1 | 1 | 743 | 1303 | 560 | Vannella simplex strain A17WVB small subunit ribosomal RNA gene, partial sequence | blastn | 55717 | 1186 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 22567525 | 22567525 | PRJNA908278_P_NODE_5298_length_505_cov_3.831019_g5195_i0 | PRJNA908278 | 5298 | 505 | 3.831019 | 19.34664595 | Vannella simplex | 197532 | Discosea | other_Eukaryota | 852 | 0 | NTclustered | gi|284192604|gb|GQ265402.1| | 197532 | g5195 | i0 | 97.228 | 97.3128712871287 | 505 | 10 | 100 | 2 | 1 | 505 | 799 | 299 | Vannella simplex strain Ladoga Cl 12/2 clone A144.5 18S ribosomal RNA gene, partial sequence | blastn | 49143 | 852 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 25475708 | 25475708 | PRJNA908278_P_NODE_5500_length_498_cov_1.065882_g5397_i0 | PRJNA908278 | 5500 | 498 | 1.065882 | 5.30809236 | Vannellidae | 95227 | Discosea | other_Eukaryota | 750 | 0 | NTclustered | gi|62865946|gb|AY929921.1| | 325071 | g5397 | i0 | 93.849 | 100.253012048193 | 504 | 21 | 100 | 9 | 1 | 498 | 1175 | 1674 | Platyamoeba sp. strain SUM1S/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 49926 | 750 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain SUM1S/I |
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);;