RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA591000", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA591000 · 7 ✖

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
26952965 26952965 PRJNA591000_P_NODE_16042_length_183_cov_1.415584_g14436_i0 PRJNA591000 16042 183 1.415584 2.59051872 Nitrospira sp. 70125 Bacteria Bacteria 63.5 4.1e-10   NR HNG00902.1 70125 g14436 i0 63.8 0.770491803278688 47 17 77 0 30 170 167 213 HNG00902.1 DNA polymerase [Nitrospira sp.] diamond 141 63.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28279623 28279623 PRJNA591000_P_NODE_7086_length_527_cov_1.901606_g5665_i0 PRJNA591000 7086 527 1.901606 10.02146362 Nitrospira sp. 70125 Bacteria Bacteria 82 1.57e-14   NR HNE33139.1 70125 g5665 i0 88.9 0.307400379506641 54 6 30.7 0 366 527 595 648 HNE33139.1 hypothetical protein [Nitrospira sp.] diamond 162 82 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30440833 30440833 PRJNA591000_P_NODE_2113_length_892_cov_13.412514_g1563_i0 PRJNA591000 2113 892 13.412514 119.63962488 Pseudomonadati 3379134 Bacteria Bacteria 200 2.21e-59   NR HDZ62303.1 2026887 g1563 i0 77.1 1.62443946188341 118 26 39.7 1 525 878 1 117 HDZ62303.1 DNA cytosine methyltransferase [Nitrospirota bacterium] diamond 1449 200 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31596942 31596942 PRJNA591000_P_NODE_6816_length_538_cov_3.165029_g5427_i0 PRJNA591000 6816 538 3.165029 17.02785602 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 68.6 7.4e-10   NR MEE8608592.1 2026770 g5427 i0 40.4 0.99814126394052 89 49 47.4 1 283 537 259 347 MEE8608592.1 helicase C-terminal domain-containing protein [Nitrospiraceae bacterium] diamond 537 68.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31723125 31723125 PRJNA591000_P_NODE_1577_length_980_cov_6.218717_g1133_i0 PRJNA591000 1577 980 6.218717 60.9434266 Nitrospira sp. 70125 Bacteria Bacteria 208 2.47e-63   NR MEQ1845250.1 70125 g1133 i0 88.7 0.352040816326531 115 13 35.2 0 184 528 1 115 MEQ1845250.1 hypothetical protein [Nitrospira sp.] diamond 345 208 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32071194 32071194 PRJNA591000_P_NODE_8438_length_478_cov_4.425390_g6917_i0 PRJNA591000 8438 478 4.42539 21.1533642 Nitrospira sp. 70125 Bacteria Bacteria 186 3.16e-57   NR HAN93877.1 70125 g6917 i0 92.4 0.658995815899582 105 8 65.9 0 164 478 16 120 HAN93877.1 hypothetical protein [Nitrospira sp.] diamond 315 186 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32419352 32419352 PRJNA591000_P_NODE_699_length_1265_cov_9.145631_g474_i0 PRJNA591000 699 1265 9.145631 115.69223215 Nitrospira sp. 70125 Bacteria Bacteria 70.1 2.48e-11   NR TKB76832.1 70125 g474 i0 56.6 1.17154150197628 53 20 11.9 1 308 457 1 53 TKB76832.1 MAG: hypothetical protein E8D45_05505 [Nitrospira sp.] diamond 1482 70.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira 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);;