RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA744060 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
1999223 1999223 PRJNA744060_P_NODE_26882_length_314_cov_1.937759_g26553_i0 PRJNA744060 26882 314 1.937759 6.08456326 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 62.1 4.88e-5   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g26553 i0 92.857 0.133757961783439 42 3 13 0 241 282 4348239 4348280 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 42 62.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
4551589 4551589 PRJNA744060_P_NODE_1904_length_1081_cov_2.085317_g1700_i0 PRJNA744060 1904 1081 2.085317 22.54227677 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 1472 0   NTclustered gi|2874253757|emb|OY969698.1| 100233 g1700 i0 91.236 127.072155411656 1084 91 100 4 1 1081 4421793 4422875 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 137365 1472 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
9651494 9651494 PRJNA744060_P_NODE_17088_length_389_cov_3.022152_g16759_i0 PRJNA744060 17088 389 3.022152 11.75617128 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.8 0.037   NTclustered gi|1850852299|gb|CP053450.1| 2026780 g16759 i0 96.774 0.0796915167095116 31 1 8 0 342 372 3097683 3097713 MAG: Planctomycetota bacterium isolate PNC22 chromosome blastn 31 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
16025926 16025926 PRJNA744060_P_NODE_32973_length_286_cov_2.793427_g32644_i0 PRJNA744060 32973 286 2.793427 7.98920122 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 407 4.9e-109   NTclustered gi|2874253948|emb|OY970273.1| 100233 g32644 i0 92.334 143.076923076923 287 20 100 2 1 286 2620676 2620961 MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 blastn 40920 407 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
17301521 17301521 PRJNA744060_P_NODE_3814_length_800_cov_3.735901_g3532_i0 PRJNA744060 3814 800 3.735901 29.887208 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 918 0   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g3532 i0 87.863 92.565 791 84 98 10 1 782 1866224 1867011 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 74052 918 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
17776232 17776232 PRJNA744060_P_NODE_20754_length_355_cov_1.641844_g20425_i0 PRJNA744060 20754 355 1.641844 5.8285462 root 1 Root_unresolved Root_unresolved 75 7.17e-9   NTclustered gi|1712520392|gb|CP036316.1| 2528027 g20425 i0 86.111 3.10985915492958 72 7 20 2 178 249 4595780 4595712 Calycomorphotria hydatis strain V22 chromosome blastn 1104 75 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Calycomorphotria Calycomorphotria hydatis
18574821 18574821 PRJNA744060_P_NODE_20975_length_353_cov_2.085714_g20646_i0 PRJNA744060 20975 353 2.085714 7.36257042 Planctomycetes bacterium syqfu 2896527 Bacteria Bacteria 180 1.47e-40   NTclustered gi|2155219436|gb|CP087563.1| 2896527 g20646 i0 81.057 25.7252124645892 227 41 64 2 60 285 422844 422619 Planctomycetes bacterium syqfu chromosome, complete genome blastn 9081 180 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium syqfu
19850662 19850662 PRJNA744060_P_NODE_53276_length_232_cov_2.893082_g52947_i0 PRJNA744060 53276 232 2.893082 6.71195024 Phycisphaerae bacterium RAS2 2528035 Bacteria Bacteria 137 5.569999999999999e-28   NTclustered gi|1712788464|gb|CP036352.1| 2528035 g52947 i0 81.437 9.22413793103448 167 31 72 0 5 171 3619968 3619802 Phycisphaerae bacterium RAS2 chromosome, complete genome blastn 2140 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium RAS2
21125529 21125529 PRJNA744060_P_NODE_14877_length_416_cov_3.545190_g14548_i0 PRJNA744060 14877 416 3.54519 14.7479904 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 545 1.5099999999999996e-150   NTclustered gi|1938775668|gb|CP054178.1| 2026777 g14548 i0 90.361 513.165865384615 415 40 99 0 1 415 192371 192785 MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome blastn 213477 545 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
22400531 22400531 PRJNA744060_P_NODE_19538_length_365_cov_2.493151_g19209_i0 PRJNA744060 19538 365 2.493151 9.10000115 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 538 2.1799999999999998e-148   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g19209 i0 93.048 130.78904109589 374 17 100 6 1 365 2582131 2581758 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 47738 538 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium

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