contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9573210 | 9573210 | PRJNA674308_P_NODE_2468_length_624_cov_18.902609_g2245_i0 | PRJNA674308 | 2468 | 624 | 18.902609000000002 | 117.95228016 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 944 | 0 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g2245 | i0 | 96.213 | 59.2596153846154 | 581 | 15 | 92 | 7 | 49 | 624 | 4 | 582 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 36978 | 944 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 10848859 | 10848859 | PRJNA674308_P_NODE_39669_length_168_cov_0.873950_g39434_i0 | PRJNA674308 | 39669 | 168 | 0.87395 | 1.468236 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 243 | 7.8e-60 | NTclustered | gi|470394462|ref|XM_004334945.1| | 1257118 | g39434 | i0 | 98.54 | 4.07738095238095 | 137 | 2 | 82 | 0 | 1 | 137 | 137 | 1 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_096510), partial mRNA | blastn | 685 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13920451 | 13920451 | PRJNA674308_P_NODE_2171_length_671_cov_91.607717_g1959_i0 | PRJNA674308 | 2171 | 671 | 91.607717 | 614.68778107 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 913 | 0 | NTclustered | gi|59876024|gb|AY785057.1| | 313998 | g1959 | i0 | 91.241 | 55.6304023845007 | 685 | 38 | 100 | 18 | 1 | 671 | 47 | 723 | Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence | blastn | 37328 | 913 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. strain Kiel | |||
| 17222828 | 17222828 | PRJNA674308_P_NODE_31614_length_180_cov_1.274809_g31379_i0 | PRJNA674308 | 31614 | 180 | 1.274809 | 2.2946562 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 263 | 6.479999999999999e-66 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g31379 | i0 | 92.222 | 1.23333333333333 | 180 | 14 | 100 | 0 | 1 | 180 | 7831 | 7652 | Acanthamoeba castellanii 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 | 222 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18497329 | 18497329 | PRJNA674308_P_NODE_8775_length_321_cov_15.360294_g8540_i0 | PRJNA674308 | 8775 | 321 | 15.360294 | 49.30654374 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 459 | 1.5199999999999996e-124 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g8540 | i0 | 93.291 | 36.9781931464174 | 313 | 17 | 96 | 3 | 13 | 321 | 1760 | 1448 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 11870 | 459 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 18497339 | 18497339 | PRJNA674308_P_NODE_9795_length_304_cov_1.545098_g9560_i0 | PRJNA674308 | 9795 | 304 | 1.545098 | 4.69709792 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 540 | 4.96e-149 | NTclustered | gi|659103845|gb|KJ569729.1| | 1512276 | g9560 | i0 | 98.684 | 99.4243421052632 | 304 | 4 | 100 | 0 | 1 | 304 | 133 | 436 | Cochliopodium kieliense isolate 2 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 30225 | 540 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 19771468 | 19771468 | PRJNA674308_P_NODE_14856_length_250_cov_16.641791_g14621_i0 | PRJNA674308 | 14856 | 250 | 16.641791 | 41.6044775 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 357 | 4.28e-94 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g14621 | i0 | 92.248 | 54.076 | 258 | 11 | 100 | 7 | 1 | 250 | 2000 | 1744 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 13519 | 357 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 21047412 | 21047412 | PRJNA674308_P_NODE_49457_length_163_cov_1.789474_g49222_i0 | PRJNA674308 | 49457 | 163 | 1.789474 | 2.91684262 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 1.63e-56 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g49222 | i0 | 92.169 | 1.01840490797546 | 166 | 9 | 99 | 3 | 1 | 162 | 5920 | 5755 | Acanthamoeba castellanii 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 | 166 | 231 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;