contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7678602 | 7678602 | PRJEB29441_P_NODE_19807_length_240_cov_0.931937_g19366_i0 | PRJEB29441 | 19807 | 240 | 0.931937 | 2.2366488 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 296 | 9.03e-76 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g19366 | i0 | 95.652 | 6.3 | 184 | 8 | 77 | 0 | 57 | 240 | 2481 | 2298 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 1512 | 296 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 8953666 | 8953666 | PRJEB29441_P_NODE_39008_length_167_cov_0.864407_g38567_i0 | PRJEB29441 | 39008 | 167 | 0.864407 | 1.44355969 | Schizoplasmodiopsis pseudoendospora | 668367 | Evosea | other_Eukaryota | 108 | 2.95e-19 | NTclustered | gi|260909289|gb|FJ766475.1| | 668367 | g38567 | i0 | 84.071 | 0.676646706586826 | 113 | 16 | 66 | 2 | 57 | 167 | 216 | 328 | Schizoplasmodiopsis pseudoendospora strain PBR-G5-1 culture-collection ATCC:PRA-195 clone 36 18S ribosomal RNA gene, partial sequence | blastn | 113 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Schizoplasmodiopsis | Schizoplasmodiopsis pseudoendospora | |||
| 16603456 | 16603456 | PRJEB29441_P_NODE_35174_length_176_cov_1.606299_g34733_i0 | PRJEB29441 | 35174 | 176 | 1.606299 | 2.82708624 | Schizoplasmodiopsis pseudoendospora | 668367 | Evosea | other_Eukaryota | 204 | 3.87e-48 | NTclustered | gi|260909289|gb|FJ766475.1| | 668367 | g34733 | i0 | 87.5 | 2.75568181818182 | 176 | 22 | 100 | 0 | 1 | 176 | 1449 | 1624 | Schizoplasmodiopsis pseudoendospora strain PBR-G5-1 culture-collection ATCC:PRA-195 clone 36 18S ribosomal RNA gene, partial sequence | blastn | 485 | 204 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Schizoplasmodiopsis | Schizoplasmodiopsis pseudoendospora | |||
| 19152182 | 19152182 | PRJEB29441_P_NODE_37816_length_169_cov_1.700000_g37375_i0 | PRJEB29441 | 37816 | 169 | 1.7 | 2.873 | Ceratiomyxella tahitiensis | 661162 | Evosea | other_Eukaryota | 307 | 2.73e-79 | NTclustered | gi|254679474|gb|FJ544419.1| | 661162 | g37375 | i0 | 99.408 | 47.3668639053254 | 169 | 1 | 100 | 0 | 1 | 169 | 1525 | 1357 | Ceratiomyxella tahitiensis isolate HI04-93-l-1 18S ribosomal RNA gene, partial sequence | blastn | 8005 | 307 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Schizoplasmodiidae | Ceratiomyxella | Ceratiomyxella tahitiensis | ||
| 21703043 | 21703043 | PRJEB29441_P_NODE_15798_length_273_cov_2.732143_g15357_i0 | PRJEB29441 | 15798 | 273 | 2.732143 | 7.45875039 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 505 | 1.6e-138 | NTclustered | gi|262262919|gb|FJ766462.1| | 65008 | g15357 | i0 | 100 | 50.3443223443223 | 273 | 0 | 100 | 0 | 1 | 273 | 48 | 320 | Planoprotostelium aurantium strain LEE06-2l-3-1 small subunit ribosomal RNA gene, partial sequence | blastn | 13744 | 505 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium | ||
| 24252330 | 24252330 | PRJEB29441_P_NODE_30200_length_190_cov_2.560284_g29759_i0 | PRJEB29441 | 30200 | 190 | 2.560284 | 4.8645396 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 348 | 1.86e-91 | NTclustered | gi|262262919|gb|FJ766462.1| | 65008 | g29759 | i0 | 100 | 278.410526315789 | 188 | 0 | 99 | 0 | 1 | 188 | 1305 | 1492 | Planoprotostelium aurantium strain LEE06-2l-3-1 small subunit ribosomal RNA gene, partial sequence | blastn | 52898 | 348 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium | ||
| 24252683 | 24252683 | PRJEB29441_P_NODE_9600_length_367_cov_2.352201_g9159_i0 | PRJEB29441 | 9600 | 367 | 2.352201 | 8.63257767 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 676 | 0 | NTclustered | gi|262262919|gb|FJ766462.1| | 65008 | g9159 | i0 | 100 | 53.5476839237057 | 366 | 0 | 99 | 0 | 1 | 366 | 639 | 1004 | Planoprotostelium aurantium strain LEE06-2l-3-1 small subunit ribosomal RNA gene, partial sequence | blastn | 19652 | 676 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium |
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);;