RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA438687 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1091176 1091176 PRJNA438687_S_NODE_4141_length_218_cov_1.830601_g4051_i0 PRJNA438687 4141 218 1.830601 3.99071018 Urospora 138168 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.48e-8   NTclustered gi|2574881051|gb|OR529005.1| 1852269 g4051 i0 78.899 1.51376146788991 109 22 50 1 61 168 1261 1369 Urospora ovalis isolate WSBS large subunit ribosomal RNA gene, partial sequence blastn 330 73.1 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Urosporidae Urospora Urospora ovalis
1710243 1710243 PRJNA438687_S_NODE_7562_length_157_cov_3.180328_g7472_i0 PRJNA438687 7562 157 3.180328 4.99311496 Anthozoaphila gnarlus 2783686 SAR_Eukaryotes SAR_Eukaryotes 63.9 5.98e-6   NTclustered gi|1926181219|gb|MW192642.1| 2783686 g7472 i0 95.122 19.7770700636943 41 1 25 1 1 40 3396 3436 Apicomplexa sp. WKwo-2020a isolate sample_27 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 3105 63.9 1 Eukaryota Sar   Apicomplexa Conoidasida Corallicolida Corallicolidae Anthozoaphila Anthozoaphila gnarlus
4262365 4262365 PRJNA438687_S_NODE_6364_length_174_cov_1.050360_g6274_i0 PRJNA438687 6364 174 1.05036 1.8276264 Coccidia sp. 2049902 SAR_Eukaryotes SAR_Eukaryotes 69.4 1.45e-7   NTclustered gi|1419337969|gb|MH590231.1| 2049902 g6274 i0 80.682 1.01149425287356 88 17 51 0 87 174 3182 3269 Coccidia sp. clone C2.1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 176 69.4 1 Eukaryota Sar   Apicomplexa Conoidasida       Coccidia sp.
7469124 7469124 PRJNA438687_S_NODE_1566_length_330_cov_6.742373_g1476_i0 PRJNA438687 1566 330 6.742373 22.2498309 Stenophora 650298 SAR_Eukaryotes SAR_Eukaryotes 91.6 6.58e-14   NTclustered gi|2295827472|gb|OP390087.1| 2977109 g1476 i0 91.045 36.6333333333333 67 6 20 0 1 67 4474 4540 Stenophora sp. TMiroliubova-2022b isolate T35 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 12089 91.6 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Stenophoridae Stenophora Stenophora draconis
7469179 7469179 PRJNA438687_S_NODE_4966_length_199_cov_24.371951_g4876_i0 PRJNA438687 4966 199 24.371951 48.50018249 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 99 2.19e-16   NTclustered gi|1272609464|gb|KY882319.1| 83999 g4876 i0 98.214 40.6381909547739 56 1 53 0 144 199 234 179 Cryptosporidium serpentis isolate HR226 28S ribosomal RNA gene, partial sequence blastn 8087 100 0.99 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium serpentis
8088585 8088585 PRJNA438687_S_NODE_7427_length_159_cov_1.709677_g7337_i0 PRJNA438687 7427 159 1.709677 2.71838643 Anthozoaphila gnarlus 2783686 SAR_Eukaryotes SAR_Eukaryotes 67.6 4.7e-7   NTclustered gi|2887157054|gb|PQ871568.1| 2783686 g7337 i0 90.385 1.20125786163522 52 4 32 1 109 159 1557 1608 Anthozoaphila gnarlus isolate GZ2750 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 191 67.6 1 Eukaryota Sar   Apicomplexa Conoidasida Corallicolida Corallicolidae Anthozoaphila Anthozoaphila gnarlus
8744107 8744107 PRJNA438687_S_NODE_1247_length_352_cov_125.372240_g1157_i0 PRJNA438687 1247 352 125.37224 441.3102848 Apicomplexa 5794 SAR_Eukaryotes SAR_Eukaryotes 608 1.5699999999999995e-169   NTclustered gi|1617862800|gb|MK796081.1| 90962 g1157 i0 99.403 95.1875 335 2 95 0 1 335 725 391 Cryptosporidium sp. isolate 8 small subunit ribosomal RNA gene, partial sequence blastn 33506 614 0.990228013029316 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium sp.
12570094 12570094 PRJNA438687_S_NODE_6710_length_168_cov_12.428571_g6620_i0 PRJNA438687 6710 168 12.428571 20.87999928 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 311 2.11e-80   NTclustered gi|134021876|gb|EF023226.1| 404735 g6620 i0 100 100.244047619048 168 0 100 0 1 168 1479 1646 Eimeriidae environmental sample clone Amb_18S_526 18S ribosomal RNA gene, partial sequence blastn 16841 311 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae   uncultured Eimeriidae
18287040 18287040 PRJNA438687_S_NODE_7935_length_153_cov_2.491525_g7845_i0 PRJNA438687 7935 153 2.491525 3.81203325 Apicomplexa sp. ABonacolta-2023a 3096982 SAR_Eukaryotes SAR_Eukaryotes 132 1.5600000000000002e-26   NTclustered gi|2623109821|gb|OR832858.1| 3096982 g7845 i0 82.166 66.516339869281 157 24 100 4 1 153 4104 3948 Apicomplexa sp. ABonacolta-2023a 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 10177 132 1 Eukaryota Sar   Apicomplexa         Apicomplexa sp. ABonacolta-2023a
24043040 24043040 PRJNA438687_S_NODE_39_length_849_cov_11.697789_g22_i0 PRJNA438687 39 849 11.697789 99.31422861 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 119 8.31e-22   NTclustered gi|1461075351|gb|MH413038.1| 5818 g22 i0 86.364 12.9116607773852 110 14 13 1 1 110 1638 1746 Sarcocystis tenella isolate 2bST 28S ribosomal RNA gene, partial sequence blastn 10962 119 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Sarcocystis Sarcocystis tenella
24661563 24661563 PRJNA438687_S_NODE_3940_length_224_cov_4.259259_g3850_i0 PRJNA438687 3940 224 4.259259 9.54074016 Cryptosporidium felis 83540 SAR_Eukaryotes SAR_Eukaryotes 84.2 7.06e-12   NTclustered gi|2293339699|gb|OP345054.1| 83540 g3850 i0 96.078 21.8080357142857 51 2 23 0 174 224 64 114 Cryptosporidium felis isolate BO81 large subunit ribosomal RNA gene, partial sequence blastn 4885 84.2 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium felis
24661609 24661609 PRJNA438687_S_NODE_6780_length_167_cov_8.871212_g6690_i0 PRJNA438687 6780 167 8.871212 14.81492404 uncultured Eimeriidae 404735 SAR_Eukaryotes SAR_Eukaryotes 287 3.53e-73   NTclustered gi|166084133|gb|EF024656.1| 404735 g6690 i0 97.633 39.1676646706587 169 0 100 4 1 167 1000 1166 Eimeriidae environmental sample clone Elev_18S_983 18S ribosomal RNA gene, partial sequence blastn 6541 287 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae   uncultured Eimeriidae

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