RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA615175 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
595251 595251 PRJNA615175_P_NODE_7901_length_534_cov_3.631236_g7735_i0 PRJNA615175 7901 534 3.631236 19.39080024 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 492 2.61e-134   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g7735 i0 86.1 0.902621722846442 482 37 90 15 34 515 994018 993567 Luteolibacter sp. SL250 chromosome blastn 482 492 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
1871074 1871074 PRJNA615175_P_NODE_32062_length_245_cov_1.343023_g31894_i0 PRJNA615175 32062 245 1.343023 3.29040635 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 222 1.59e-53   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g31894 i0 86.341 7.55918367346939 205 26 83 2 14 217 3822801 3823004 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 1852 222 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
4422328 4422328 PRJNA615175_P_NODE_13584_length_386_cov_1.476038_g13416_i0 PRJNA615175 13584 386 1.476038 5.69750668 Nibricoccus aquaticus 2576891 Bacteria Bacteria 305 2.56e-78   NTclustered gi|1243404978|gb|CP023344.1| 2576891 g13416 i0 82.709 23.0077720207254 347 56 89 4 42 386 1498126 1498470 Nibricoccus aquaticus strain HZ-65 chromosome, complete genome blastn 8881 305 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus aquaticus
6973169 6973169 PRJNA615175_P_NODE_11886_length_418_cov_2.602899_g11718_i0 PRJNA615175 11886 418 2.602899 10.88011782 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 534 3.279999999999999e-147   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g11718 i0 92.916 0.87799043062201 367 26 88 0 52 418 2425019 2425385 Luteolibacter sp. SL250 chromosome blastn 367 534 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
8248306 8248306 PRJNA615175_P_NODE_36187_length_222_cov_4.590604_g36019_i0 PRJNA615175 36187 222 4.590604 10.19114088 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 272 1.3899999999999999e-68   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g36019 i0 89.041 0.986486486486487 219 24 99 0 1 219 1162069 1161851 Luteolibacter sp. SL250 chromosome blastn 219 272 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
9523114 9523114 PRJNA615175_P_NODE_10828_length_443_cov_1.608108_g10660_i0 PRJNA615175 10828 443 1.608108 7.12391844 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 189 3.13e-43   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g10660 i0 83.582 0.45372460496614 201 33 45 0 1 201 1182189 1182389 Luteolibacter sp. SL250 chromosome blastn 201 189 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
9523677 9523677 PRJNA615175_P_NODE_9628_length_474_cov_8.940150_g9460_i0 PRJNA615175 9628 474 8.94015 42.376311 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 717 0   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g9460 i0 96.145 272.434599156118 441 13 93 4 1 440 1669 1232 Luteolibacter sp. SL250 chromosome blastn 129134 717 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
15897626 15897626 PRJNA615175_P_NODE_11953_length_417_cov_1.514535_g11785_i0 PRJNA615175 11953 417 1.514535 6.31561095 Verrucomicrobia bacterium IMCC26134 1637999 Bacteria Bacteria 673 0   NTclustered gi|807238858|gb|CP011265.1| 1637999 g11785 i0 95.714 93.0623501199041 420 15 100 2 1 417 1903891 1903472 Verrucomicrobia bacterium IMCC26134, complete genome blastn 38807 673 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium IMCC26134
18446735 18446735 PRJNA615175_P_NODE_12155_length_412_cov_2.651917_g11987_i0 PRJNA615175 12155 412 2.651917 10.92589804 Prosthecobacter fusiformis 48464 Bacteria Bacteria 712 0   NTclustered gi|12583974|gb|AF245378.1|AF245378 48464 g11987 i0 97.816 159.468446601942 412 9 100 0 1 412 265 676 Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence blastn 65701 712 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter fusiformis
19721418 19721418 PRJNA615175_P_NODE_17436_length_335_cov_2.240458_g17268_i0 PRJNA615175 17436 335 2.240458 7.5055343 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 608 1.489999999999999e-169   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g17268 i0 99.403 281.137313432836 335 2 100 0 1 335 4718678 4719012 Luteolibacter sp. SL250 chromosome blastn 94181 608 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250

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