RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA498309" 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

bioproject 1

  • PRJNA498309 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
3030978 3030978 PRJNA498309_P_NODE_105303_length_182_cov_2.103448_g103154_i0 PRJNA498309 105303 182 2.103448 3.82827536 Nitrospira sp. 70125 Bacteria Bacteria 226 8.619999999999999e-55   NTclustered gi|2194428397|gb|CP092079.1| 70125 g103154 i0 90.173 3.14835164835165 173 17 95 0 4 176 2600362 2600190 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 573 226 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
18332687 18332687 PRJNA498309_P_NODE_59615_length_329_cov_5.489726_g57467_i0 PRJNA498309 59615 329 5.489726 18.06119854 Nitrospira sp. 70125 Bacteria Bacteria 324 5.94e-84   NTclustered gi|2194428397|gb|CP092079.1| 70125 g57467 i0 85.902 0.927051671732523 305 42 92 1 15 318 711343 711647 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 305 324 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
18333994 18333994 PRJNA498309_S_NODE_38655_length_221_cov_6.403226_g36487_i0 PRJNA498309 38655 221 6.403226 14.15112946 uncultured Nitrospira sp. 157176 Bacteria Bacteria 281 2.29e-71   NTclustered gi|969812311|dbj|LC017023.1| 157176 g36487 i0 89.64 71.841628959276 222 22 100 1 1 221 350 571 Uncultured Nitrospira sp. gene for 16S ribosomal RNA, partial sequence, clone: EDay154C-CL65 blastn 15877 281 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira uncultured Nitrospira sp.
19606417 19606417 PRJNA498309_P_NODE_25356_length_572_cov_3.745794_g23417_i0 PRJNA498309 25356 572 3.745794 21.42594168 Nitrospira sp. 70125 Bacteria Bacteria 366 1.7699999999999993e-96   NTclustered gi|2194428397|gb|CP092079.1| 70125 g23417 i0 83.127 0.704545454545455 403 66 70 2 22 422 2658808 2658406 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 403 366 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
19607054 19607054 PRJNA498309_P_NODE_63156_length_313_cov_11.597826_g61008_i0 PRJNA498309 63156 313 11.597826 36.30119538 Nitrospira sp. 70125 Bacteria Bacteria 209 1.64e-49   NTclustered gi|2290911150|gb|CP060501.1| 70125 g61008 i0 80.435 0.881789137380192 276 52 88 2 14 288 2325533 2325807 MAG: Nitrospira sp. isolate NSFW chromosome, complete genome blastn 276 209 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
20884756 20884756 PRJNA498309_S_NODE_8737_length_885_cov_12.140000_g7064_i0 PRJNA498309 8737 885 12.14 107.439 Nitrospira sp. 70125 Bacteria Bacteria 833 0   NTclustered gi|2290911150|gb|CP060501.1| 70125 g7064 i0 84.634 0.955932203389831 846 120 95 9 23 863 2328400 2327560 MAG: Nitrospira sp. isolate NSFW chromosome, complete genome blastn 846 833 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23434047 23434047 PRJNA498309_P_NODE_95819_length_204_cov_2.694611_g93670_i0 PRJNA498309 95819 204 2.694611 5.49700644 Nitrospira sp. 70125 Bacteria Bacteria 233 5.919999999999999e-57   NTclustered gi|2290911150|gb|CP060501.1| 70125 g93670 i0 87.255 1 204 26 100 0 1 204 2327642 2327845 MAG: Nitrospira sp. isolate NSFW chromosome, complete genome blastn 204 233 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);;