contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2055920 | 2055920 | PRJNA795983_S_NODE_17222_length_322_cov_4.216867_g17097_i0 | PRJNA795983 | 17222 | 322 | 4.216867 | 13.57831174 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 499 | 8.979999999999999e-137 | NTclustered | gi|1269228471|gb|MF683596.1| | 2047823 | g17097 | i0 | 94.769 | 101.577639751553 | 325 | 9 | 100 | 7 | 1 | 322 | 1622 | 1303 | Ripella tribonemae clone 22.1.14 18S ribosomal RNA gene, partial sequence | blastn | 32708 | 499 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 2056233 | 2056233 | PRJNA795983_S_NODE_8902_length_405_cov_1.174699_g8777_i0 | PRJNA795983 | 8902 | 405 | 1.174699 | 4.75753095 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 8.35e-4 | NTclustered | gi|470469416|ref|XM_004341948.1| | 1257118 | g8777 | i0 | 83.077 | 0.160493827160494 | 65 | 9 | 16 | 2 | 185 | 248 | 884 | 821 | Acanthamoeba castellanii str. Neff MORN repeatcontaining protein (ACA1_050500), partial mRNA | blastn | 65 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8433097 | 8433097 | PRJNA795983_S_NODE_17927_length_318_cov_4.118367_g17802_i0 | PRJNA795983 | 17927 | 318 | 4.118367 | 13.09640706 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 327 | 4.42e-85 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g17802 | i0 | 85.449 | 23.8396226415094 | 323 | 37 | 100 | 8 | 1 | 318 | 1884 | 2201 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 7581 | 327 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13970463 | 13970463 | PRJNA795983_S_NODE_33971_length_256_cov_1.218579_g33846_i0 | PRJNA795983 | 33971 | 256 | 1.218579 | 3.11956224 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 3.5999999999999986e-55 | NTclustered | gi|1914009695|gb|MT975597.1| | 313997 | g33846 | i0 | 84.322 | 91.96875 | 236 | 33 | 91 | 4 | 1 | 234 | 40 | 273 | Cochliopodium minus clone 2 actin gene, partial cds | blastn | 23544 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16082442 | 16082442 | PRJNA795983_S_NODE_11213_length_373_cov_1.446667_g11088_i0 | PRJNA795983 | 11213 | 373 | 1.446667 | 5.39606791 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 324 | 6.809999999999999e-84 | NTclustered | gi|470525569|ref|XM_004356569.1| | 1257118 | g11088 | i0 | 82.574 | 6.9597855227882 | 373 | 59 | 99 | 4 | 1 | 370 | 391 | 760 | Acanthamoeba castellanii str. Neff mitochondrial phosphate transporter, putative (ACA1_173800), partial mRNA | blastn | 2596 | 324 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16082483 | 16082483 | PRJNA795983_S_NODE_1573_length_792_cov_1.866481_g1477_i0 | PRJNA795983 | 1573 | 792 | 1.866481 | 14.78252952 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 952 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1477 | i0 | 88.943 | 55.6590909090909 | 814 | 28 | 100 | 32 | 1 | 792 | 2209 | 1436 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 44082 | 952 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16082802 | 16082802 | PRJNA795983_S_NODE_6753_length_448_cov_4.605333_g6628_i0 | PRJNA795983 | 6753 | 448 | 4.605333 | 20.63189184 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 662 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g6628 | i0 | 93.722 | 101.1875 | 446 | 20 | 99 | 6 | 1 | 445 | 996 | 558 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 45332 | 662 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 17358631 | 17358631 | PRJNA795983_S_NODE_4674_length_514_cov_1.736961_g4550_i0 | PRJNA795983 | 4674 | 514 | 1.736961 | 8.92797954 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 501 | 4.16e-137 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g4550 | i0 | 85.246 | 72.9591439688716 | 488 | 70 | 95 | 2 | 2 | 488 | 1699 | 1213 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 37501 | 501 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19907021 | 19907021 | PRJNA795983_S_NODE_4196_length_536_cov_4.881210_g4073_i0 | PRJNA795983 | 4196 | 536 | 4.88121 | 26.1632856 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 828 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g4073 | i0 | 96.627 | 59.5111940298507 | 504 | 8 | 94 | 6 | 35 | 536 | 4 | 500 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 31898 | 828 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 21182662 | 21182662 | PRJNA795983_S_NODE_3777_length_559_cov_7.668724_g3655_i0 | PRJNA795983 | 3777 | 559 | 7.668724 | 42.86816716 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 852 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g3655 | i0 | 94.595 | 99.5044722719141 | 555 | 22 | 99 | 8 | 1 | 552 | 550 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 55623 | 852 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 21182728 | 21182728 | PRJNA795983_S_NODE_4537_length_520_cov_1.711409_g4414_i0 | PRJNA795983 | 4537 | 520 | 1.711409 | 8.8993268 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 237 | 1.31e-57 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g4414 | i0 | 80.795 | 57.4211538461538 | 302 | 58 | 58 | 0 | 100 | 401 | 422 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 29859 | 237 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22457445 | 22457445 | PRJNA795983_S_NODE_4618_length_516_cov_2.458239_g4494_i0 | PRJNA795983 | 4618 | 516 | 2.458239 | 12.68451324 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 274 | 9.91e-69 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g4494 | i0 | 79.79 | 54.8217054263566 | 381 | 73 | 73 | 3 | 102 | 480 | 544 | 166 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 28288 | 274 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25006370 | 25006370 | PRJNA795983_S_NODE_11500_length_370_cov_1.006734_g11375_i0 | PRJNA795983 | 11500 | 370 | 1.006734 | 3.7249158000000002 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 187 | 9.24e-43 | NTclustered | gi|470443630|ref|XM_004339621.1| | 1257118 | g11375 | i0 | 79.848 | 2.1027027027027 | 263 | 48 | 71 | 5 | 3 | 263 | 265 | 6 | Acanthamoeba castellanii str. Neff Rasrelated protein Rac1, putative (ACA1_064420), partial mRNA | blastn | 778 | 187 | 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);;