contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9371717 | 9371717 | PRJNA473201_P_NODE_47168_length_298_cov_1.928889_g46426_i0 | PRJNA473201 | 47168 | 298 | 1.928889 | 5.74808922 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 263 | 1.18e-65 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g46426 | i0 | 82.828 | 20.6543624161074 | 297 | 47 | 99 | 4 | 4 | 298 | 1808 | 2102 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 6155 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9372127 | 9372127 | PRJNA473201_P_NODE_68908_length_250_cov_0.870056_g68166_i0 | PRJNA473201 | 68908 | 250 | 0.870056 | 2.17514 | Stenamoeba amazonica | 746910 | Discosea | other_Eukaryota | 422 | 1.4999999999999998e-113 | NTclustered | gi|292399456|gb|GU810184.1| | 746910 | g68166 | i0 | 97.211 | 45.756 | 251 | 3 | 100 | 4 | 1 | 250 | 1151 | 904 | Stenamoeba amazonica strain P119 small subunit ribosomal RNA gene, partial sequence | blastn | 11439 | 422 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba amazonica | |||
| 10647158 | 10647158 | PRJNA473201_P_NODE_13349_length_548_cov_12.058947_g12610_i0 | PRJNA473201 | 13349 | 548 | 12.058947 | 66.08302956 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 835 | 0 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g12610 | i0 | 94.364 | 100.64598540146 | 550 | 21 | 100 | 6 | 1 | 548 | 1045 | 504 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 55154 | 835 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 17020738 | 17020738 | PRJNA473201_P_NODE_17014_length_482_cov_5.041565_g16272_i0 | PRJNA473201 | 17014 | 482 | 5.041565 | 24.3003433 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 743 | 0 | NTclustered | gi|1269228431|gb|MF683556.1| | 2047822 | g16272 | i0 | 94.433 | 101.016597510373 | 485 | 23 | 100 | 3 | 1 | 482 | 1159 | 1642 | Ripella decalvata clone 26.2.11 18S ribosomal RNA gene, partial sequence | blastn | 48690 | 743 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 17021628 | 17021628 | PRJNA473201_P_NODE_65954_length_251_cov_0.865169_g65212_i0 | PRJNA473201 | 65954 | 251 | 0.865169 | 2.17157419 | Vannella ebro | 207334 | Discosea | other_Eukaryota | 320 | 5.65e-83 | NTclustered | gi|33946344|gb|AY294151.1| | 207334 | g65212 | i0 | 89.641 | 91.3266932270916 | 251 | 26 | 100 | 0 | 1 | 251 | 870 | 1120 | Vannella ebro actin mRNA, complete cds | blastn | 22923 | 320 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro | |||
| 18295137 | 18295137 | PRJNA473201_P_NODE_23955_length_402_cov_3.501520_g23213_i0 | PRJNA473201 | 23955 | 402 | 3.50152 | 14.0761104 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 196 | 1.68e-45 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g23213 | i0 | 80 | 41.6268656716418 | 270 | 50 | 67 | 3 | 135 | 402 | 544 | 277 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 16734 | 196 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18296237 | 18296237 | PRJNA473201_P_NODE_81815_length_243_cov_0.905882_g81073_i0 | PRJNA473201 | 81815 | 243 | 0.905882 | 2.20129326 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 311 | 3.27e-80 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g81073 | i0 | 90 | 97.3497942386831 | 240 | 24 | 99 | 0 | 1 | 240 | 92 | 331 | Platyamoeba placida actin mRNA, partial cds | blastn | 23656 | 311 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 20845697 | 20845697 | PRJNA473201_P_NODE_54817_length_280_cov_1.149758_g54075_i0 | PRJNA473201 | 54817 | 280 | 1.149758 | 3.2193224 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 189 | 1.88e-43 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g54075 | i0 | 80.4 | 4.30714285714286 | 250 | 47 | 89 | 2 | 31 | 279 | 540 | 292 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 1206 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22121190 | 22121190 | PRJNA473201_P_NODE_84818_length_241_cov_0.916667_g84076_i0 | PRJNA473201 | 84818 | 241 | 0.916667 | 2.20916747 | Dermamoeba algensis | 242549 | Discosea | other_Eukaryota | 169 | 2.0599999999999997e-37 | NTclustered | gi|33946341|gb|AY294148.1| | 242549 | g84076 | i0 | 91.736 | 49.3983402489627 | 121 | 10 | 50 | 0 | 1 | 121 | 1166 | 1046 | Dermamoeba algensis small subunit ribosomal RNA gene, partial sequence | blastn | 11905 | 169 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Dermamoeba | Dermamoeba algensis | ||||
| 23395510 | 23395510 | PRJNA473201_P_NODE_14099_length_532_cov_17.298475_g13358_i0 | PRJNA473201 | 14099 | 532 | 17.298475 | 92.027887 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 843 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g13358 | i0 | 95.345 | 101.402255639098 | 537 | 14 | 100 | 8 | 1 | 532 | 14 | 544 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 53946 | 843 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 |
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);;