contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 330289 | 330289 | PRJNA1214993_P_NODE_21501_length_249_cov_2.835227_g21315_i0 | PRJNA1214993 | 21501 | 249 | 2.835227 | 7.05971523 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 344 | 3.32e-90 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g21315 | i0 | 91.566 | 97.9518072289157 | 249 | 21 | 100 | 0 | 1 | 249 | 887 | 639 | Platyamoeba placida actin mRNA, partial cds | blastn | 24390 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 2881211 | 2881211 | PRJNA1214993_P_NODE_17903_length_265_cov_1.046875_g17717_i0 | PRJNA1214993 | 17903 | 265 | 1.046875 | 2.77421875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 263 | 1.03e-65 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g17717 | i0 | 84.962 | 21.9584905660377 | 266 | 32 | 99 | 6 | 4 | 265 | 2153 | 1892 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 5819 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5433599 | 5433599 | PRJNA1214993_P_NODE_8465_length_373_cov_5.343333_g8279_i0 | PRJNA1214993 | 8465 | 373 | 5.343333 | 19.93063209 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 614 | 3.6099999999999997e-171 | NTclustered | gi|1269228443|gb|MF683568.1| | 2047823 | g8279 | i0 | 97.253 | 94.3378016085791 | 364 | 6 | 97 | 4 | 1 | 362 | 1036 | 675 | Ripella tribonemae clone 70.1.3 18S ribosomal RNA gene, partial sequence | blastn | 35188 | 614 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 6708165 | 6708165 | PRJNA1214993_P_NODE_26626_length_231_cov_2.025316_g26440_i0 | PRJNA1214993 | 26626 | 231 | 2.025316 | 4.67847996 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 291 | 4.02e-74 | NTclustered | gi|575488798|gb|KF772979.1| | 180228 | g26440 | i0 | 90.455 | 100.17316017316 | 220 | 21 | 95 | 0 | 1 | 220 | 498 | 717 | Paramoeba pemaquidensis strain PA027 beta actin mRNA, partial cds | blastn | 23140 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 7983704 | 7983704 | PRJNA1214993_P_NODE_1647_length_805_cov_3.607923_g1487_i0 | PRJNA1214993 | 1647 | 805 | 3.607923 | 29.04378015 | Ripella sp. | 1973050 | Discosea | other_Eukaryota | 473 | 1.4599999999999998e-128 | NTclustered | gi|2666517890|gb|PP259001.1| | 1973050 | g1487 | i0 | 82.982 | 61.0832298136646 | 570 | 51 | 67 | 25 | 268 | 805 | 3 | 558 | Ripella sp. strain CHIESE60 small subunit ribosomal RNA gene, partial sequence | blastn | 49172 | 473 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. | |||
| 11248699 | 11248699 | PRJNA1214993_P_NODE_18329_length_261_cov_3.255319_g18143_i0 | PRJNA1214993 | 18329 | 261 | 3.255319 | 8.49638259 | Ripella | 1217112 | Discosea | other_Eukaryota | 446 | 9.339999999999999e-121 | NTclustered | gi|399764203|gb|JQ271714.1| | 1217114 | g18143 | i0 | 97.338 | 100.850574712644 | 263 | 5 | 100 | 2 | 1 | 261 | 1322 | 1584 | Ripella sp. DP13 18S ribosomal RNA gene, partial sequence | blastn | 26322 | 446 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. DP13 | |||
| 11248719 | 11248719 | PRJNA1214993_P_NODE_3189_length_592_cov_2.057803_g3008_i0 | PRJNA1214993 | 3189 | 592 | 2.057803 | 12.18219376 | Vannellidae | 95227 | Discosea | other_Eukaryota | 435 | 4.98e-117 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g3008 | i0 | 80.467 | 102.045608108108 | 599 | 91 | 100 | 19 | 1 | 592 | 1092 | 1671 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 60411 | 435 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 16907537 | 16907537 | PRJNA1214993_P_NODE_574_length_1247_cov_6.677172_g487_i0 | PRJNA1214993 | 574 | 1247 | 6.677172 | 83.26433484 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 754 | 0 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g487 | i0 | 78.59 | 53.8388131515638 | 1149 | 238 | 92 | 7 | 1 | 1145 | 56 | 1200 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 67137 | 754 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 18181935 | 18181935 | PRJNA1214993_P_NODE_4935_length_480_cov_4.174447_g4750_i0 | PRJNA1214993 | 4935 | 480 | 4.174447 | 20.0373456 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 712 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g4750 | i0 | 93.173 | 102.216666666667 | 498 | 13 | 100 | 9 | 1 | 480 | 4 | 498 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 49064 | 712 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 20731823 | 20731823 | PRJNA1214993_P_NODE_4897_length_482_cov_2.158924_g4712_i0 | PRJNA1214993 | 4897 | 482 | 2.158924 | 10.40601368 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 298 | 5.46e-76 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g4712 | i0 | 78.407 | 4.94813278008299 | 477 | 90 | 98 | 11 | 10 | 481 | 2520 | 2052 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 2385 | 298 | 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);;