RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 28 ✖

bioproject 1

  • PRJNA1113956 · 28 ✖

analysis 1

  • blastn · 28 ✖

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
1023692 1023692 PRJNA1113956_P_NODE_12181_length_374_cov_8.637874_g11841_i0 PRJNA1113956 12181 374 8.637874 32.30564876 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 691 0   NTclustered gi|1802599797|gb|MT001206.1| 41631 g11841 i0 100 99.1550802139037 374 0 100 0 1 374 509 882 Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence blastn 37084 691 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
2299217 2299217 PRJNA1113956_P_NODE_16002_length_301_cov_2.026316_g15662_i0 PRJNA1113956 16002 301 2.026316 6.09921116 root 1 Root_unresolved Root_unresolved 473 5.04e-129   NTclustered gi|166046607|emb|CU367724.1| 100861 g15662 i0 95.017 14.9102990033223 301 15 100 0 1 301 268 568 Aphanomyces euteiches cDNA blastn 4488 473 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2299255 2299255 PRJNA1113956_P_NODE_18942_length_260_cov_1.647059_g18602_i0 PRJNA1113956 18942 260 1.647059 4.2823534 root 1 Root_unresolved Root_unresolved 446 9.3e-121   NTclustered gi|166046535|emb|CU367652.1| 100861 g18602 i0 97.683 99.3346153846154 259 6 99 0 1 259 197 455 Aphanomyces euteiches cDNA blastn 25827 446 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
5324796 5324796 PRJNA1113956_P_NODE_10565_length_422_cov_1.323782_g10226_i0 PRJNA1113956 10565 422 1.323782 5.58636004 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 691 0   NTclustered gi|166044528|emb|CU367437.1| 100861 g10226 i0 96.209 20.3293838862559 422 16 100 0 1 422 134 555 Aphanomyces euteiches cDNA blastn 8579 691 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
5324835 5324835 PRJNA1113956_P_NODE_14485_length_327_cov_0.909449_g14145_i0 PRJNA1113956 14485 327 0.909449 2.97389823 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 566 8.879999999999998e-157   NTclustered gi|166044608|emb|CU367517.1| 100861 g14145 i0 97.859 99.7247706422018 327 7 100 0 1 327 687 361 Aphanomyces euteiches cDNA blastn 32610 566 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
6126681 6126681 PRJNA1113956_P_NODE_11945_length_381_cov_1.500000_g11605_i0 PRJNA1113956 11945 381 1.5 5.715 root 1 Root_unresolved Root_unresolved 627 4.7499999999999997e-175   NTclustered gi|166044505|emb|CU367414.1| 100861 g11605 i0 96.325 99.5380577427822 381 14 100 0 1 381 412 792 Aphanomyces euteiches cDNA blastn 37924 627 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
7401568 7401568 PRJNA1113956_P_NODE_12206_length_374_cov_1.019934_g11866_i0 PRJNA1113956 12206 374 1.019934 3.81455316 root 1 Root_unresolved Root_unresolved 586 7.889999999999998e-163   NTclustered gi|166046505|emb|CU367622.1| 100861 g11866 i0 94.92 82.8689839572193 374 19 100 0 1 374 568 195 Aphanomyces euteiches cDNA blastn 30993 586 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
11227069 11227069 PRJNA1113956_P_NODE_11369_length_397_cov_0.950617_g11029_i0 PRJNA1113956 11369 397 0.950617 3.77394949 root 1 Root_unresolved Root_unresolved 678 0   NTclustered gi|166046483|emb|CU367600.1| 100861 g11029 i0 97.481 72.0906801007557 397 10 100 0 1 397 190 586 Aphanomyces euteiches cDNA blastn 28620 678 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
11227105 11227105 PRJNA1113956_P_NODE_13289_length_349_cov_1.039855_g12949_i0 PRJNA1113956 13289 349 1.039855 3.62909395 root 1 Root_unresolved Root_unresolved 612 1.21e-170   NTclustered gi|166046554|emb|CU367671.1| 100861 g12949 i0 98.281 99.9255014326648 349 6 100 0 1 349 429 81 Aphanomyces euteiches cDNA blastn 34874 612 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
11227108 11227108 PRJNA1113956_P_NODE_13429_length_345_cov_2.011029_g13089_i0 PRJNA1113956 13429 345 2.011029 6.93805005 root 1 Root_unresolved Root_unresolved 599 9.299999999999998e-167   NTclustered gi|166044590|emb|CU367499.1| 100861 g13089 i0 97.971 100.040579710145 345 7 100 0 1 345 441 97 Aphanomyces euteiches cDNA blastn 34514 604 0.991721854304636 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12502602 12502602 PRJNA1113956_P_NODE_13950_length_335_cov_4.503817_g13610_i0 PRJNA1113956 13950 335 4.503817 15.08778695 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 619 6.91e-173   NTclustered gi|89077592|gb|DQ388599.1| 63136 g13610 i0 100 99.5283582089552 335 0 100 0 1 335 14 348 Colpoda steinii strain Sp1 small subunit ribosomal RNA gene, partial sequence blastn 33342 619 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
12502649 12502649 PRJNA1113956_P_NODE_17670_length_277_cov_1.509804_g17330_i0 PRJNA1113956 17670 277 1.509804 4.18215708 root 1 Root_unresolved Root_unresolved 457 4.62e-124   NTclustered gi|166046506|emb|CU367623.1| 100861 g17330 i0 96.39 100.285198555957 277 10 100 0 1 277 301 25 Aphanomyces euteiches cDNA blastn 27779 457 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12502675 12502675 PRJNA1113956_P_NODE_19270_length_256_cov_1.262295_g18930_i0 PRJNA1113956 19270 256 1.262295 3.2314752 root 1 Root_unresolved Root_unresolved 446 9.139999999999999e-121   NTclustered gi|166044576|emb|CU367485.1| 100861 g18930 i0 98.047 95.7265625 256 5 100 0 1 256 436 181 Aphanomyces euteiches cDNA blastn 24506 446 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
13777088 13777088 PRJNA1113956_P_NODE_15191_length_314_cov_3.045643_g14851_i0 PRJNA1113956 15191 314 3.045643 9.56331902 root 1 Root_unresolved Root_unresolved 558 1.42e-154   NTclustered gi|166044554|emb|CU367463.1| 100861 g14851 i0 98.726 99.5923566878981 314 4 100 0 1 314 352 39 Aphanomyces euteiches cDNA blastn 31272 558 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
14250848 14250848 PRJNA1113956_P_NODE_13872_length_337_cov_1.424242_g13532_i0 PRJNA1113956 13872 337 1.424242 4.79969554 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 579 1.1799999999999999e-160   NTclustered gi|166046631|emb|CU367748.1| 100861 g13532 i0 97.626 98.4421364985163 337 8 100 0 1 337 422 86 Aphanomyces euteiches cDNA blastn 33175 579 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
15051504 15051504 PRJNA1113956_P_NODE_20512_length_248_cov_1.320000_g20172_i0 PRJNA1113956 20512 248 1.32 3.2736 root 1 Root_unresolved Root_unresolved 459 1.13e-124   NTclustered gi|166046729|emb|CU367839.1| 100861 g20172 i0 100 98.6653225806452 248 0 100 0 1 248 283 36 Aphanomyces euteiches cDNA blastn 24469 459 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16326348 16326348 PRJNA1113956_P_NODE_17933_length_273_cov_1.995000_g17593_i0 PRJNA1113956 17933 273 1.995 5.44635 root 1 Root_unresolved Root_unresolved 499 7.45e-137   NTclustered gi|166044487|emb|CU367396.1| 100861 g17593 i0 99.634 99.978021978022 273 1 100 0 1 273 815 543 Aphanomyces euteiches cDNA blastn 27294 499 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17601484 17601484 PRJNA1113956_P_NODE_14114_length_333_cov_0.888462_g13774_i0 PRJNA1113956 14114 333 0.888462 2.95857846 root 1 Root_unresolved Root_unresolved 582 8.999999999999997e-162   NTclustered gi|166046581|emb|CU367698.1| 100861 g13774 i0 98.198 26.9339339339339 333 6 100 0 1 333 5 337 Aphanomyces euteiches cDNA blastn 8969 582 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18073520 18073520 PRJNA1113956_P_NODE_12615_length_364_cov_1.003436_g12275_i0 PRJNA1113956 12615 364 1.003436 3.65250704 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.035   NTclustered gi|145509286|ref|XM_001440550.1| 5888 g12275 i0 100 0.0769230769230769 28 0 8 0 50 77 1433 1406 Paramecium tetraurelia uncharacterized protein (GSPATT00038846001), partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
21425756 21425756 PRJNA1113956_P_NODE_11517_length_393_cov_0.946875_g11177_i0 PRJNA1113956 11517 393 0.946875 3.72121875 root 1 Root_unresolved Root_unresolved 699 0   NTclustered gi|166046615|emb|CU367732.1| 100861 g11177 i0 98.728 97.64631043257 393 5 100 0 1 393 558 166 Aphanomyces euteiches cDNA blastn 38375 699 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21425872 21425872 PRJNA1113956_P_NODE_19277_length_256_cov_1.262295_g18937_i0 PRJNA1113956 19277 256 1.262295 3.2314752 root 1 Root_unresolved Root_unresolved 431 2.56e-116   NTclustered gi|166044599|emb|CU367508.1| 100861 g18937 i0 98.367 98.71484375 245 4 96 0 12 256 268 24 Aphanomyces euteiches cDNA blastn 25271 431 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21425880 21425880 PRJNA1113956_P_NODE_19977_length_250_cov_0.870056_g19637_i0 PRJNA1113956 19977 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 446 8.89e-121   NTclustered gi|166046677|emb|CU367787.1| 100861 g19637 i0 98.8 96.78 250 3 100 0 1 250 431 680 Aphanomyces euteiches cDNA blastn 24195 446 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
22700737 22700737 PRJNA1113956_P_NODE_16958_length_287_cov_1.079439_g16618_i0 PRJNA1113956 16958 287 1.079439 3.09798993 root 1 Root_unresolved Root_unresolved 525 1.2999999999999995e-144   NTclustered gi|166046587|emb|CU367704.1| 100861 g16618 i0 99.652 100.094076655052 287 1 100 0 1 287 322 608 Aphanomyces euteiches cDNA blastn 28727 525 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
22700891 22700891 PRJNA1113956_P_NODE_6478_length_635_cov_1.240214_g6154_i0 PRJNA1113956 6478 635 1.240214 7.8753589 root 1 Root_unresolved Root_unresolved 1112 0   NTclustered gi|166046470|emb|CU367587.1| 100861 g6154 i0 98.268 109.007874015748 635 11 100 0 1 635 83 717 Aphanomyces euteiches cDNA blastn 69220 1118 0.994633273703041 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23976034 23976034 PRJNA1113956_P_NODE_10519_length_423_cov_1.320000_g10180_i0 PRJNA1113956 10519 423 1.32 5.5836 root 1 Root_unresolved Root_unresolved 726 0   NTclustered gi|166044580|emb|CU367489.1| 100861 g10180 i0 97.636 61.3617021276596 423 10 100 0 1 423 243 665 Aphanomyces euteiches cDNA blastn 25956 726 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23976145 23976145 PRJNA1113956_P_NODE_18739_length_263_cov_1.215789_g18399_i0 PRJNA1113956 18739 263 1.215789 3.19752507 root 1 Root_unresolved Root_unresolved 442 1.2199999999999994e-119   NTclustered gi|166046476|emb|CU367593.1| 100861 g18399 i0 96.958 12.9087452471483 263 8 100 0 1 263 348 86 Aphanomyces euteiches cDNA blastn 3395 442 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23976176 23976176 PRJNA1113956_P_NODE_21699_length_244_cov_1.321637_g21359_i0 PRJNA1113956 21699 244 1.321637 3.22479428 root 1 Root_unresolved Root_unresolved 396 8.829999999999997e-106   NTclustered gi|166044655|emb|CU367564.1| 100861 g21359 i0 95.902 20.0450819672131 244 10 100 0 1 244 385 142 Aphanomyces euteiches cDNA blastn 4891 396 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
25250174 25250174 PRJNA1113956_P_NODE_21420_length_245_cov_0.895349_g21080_i0 PRJNA1113956 21420 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 401 1.9099999999999994e-107   NTclustered gi|166044533|emb|CU367442.1| 100861 g21080 i0 96.311 30.6489795918367 244 9 99 0 2 245 362 605 Aphanomyces euteiches cDNA blastn 7509 401 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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