RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA724039" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA724039 · 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
8364575 8364575 PRJNA724039_S_NODE_7887_length_236_cov_8.698492_g7680_i0 PRJNA724039 7887 236 8.698492 20.52844112 Nitrospira sp. KM1 1936990 Bacteria Bacteria 346 8.67e-91   NTclustered gi|1808878785|dbj|AP022671.1| 1936990 g7680 i0 98.469 174.800847457627 196 3 83 0 40 235 4207120 4206925 Nitrospira sp. KM1 DNA, complete genome blastn 41253 346 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. KM1
9639692 9639692 PRJNA724039_S_NODE_4288_length_342_cov_4.704918_g4081_i0 PRJNA724039 4288 342 4.704918 16.09081956 Nitrospira sp. 70125 Bacteria Bacteria 516 9.54e-142   NTclustered gi|2863129529|dbj|AP038806.1| 70125 g4081 i0 93.86 67.7309941520468 342 21 100 0 1 342 3063118 3062777 MAG: Nitrospira sp. NFB02 DNA, complete genome blastn 23164 516 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
12190404 12190404 PRJNA724039_S_NODE_14350_length_168_cov_3.740458_g14143_i0 PRJNA724039 14350 168 3.740458 6.28396944 Thermodesulfovibrio autotrophicus 3118333 Bacteria Bacteria 106 1.07e-18   NTclustered gi|2752966453|gb|CP144373.1| 3118333 g14143 i0 83.621 41.7202380952381 116 16 68 3 53 166 499566 499452 Thermodesulfovibrio autotrophicus strain 3907-1M chromosome, complete genome blastn 7009 106 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Thermodesulfovibrionaceae Thermodesulfovibrio Thermodesulfovibrio autotrophicus
14740217 14740217 PRJNA724039_S_NODE_17992_length_150_cov_11.389381_g17785_i0 PRJNA724039 17992 150 11.389381 17.0840715 Nitrospira sp. 70125 Bacteria Bacteria 233 4.07e-57   NTclustered gi|2290907019|gb|CP060499.1| 70125 g17785 i0 94.667 15.7933333333333 150 8 100 0 1 150 2684624 2684475 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 2369 233 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
19045945 19045945 PRJNA724039_S_NODE_1775_length_586_cov_6.843352_g1585_i0 PRJNA724039 1775 586 6.843352 40.10204272 Nitrospira 1234 Bacteria Bacteria 617 4.55e-172   NTclustered gi|2290907019|gb|CP060499.1| 70125 g1585 i0 96.765 514.878839590444 371 10 63 2 217 586 2683510 2683879 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 301719 617 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23664115 23664115 PRJNA724039_S_NODE_12639_length_180_cov_4.265734_g12432_i0 PRJNA724039 12639 180 4.265734 7.6783212 Nitrospira sp. 70125 Bacteria Bacteria 327 2.2699999999999996e-85   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g12432 i0 99.444 118.083333333333 180 1 100 0 1 180 2095226 2095047 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 21255 327 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);;