RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA380129" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA380129 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
7452046 7452046 PRJNA380129_P_NODE_3586_length_172_cov_4.216783_g3262_i0 PRJNA380129 3586 172 4.216783 7.25286676 Enterobacteriaceae 543 Bacteria Bacteria 318 1.2899999999999999e-82   NTclustered gi|2650988455|gb|CP142548.1| 562 g3262 i0 100 683.645348837209 172 0 100 0 1 172 42676 42847 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 117587 318 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
8726799 8726799 PRJNA380129_P_NODE_2047_length_396_cov_1.275204_g1723_i0 PRJNA380129 2047 396 1.275204 5.04980784 Sphingomonas 13687 Bacteria Bacteria 161 6.04e-35   NTclustered gi|2814041301|gb|CP170557.1| 68569 g1723 i0 98.889 84.7979797979798 90 1 54 0 1 90 2335486 2335575 Sphingomonas leidyi strain UC122_23 chromosome, complete genome blastn 33580 161 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas leidyi
13155736 13155736 PRJNA380129_P_NODE_2331_length_381_cov_0.741477_g2007_i0 PRJNA380129 2331 381 0.741477 2.82502737 Caulifigura coniformis 2527983 Bacteria Bacteria 222 2.62e-53   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g2007 i0 99.187 4.04724409448819 123 1 52 0 259 381 2925587 2925465 Caulifigura coniformis strain Pan44 chromosome blastn 1542 222 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
15704700 15704700 PRJNA380129_P_NODE_1133_length_593_cov_11.189716_g821_i0 PRJNA380129 1133 593 11.189716 66.35501588 Alteromonas macleodii 28108 Bacteria Bacteria 1096 0   NTclustered gi|2321920657|emb|OX359241.1| 28108 g821 i0 100 43.1349072512648 593 0 100 0 1 593 1102375 1102967 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 25579 1096 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
15704704 15704704 PRJNA380129_P_NODE_953_length_664_cov_1.400000_g648_i0 PRJNA380129 953 664 1.4 9.296 uncultured Granulicella sp. 1241325 Bacteria Bacteria 536 1.4999999999999995e-147   NTclustered gi|2626255659|emb|OY843766.1| 1241325 g648 i0 98.675 68.7183734939759 302 4 74 0 362 663 3195263 3195564 MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1 blastn 45629 536 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.
17651722 17651722 PRJNA380129_P_NODE_1374_length_492_cov_3.349892_g1055_i0 PRJNA380129 1374 492 3.349892 16.48146864 root 1 Root_unresolved Root_unresolved 438 3.149999999999999e-118   NTclustered gi|996042317|gb|CP014323.1| 28108 g1055 i0 100 43.9817073170732 237 0 63 0 1 237 2054612 2054376 Alteromonas macleodii strain D7 chromosome, complete genome blastn 21639 438 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
17651724 17651724 PRJNA380129_P_NODE_3114_length_317_cov_3.423611_g2790_i0 PRJNA380129 3114 317 3.423611 10.85284687 Acinetobacter 469 Bacteria Bacteria 475 1.49e-129   NTclustered gi|2456158263|gb|CP119200.1| 40214 g2790 i0 100 701.299684542587 257 0 100 0 1 257 167790 168046 Acinetobacter johnsonii strain AJ572 chromosome, complete genome blastn 222312 475 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter johnsonii
18253644 18253644 PRJNA380129_P_NODE_1815_length_415_cov_3.461140_g1491_i0 PRJNA380129 1815 415 3.46114 14.363731 Sphingomonas leidyi 68569 Bacteria Bacteria 327 5.92e-85   NTclustered gi|2814041301|gb|CP170557.1| 68569 g1491 i0 96.465 77.9518072289157 198 7 48 0 1 198 2337129 2337326 Sphingomonas leidyi strain UC122_23 chromosome, complete genome blastn 32350 327 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas leidyi
18925569 18925569 PRJNA380129_P_NODE_2075_length_394_cov_1.158904_g1751_i0 PRJNA380129 2075 394 1.158904 4.56608176 Acinetobacter 469 Bacteria Bacteria 233 1.25e-56   NTclustered gi|1338973579|gb|CP026412.1| 1758189 g1751 i0 100 197.045685279188 126 0 32 0 1 126 812347 812472 Acinetobacter sp. ACNIH2 chromosome, complete genome blastn 77636 233 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp. ACNIH2
22750924 22750924 PRJNA380129_P_NODE_498_length_892_cov_10.972190_g234_i0 PRJNA380129 498 892 10.97219 97.8719348 Alteromonas 226 Bacteria Bacteria 1642 0   NTclustered gi|2321920657|emb|OX359241.1| 28108 g234 i0 99.888 457.816143497758 892 1 100 0 1 892 37164 38055 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 408372 1642 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
24025863 24025863 PRJNA380129_P_NODE_3699_length_151_cov_2.672131_g3375_i0 PRJNA380129 3699 151 2.672131 4.03491781 root 1 Root_unresolved Root_unresolved 231 1.47e-56   NTclustered gi|2721415253|gb|CP151860.1| 546 g3375 i0 97.08 688.437086092715 137 4 91 0 13 149 21098 20962 Citrobacter freundii strain MO_AK867 chromosome, complete genome blastn 103954 233 0.991416309012876 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Citrobacter Citrobacter freundii

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