contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA698538" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3232469 | 3232469 | PRJNA698538_S_NODE_29583_length_242_cov_1.958580_g29417_i0 | PRJNA698538 | 29583 | 242 | 1.95858 | 4.7397636 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 372 | 1.47e-98 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g29417 | i0 | 94.672 | 68.7644628099174 | 244 | 6 | 98 | 6 | 1 | 238 | 959 | 717 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 16641 | 372 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 3232473 | 3232473 | PRJNA698538_S_NODE_29863_length_241_cov_4.547619_g29697_i0 | PRJNA698538 | 29863 | 241 | 4.547619 | 10.95976179 | Endolimax nana | 110788 | Evosea | other_Eukaryota | 178 | 3.43e-40 | NTclustered | gi|6625685|gb|AF149916.1|AF149916 | 110788 | g29697 | i0 | 86.503 | 50.7302904564315 | 163 | 20 | 67 | 2 | 1 | 162 | 2428 | 2589 | Endolimax nana 16S-like small subunit ribosomal RNA gene, complete sequence | blastn | 12226 | 178 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax nana | |||
| 7059850 | 7059850 | PRJNA698538_S_NODE_14926_length_313_cov_1.866667_g14760_i0 | PRJNA698538 | 14926 | 313 | 1.866667 | 5.84266771 | Korotnevella jeppesenii | 1678066 | Discosea | other_Eukaryota | 556 | 5.09e-154 | NTclustered | gi|861553759|gb|KP719186.1| | 1678066 | g14760 | i0 | 98.726 | 78.8083067092652 | 314 | 2 | 100 | 2 | 1 | 313 | 137 | 449 | Korotnevella jeppesenii strain A4DVDPB clone 4 small subunit ribosomal RNA gene, partial sequence | blastn | 24667 | 556 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Korotnevella | Korotnevella jeppesenii | ||
| 7561934 | 7561934 | PRJNA698538_S_NODE_16706_length_302_cov_2.598253_g16540_i0 | PRJNA698538 | 16706 | 302 | 2.598253 | 7.84672406 | Endolimax | 110787 | Evosea | other_Eukaryota | 159 | 1.61e-34 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g16540 | i0 | 95.05 | 23.8576158940397 | 101 | 5 | 47 | 0 | 1 | 101 | 2104 | 2004 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 7205 | 159 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 10885373 | 10885373 | PRJNA698538_S_NODE_17389_length_298_cov_2.053333_g17223_i0 | PRJNA698538 | 17389 | 298 | 2.053333 | 6.11893234 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 110 | 1.62e-19 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g17223 | i0 | 98.387 | 4.22147651006711 | 62 | 1 | 21 | 0 | 237 | 298 | 1005 | 944 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 1258 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 12663567 | 12663567 | PRJNA698538_S_NODE_25410_length_256_cov_6.306011_g25244_i0 | PRJNA698538 | 25410 | 256 | 6.306011 | 16.14338816 | Endolimax | 110787 | Evosea | other_Eukaryota | 219 | 2.1699999999999993e-52 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g25244 | i0 | 95 | 41.15625 | 140 | 6 | 78 | 1 | 118 | 256 | 2788 | 2927 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 10536 | 219 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 13435229 | 13435229 | PRJNA698538_S_NODE_23031_length_268_cov_1.302564_g22865_i0 | PRJNA698538 | 23031 | 268 | 1.302564 | 3.49087152 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 496 | 9.429999999999999e-136 | NTclustered | gi|381139265|emb|HE655082.1| | 159720 | g22865 | i0 | 100 | 68.4589552238806 | 268 | 0 | 100 | 0 | 1 | 268 | 1806 | 2073 | Fuligo septica partial 28S rRNA gene, isolate IW-1 | blastn | 18347 | 496 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica |
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);;