RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA414036", tax_kingdom = "Pseudomonadati" and tax_phylum = "Abditibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Abditibacteriota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA414036 · 6 ✖

analysis 1

tax_clade 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
1693502 1693502 PRJNA414036_P_NODE_22822_length_317_cov_4.716312_g21091_i0 PRJNA414036 22822 317 4.716312 14.95070904 Abditibacteriota bacterium 2783868 Bacteria Bacteria 137 7.97e-28   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g21091 i0 98.701 41.3596214511041 77 1 69 0 83 159 2852370 2852294 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 13111 137 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
8072131 8072131 PRJNA414036_P_NODE_79147_length_164_cov_3.922481_g77408_i0 PRJNA414036 79147 164 3.922481 6.43286884 Abditibacteriota bacterium 2783868 Bacteria Bacteria 141 2.84e-29   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g77408 i0 98.734 0.963414634146341 79 1 48 0 78 156 2851114 2851192 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 158 141 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
9346794 9346794 PRJNA414036_P_NODE_12128_length_410_cov_5.138667_g10527_i0 PRJNA414036 12128 410 5.138667 21.0685347 Abditibacteriota bacterium 2783868 Bacteria Bacteria 254 1.01e-62   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g10527 i0 94.012 3.71951219512195 167 10 77 0 10 176 2851545 2851711 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 1525 254 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
14447711 14447711 PRJNA414036_P_NODE_6592_length_487_cov_3.608407_g5426_i0 PRJNA414036 6592 487 3.608407 17.57294209 Abditibacteriota bacterium 2783868 Bacteria Bacteria 259 2.61e-64   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g5426 i0 93.22 31.8850102669405 177 11 66 1 147 322 2850851 2851027 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 15528 259 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
15721442 15721442 PRJNA414036_P_NODE_46913_length_231_cov_2.816327_g45174_i0 PRJNA414036 46913 231 2.816327 6.50571537 Abditibacteriota bacterium 2783868 Bacteria Bacteria 104 5.62e-18   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g45174 i0 100 36.4502164502165 56 0 24 0 20 75 2853408 2853463 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 8420 104 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
24645236 24645236 PRJNA414036_P_NODE_64840_length_198_cov_8.361963_g63101_i0 PRJNA414036 64840 198 8.361963 16.55668674 Abditibacteriota bacterium 2783868 Bacteria Bacteria 235 1.59e-57   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g63101 i0 88.889 76.3737373737374 198 12 95 4 1 189 2852555 2852359 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 15122 235 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota 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);;