contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB75017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135398 | 135398 | PRJEB75017_P_NODE_441_length_1203_cov_12.205310_g376_i0 | PRJEB75017 | 441 | 1203 | 12.20531 | 146.8298793 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 893 | 0 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g376 | i0 | 94.511 | 32.1886949293433 | 583 | 25 | 81 | 5 | 511 | 1087 | 582 | 1 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 38723 | 893 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 2270693 | 2270693 | PRJEB75017_P_NODE_4242_length_425_cov_4.903409_g4113_i0 | PRJEB75017 | 4242 | 425 | 4.903409 | 20.83948825 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 1.42e-26 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4113 | i0 | 89.623 | 21.5529411764706 | 106 | 10 | 25 | 1 | 7 | 112 | 883 | 987 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 9160 | 135 | 0.992592592592593 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7787807 | 7787807 | PRJEB75017_P_NODE_7187_length_333_cov_1.188462_g7058_i0 | PRJEB75017 | 7187 | 333 | 1.188462 | 3.95757846 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 455 | 2.05e-123 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g7058 | i0 | 91.291 | 99.0960960960961 | 333 | 29 | 100 | 0 | 1 | 333 | 538 | 870 | Platyamoeba placida actin mRNA, partial cds | blastn | 32999 | 455 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 8648707 | 8648707 | PRJEB75017_P_NODE_16107_length_247_cov_1.752874_g15978_i0 | PRJEB75017 | 16107 | 247 | 1.752874 | 4.32959878 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|330843038|ref|XM_003293424.1| | 5786 | g15978 | i0 | 100 | 0.676113360323887 | 28 | 0 | 11 | 0 | 220 | 247 | 782 | 809 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_158333), partial mRNA | blastn | 167 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12888903 | 12888903 | PRJEB75017_P_NODE_151_length_1736_cov_6.110643_g121_i0 | PRJEB75017 | 151 | 1736 | 6.110643 | 106.08076248 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 2741 | 0 | NTclustered | gi|330902846|gb|JF298250.1| | 703021 | g121 | i0 | 97.979 | 48.3945852534562 | 1583 | 25 | 91 | 7 | 159 | 1736 | 2176 | 596 | Cochliopodium actinophorum clone 1201 18S ribosomal RNA gene, partial sequence | blastn | 84013 | 2741 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 12888977 | 12888977 | PRJEB75017_P_NODE_7511_length_326_cov_4.086957_g7382_i0 | PRJEB75017 | 7511 | 326 | 4.086957 | 13.32347982 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 87.9 | 8.4e-13 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g7382 | i0 | 78.571 | 0.429447852760736 | 140 | 24 | 42 | 5 | 189 | 326 | 4312 | 4177 | Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 140 | 87.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 12888987 | 12888987 | PRJEB75017_P_NODE_9691_length_292_cov_1.301370_g9562_i0 | PRJEB75017 | 9691 | 292 | 1.30137 | 3.8000004 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 139 | 2.02e-28 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g9562 | i0 | 86.26 | 0.448630136986301 | 131 | 14 | 44 | 4 | 1 | 128 | 31909 | 32038 | Paravannella minima mitochondrion, complete genome | blastn | 131 | 139 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 14163716 | 14163716 | PRJEB75017_P_NODE_12292_length_266_cov_1.777202_g12163_i0 | PRJEB75017 | 12292 | 266 | 1.777202 | 4.72735732 | Entamoeba nuttalli | 412467 | Evosea | other_Eukaryota | 268 | 2.22e-67 | NTclustered | gi|672804637|ref|XM_008859135.1| | 1076696 | g12163 | i0 | 85.075 | 45.4210526315789 | 268 | 35 | 99 | 5 | 1 | 265 | 415 | 150 | Entamoeba nuttalli P19 Ran family GTPase partial mRNA | blastn | 12082 | 268 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba nuttalli | |||
| 15437903 | 15437903 | PRJEB75017_P_NODE_7913_length_319_cov_1.292683_g7784_i0 | PRJEB75017 | 7913 | 319 | 1.292683 | 4.12365877 | Vannella persistens | 303303 | Discosea | other_Eukaryota | 579 | 1.1099999999999996e-160 | NTclustered | gi|165968549|gb|EU377589.1| | 303303 | g7784 | i0 | 99.373 | 99.3699059561129 | 319 | 2 | 100 | 0 | 1 | 319 | 331 | 649 | Vannella persistens strain CRIB49 18S ribosomal RNA gene, partial sequence | blastn | 31699 | 579 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella persistens | |||
| 16712013 | 16712013 | PRJEB75017_P_NODE_1394_length_732_cov_6.836115_g1273_i0 | PRJEB75017 | 1394 | 732 | 6.836115 | 50.0403618 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 1059 | 0 | NTclustered | gi|330902845|gb|JF298249.1| | 703021 | g1273 | i0 | 98.505 | 50.655737704918 | 602 | 6 | 82 | 3 | 131 | 732 | 4 | 602 | Cochliopodium actinophorum clone 1202 18S ribosomal RNA gene, partial sequence | blastn | 37080 | 1059 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 16712032 | 16712032 | PRJEB75017_P_NODE_16174_length_247_cov_1.344828_g16045_i0 | PRJEB75017 | 16174 | 247 | 1.344828 | 3.32172516 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 243 | 1.23e-59 | NTclustered | gi|66820585|ref|XM_638794.1| | 352472 | g16045 | i0 | 85.714 | 0.935222672064777 | 231 | 31 | 93 | 2 | 1 | 230 | 634 | 863 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0274775) mRNA, complete cds | blastn | 231 | 243 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 17573472 | 17573472 | PRJEB75017_P_NODE_16734_length_246_cov_0.901734_g16605_i0 | PRJEB75017 | 16734 | 246 | 0.901734 | 2.21826564 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 276 | 1.21e-69 | NTclustered | gi|167579|gb|M14146.1|DDIACT15 | 44689 | g16605 | i0 | 87.19 | 65.4105691056911 | 242 | 31 | 98 | 0 | 5 | 246 | 1388 | 1147 | D.discoideum actin 15 gene, complete cds | blastn | 16091 | 276 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20122084 | 20122084 | PRJEB75017_P_NODE_2056_length_608_cov_4.371963_g1929_i0 | PRJEB75017 | 2056 | 608 | 4.371963 | 26.58153504 | Vexillifera | 218659 | Root_unresolved | Root_unresolved | 492 | 2.99e-134 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g1929 | i0 | 84.843 | 38.6069078947368 | 508 | 56 | 80 | 16 | 1 | 489 | 1332 | 1837 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 23473 | 492 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 24361242 | 24361242 | PRJEB75017_P_NODE_800_length_937_cov_6.237269_g707_i0 | PRJEB75017 | 800 | 937 | 6.237269 | 58.44321053 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 1238 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g707 | i0 | 90.502 | 99.0640341515475 | 937 | 89 | 100 | 0 | 1 | 937 | 1024 | 88 | Platyamoeba placida actin mRNA, partial cds | blastn | 92823 | 1238 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida |
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);;