contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2096751 | 2096751 | PRJNA827593_P_NODE_39762_length_322_cov_1.273092_g39463_i0 | PRJNA827593 | 39762 | 322 | 1.273092 | 4.09935624 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 490 | 5.4e-134 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g39463 | i0 | 94.099 | 33.7577639751553 | 322 | 19 | 100 | 0 | 1 | 322 | 4097 | 4418 | 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 | 10870 | 490 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 3372327 | 3372327 | PRJNA827593_P_NODE_54443_length_269_cov_1.571429_g54144_i0 | PRJNA827593 | 54443 | 269 | 1.571429 | 4.22714401 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 226 | 1.37e-54 | NTclustered | gi|3185|emb|X60211.1| | 5791 | g54144 | i0 | 83.012 | 43.6505576208178 | 259 | 34 | 94 | 10 | 10 | 262 | 316 | 62 | P.polycephalum 26S rRNA | blastn | 11742 | 226 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 11025486 | 11025486 | PRJNA827593_P_NODE_68709_length_236_cov_2.723926_g68410_i0 | PRJNA827593 | 68709 | 236 | 2.723926 | 6.42846536 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 91.6 | 4.49e-14 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g68410 | i0 | 84.158 | 9 | 101 | 8 | 41 | 8 | 34 | 130 | 5215 | 5119 | Paravannella minima mitochondrion, complete genome | blastn | 2124 | 91.6 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 13574587 | 13574587 | PRJNA827593_P_NODE_29811_length_379_cov_2.035948_g29512_i0 | PRJNA827593 | 29811 | 379 | 2.035948 | 7.71624292 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 472 | 2.3399999999999997e-128 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g29512 | i0 | 89.785 | 8.73614775725594 | 372 | 32 | 98 | 6 | 1 | 370 | 4410 | 4777 | 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 | 3311 | 472 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 14849466 | 14849466 | PRJNA827593_P_NODE_51352_length_278_cov_2.356098_g51053_i0 | PRJNA827593 | 51352 | 278 | 2.356098 | 6.54995244 | Heterostelium pallidum | 13642 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|160688721|gb|EU275726.1| | 13642 | g51053 | i0 | 94.595 | 0.133093525179856 | 37 | 1 | 13 | 1 | 240 | 275 | 12766 | 12802 | Polysphondylium pallidum strain PN500 mitochondrion, complete genome | blastn | 37 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium pallidum | ||
| 17399062 | 17399062 | PRJNA827593_P_NODE_12254_length_625_cov_2.211957_g11962_i0 | PRJNA827593 | 12254 | 625 | 2.211957 | 13.82473125 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 961 | 0 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g11962 | i0 | 99.248 | 8.7664 | 532 | 4 | 100 | 0 | 94 | 625 | 8644 | 9175 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 5479 | 961 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 22498462 | 22498462 | PRJNA827593_P_NODE_65778_length_244_cov_1.292398_g65479_i0 | PRJNA827593 | 65778 | 244 | 1.292398 | 3.15345112 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 420 | 5.24e-113 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g65479 | i0 | 99.145 | 47.9590163934426 | 234 | 1 | 96 | 1 | 11 | 244 | 2885 | 2653 | D.iridis LSU rRNA gene | blastn | 11702 | 420 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis |
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);;