RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1148190 · 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
297778 297778 PRJNA1148190_P_NODE_590381_length_251_cov_0.865169_g579208_i0 PRJNA1148190 590381 251 0.865169 2.17157419 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g579208 i0 99.602 1 251 1 100 0 1 251 739908 740158 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 251 459 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
1574724 1574724 PRJNA1148190_P_NODE_783522_length_241_cov_0.916667_g772349_i0 PRJNA1148190 783522 241 0.916667 2.20916747 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 139 1.62e-28   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g772349 i0 86.26 1.08713692946058 131 15 54 3 60 189 1005370 1005498 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 262 139 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
2843818 2843818 PRJNA1148190_P_NODE_250663_length_343_cov_1.218519_g239493_i0 PRJNA1148190 250663 343 1.218519 4.17952017 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 342 1.7199999999999994e-89   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g239493 i0 84.751 16.3527696793003 341 52 99 0 3 343 3280322 3279982 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 5609 342 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
2849935 2849935 PRJNA1148190_P_NODE_691923_length_246_cov_0.890173_g680750_i0 PRJNA1148190 691923 246 0.890173 2.18982558 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 67.6 7.94e-7   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g680750 i0 83.562 0.296747967479675 73 10 29 2 50 121 1758814 1758885 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 73 67.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
7948677 7948677 PRJNA1148190_P_NODE_434787_length_279_cov_1.640777_g423614_i0 PRJNA1148190 434787 279 1.640777 4.57776783 uncultured Lentisphaeria bacterium 1506601 Bacteria Bacteria 106 1.94e-18   NTclustered gi|2518551196|emb|OX638337.1| 1506601 g423614 i0 89.286 3.83512544802867 84 9 30 0 171 254 1520434 1520351 MAG: uncultured Lentisphaeria bacterium isolate c31e16b5-b392-4df5-8896-43fa5ca65f34 genome assembly, chromosome: 1 blastn 1070 106 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       uncultured Lentisphaeria bacterium
20699764 20699764 PRJNA1148190_P_NODE_632357_length_249_cov_0.875000_g621184_i0 PRJNA1148190 632357 249 0.875 2.17875 Lentisphaeria bacterium 2053569 Bacteria Bacteria 196 9.84e-46   NTclustered gi|2189495548|gb|CP091727.1| 2053569 g621184 i0 81.301 21.8273092369478 246 42 98 4 1 244 980034 980277 MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome blastn 5435 196 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
20700363 20700363 PRJNA1148190_P_NODE_681597_length_246_cov_0.890173_g670424_i0 PRJNA1148190 681597 246 0.890173 2.18982558 Victivallales bacterium 2212475 Bacteria Bacteria 54.7 0.006   NTclustered gi|2622071908|emb|OY787460.1| 2212475 g670424 i0 100 0.117886178861789 29 0 12 0 156 184 6144802 6144774 MAG: Victivallales bacterium isolate c43507a4-3b0a-454f-a213-a96987c4837a genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium

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