RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1005695 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
153483 153483 PRJNA1005695_P_NODE_22341_length_317_cov_13.647541_g21489_i0 PRJNA1005695 22341 317 13.647541 43.26270497 Coccidia sp. 2049902 SAR_Eukaryotes SAR_Eukaryotes 488 1.91e-133   NTclustered gi|1419337971|gb|MH590232.1| 2049902 g21489 i0 94.603 3.45425867507886 315 17 99 0 2 316 2883 2569 Coccidia sp. clone C2.5 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 1095 488 1 Eukaryota Sar   Apicomplexa Conoidasida       Coccidia sp.
1428271 1428271 PRJNA1005695_P_NODE_28782_length_278_cov_6.229268_g27930_i0 PRJNA1005695 28782 278 6.229268 17.31736504 Goussia pannonica 947569 SAR_Eukaryotes SAR_Eukaryotes 473 4.6099999999999987e-129   NTclustered gi|328460776|gb|GU479651.1| 947569 g27930 i0 97.473 100.035971223022 277 7 99 0 1 277 411 687 Goussia pannonica isolate ABS622-#622 18S ribosomal RNA gene, partial sequence blastn 27810 473 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia pannonica
2703751 2703751 PRJNA1005695_P_NODE_29943_length_272_cov_61.788945_g29091_i0 PRJNA1005695 29943 272 61.788945 168.0659304 Coccidia sp. 2049902 SAR_Eukaryotes SAR_Eukaryotes 449 7.57e-122   NTclustered gi|1419337971|gb|MH590232.1| 2049902 g29091 i0 96.667 91.9852941176471 270 9 99 0 2 271 2259 2528 Coccidia sp. clone C2.5 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 25020 449 1 Eukaryota Sar   Apicomplexa Conoidasida       Coccidia sp.
9929122 9929122 PRJNA1005695_P_NODE_29948_length_272_cov_7.753769_g29096_i0 PRJNA1005695 29948 272 7.753769 21.09025168 Goussia 169155 SAR_Eukaryotes SAR_Eukaryotes 483 7.47e-132   NTclustered gi|21304222|gb|AY043206.1| 169156 g29096 i0 98.889 98.0110294117647 270 3 99 0 2 271 127 396 Goussia janae small subunit ribosomal RNA, partial sequence blastn 26659 483 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia janae
10356562 10356562 PRJNA1005695_P_NODE_14549_length_399_cov_27.177914_g13697_i0 PRJNA1005695 14549 399 27.177914 108.43987686 Goussia bayae 2303416 SAR_Eukaryotes SAR_Eukaryotes 643 4.959999999999999e-180   NTclustered gi|1450318675|gb|MH758782.1| 2303416 g13697 i0 95.771 99.5789473684211 402 11 99 5 2 398 2007 1607 Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence blastn 39732 643 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia bayae
13754550 13754550 PRJNA1005695_P_NODE_34331_length_254_cov_0.850829_g33479_i0 PRJNA1005695 34331 254 0.850829 2.16110566 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|1976646559|ref|XM_039114055.1| 5851 g33479 i0 100 0.228346456692913 29 0 11 0 1 29 9639 9667 Plasmodium knowlesi strain H conserved Plasmodium protein, unknown function (PKNH_1218400), partial mRNA blastn 58 54.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
15456132 15456132 PRJNA1005695_P_NODE_24153_length_305_cov_10.750000_g23301_i0 PRJNA1005695 24153 305 10.75 32.7875 Goussia bayae 2303416 SAR_Eukaryotes SAR_Eukaryotes 501 2.35e-137   NTclustered gi|1450318675|gb|MH758782.1| 2303416 g23301 i0 96.393 100.590163934426 305 9 99 2 2 305 2805 2502 Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence blastn 30680 501 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia bayae
16303548 16303548 PRJNA1005695_P_NODE_13313_length_420_cov_3.423631_g12461_i0 PRJNA1005695 13313 420 3.423631 14.3792502 root 1 Root_unresolved Root_unresolved 56.5 0.003   NTclustered gi|84997470|ref|XM_948364.1| 5874 g12461 i0 100 0.15 30 0 7 0 89 118 352 381 Theileria annulata uncharacterized protein (TA11355), partial mRNA blastn 63 56.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria annulata
17578919 17578919 PRJNA1005695_P_NODE_20554_length_333_cov_1.003846_g19702_i0 PRJNA1005695 20554 333 1.003846 3.34280718 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 213 1.36e-50   NTclustered gi|8918237|dbj|AB023579.1| 5833 g19702 i0 79.048 6.54954954954955 315 62 94 4 1 313 888 1200 Plasmodium falciparum gene for elongation factor 2, partial cds blastn 2181 213 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
24379465 24379465 PRJNA1005695_P_NODE_18360_length_352_cov_36.086022_g17508_i0 PRJNA1005695 18360 352 36.086022 127.02279744 Goussia bayae 2303416 SAR_Eukaryotes SAR_Eukaryotes 549 9.679999999999996e-152   NTclustered gi|1450318675|gb|MH758782.1| 2303416 g17508 i0 94.872 72.7869318181818 351 18 99 0 1 351 3434 3084 Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence blastn 25621 549 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia bayae

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