RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1032461", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 7 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJNA1032461 · 7 ✖

analysis 1

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
19292905 19292905 PRJNA1032461_S_NODE_20136_length_163_cov_0.912281_g20038_i0 PRJNA1032461 20136 163 0.912281 1.48701803 Opitutaceae bacterium 2006848 Bacteria Bacteria 82 1.72e-16   NR HEY1110425.1 2006848 g20038 i0 76 0.920245398773006 50 12 92 0 152 3 155 204 HEY1110425.1 reverse transcriptase domain-containing protein [Opitutaceae bacterium] diamond 150 82 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
26623510 26623510 PRJNA1032461_S_NODE_21281_length_162_cov_0.920354_g21183_i0 PRJNA1032461 21281 162 0.920354 1.49097348 Luteolibacter sp. SL25 1962973 Bacteria Bacteria 58.9 6.71e-10   NR WP_267671668.1 2995170 g21183 i0 87.2 0.87037037037037 47 6 87 0 162 22 19 65 WP_267671668.1 hypothetical protein [Luteolibacter sp. SL250] diamond 141 58.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
27098299 27098299 PRJNA1032461_S_NODE_10202_length_193_cov_1.444444_g10104_i0 PRJNA1032461 10202 193 1.444444 2.78777692 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 73.2 3.59e-13   NR MDQ3622138.1 2026799 g10104 i0 62.5 0.994818652849741 64 24 99.5 0 2 193 146 209 MDQ3622138.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 192 73.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30603748 30603748 PRJNA1032461_S_NODE_16633_length_167_cov_0.881356_g16535_i0 PRJNA1032461 16633 167 0.881356 1.47186452 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 88.2 1.28e-18   NR HEV7402119.1 2811408 g16535 i0 87.3 0.988023952095808 55 7 98.8 0 2 166 269 323 HEV7402119.1 ComEC/Rec2 family competence protein [Chthoniobacteraceae bacterium] diamond 165 88.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae bacterium
31520603 31520603 PRJNA1032461_S_NODE_15756_length_168_cov_0.873950_g15658_i0 PRJNA1032461 15756 168 0.87395 1.468236 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 79.7 1.22e-15   NR HAM71517.1 2026801 g15658 i0 63.6 1.96428571428571 55 20 98.2 0 166 2 424 478 HAM71517.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 330 79.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32184899 32184899 PRJNA1032461_S_NODE_21818_length_162_cov_0.920354_g21720_i0 PRJNA1032461 21818 162 0.920354 1.49097348 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 69.7 3.93e-12   NR MFL6519441.1 2201154 g21720 i0 63 3.03703703703704 54 20 100 0 1 162 1161 1214 MFL6519441.1 choice-of-anchor Q domain-containing protein [Chthoniobacterales bacterium] diamond 492 69.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
32374786 32374786 PRJNA1032461_S_NODE_13639_length_171_cov_1.245902_g13541_i0 PRJNA1032461 13639 171 1.245902 2.13049242 Luteolibacter sp. AS25 3135776 Bacteria Bacteria 65.1 1.79e-10   NR WP_411826179.1 3135776 g13541 i0 50.9 0.964912280701754 55 27 96.5 0 169 5 107 161 WP_411826179.1 PIG-L family deacetylase [Luteolibacter sp. AS25] diamond 165 65.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. AS25

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);;