RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA473641 · 13 ✖

analysis 1

  • blastn · 13 ✖

tax_kingdom 0

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
444785 444785 PRJNA473641_P_NODE_11081_length_304_cov_1.658009_g10998_i0 PRJNA473641 11081 304 1.658009 5.04034736 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 507 5.03e-139   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g10998 i0 96.711 2.37828947368421 304 10 100 0 1 304 6819 7122 Cryptocaryon irritans mitochondrion, complete genome blastn 723 507 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
445255 445255 PRJNA473641_P_NODE_4141_length_438_cov_2.583562_g4058_i0 PRJNA473641 4141 438 2.583562 11.31600156 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|2234196641|dbj|LC627764.1| 153251 g4058 i0 98.866 3.98630136986301 441 2 100 3 1 438 966 526 Cryptocaryon irritans UT2 mRNA for agglutination/immobilization antigen, partial cds, clone: UT2_i_antigen_1 blastn 1746 784 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
1719689 1719689 PRJNA473641_P_NODE_13662_length_279_cov_2.577670_g13579_i0 PRJNA473641 13662 279 2.57767 7.1916993 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 499 7.63e-137   NTclustered gi|1004125725|gb|KU761582.1| 153251 g13579 i0 98.925 100.268817204301 279 3 100 0 1 279 5616 5338 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 27975 499 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
9373032 9373032 PRJNA473641_P_NODE_6848_length_361_cov_9.906250_g6765_i0 PRJNA473641 6848 361 9.90625 35.7615625 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 667 0   NTclustered gi|1004125725|gb|KU761582.1| 153251 g6765 i0 100 99.6149584487535 361 0 100 0 1 361 2494 2134 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 35961 667 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
11923449 11923449 PRJNA473641_P_NODE_1130_length_745_cov_3.431548_g1058_i0 PRJNA473641 1130 745 3.431548 25.5650326 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 329 3.08e-85   NTclustered gi|471230286|ref|XM_004036375.1| 5932 g1058 i0 75.61 24.8228187919463 697 153 92 15 1 689 646 1333 Ichthyophthirius multifiliis hypothetical protein (IMG5_083250) mRNA, complete cds blastn 18493 329 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
13198381 13198381 PRJNA473641_P_NODE_11391_length_301_cov_2.447368_g11308_i0 PRJNA473641 11391 301 2.447368 7.36657768 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 527 3.819999999999999e-145   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g11308 i0 98.658 91.6943521594684 298 3 99 1 1 297 5389 5686 Cryptocaryon irritans mitochondrion, complete genome blastn 27600 527 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
14473533 14473533 PRJNA473641_P_NODE_1672_length_633_cov_2.612500_g1590_i0 PRJNA473641 1672 633 2.6125 16.537125 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 1092 0   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g1590 i0 97.937 57.9794628751975 630 13 99 0 4 633 6416 5787 Cryptocaryon irritans mitochondrion, complete genome blastn 36701 1092 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
17022365 17022365 PRJNA473641_P_NODE_19934_length_248_cov_0.880000_g19851_i0 PRJNA473641 19934 248 0.88 2.1824 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 359 1.18e-94   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g19851 i0 92.771 46.1088709677419 249 17 100 1 1 248 32218 31970 Cryptocaryon irritans mitochondrion, complete genome blastn 11435 359 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
17022614 17022614 PRJNA473641_P_NODE_6634_length_365_cov_1.880137_g6551_i0 PRJNA473641 6634 365 1.880137 6.86250005 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 595 1.2799999999999998e-165   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g6551 i0 96.164 1 365 12 99 2 1 363 7088 7452 Cryptocaryon irritans mitochondrion, complete genome blastn 365 595 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
18296831 18296831 PRJNA473641_P_NODE_4255_length_434_cov_1.033241_g4172_i0 PRJNA473641 4255 434 1.033241 4.48426594 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 560 5.63e-155   NTclustered gi|1779767357|gb|MK861969.1| 153251 g4172 i0 90.278 26.5299539170507 432 36 99 3 1 432 2105 1680 Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds blastn 11514 560 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
20846847 20846847 PRJNA473641_P_NODE_5177_length_401_cov_1.021341_g5094_i0 PRJNA473641 5177 401 1.021341 4.09557741 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 603 8.459999999999999e-168   NTclustered gi|1779767357|gb|MK861969.1| 153251 g5094 i0 93.766 62.3266832917706 401 25 100 0 1 401 1603 1203 Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds blastn 24993 603 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
22121711 22121711 PRJNA473641_P_NODE_4938_length_408_cov_1.465672_g4855_i0 PRJNA473641 4938 408 1.465672 5.97994176 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 555 2.45e-153   NTclustered gi|1779767357|gb|MK861969.1| 153251 g4855 i0 91.379 3.77450980392157 406 34 99 1 1 406 1214 810 Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds blastn 1540 555 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
23397524 23397524 PRJNA473641_P_NODE_8319_length_336_cov_7.422053_g8236_i0 PRJNA473641 8319 336 7.422053 24.93809808 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 621 1.9299999999999997e-173   NTclustered gi|1161057763|gb|KY440336.1| 153251 g8236 i0 100 100.145833333333 336 0 100 0 1 336 1561 1226 Cryptocaryon irritans isolate CN_CL_2012 18S ribosomal RNA gene, partial sequence blastn 33649 621 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;