contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2571112 | 2571112 | PRJEB14664_P_NODE_3183_length_505_cov_2.889362_g3061_i0 | PRJEB14664 | 3183 | 505 | 2.889362 | 14.5912781 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 658 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g3061 | i0 | 90.4 | 99.0594059405941 | 500 | 48 | 99 | 0 | 3 | 502 | 581 | 1080 | Platyamoeba placida actin mRNA, partial cds | blastn | 50025 | 658 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 11189094 | 11189094 | PRJEB14664_P_NODE_16849_length_169_cov_1.425373_g16719_i0 | PRJEB14664 | 16849 | 169 | 1.425373 | 2.40888037 | Vannella | 95228 | Discosea | other_Eukaryota | 313 | 5.859999999999999e-81 | NTclustered | gi|62865934|gb|AY929909.1| | 325075 | g16719 | i0 | 100 | 100.781065088757 | 169 | 0 | 100 | 0 | 1 | 169 | 851 | 1019 | Vannella sp. strain 4362V/II 18S small subunit ribosomal RNA gene, partial sequence | blastn | 17032 | 313 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4362V/II | |||
| 11499179 | 11499179 | PRJEB14664_P_NODE_12030_length_212_cov_1.830508_g11900_i0 | PRJEB14664 | 12030 | 212 | 1.830508 | 3.88067696 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 281 | 2.18e-71 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g11900 | i0 | 90.61 | 99.3066037735849 | 213 | 19 | 100 | 1 | 1 | 212 | 919 | 707 | Platyamoeba placida actin mRNA, partial cds | blastn | 21053 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 17872881 | 17872881 | PRJEB14664_P_NODE_5275_length_367_cov_20.689759_g5145_i0 | PRJEB14664 | 5275 | 367 | 20.689759 | 75.93141553 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 204 | 9.09e-48 | NTclustered | gi|470521486|ref|XM_004353672.1| | 1257118 | g5145 | i0 | 82.479 | 64.16621253406 | 234 | 39 | 63 | 2 | 99 | 331 | 99 | 331 | Acanthamoeba castellanii str. Neff Histone H4, putative (ACA1_376700), partial mRNA | blastn | 23549 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;