RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939415 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
9843959 9843959 PRJNA939415_P_NODE_67208_length_266_cov_4.056995_g66786_i0 PRJNA939415 67208 266 4.056995 10.791606700000001 Nitrospira sp. 70125 Bacteria Bacteria 147 1.08e-30   NTclustered gi|2511635996|gb|CP126122.1| 70125 g66786 i0 84.828 0.545112781954887 145 22 55 0 1 145 4164848 4164992 MAG: Nitrospira sp. isolate bin_005 chromosome blastn 145 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17494748 17494748 PRJNA939415_P_NODE_94474_length_242_cov_0.911243_g94052_i0 PRJNA939415 94474 242 0.911243 2.20520806 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 351 1.92e-92   NTclustered gi|2449729286|gb|CP114553.1| 2927580 g94052 i0 92.946 99.504132231405 241 17 99 0 1 241 903469 903229 MAG: Candidatus Manganitrophus sp. isolate GAC1 chromosome, complete genome blastn 24080 351 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
20041686 20041686 PRJNA939415_P_NODE_19116_length_356_cov_5.742049_g18696_i0 PRJNA939415 19116 356 5.742049 20.44169444 Nitrospira sp. 70125 Bacteria Bacteria 147 1.5e-30   NTclustered gi|2863129529|dbj|AP038806.1| 70125 g18696 i0 83.23 1.13202247191011 161 25 45 2 165 324 3851543 3851702 MAG: Nitrospira sp. NFB02 DNA, complete genome blastn 403 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21317875 21317875 PRJNA939415_P_NODE_57257_length_276_cov_3.463054_g56835_i0 PRJNA939415 57257 276 3.463054 9.55802904 Leptospirillum sp. Group II 'CF-1' 1660083 Bacteria Bacteria 183 8.629999999999998e-42   NTclustered gi|902829180|gb|CP012147.1| 1660083 g56835 i0 78.623 1 276 59 100 0 1 276 2137607 2137332 Leptospirillum sp. Group II 'CF-1', complete genome blastn 276 183 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Leptospirillum Leptospirillum sp. Group II 'CF-1'
23867944 23867944 PRJNA939415_P_NODE_43339_length_290_cov_2.368664_g42917_i0 PRJNA939415 43339 290 2.368664 6.8691256 Nitrospira sp. 70125 Bacteria Bacteria 176 1.53e-39   NTclustered gi|2194432121|gb|CP092081.1| 70125 g42917 i0 79.528 25.2586206896552 254 46 87 5 39 289 124978 124728 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 7325 176 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);;