RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA716463 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2468102 2468102 PRJNA716463_P_NODE_15242_length_312_cov_3.531381_g14825_i0 PRJNA716463 15242 312 3.531381 11.01790872 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 510 4e-140   NTclustered gi|2166921685|gb|OL894853.1| 63136 g14825 i0 98.294 8.32051282051282 293 2 94 2 1 293 343 54 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 2596 510 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
4535766 4535766 PRJNA716463_P_NODE_1224_length_812_cov_3.826793_g876_i0 PRJNA716463 1224 812 3.826793 31.07355916 Epispathidium amphoriforme 114794 SAR_Eukaryotes SAR_Eukaryotes 1166 0   NTclustered gi|6980029|gb|AF223570.1|AF223570 114794 g876 i0 92.638 78.2721674876847 815 52 100 7 1 812 2526 1717 Spathidium amphoriforme internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 63557 1166 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Spathidiidae Epispathidium Epispathidium amphoriforme
4536878 4536878 PRJNA716463_P_NODE_77884_length_270_cov_2.329949_g77467_i0 PRJNA716463 77884 270 2.329949 6.2908623 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 100 8.71e-17   NTclustered gi|118360339|ref|XM_001013407.1| 312017 g77467 i0 86.667 1.98148148148148 90 12 33 0 4 93 304 393 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 535 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8360424 8360424 PRJNA716463_P_NODE_102707_length_249_cov_1.750000_g102290_i0 PRJNA716463 102707 249 1.75 4.3575 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 148 2.7899999999999996e-31   NTclustered gi|1585114938|gb|MG744347.1| 5909 g102290 i0 81.72 44.6746987951807 186 26 73 8 23 204 31222 31403 Tetrahymena rostrata isolate TRO1 mitochondrion blastn 11124 148 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
12187220 12187220 PRJNA716463_P_NODE_4030_length_500_cov_3.903981_g3631_i0 PRJNA716463 4030 500 3.903981 19.519905 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 366 1.5399999999999996e-96   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g3631 i0 85.634 67.288 355 44 70 6 1 351 5373 5724 Cryptocaryon irritans mitochondrion, complete genome blastn 33644 366 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
12672224 12672224 PRJNA716463_P_NODE_111950_length_241_cov_1.833333_g111532_i0 PRJNA716463 111950 241 1.833333 4.41833253 Maryna 638344 SAR_Eukaryotes SAR_Eukaryotes 435 1.84e-117   NTclustered gi|332712527|gb|JF747217.1| 638345 g111532 i0 99.17 100.016597510373 241 2 100 0 1 241 710 950 Maryna umbrellata 18S ribosomal RNA gene, partial sequence; macronuclear blastn 24104 435 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Marynidae Maryna Maryna umbrellata
13462249 13462249 PRJNA716463_P_NODE_8151_length_400_cov_2.397554_g7738_i0 PRJNA716463 8151 400 2.397554 9.590216 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 368 3.35e-97   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g7738 i0 85.246 81.23 366 45 91 9 16 379 6366 6008 Cryptocaryon irritans mitochondrion, complete genome blastn 32492 368 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
13946615 13946615 PRJNA716463_P_NODE_1511_length_730_cov_6.613394_g1154_i0 PRJNA716463 1511 730 6.613394 48.2777762 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 1175 0   NTclustered gi|2166921685|gb|OL894853.1| 63136 g1154 i0 96.374 77.1561643835616 717 20 98 5 16 730 1021 309 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 56324 1175 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
17286632 17286632 PRJNA716463_P_NODE_834_length_999_cov_6.876890_g515_i0 PRJNA716463 834 999 6.87689 68.7001311 Tetrahymena paravorax 5905 SAR_Eukaryotes SAR_Eukaryotes 281 1.19e-70   NTclustered gi|114329857|ref|NC_008338.1| 5905 g515 i0 76.101 5.91891891891892 636 97 63 41 48 673 3228 2638 Tetrahymena paravorax mitochondrion, complete genome blastn 5913 281 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena paravorax

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