RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA884104", tax_clade = "Sar" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA884104 · 18 ✖

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
13613930 13613930 PRJNA884104_S_NODE_19471_length_457_cov_1.195312_g18728_i0 PRJNA884104 19471 457 1.195312 5.46257584 Miliammina fusca 302103 SAR_Eukaryotes SAR_Eukaryotes 318 3.96e-82   NTclustered gi|59859617|gb|AY763994.1| 302103 g18728 i0 79.258 78.7221006564551 458 93 100 2 1 457 919 463 Miliammina fusca clone MmA1318_41 actin type 2 gene, partial cds blastn 35976 318 1 Eukaryota Sar   Foraminifera     Rzehakinidae Miliammina Miliammina fusca
16163479 16163479 PRJNA884104_S_NODE_40773_length_324_cov_1.848606_g40030_i0 PRJNA884104 40773 324 1.848606 5.98948344 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 92 1.05e-20   NR ETO03070.1 46433 g40030 i0 75.4 4.18518518518519 57 14 52.8 0 2 172 131 187 ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] diamond 1356 92 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
17818700 17818700 PRJNA884104_S_NODE_10894_length_612_cov_1.552876_g10175_i0 PRJNA884104 10894 612 1.552876 9.50360112 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 200 1.22e-56   NR ETO16925.1 46433 g10175 i0 70.1 2.13725490196078 147 40 71.1 2 23 457 464 608 ETO16925.1 hypothetical protein RFI_20413 [Reticulomyxa filosa] diamond 1308 200 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
26770577 26770577 PRJNA884104_S_NODE_30661_length_369_cov_1.040541_g29918_i0 PRJNA884104 30661 369 1.040541 3.83959629 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 97.4 5.480000000000001e-21   NR ETO18718.1 46433 g29918 i0 49.5 0.821138211382114 101 47 78.9 3 54 344 224 324 ETO18718.1 hypothetical protein RFI_18539 [Reticulomyxa filosa] diamond 303 97.4 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27466365 27466365 PRJNA884104_S_NODE_16583_length_494_cov_1.463183_g15845_i0 PRJNA884104 16583 494 1.463183 7.22812402 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0292   NR ETO04255.1 46433 g15845 i0 23.3 1.09311740890688 180 95 99 6 1 489 1823 1976 ETO04255.1 hypothetical protein RFI_33142, partial [Reticulomyxa filosa] diamond 540 46.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27695461 27695461 PRJNA884104_S_NODE_77024_length_246_cov_0.890173_g76281_i0 PRJNA884104 77024 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.24e-11   NR ETO04255.1 46433 g76281 i0 45.9 5.10975609756098 85 42 98.8 2 2 244 2334 2418 ETO04255.1 hypothetical protein RFI_33142, partial [Reticulomyxa filosa] diamond 1257 69.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27750635 27750635 PRJNA884104_S_NODE_31364_length_365_cov_1.318493_g30621_i0 PRJNA884104 31364 365 1.318493 4.81249945 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 133 1.44e-33   NR ETO27916.1 46433 g30621 i0 54.9 1.92328767123288 113 49 91.2 1 1 333 503 615 ETO27916.1 alpha-1,2-mannosidase, partial [Reticulomyxa filosa] diamond 702 133 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28097663 28097663 PRJNA884104_S_NODE_55465_length_281_cov_1.110577_g54722_i0 PRJNA884104 55465 281 1.110577 3.12072137 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 122 7.04e-33   NR ETO05185.1 46433 g54722 i0 54.8 0.99288256227758 93 42 99.3 0 280 2 70 162 ETO05185.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] diamond 279 122 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28381859 28381859 PRJNA884104_S_NODE_41086_length_323_cov_1.540000_g40343_i0 PRJNA884104 41086 323 1.54 4.9742 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 121 2.67e-29   NR ETO05095.1 46433 g40343 i0 61.9 1.95046439628483 105 37 97.5 1 8 322 47 148 ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] diamond 630 121 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28413541 28413541 PRJNA884104_S_NODE_35066_length_347_cov_1.124088_g34323_i0 PRJNA884104 35066 347 1.124088 3.90058536 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 84.7 7.31e-17   NR ETO07542.1 46433 g34323 i0 43.7 0.890489913544669 103 46 89 2 310 2 23 113 ETO07542.1 hypothetical protein RFI_29850 [Reticulomyxa filosa] diamond 309 84.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28571253 28571253 PRJNA884104_S_NODE_43607_length_315_cov_1.148760_g42864_i0 PRJNA884104 43607 315 1.14876 3.618594 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 61.6 1.91e-8   NR ETO31968.1 46433 g42864 i0 34 2.03809523809524 106 64 95.2 3 1 300 92 197 ETO31968.1 CMGC family protein kinase [Reticulomyxa filosa] diamond 642 61.6 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28855280 28855280 PRJNA884104_S_NODE_32268_length_360_cov_2.097561_g31525_i0 PRJNA884104 32268 360 2.097561 7.5512196 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 172 3.3299999999999992e-52   NR ETO17530.1 46433 g31525 i0 86.5 0.8 96 13 80 0 355 68 96 191 ETO17530.1 hypothetical protein RFI_19788 [Reticulomyxa filosa] diamond 288 172 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28886945 28886945 PRJNA884104_S_NODE_45908_length_308_cov_0.982979_g45165_i0 PRJNA884104 45908 308 0.982979 3.02757532 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 66.2 3.47e-10   NR ETO18614.1 46433 g45165 i0 47.5 0.574675324675325 59 29 55.5 1 135 305 72 130 ETO18614.1 hypothetical protein RFI_18649, partial [Reticulomyxa filosa] diamond 177 66.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29454992 29454992 PRJNA884104_S_NODE_23130_length_421_cov_1.002874_g22387_i0 PRJNA884104 23130 421 1.002874 4.22209954 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.87e-10   NR ETN98168.1 46433 g22387 i0 44.7 1.08313539192399 76 35 54.2 2 25 252 392 460 ETN98168.1 hypothetical protein RFI_39346 [Reticulomyxa filosa] diamond 456 68.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29581370 29581370 PRJNA884104_S_NODE_63230_length_262_cov_1.523810_g62487_i0 PRJNA884104 63230 262 1.52381 3.9923822 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 64.7 8.99e-10   NR ETO26409.1 46433 g62487 i0 57.6 1.35114503816794 59 20 67.6 2 86 262 879 932 ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] diamond 354 64.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30024017 30024017 PRJNA884104_S_NODE_51571_length_291_cov_1.766055_g50828_i0 PRJNA884104 51571 291 1.766055 5.13922005 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 159 3.4099999999999996e-47   NR ETO03070.1 46433 g50828 i0 81.3 2.95876288659794 96 18 99 0 290 3 29 124 ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] diamond 861 159 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30623972 30623972 PRJNA884104_S_NODE_43253_length_316_cov_1.267490_g42510_i0 PRJNA884104 43253 316 1.26749 4.0052684 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 163 2.11e-44   NR ETO28442.1 46433 g42510 i0 73.8 2.88607594936709 103 27 97.8 0 3 311 584 686 ETO28442.1 hypothetical protein RFI_08694, partial [Reticulomyxa filosa] diamond 912 163 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31825260 31825260 PRJNA884104_S_NODE_52677_length_288_cov_1.776744_g51934_i0 PRJNA884104 52677 288 1.776744 5.11702272 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00371   NR ETO30045.1 46433 g51934 i0 35.7 0.729166666666667 70 44 71.9 1 288 82 33 102 ETO30045.1 deoxyribonuclease-2-alpha [Reticulomyxa filosa] diamond 210 46.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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