contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2610081 | 2610081 | PRJEB43370_P_NODE_10283_length_163_cov_0.912281_g10240_i0 | PRJEB43370 | 10283 | 163 | 0.912281 | 1.48701803 | Vannella sp. strain W181G/I | 325084 | Discosea | other_Eukaryota | 84.2 | 4.82e-12 | NTclustered | gi|62865938|gb|AY929913.1| | 325084 | g10240 | i0 | 93.103 | 29.9570552147239 | 58 | 3 | 36 | 1 | 106 | 163 | 1357 | 1301 | Vannella sp. strain W181G/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 4883 | 84.2 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain W181G/I | |||
| 2610133 | 2610133 | PRJEB43370_P_NODE_4843_length_205_cov_1.115385_g4800_i0 | PRJEB43370 | 4843 | 205 | 1.115385 | 2.28653925 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 379 | 7.229999999999999e-101 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g4800 | i0 | 100 | 100.019512195122 | 205 | 0 | 100 | 0 | 1 | 205 | 566 | 770 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 20504 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 2610135 | 2610135 | PRJEB43370_P_NODE_4963_length_203_cov_1.012987_g4920_i0 | PRJEB43370 | 4963 | 203 | 1.012987 | 2.05636361 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 126 | 1.03e-24 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g4920 | i0 | 87.273 | 0.541871921182266 | 110 | 14 | 54 | 0 | 78 | 187 | 122 | 13 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 110 | 126 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12469016 | 12469016 | PRJEB43370_P_NODE_890_length_461_cov_3.279126_g847_i0 | PRJEB43370 | 890 | 461 | 3.279126 | 15.11677086 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 542 | 2.18e-149 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g847 | i0 | 87.852 | 97.529284164859 | 461 | 56 | 100 | 0 | 1 | 461 | 1053 | 593 | Platyamoeba placida actin mRNA, partial cds | blastn | 44961 | 542 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 24286002 | 24286002 | PRJEB43370_P_NODE_340_length_713_cov_5.141566_g301_i0 | PRJEB43370 | 340 | 713 | 5.141566 | 36.65936558 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 880 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g301 | i0 | 91.331 | 96.6521739130435 | 646 | 52 | 90 | 3 | 2 | 645 | 539 | 1182 | Platyamoeba placida actin mRNA, partial cds | blastn | 68913 | 880 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 24286037 | 24286037 | PRJEB43370_P_NODE_6900_length_174_cov_2.704000_g6857_i0 | PRJEB43370 | 6900 | 174 | 2.704 | 4.70496 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 219 | 1.3599999999999996e-52 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g6857 | i0 | 91.72 | 77.7528735632184 | 157 | 13 | 90 | 0 | 16 | 172 | 39 | 195 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 13529 | 219 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 |
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);;