contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA560029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8197137 | 8197137 | PRJNA560029_S_NODE_4427_length_451_cov_35.428571_g4203_i0 | PRJNA560029 | 4427 | 451 | 35.428571 | 159.78285521 | Iodamoeba sp. RL1 | 1089794 | Evosea | other_Eukaryota | 315 | 5.05e-81 | NTclustered | gi|347976700|gb|JN635745.1| | 1089794 | g4203 | i0 | 87.455 | 48.3259423503326 | 279 | 28 | 61 | 4 | 118 | 390 | 1752 | 1475 | Iodamoeba sp. RL1 isolate EM081 clone 6 small subunit ribosomal RNA gene, partial sequence | blastn | 21795 | 315 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Iodamoeba | Iodamoeba sp. RL1 | |||
| 10748424 | 10748424 | PRJNA560029_S_NODE_31569_length_252_cov_5.782123_g31345_i0 | PRJNA560029 | 31569 | 252 | 5.782123 | 14.57094996 | Endolimax carassius | 2949625 | Evosea | other_Eukaryota | 220 | 5.919999999999999e-53 | NTclustered | gi|2247024974|gb|ON646298.1| | 2949625 | g31345 | i0 | 82.772 | 27.25 | 267 | 27 | 99 | 10 | 4 | 252 | 1197 | 932 | Endolimax carassius isolate BCN_1 small subunit ribosomal RNA gene, partial sequence | blastn | 6867 | 220 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax carassius | |||
| 19670220 | 19670220 | PRJNA560029_S_NODE_15436_length_327_cov_11.078740_g15212_i0 | PRJNA560029 | 15436 | 327 | 11.07874 | 36.2274798 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 174 | 6.29e-39 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g15212 | i0 | 94.69 | 26.5290519877676 | 113 | 5 | 53 | 1 | 1 | 112 | 2232 | 2344 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 8675 | 174 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium |
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);;