contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1749056 | 1749056 | PRJNA493827_P_NODE_89422_length_363_cov_1.562069_g87224_i0 | PRJNA493827 | 89422 | 363 | 1.562069 | 5.67031047 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 662 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g87224 | i0 | 99.449 | 99.3581267217631 | 363 | 2 | 100 | 0 | 1 | 363 | 457 | 819 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 36067 | 662 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 3024612 | 3024612 | PRJNA493827_P_NODE_7243_length_1577_cov_29.415559_g6252_i0 | PRJNA493827 | 7243 | 1577 | 29.415559 | 463.88336543 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 721 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g6252 | i0 | 84.924 | 12.2618896639188 | 723 | 97 | 93 | 12 | 1 | 716 | 1751 | 2468 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19337 | 721 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 9401450 | 9401450 | PRJNA493827_P_NODE_60348_length_452_cov_6.854881_g58151_i0 | PRJNA493827 | 60348 | 452 | 6.854881 | 30.98406212 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 575 | 2.0999999999999994e-159 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g58151 | i0 | 90.249 | 98.5110619469027 | 441 | 41 | 98 | 1 | 1 | 441 | 758 | 320 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 44527 | 575 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 10674875 | 10674875 | PRJNA493827_P_NODE_178269_length_255_cov_2.296703_g176071_i0 | PRJNA493827 | 178269 | 255 | 2.296703 | 5.85659265 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 462 | 9.03e-126 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g176071 | i0 | 99.216 | 63.0627450980392 | 255 | 2 | 100 | 0 | 1 | 255 | 1704 | 1958 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16081 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 15772421 | 15772421 | PRJNA493827_P_NODE_115073_length_318_cov_3.400000_g112875_i0 | PRJNA493827 | 115073 | 318 | 3.4 | 10.812 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 453 | 6.990000000000001e-123 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g112875 | i0 | 92.429 | 92.251572327044 | 317 | 24 | 99 | 0 | 2 | 318 | 339 | 23 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 29336 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 15773089 | 15773089 | PRJNA493827_P_NODE_144433_length_284_cov_4.061611_g142235_i0 | PRJNA493827 | 144433 | 284 | 4.061611 | 11.53497524 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 525 | 1.2899999999999994e-144 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g142235 | i0 | 100 | 100.207746478873 | 284 | 0 | 100 | 0 | 1 | 284 | 1165 | 882 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28459 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 20873870 | 20873870 | PRJNA493827_P_NODE_224637_length_243_cov_0.905882_g222439_i0 | PRJNA493827 | 224637 | 243 | 0.905882 | 2.20129326 | Pseudokabatana alburnus | 2913282 | Fungi | Fungi | 84.2 | 7.77e-12 | NTclustered | gi|2385777512|gb|OP948229.1| | 2913282 | g222439 | i0 | 86.076 | 4.51851851851852 | 79 | 10 | 33 | 1 | 1 | 79 | 2069 | 2146 | Pseudokabatana alburnus 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 | 1098 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudokabatana | Pseudokabatana alburnus | ||||
| 22781908 | 22781908 | PRJNA493827_P_NODE_131078_length_298_cov_2.595556_g128880_i0 | PRJNA493827 | 131078 | 298 | 2.595556 | 7.73475688 | Pleistophoridae | 35232 | Fungi | Fungi | 333 | 8.829999999999999e-87 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g128880 | i0 | 87 | 14.1778523489933 | 300 | 33 | 99 | 6 | 1 | 297 | 2304 | 2600 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 4225 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 25330927 | 25330927 | PRJNA493827_P_NODE_111000_length_324_cov_2.980080_g108802_i0 | PRJNA493827 | 111000 | 324 | 2.98008 | 9.6554592 | Opisthokonta | 33154 | Fungi | Fungi | 52.8 | 0.03 | NTclustered | gi|149391566|emb|AM422905.1| | 723287 | g108802 | i0 | 100 | 0.172839506172839 | 28 | 0 | 9 | 0 | 137 | 164 | 8691 | 8664 | Brachiola algerae 16S rRNA gene, ITS1 and 23S rRNA gene, strain Undeen | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae |
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);;