RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB65329" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJEB65329 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1404589 1404589 PRJEB65329_S_NODE_15622_length_165_cov_2.735294_g15460_i0 PRJEB65329 15622 165 2.735294 4.5132351 Spumella-like flagellate 1031 373023 SAR_Eukaryotes SAR_Eukaryotes 252 1.27e-62   NTclustered gi|161015603|gb|EF577211.1| 373023 g15460 i0 94.479 92 163 9 99 0 3 165 753 591 Spumella-like flagellate 1031 actin gene, partial cds blastn 15180 252 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae   Spumella-like flagellate 1031
1404825 1404825 PRJEB65329_S_NODE_9362_length_228_cov_11.934673_g9200_i0 PRJEB65329 9362 228 11.934673 27.21105444 Licnophora cf. lyngbycola 696112 SAR_Eukaryotes SAR_Eukaryotes 231 2.43e-56   NTclustered gi|759083365|gb|KM222007.1| 696112 g9200 i0 85.088 16.4210526315789 228 32 99 2 2 228 73 299 Licnophora cf. lyngbycola voucher LWW2007110806 alpha-tubulin gene, partial cds blastn 3744 231 1 Eukaryota Sar   Ciliophora Heterotrichea Licnophorida Licnophoridae Licnophora Licnophora cf. lyngbycola
2269098 2269098 PRJEB65329_S_NODE_11682_length_197_cov_3.553571_g11520_i0 PRJEB65329 11682 197 3.553571 7.00053487 Chromulinales 96792 SAR_Eukaryotes SAR_Eukaryotes 200 5.759999999999999e-47   NTclustered gi|161015561|gb|EF577185.1| 293189 g11520 i0 85.128 81.4416243654822 195 29 99 0 3 197 250 444 Spumella-like flagellate JBNZ41 beta-tubulin gene, partial cds blastn 16044 202 0.99009900990099 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBNZ41
2680142 2680142 PRJEB65329_S_NODE_13683_length_179_cov_2.260000_g13521_i0 PRJEB65329 13683 179 2.26 4.0454 Plasmodium coatneyi 208452 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|1139863046|ref|XM_020059359.1| 208452 g13521 i0 100 0.162011173184358 29 0 16 0 112 140 1102 1130 Plasmodium coatneyi Calcium-dependent protein kinase 3 partial mRNA blastn 29 54.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium coatneyi
2680357 2680357 PRJEB65329_S_NODE_6983_length_281_cov_3.730159_g6821_i0 PRJEB65329 6983 281 3.730159 10.48174679 Spumella-like flagellate JBM08 293212 SAR_Eukaryotes SAR_Eukaryotes 366 8.15e-97   NTclustered gi|161015624|gb|EF577223.1| 293212 g6821 i0 90.323 68.2562277580071 279 27 99 0 3 281 283 561 Spumella-like flagellate JBM08 alpha-tubulin gene, partial cds blastn 19180 366 1 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBM08
7782372 7782372 PRJEB65329_S_NODE_11707_length_197_cov_2.922619_g11545_i0 PRJEB65329 11707 197 2.922619 5.75755943 Spumella-like flagellate JBM18 293206 SAR_Eukaryotes SAR_Eukaryotes 220 4.42e-53   NTclustered gi|161015626|gb|EF577224.1| 293206 g11545 i0 86.802 38.8832487309645 197 26 100 0 1 197 1036 840 Spumella-like flagellate JBM18 alpha-tubulin gene, partial cds blastn 7660 220 1 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBM18
11608800 11608800 PRJEB65329_S_NODE_9510_length_226_cov_3.081218_g9348_i0 PRJEB65329 9510 226 3.081218 6.96355268 Spumella-like flagellate JBM08 293212 SAR_Eukaryotes SAR_Eukaryotes 279 8.48e-71   NTclustered gi|161015566|gb|EF577188.1| 293212 g9348 i0 88.938 96.9646017699115 226 25 100 0 1 226 492 267 Spumella-like flagellate JBM08 beta-tubulin gene, partial cds blastn 21914 279 1 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBM08
15432642 15432642 PRJEB65329_S_NODE_7313_length_271_cov_5.334711_g7151_i0 PRJEB65329 7313 271 5.334711 14.45706681 Spumella sp. OF-40 1432661 SAR_Eukaryotes SAR_Eukaryotes 331 2.8500000000000002e-86   NTclustered gi|677286268|gb|KF997856.1| 1432661 g7151 i0 89.883 80.3247232472325 257 26 95 0 15 271 991 1247 Spumella sp. OF-40 translation elongation factor 1-alpha (EF1A) mRNA, complete cds blastn 21768 331 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Spumella Spumella sp. OF-40
15432648 15432648 PRJEB65329_S_NODE_7513_length_266_cov_3.379747_g7351_i0 PRJEB65329 7513 266 3.379747 8.99012702 Spumella-like flagellate JBNZ39 293202 SAR_Eukaryotes SAR_Eukaryotes 353 5.95e-93   NTclustered gi|161015632|gb|EF577227.1| 293202 g7351 i0 90.602 97.5263157894737 266 25 100 0 1 266 296 31 Spumella-like flagellate JBNZ39 alpha-tubulin gene, partial cds blastn 25942 353 1 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBNZ39
17981837 17981837 PRJEB65329_S_NODE_9375_length_228_cov_3.437186_g9213_i0 PRJEB65329 9375 228 3.437186 7.83678408 Spumella-like flagellate Got220 441774 SAR_Eukaryotes SAR_Eukaryotes 259 1.12e-64   NTclustered gi|161015585|gb|EF577199.1| 441774 g9213 i0 87.225 61.4166666666667 227 29 99 0 2 228 117 343 Spumella-like flagellate Got220 beta-tubulin-like gene, partial sequence blastn 14003 259 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae   Spumella-like flagellate Got220
19255629 19255629 PRJEB65329_S_NODE_16296_length_161_cov_2.674242_g16134_i0 PRJEB65329 16296 161 2.674242 4.30552962 Toxoplasma gondii 5811 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|820696656|tpe|LN714493.1| 432359 g16134 i0 100 0.186335403726708 30 0 19 0 86 115 2349734 2349705 TPA_asm: Toxoplasma gondii VEG, chromosome chrIV, complete genome blastn 30 56.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Toxoplasma Toxoplasma gondii
20531191 20531191 PRJEB65329_S_NODE_6977_length_281_cov_4.666667_g6815_i0 PRJEB65329 6977 281 4.666667 13.11333427 Spumella-like flagellate JBM08 293212 SAR_Eukaryotes SAR_Eukaryotes 320 6.43e-83   NTclustered gi|161015624|gb|EF577223.1| 293212 g6815 i0 87.189 65.4697508896797 281 36 100 0 1 281 121 401 Spumella-like flagellate JBM08 alpha-tubulin gene, partial cds blastn 18397 320 1 Eukaryota Sar     Chrysophyceae       Spumella-like flagellate JBM08
21807005 21807005 PRJEB65329_S_NODE_8958_length_235_cov_3.621359_g8796_i0 PRJEB65329 8958 235 3.621359 8.51019365 Wobblia lunata 104657 SAR_Eukaryotes SAR_Eukaryotes 220 5.46e-53   NTclustered gi|2163288121|gb|MZ440312.1| 104657 g8796 i0 89.326 63.9446808510638 178 16 74 1 1 175 1181 1358 Wobblia lunata strain NIES-1015 alpha-tubulin mRNA, complete cds blastn 15027 220 1 Eukaryota Sar     Bigyra Placidida Placidiaceae Wobblia Wobblia lunata
23081908 23081908 PRJEB65329_S_NODE_11399_length_200_cov_3.578947_g11237_i0 PRJEB65329 11399 200 3.578947 7.157894 Poteriospumella lacustris 1117027 SAR_Eukaryotes SAR_Eukaryotes 270 4.4099999999999986e-68   NTclustered gi|161015559|gb|EF577184.1| 1117027 g11237 i0 91 94.82 200 18 100 0 1 200 766 567 Spumella-like flagellate JBM10 beta-tubulin gene, partial cds blastn 18964 270 1 Eukaryota Sar     Chrysophyceae Chromulinales Dinobryaceae Poteriospumella Poteriospumella lacustris
23082171 23082171 PRJEB65329_S_NODE_8259_length_249_cov_2.459091_g8097_i0 PRJEB65329 8259 249 2.459091 6.12313659 Chrysophyceae sp. 1955566 SAR_Eukaryotes SAR_Eukaryotes 405 1.5e-108   NTclustered gi|1209182930|gb|KX100672.1| 1955566 g8097 i0 98.268 73.9156626506024 231 4 93 0 16 246 1 231 Chrysophyceae sp. strain 9-6-B2 28S ribosomal RNA gene, partial sequence blastn 18405 405 1 Eukaryota Sar     Chrysophyceae       Chrysophyceae sp.

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