contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1749859 | 1749859 | PRJNA493828_P_NODE_44262_length_225_cov_8.552632_g43843_i0 | PRJNA493828 | 44262 | 225 | 8.552632 | 19.243422 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 171 | 5.29e-38 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g43843 | i0 | 88.732 | 4.93333333333333 | 142 | 13 | 63 | 3 | 84 | 224 | 7194 | 7333 | Mucilago crustacea 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 | 1110 | 171 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 1749948 | 1749948 | PRJNA493828_P_NODE_6382_length_438_cov_2.778082_g5982_i0 | PRJNA493828 | 6382 | 438 | 2.778082 | 12.16799916 | Perichaena dictyonema | 2951132 | Evosea | other_Eukaryota | 809 | 0 | NTclustered | gi|2250222210|gb|ON713340.1| | 2951132 | g5982 | i0 | 100 | 76.8812785388128 | 438 | 0 | 100 | 0 | 1 | 438 | 775 | 1212 | Perichaena dictyonema voucher MA59057 small subunit ribosomal RNA gene, partial sequence | blastn | 33674 | 809 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Perichaena | Perichaena dictyonema | ||
| 4301481 | 4301481 | PRJNA493828_P_NODE_21624_length_282_cov_0.976077_g21205_i0 | PRJNA493828 | 21624 | 282 | 0.976077 | 2.75253714 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 337 | 6.41e-88 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g21205 | i0 | 88.298 | 15.1595744680851 | 282 | 31 | 99 | 2 | 1 | 280 | 2011 | 1730 | D.iridis LSU rRNA gene | blastn | 4275 | 337 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 9403003 | 9403003 | PRJNA493828_P_NODE_6048_length_449_cov_1.797872_g5655_i0 | PRJNA493828 | 6048 | 449 | 1.797872 | 8.07244528 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 211 | 6.78e-50 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g5655 | i0 | 94.203 | 1.17149220489978 | 138 | 8 | 31 | 0 | 293 | 430 | 14003 | 13866 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 526 | 211 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 9403018 | 9403018 | PRJNA493828_P_NODE_7008_length_421_cov_20.560345_g6597_i0 | PRJNA493828 | 7008 | 421 | 20.560345 | 86.55905245 | uncultured Soliformovum | 2510342 | Evosea | other_Eukaryota | 464 | 4.389999999999999e-126 | NTclustered | gi|1564356923|gb|MK443523.1| | 2510342 | g6597 | i0 | 96.441 | 43.6579572446556 | 281 | 10 | 67 | 0 | 4 | 284 | 145 | 425 | Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18380 | 464 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | uncultured Soliformovum | |||
| 13228569 | 13228569 | PRJNA493828_P_NODE_31311_length_252_cov_3.826816_g30892_i0 | PRJNA493828 | 31311 | 252 | 3.826816 | 9.64357632 | Phalansterium filosum | 857046 | Evosea | other_Eukaryota | 169 | 2.17e-37 | NTclustered | gi|300078501|gb|GU001163.1| | 857046 | g30892 | i0 | 79.134 | 63.6587301587302 | 254 | 45 | 100 | 7 | 1 | 252 | 2078 | 1831 | Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16042 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium filosum | ||||
| 13228911 | 13228911 | PRJNA493828_P_NODE_9751_length_364_cov_5.250859_g9333_i0 | PRJNA493828 | 9751 | 364 | 5.250859 | 19.11312676 | Perichaena dictyonema | 2951132 | Evosea | other_Eukaryota | 649 | 0 | NTclustered | gi|2250222210|gb|ON713340.1| | 2951132 | g9333 | i0 | 98.898 | 95.6593406593407 | 363 | 4 | 99 | 0 | 1 | 363 | 1295 | 1657 | Perichaena dictyonema voucher MA59057 small subunit ribosomal RNA gene, partial sequence | blastn | 34820 | 649 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Perichaena | Perichaena dictyonema | ||
| 15777478 | 15777478 | PRJNA493828_P_NODE_40053_length_240_cov_3.796407_g39634_i0 | PRJNA493828 | 40053 | 240 | 3.796407 | 9.1113768 | Physarum cinereum | 289951 | Evosea | other_Eukaryota | 438 | 1.4199999999999995e-118 | NTclustered | gi|374255699|emb|HE614599.1| | 289951 | g39634 | i0 | 99.583 | 98.0791666666667 | 240 | 1 | 100 | 0 | 1 | 240 | 354 | 593 | Physarum cinereum partial 18S rRNA gene, strain Idn-2 | blastn | 23539 | 438 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 17052187 | 17052187 | PRJNA493828_P_NODE_40254_length_239_cov_6.379518_g39835_i0 | PRJNA493828 | 40254 | 239 | 6.379518 | 15.24704802 | Perichaena dictyonema | 2951132 | Evosea | other_Eukaryota | 420 | 5.11e-113 | NTclustered | gi|2250222210|gb|ON713340.1| | 2951132 | g39835 | i0 | 98.326 | 52.4225941422594 | 239 | 4 | 100 | 0 | 1 | 239 | 139 | 377 | Perichaena dictyonema voucher MA59057 small subunit ribosomal RNA gene, partial sequence | blastn | 12529 | 420 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Perichaena | Perichaena dictyonema | ||
| 18958166 | 18958166 | PRJNA493828_P_NODE_32335_length_250_cov_5.983051_g31916_i0 | PRJNA493828 | 32335 | 250 | 5.983051 | 14.9576275 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 159 | 1.3e-34 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g31916 | i0 | 89.844 | 48.676 | 128 | 8 | 64 | 3 | 128 | 250 | 3992 | 3865 | Phalansterium solitarium 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 | 12169 | 159 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 20233006 | 20233006 | PRJNA493828_P_NODE_34416_length_248_cov_0.880000_g33997_i0 | PRJNA493828 | 34416 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 2.7199999999999993e-46 | NTclustered | gi|290054|gb|L16578.1|DDITATBPA | 44689 | g33997 | i0 | 82.667 | 19.4435483870968 | 225 | 37 | 90 | 2 | 25 | 248 | 1165 | 942 | Dictyostelium discoideum HIV1 TAT-binding protein homologous protein mRNA, complete cds | blastn | 4822 | 200 | 0.99 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22151317 | 22151317 | PRJNA493828_P_NODE_3158_length_601_cov_3.066288_g2814_i0 | PRJNA493828 | 3158 | 601 | 3.066288 | 18.42839088 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 113 | 2.69e-20 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g2814 | i0 | 77.835 | 8.00665557404326 | 194 | 35 | 32 | 6 | 166 | 358 | 2285 | 2471 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 4812 | 113 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum |
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);;