RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA358490 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
2949643 2949643 PRJNA358490_P_NODE_3303_length_787_cov_3.122995_g3090_i0 PRJNA358490 3303 787 3.122995 24.57797065 Sulfuriroseicoccus oceanibius 2707525 Bacteria Bacteria 462 3.08e-125   NTclustered gi|1953472588|gb|CP066776.1| 2707525 g3090 i0 89.037 94.9097839898348 374 39 87 2 415 787 632231 631859 Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome blastn 74694 462 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Sulfuriroseicoccus Sulfuriroseicoccus oceanibius
6776647 6776647 PRJNA358490_P_NODE_17186_length_159_cov_1.500000_g16842_i0 PRJNA358490 17186 159 1.5 2.385 Luteolibacter sp. Populi 3230487 Bacteria Bacteria 196 5.75e-46   NTclustered gi|2774618348|gb|CP161812.1| 3230487 g16842 i0 90.066 421.987421383648 151 15 95 0 2 152 3261583 3261433 Luteolibacter sp. Populi chromosome, complete genome blastn 67096 196 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. Populi
10602780 10602780 PRJNA358490_P_NODE_1929_length_1010_cov_2.929969_g1789_i0 PRJNA358490 1929 1010 2.929969 29.5926869 Luteolibacter sp. LG18 2819286 Bacteria Bacteria 686 0   NTclustered gi|2585939279|dbj|AP024600.1| 2819286 g1789 i0 79.3 3.74257425742574 1000 191 98 13 22 1010 110019 109025 Luteolibacter sp. LG18 DNA, complete genome blastn 3780 686 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. LG18
11877682 11877682 PRJNA358490_P_NODE_16090_length_169_cov_1.569231_g15746_i0 PRJNA358490 16090 169 1.569231 2.65200039 Haloferula helveola 490095 Bacteria Bacteria 91.6 2.99e-14   NTclustered gi|2647781590|dbj|AP024702.1| 490095 g15746 i0 83.505 1.63313609467456 97 16 57 0 5 101 2179358 2179454 Haloferula helveola CN-1 DNA, complete genome blastn 276 91.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula helveola
15701649 15701649 PRJNA358490_P_NODE_1433_length_1130_cov_16.079743_g1319_i0 PRJNA358490 1433 1130 16.079743 181.7010959 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 1295 0   NTclustered gi|2874253793|emb|OY969777.1| 412056 g1319 i0 90.622 321.958407079646 981 84 87 5 153 1130 2364712 2365687 MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 blastn 363813 1295 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16976446 16976446 PRJNA358490_P_NODE_3294_length_788_cov_4.217623_g3083_i0 PRJNA358490 3294 788 4.217623 33.23486924 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 708 0   NTclustered gi|2874253793|emb|OY969777.1| 412056 g3083 i0 86.76 263.121827411167 642 77 81 8 146 783 2364708 2365345 MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 blastn 207340 708 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
24625234 24625234 PRJNA358490_P_NODE_16860_length_162_cov_1.268293_g16516_i0 PRJNA358490 16860 162 1.268293 2.05463466 Luteolibacter sp. LG18 2819286 Bacteria Bacteria 163 5.97e-36   NTclustered gi|2585939279|dbj|AP024600.1| 2819286 g16516 i0 85 74.8333333333333 160 24 99 0 1 160 5179506 5179347 Luteolibacter sp. LG18 DNA, complete genome blastn 12123 163 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. LG18

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