contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904407 | 1904407 | PRJNA662254_P_NODE_38902_length_269_cov_1.311224_g38251_i0 | PRJNA662254 | 38902 | 269 | 1.311224 | 3.52719256 | Arcella discoides | 1078856 | Tubulinea | other_Eukaryota | 287 | 6.21e-73 | NTclustered | gi|345452540|gb|JF694288.1| | 1078856 | g38251 | i0 | 86.364 | 81.2973977695167 | 264 | 34 | 98 | 2 | 3 | 265 | 437 | 699 | Arcella discoides isolate DL3_98 clone 2 actin gene, partial cds | blastn | 21869 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella discoides | ||
| 1904472 | 1904472 | PRJNA662254_P_NODE_53642_length_247_cov_0.885057_g52991_i0 | PRJNA662254 | 53642 | 247 | 0.885057 | 2.18609079 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 302 | 2.01e-77 | NTclustered | gi|167859728|gb|EU273444.1| | 497998 | g52991 | i0 | 90.789 | 60.1578947368421 | 228 | 17 | 91 | 3 | 22 | 247 | 1000 | 775 | Arcella hemisphaerica alpha-tubulin gene, partial cds | blastn | 14859 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 4456109 | 4456109 | PRJNA662254_P_NODE_1204_length_1592_cov_7.714944_g939_i2 | PRJNA662254 | 1204 | 1592 | 7.714944 | 122.82190848 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 780 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g939 | i2 | 77.19 | 7.01570351758794 | 1381 | 287 | 85 | 21 | 26 | 1383 | 1 | 1376 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 11169 | 780 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 4990243 | 4990243 | PRJNA662254_P_NODE_53324_length_247_cov_0.885057_g52673_i0 | PRJNA662254 | 53324 | 247 | 0.885057 | 2.18609079 | Leptomyxida | 66524 | Tubulinea | other_Eukaryota | 455 | 1.4600000000000002e-123 | NTclustered | gi|11527305|gb|AF293898.1|AF293898 | 136456 | g52673 | i0 | 100 | 83.7085020242915 | 246 | 0 | 99 | 0 | 2 | 247 | 1335 | 1580 | Leptomyxa reticulata small subunit ribosomal RNA gene, complete sequence | blastn | 20676 | 455 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Leptomyxidae | Leptomyxa | Leptomyxa reticulata | ||
| 7539873 | 7539873 | PRJNA662254_P_NODE_7706_length_609_cov_10.294776_g7078_i0 | PRJNA662254 | 7706 | 609 | 10.294776 | 62.69518584 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 1092 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g7078 | i0 | 99.015 | 83.2692939244663 | 609 | 6 | 100 | 0 | 1 | 609 | 1784 | 1176 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 50711 | 1092 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 9556798 | 9556798 | PRJNA662254_P_NODE_42128_length_258_cov_3.583784_g41477_i0 | PRJNA662254 | 42128 | 258 | 3.583784 | 9.24616272 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 200 | 7.93e-47 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g41477 | i0 | 80.899 | 4.35271317829457 | 267 | 40 | 100 | 9 | 1 | 258 | 2540 | 2804 | 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 | 1123 | 200 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 12641189 | 12641189 | PRJNA662254_P_NODE_6490_length_670_cov_4.966499_g5877_i0 | PRJNA662254 | 6490 | 670 | 4.966499 | 33.2755433 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 562 | 2.49e-155 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g5877 | i0 | 83.811 | 88.6402985074627 | 593 | 92 | 88 | 4 | 80 | 670 | 1124 | 534 | Glaeseria mira actin mRNA, partial cds | blastn | 59389 | 566 | 0.992932862190813 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 13382443 | 13382443 | PRJNA662254_P_NODE_56571_length_245_cov_1.360465_g55920_i0 | PRJNA662254 | 56571 | 245 | 1.360465 | 3.33313925 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 119 | 2.15e-22 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g55920 | i0 | 76.21 | 1.01224489795918 | 248 | 45 | 100 | 13 | 1 | 245 | 3708 | 3944 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 248 | 119 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 16464804 | 16464804 | PRJNA662254_P_NODE_8793_length_566_cov_11.989858_g8153_i0 | PRJNA662254 | 8793 | 566 | 11.989858 | 67.86259628 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 990 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g8153 | i0 | 98.233 | 64.2932862190813 | 566 | 10 | 100 | 0 | 1 | 566 | 1132 | 567 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 36390 | 996 | 0.993975903614458 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 22305722 | 22305722 | PRJNA662254_P_NODE_8378_length_582_cov_0.886051_g7744_i0 | PRJNA662254 | 8378 | 582 | 0.886051 | 5.15681682 | Ptolemeba bulliensis | 1525729 | Tubulinea | other_Eukaryota | 952 | 0 | NTclustered | gi|1255287465|dbj|LC272073.1| | 1525729 | g7744 | i0 | 96.392 | 75.0567010309278 | 582 | 14 | 100 | 7 | 1 | 582 | 604 | 1178 | Ptolemeba bulliensis gene for 18S ribosomal RNA, partial sequence, strain: BA02 | blastn | 43683 | 952 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba bulliensis |
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);;